On Mon, Feb 10, 2014 at 9:02 PM, Richard Hipp <[email protected]> wrote:
>
> Your work-arounds pending the patch release:
>
> (1) Do not compile with SQLITE_ENABLE_STAT3 or SQLITE_ENABLE_STAT4
> (2) Change your query so that it says "+moved_to IS NOT NULL" - add a
> unary "+" operator before every column name that is subject to an IS NOT
> NULL operator.
>
A third work-around:
(3) After opening each database connection ("db") run the following code:
if( strcmp(sqlite3_sourceid(),"2013-08-26 23:00")>0
&& strcmp(sqlite3_sourceid(),"2014-02-11")<0 ){
sqlite3_test_control(SQLITE_TESTCTRL_OPTIMIZATIONS, db, 0x800);
}
The call to sqlite3_test_control() will disable the STAT3 and STAT4 logic,
which will suppress the bug.
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
