SQLite

View Ticket
Login
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:

Consider the following test case:

CREATE TABLE t0(c0 AS (0 = UNLIKELY(c1)) UNIQUE, c1 TEXT);
INSERT INTO t0(c1) VALUES (1), (0);
REINDEX; -- UNIQUE constraint failed: t0.c0

Unexpectedly, the REINDEX results in a "UNIQUE constraint failed" error.