[MonetDB-users] SQL DELETE bug?

29 Oct 2007

      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.

kind regards,
Sander Kruseman