On Wed, May 9, 2012 at 5:33 AM, <ext-esko.huja...@elektrobit.com> wrote:
> Hi All, > > > > 1: SAVEPOINT 1 > > 2: insert A > > 3: RELEASE SAVEPOINT 1 > > 4: SAVEPOINT 2 > > 5: insert B > > 6: ROLLBACK TO SAVEPOINT 2 > > > > ROLLBACK in line 6 cancels also line 2 in addition to line 5. > > I want to cancel just line 5. > I did this: CREATE TABLE t1(x); INSERT INTO t1 VALUES('one'); SAVEPOINT x1; INSERT INTO t1 VALUES('two'); RELEASE x1; SAVEPOINT x2; INSERT INTO t1 VALUES('three'); ROLLBACK TO SAVEPOINT x2; SELECT * FROM t1; And the output is "one" and "two", as you would expect. Can you provide an actual test case for the problem you are seeing? > > > > What am I doing wrong ? > > > > br, > > Esko > > > > ---------------------------------------------------------------- > Please note: This e-mail may contain confidential information > intended solely for the addressee. If you have received this > e-mail in error, please do not disclose it to anyone, notify > the sender promptly, and delete the message from your system. > Thank you. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users