(text/x-fossil-wiki)
The REINDEX statement in the following SQL gives an error indicating that
the index is not unique:
<blockquote><verbatim>
CREATE TABLE t1(a TEXT, b REAL);
CREATE UNIQUE INDEX t1x1 ON t1(a GLOB b);
INSERT INTO t1(a,b) VALUES('0','1'),('1','1');
REINDEX;
</verbatim></blockquote>
This problem was reported on the SQLite mailing list by Manuel Rigger.
This ticket is given a low priority since we not (yet) been able to devise
a scenario where this quirk could cause problems in a practical,
real-world database.
|