Hello, There is some quirk when using v056 version of jdbc driver, but it may be also non-driver issue. I'm new to sqlite so cannot distinguish where it comes from
for example create table a (b) insert into a values (1) //statement returns update count 1 insert into a values (2) //statement returns update count 1 select count(*) from a // returns 2 as expected delete from a //statement returns update count 0 instead of 2 select count(*) from a // returns 0 as expected then again, but with workaround insert into a values (3) //statement returns update count 1 insert into a values (4) //statement returns update count 1 select count(*) from a // returns 2 as expected delete from a where b = b //bogus `where` clause makes update count 2, as should be select count(*) from a // returns 0 as expected Regards, Eugene Lucash _______________________________________________ SQLiteJDBC mailing list [email protected] https://lists.hcoop.net/listinfo/sqlitejdbc
