Re: [sqlite] setting journal_mode while in a transaction may behave strangely

Alright, thank you for these precisions. On 08/13/2014 02:28 PM, Richard Hipp wrote: On Tue, Aug 12, 2014 at 12:35 PM, Jean GIARD wrote: I know it's not a good behavior to have structure queries inside a transaction ... There is absolutely nothing wrong with doing DDL statements inside a tr

Re: [sqlite] setting journal_mode while in a transaction may behave strangely

On Tue, Aug 12, 2014 at 12:35 PM, Jean GIARD wrote: > > I know it's not a good behavior to have structure queries inside a > transaction ... > There is absolutely nothing wrong with doing DDL statements inside a transaction in SQLite. Other SQL database engines might have issues with that, but

[sqlite] setting journal_mode while in a transaction may behave strangely

Hi, I stumbled upon a bug in my code which looked like a wrong sqlite behavior. When simply using the "begin - pragma journal_mode=wal - commit" query sequence, sqlite return a proper error saying this is not allowed. However if I execute a command affecting the database structure (such as create