[MonetDB-users] SQL DELETE bug?
kruseman at xs4all.nl
Mon Oct 29 14:29:04 CET 2007
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
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
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.
More information about the users-list