[MonetDB-users] SQL DELETE bug?

Sander Kruseman kruseman at xs4all.nl
Tue Oct 30 15:21:22 CET 2007


Switching to the latest release solved it. Thanks.

Kind regards,
Sander Kruseman


Niels Nes wrote:
> On Mon, Oct 29, 2007 at 02:29:04PM +0100, Sander Kruseman wrote:
>> Hi,
>>
>> Using server v5.0.0 on Windows with the JDBC terminal v1.18.0, SQL DELETE
>> statements appear to fail. Working in autocommit mode, I issue the
>> following commands:
>>
>> create table test (id int unique not null, name varchar(10) not null);
>> insert into test (id, name) values (1, 'jan');
>> delete from test where id = 1;
>> select * from test;
>>
>> I get no rows, as was to be expected. However, using DbVisualizer (also
>> using JDBC) I can still see the one inserted table row (after Reload
>> View).
>>
>> After restarting both server and JDBC terminal, I also get the row when
>> using the JDBC terminal. Bug or ignorance?
>>
>> Note that I am using my own schema having been setup with its own user,
>> similar to the VOC tutorial.
> 
> I fixed a bug in deletes some time ago.
> Could you switch to the latest release?
> 
> Niels
>> kind regards,
>> Sander Kruseman
>>
>>
>> -------------------------------------------------------------------------
>> This SF.net email is sponsored by: Splunk Inc.
>> Still grepping through log files to find problems?  Stop.
>> Now Search log events and configuration files using AJAX and a browser.
>> Download your FREE copy of Splunk now >> http://get.splunk.com/
>> _______________________________________________
>> MonetDB-users mailing list
>> MonetDB-users at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/monetdb-users
> 




More information about the users-list mailing list