| Ticket Hash: | d7c3f125c925c52237b5209a66c8a03ceec14378 | |||
| Title: | REINDEX results in "UNIQUE constraint failed" for generated column | |||
| Status: | Fixed | Type: | Code_Defect | |
| Severity: | Important | Priority: | Immediate | |
| Subsystem: | Unknown | Resolution: | Fixed | |
| Last Modified: | 2019-12-10 02:48:59 | |||
| Version Found In: | 3.30.0 | |||
| User Comments: | ||||
mrigger added on 2019-12-09 21:40:54:
(text/x-fossil-wiki)
Consider the following test case: <pre> CREATE TABLE t0(c0 AS (0 = UNLIKELY(c1)) UNIQUE, c1 TEXT); INSERT INTO t0(c1) VALUES (1), (0); REINDEX; -- UNIQUE constraint failed: t0.c0 </pre> Unexpectedly, the REINDEX results in a "UNIQUE constraint failed" error. | ||||