[sqlite] Index on REAL malfunctions in combination with the LENGTH function

[Manuel Rigger]

Hi,

I found another very specific corner case for which an index fails ("UNIQUE
constraint failed: index 'index_0'"):

CREATE TABLE test (c0 REAL);
CREATE UNIQUE INDEX index_0 ON test(LENGTH(-c0));
INSERT INTO test(c0) VALUES (0.0), ('10:');
REINDEX;


Best,
Manuel
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users