The following script causes an assertion fault on all prior versions of
SQLite that support partial indices:
<blockquote><verbatim>
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;
</verbatim></blockquote>
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.

This page was generated in about
0.02s by
Fossil version 1.37 [814dfd5a9c] 2016-12-08 20:03:09