Okay, thanks! Best, Manuel
Am So., 28. Apr. 2019 um 21:02 Uhr schrieb Simon Slavin < [email protected]>: > On 28 Apr 2019, at 7:58pm, Manuel Rigger <[email protected]> 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
