SQLite

Beginning with version 3.8.7, the following SQL code results in an assertion fault while executing the final UPDATE statement:

CREATE TABLE t1(a INTEGER PRIMARY KEY, b);
INSERT INTO t1(a,b) VALUES(10,'abc');
ALTER TABLE t1 ADD COLUMN c;
CREATE INDEX t1c ON t1(c);
INSERT INTO t1(a,b,c) VALUES(5,'def','ghi');

UPDATE t1 SET c=randomblob(10) WHERE c IS NULL;

This problem was discovered by Mozilla while trying to incorporate SQLite version 3.8.7 into Firefox. See https://bugzilla.mozilla.org/show_bug.cgi?id=1084437 for the original bug report.

See also ticket [094d39a4c95ee4ab].