Joe Mistachkin wrote: > Sven Bloesl wrote: > > > BEGIN IMMEDIATE > > > > SAVEPOINT SP1 > > CREATE TABLE a(key number primary key); > > > > SAVEPOINT SP2 > > INSERT INTO a VALUES(666); > > SELECT count(1) FROM a Expected: 1, Got: 1 > > > > SAVEPOINT SP3 > > INSERT INTO a VALUES(13); > > SELECT count(1) FROM a Expected: 2, Got: 2 > > > > ROLLBACK TRANSACTION TO SP3 > > SELECT count(1) FROM a Expected: 1, Got: 2 > > [...] > > 3. Could you show some example code that demonstrates the issue? > This question already helped. I must have been blind. I reviewed the complete code again and found out that our application creates the connections with journal mode off (with undefined rollback behavior). I changed that, and now it works as expected.
-- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users