On Sat, 18 Nov 2017 22:53:26 +0100, Yannick Duchêne
<[hidden email]> 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:
The same happens for
, although it's less intrusive than locking_mode , because
journal_mode will typically only be issued at database creation.
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 some users. For example suppose someone changes the page_size using this:
PRAGMA page_size = 16384;
They change page_size to 16384 but they don’t know that that works only for an empty database, or after a VACUUM. The PRAGMA outputs 4096 and, although they don’t yet know why, they do at least know that their change didn’t work properly.