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]
|