[SQLiteJDBC] Sometimes Incorrect update count

[Евген Лукаш]

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