| 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 13.28 years ago |
Created: |
2012-03-31 17:12:06 13.28 years ago |
| 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: <blockquote><pre><nowiki> 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. </nowiki></pre></blockquote> <hr><i>drh added on 2012-03-31 17:15:38:</i><br> Problem originates with check-in [9c572d424a20b0585b] on [2012-02-13] | ||||