Re: [sqlite] Choosing the best query plan

On Thursday, 30 August, 2012, at 02:03, Navaneeth.K.N wrote: > When looking throgh the execution plan, they both uses different plans. > Plan for 1st query > -- > SEARCH TABLE patterns_content AS pc USING COVERING INDEX > sqlite_autoindex_patterns_content_1 (pattern=?) (~2 rows) > S

[sqlite] Bug in winAccess

winAccess should check ERROR_PATH_NOT_FOUND in the same way as ERROR_FILE_NOT_FOUND. The former error code is returned for example by WinRT when checking for directory existence. (I just got it when checking for application folder existence, but as far I remember, it is returned in more scenari

Re: [sqlite] SQLITE_MISUE returned from sqlite3_step with inconsistent errMsg

On 08/31/2012 12:42 PM, Daniel Dawson wrote: Hey Guys, I am calling sqlite3_step and checking the return value, Usually I get an SQLITE_DONE, or an SQLITE_BUSY which I handle. However, sometimes I get an SQLITE_MISUSE return code. If I call sqlite3_errmsg straight after receiving the code the