[MonetDB-users] SQL DELETE bug?
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
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@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@cwi.nl
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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
Niels Nes -
Sander Kruseman