On 2/27/19, julian robichaux <[email protected]> wrote: > Am I doing something wrong here, or perhaps misunderstanding the > documentation? My expectation is that both LIKE queries will use the > index, but the EXPLAIN QUERY PLAN results tell me something different.
There was an issue with the LIKE optimization when there was an ESCAPE clause and the PRAGMA case_sensitive_like=ON setting was in effect. That particular combination of circumstances should work, but it did not. All the other combinations are fine. The fix is here: https://www.sqlite.org/src/info/6ae4b8c525f446dd -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
