Re: [sqlite] glob and like not using index in newest sqlite

On Fri, Nov 26, 2010 at 6:23 AM, Spiros Ioannou wrote: > Hello, I recently updated from 3.4.2 to 3.7.3 and the glob and like > operators are now not using the indexes. > My table "dict" has a column named "word" without defined type, containing > utf-8 words. The index is: > CREATE INDEX wordidx o

[sqlite] glob and like not using index in newest sqlite

Hello, I recently updated from 3.4.2 to 3.7.3 and the glob and like operators are now not using the indexes. My table "dict" has a column named "word" without defined type, containing utf-8 words. The index is: CREATE INDEX wordidx on dicts (word); explain query plan SELECT * from dicts where word