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. |