On 4/28/19, Manuel Rigger <rigger.man...@gmail.com> 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 d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
