Hello ! I have an application that uses sqlite3 and in one database I get different responses between the sqlite3 executable and my application that uses the same sqlite3.c:
The query: explain query plan select * from companies where post_code like 'rg%'; My application: 0??? 0??? 0??? SCAN TABLE companies sqlite3 executable: 0|0|0|SEARCH TABLE companies USING INDEX companies_post_code_idx (post_code>? AND post_code<?) What compile time options if any can cause this ? Cheers ! ?