Re: [sqlite] LIKE Query with ESCAPE character

2019-02-27 Thread Richard Hipp
On 2/27/19, julian robichaux 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

[sqlite] LIKE Query with ESCAPE character

2019-02-27 Thread julian robichaux
Hi, I hope this is a simple question that someone can answer without a lot of trouble (maybe I am simply misunderstanding something). According to https://www.sqlite.org/optoverview.html#the_like_optimization , a LIKE query can use an ESCAPE character and still be optimized as long as the chara