Hi everyone,
I found what could be a bug. Consider the example below:
CREATE TABLE test (c1 TEXT PRIMARY KEY) WITHOUT ROWID;
CREATE INDEX index_0 ON test(c1 COLLATE NOCASE);
INSERT INTO test(c1) VALUES ('A');
INSERT INTO test(c1) VALUES ('a');
SELECT * FROM test;
The query returns only one result, namely ('a'), while I would have
expected both rows to be fetched. It seems that this bug only exists when
(1) a COLLATE NOCASE index is created and (2) WITHOUT ROWID is used. When
using COUNT(*), the expected number of 2 is returned.
Is this indeed a bug, or a misunderstanding on my side?
Best,
Manuel
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
