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