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