Re: [sqlite] Changed behavior from 3.7.17 to 3.8.0.

2013-08-30 Thread Richard Hipp
On Thu, Aug 29, 2013 at 1:01 PM, Peter Aronson wrote: > I don't know if this is serious, but a SAVEPOINT command fails with an > open statement handle used to execute PRAGMA journal_mode = off > SAVEPOINT and journal_mode=OFF do not play well together. Please do not do that.

Re: [sqlite] Changed behavior from 3.7.17 to 3.8.0.

2013-08-30 Thread Clemens Ladisch
Peter Aronson wrote: > a SAVEPOINT command fails with an open statement handle used to > execute PRAGMA journal_mode = off at SQLite 3.8.0, but appears to > succeed at SQLite 3.7.17. This does not appear to be documented. says: | An implicit

[sqlite] Changed behavior from 3.7.17 to 3.8.0.

2013-08-29 Thread Peter Aronson
I don't know if this is serious, but a SAVEPOINT command fails with an open statement handle used to execute PRAGMA journal_mode = off at SQLite 3.8.0, but appears to succeed at SQLite 3.7.17.  This does not appear to be documented.  Note that a BEGIN TRANSACTION will appear to succeed where