On 2/27/19, julian robichaux <julian.robich...@panagenda.com> 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 d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users