Ticket Hash: | 27ca74af3c083f787a1c44b11fbb7c53bdbbcf1e | |||
Title: | Nested SAVEPOINT release causes pending query abort | |||
Status: | Fixed | Type: | Code_Defect | |
Severity: | Severe | Priority: | Immediate | |
Subsystem: | Unknown | Resolution: | Fixed | |
Last Modified: | 2012-03-31 18:02:56 | |||
Version Found In: | 3.7.11 | |||
Description: | ||||
The following problem was reported on the SQLite users mailing list
by Lukas Gebauer. See
http://www.mail-archive.com/sqlite-users%40sqlite.org/msg69084.html
for the original bug report. Synopsis:
Sqlite version 3.7.11 on Windows cause error in my program. Some of my pending statements are aborted by a nested savepoint transaction. See: SAVEPOINT x1; SELECT * FROM sometable; //just open statement and left it opened! SAVEPOINT x2; RELEASE x2; ... call sqlite3_step on previously opened statement - I got SQLITE_ABORT error, even I not see any Rollback. When I omit savepoint x1, then statement working well. If I omit nested x2 savepoint, statement working fine too. drh added on 2012-03-31 17:15:38: |