[MonetDB-users] SQL DELETE bug?

Niels Nes Niels.Nes at cwi.nl
Mon Oct 29 18:36:24 CET 2007


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

-- 

Niels Nes, Centre for Mathematics and Computer Science (CWI)
Kruislaan 413, 1098 SJ Amsterdam, The Netherlands
room C0.02,  phone ++31 20 592-4098, fax ++31 20 592-4312
url: http://www.cwi.nl/~niels   e-mail: Niels.Nes at cwi.nl




More information about the users-list mailing list