| Question about Rollback [message #361701] |
Thu, 27 November 2008 10:50  |
registereduser
Messages: 52
Registered: June 2008
Location: Toronto
|
Member |
|
|
DELETE FROM tbl WHERE id = 3;
SAVEPOINT a;
UPDATE tbl SET col_1 = 5 WHERE id = 4;
ROLLBACK TO a;
ROLLBACK;
My question is whether "DELETE FROM tbl WHERE id = 3" has been done? Thanks.
|
|
|
|
|
|
| Re: Question about Rollback [message #361709 is a reply to message #361701] |
Thu, 27 November 2008 11:47  |
registereduser
Messages: 52
Registered: June 2008
Location: Toronto
|
Member |
|
|
Thanks Frank.
That removed a doubt for me. According to text books, rollback constitutes a commit, which literally means the “rollback” only rollback to the specific savepoint and commit all statements before that savepoint.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
