We have this inconsistent behaviour:
Code: Select all
SELECT 0 as dummy from mytable where 1=1 -- SQLITE_INTEGER ftLargeInt (CORRECT)
SELECT 0 as dummy from mytable where 0=1 -- SQLITE_NULL ftWideMemo (WRONG)
SELECT 'test' as dummy from mytable where 0=1 -- SQLITE_NULL ftWideMemo (CORRECT)
Regards
Eric