On Wed, May 9, 2012 at 5:33 AM, <[email protected]> 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
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
