[sqlite] Bug: writing to a database in shared cache mode doesn't work if same database was opened in readonly mode previously

[Simon Slavin]

On 16 Feb 2016, at 3:04pm, Ludger Kr?mer <kraemer at dem-gmbh.de> wrote:

> I connect to the same database file twice, first in readonly mode and
> then in readwrite mode while having set sqlite3_enable_shared_cache(1).
> 
> Any attempt to change any data using the second database connection results 
> in an "attempt to write a readonly database" error.

Expected behaviour.  Sharing the cache shares the connection.

Simon.