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