| Ticket Hash: | 5a3dba81044213203047df25272ac99f25dd8017 | |||
| Title: | REINDEX causes "UNIQUE constraint failed" error | |||
| Status: | Fixed | Type: | Code_Defect | |
| Severity: | Important | Priority: | Immediate | |
| Subsystem: | Unknown | Resolution: | Fixed | |
| Last Modified: | 2019-08-30 23:15:18 | |||
| Version Found In: | 3.29.0 | |||
| User Comments: | ||||
|
mrigger added on 2019-08-30 19:41:46:
Consider the following test case: CREATE TABLE t0(c0 REAL UNIQUE, c1); CREATE UNIQUE INDEX i0 ON t0(0 || c1); INSERT INTO t0(c0, c1) VALUES (1, 2), (2, 1); INSERT INTO t0(c0) VALUES (1) ON CONFLICT(c0) DO UPDATE SET c1=excluded.c0; REINDEX; -- unexpected: UNIQUE constraint failed: index 'i0' Unexpectedly, the REINDEX causes an error. | ||||