On 3/26/2016 6:12 PM, Denis Burke wrote: > CREATE INDEX [IndxT1C3] > ON [T1]( > [C3] COLLATE [NOCASE]); > ---------- > after doing this: > explain query plan > select C1 from T1 > where C3='2016-01-02'
You are requesting a case sensitive comparison; a case insensitive index cannot be used to satisfy it. If you expect SQLite to inspect the string literal character by character and prove that case sensitivity won't make a difference, then I'm afraid you expect too much. -- Igor Tandetnik