Re: [sqlite] Strange SAVEPOINT behaviour with locking_mode=exclusive

2009-04-20 Thread Ralf Junker
At 15:37 20.04.2009, D. Richard Hipp wrote: >Ticket #3811 has been addressed by enhancing the documentation to >explain that journal_mode changes are only guaranteed to work if they >occur prior to the first transaction. Whether or not a journal_mode >change works after the start of the

Re: [sqlite] Strange SAVEPOINT behaviour with locking_mode=exclusive

2009-04-20 Thread D. Richard Hipp
On Apr 20, 2009, at 6:59 AM, Ralf Junker wrote: > Hello Ken, > >> I think the problem is not in the locking mode but rather: >> >> PRAGMA journal_mode = off; >> >> I'm not sure if rollbacks actually function with the journalling >> turned off. > > According to the documentation,

Re: [sqlite] Strange SAVEPOINT behaviour with locking_mode=exclusive

2009-04-19 Thread Ken
. hth --- On Fri, 4/17/09, Ralf Junker <ralfjun...@gmx.de> wrote: > From: Ralf Junker <ralfjun...@gmx.de> > Subject: [sqlite] Strange SAVEPOINT behaviour with locking_mode=exclusive > To: sqlite-users@sqlite.org > Date: Friday, April 17, 2009, 3:07 PM > I experi

[sqlite] Strange SAVEPOINT behaviour with locking_mode=exclusive

2009-04-17 Thread Ralf Junker
I experience some strange behaviour with SAVEPOINT in combination with locking_mode=exclusive. Below is a script which I assembled from savepoint.text 13.1 to 13.4. Those tests run OK in normal locking mode, but fail in exclusive locking more. To reproduce, run the script below on a NEW and