I've been reading about the LIKE optimization[1]. One of the constraints on its 
use is:

> if case_sensitive_like mode is enabled then the column must indexed using 
> BINARY collating sequence, or if case_sensitive_like mode is disabled then 
> the column must indexed using built-in NOCASE collating sequence.

Does this also apply when the LHS is not a column but an expression? I.e. does 
the index on that expression need to have BINARY (or NOCASE) collation?

—Jens

[1]: https://sqlite.org/optoverview.html#the_like_optimization
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to