Hi everyone,
Consider the example below:
CREATE TABLE test (c0 REAL);
CREATE INDEX index_0 ON test(c0 COLLATE NOCASE);
INSERT INTO test(c0) VALUES ('/');
SELECT * FROM test WHERE (c0 LIKE '/');
Unexpectedly, the SELECT statement does not return a result. If the
statement for the creation of the index is omitted, the row that is
inserted is returned.
It seems that the bug is triggered only when the column is of type INT,
REAL, or NUMERIC. I could also reproduce this only for a COLLATE NOCASE
index and the slash character.
Best,
Manuel
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
