On 4/28/19, Manuel Rigger <[email protected]> wrote: > > 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; > > Is this indeed a bug, or a misunderstanding on my side?
https://www.sqlite.org/src/tktview/3182d3879020ef3b2e6db56be2470a0266d3c773 -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

