Hi everyone, the following sequence of SQL statements results in "Error: malformed database schema (index_0) - non-deterministic functions prohibited in index expressions".
CREATE TABLE test (c0); CREATE INDEX index_0 ON test(c0 LIKE ''); PRAGMA case_sensitive_like=false; VACUUM; SELECT * from test; This error relates to the statement sequence in my previous email "PRAGMA case_sensitive_like conflicts with LIKE operator when creating an index", in that both statement sequences set "case_sensitive_like" and use "like" in an index. However, in this case, the issue seems to be detected only in a query subsequent to the VACUUM statement that seems to corrupt the schema. Best, Manuel _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users