Hello, I'm using System.Data.SQLite 1.0.82.0 and can't get nested savepoint work in my application. Rollbacks to the nested savepoint do not have any effects, only rollbacks to the outermost savepoint undo my changes. According to the SQLite documentation this should work and I verified that with the Qt-based SQLite Database Browser.
Here is the connection trace, the select statements are executed with SQLiteCommand.ExecuteScalar and the other statements with ExecuteNonQuery: 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 If I rollback to SP1 instead the last select throws as expected an exception, since the table vanished. Has anyone an idea, what I'm doeing wrong or is this a bug? Thanks in advance, Sven _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
