Re: [sqlite] Bug: Problem with sqlite3_prepare_v2

2018-07-30 Thread Richard Hipp
On 7/29/18, Jürgen Palm wrote: > As a quick, ugly workaround for my situation I could add something like >sqlite3_exec(conn1, "SELECT 1",NULL,NULL,NULL); > before the sqlite3_prepare_v2 after the schema change. > > Is there any better way? Or would it be possible to add a SQLITE_PREPARE >

Re: [sqlite] Bug: Problem with sqlite3_prepare_v2

2018-07-30 Thread Jürgen Palm
Richard Hipp wrote: On 7/29/18, Jürgen Palm wrote: Hi, in an application I encountered a problem, where the changing of the structure of a table by dropping and recreating it via one connection to a db was not directly seen by another connection to the same db. Detecting a schema change

Re: [sqlite] Bug: Problem with sqlite3_prepare_v2

2018-07-29 Thread Richard Hipp
On 7/29/18, Jürgen Palm wrote: > Hi, > > in an application I encountered a problem, where the changing of the > structure of a table by dropping and recreating it via one connection to > a db was not directly seen by another connection to the same db. Detecting a schema change requires starting