/ View Ticket
Login
Ticket Hash: ae0f637bddc5290b44669e066a9ff0b167907fb9
Title: REINDEX fails on a UNIQUE index on the GLOB operator of a REAL column
Status: Fixed Type: Code_Defect
Severity: Minor Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-05-01 19:01:39
Version Found In: 3.28.0
User Comments:
drh added on 2019-05-01 13:59:35:

The REINDEX statement in the following SQL gives an error indicating that the index is not unique:

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;

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.