Re: [sqlite] Equiv stmts, different explain plans

On 05/03/2019 01:33, Richard Hipp wrote: On 3/4/19, Kyle wrote: On another DB I came across 2 stmts, that I think are equivalent, but generated different explain plans. I request a second opinion - are these 2 stmts equivalent? If so, why do they generate different explain plans even on

Re: [sqlite] SQLite3Close returns SQLITE_BUSY after executing PRAGMAs

On 05/01/2017 23:35, Richard Hipp wrote: On 1/5/17, Kyle wrote: Dear all, Under version 3.16.1, SQLite3Close is returning SQLITE_BUSY when I open a database, execute some PRAGMAS, (run some stmts) then attempt the close. This did not occur under version 3.15.2, nor does