SQLite: View Ticket

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 6.17 years ago	Created:	2019-05-01 13:59:35 6.17 years ago
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.