See ticket https://www.sqlite.org/src/info/a340eef47b0cad59
On 4/28/19, Manuel Rigger <rigger.man...@gmail.com> wrote: > Hi everyone, > > 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. For example, the example below results > in "Error: non-deterministic functions prohibited in index expressions". > > PRAGMA case_sensitive_like=false; CREATE TABLE test (c0); CREATE INDEX IF > NOT EXISTS index_1 ON test(c0 LIKE "a"); > > Is this a bug or intended? From the documentation, I would guess that when > registering the LIKE and GLOB functions, they are not registered as being > deterministic. > > Best, > Manuel > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users