Great, thanks for opening the bug report and for the attribution! Best, Manuel
Am So., 28. Apr. 2019 um 17:07 Uhr schrieb Richard Hipp <d...@sqlite.org>: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users