SQLite
View Ticket
Not logged in
Ticket UUID: 2ea3e9fe6379fc3f6ce7e090ce483c1a3a80d6c9
Title: Partial index causes assertion fault on UPDATE OR REPLACE
Status: Fixed Type: Code_Defect
Severity: Severe Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2014-04-13 19:28:14
Version Found In: 3.8.4.3
User Comments:
drh added on 2014-04-13 16:24:31:

The following script causes an assertion fault on all prior versions of SQLite that support partial indices:

CREATE TABLE t1(a,b);
CREATE UNIQUE INDEX t1ab ON t1(a,b);
CREATE INDEX t1b ON t1(b) WHERE b=1;
INSERT INTO t1(a,b) VALUES(123,456);
UPDATE OR REPLACE t1 SET b=789;

This bug was introduced with the addition of partial index support by check-in 478113f18b1d2860 on 2013-08-02 for SQLite version 3.8.0.