On 28 Apr 2019, at 7:58pm, Manuel Rigger <rigger.man...@gmail.com> wrote:
> It seems that setting "PRAGMA case_sensitive_like" to either false (the > default behavior) or true results in no longer being able to use a LIKE or > GLOB clause when creating an index. Correct. Because you cannot depend that every connection that opens the database has PRAGMA case_sensitive_like set the same way. And that might lead to an inconsistent index. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users