Re: [sqlite] Unexpected echo when setting locking_mode

2017-11-19 Thread Graham Holden
00) To: SQLite mailing list Subject: Re: [sqlite] Unexpected echo when setting locking_mode On 19 Nov 2017, at 2:01am, Kees Nuyt wrote: > The same happens for > pragma journal_mode=wal; Perhaps the PRAGMAs should be reviewed for consistency: that all PRAGMAs which change values sho

Re: [sqlite] Unexpected echo when setting locking_mode

2017-11-18 Thread Simon Slavin
On 19 Nov 2017, at 2:01am, Kees Nuyt wrote: > The same happens for > pragma journal_mode=wal; Perhaps the PRAGMAs should be reviewed for consistency: that all PRAGMAs which change values should output their new value. This might provide a useful piece of diagnostic information for som

Re: [sqlite] Unexpected echo when setting locking_mode

2017-11-18 Thread Kees Nuyt
On Sat, 18 Nov 2017 22:53:26 +0100, Yannick Duchêne wrote: >I believe I found a tiny bug, nothing bad, but may pollute some output. > >Using SQLite version 3.20.1, if I do this: > >PRAGMA locking_mode=exclusive; > >It writes an unexpected reply: > >exclusive The same happens for

[sqlite] Unexpected echo when setting locking_mode

2017-11-18 Thread Yannick Duchêne
Hello there, I believe I found a tiny bug, nothing bad, but may pollute some output. Using SQLite version 3.20.1, if I do this: PRAGMA locking_mode=exclusive; It writes an unexpected reply: exclusive It do as if I was requesting the actual value, as in this: PRAGMA locking_mode;