SQLite
View Ticket
Not logged in
Ticket UUID: 43107840f1c02680075c490108fc61fe85649261
Title: Assertion fault on UPDATE
Status: Fixed Type: Code_Defect
Severity: Severe Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2014-11-05 15:45:09
Version Found In: 3.8.7
User Comments:
drh added on 2014-10-29 00:27:24:

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.


drh added on 2014-11-05 15:45:09:

See also ticket [094d39a4c95ee4ab].