Re: [sqlite] Rollback of nested savepoints with System.Data.SQLite

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);

Re: [sqlite] Rollback of nested savepoints with System.Data.SQLite

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 Expec

Re: [sqlite] Rollback of nested savepoints with System.Data.SQLite

On 17 Sep 2012, at 7:23am, 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)

[sqlite] Rollback of nested savepoints with System.Data.SQLite

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 wit