SQLite

View Ticket
Login
Ticket Hash: 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: (text/x-fossil-wiki)
Beginning with version 3.8.7, the following SQL code results in an 
assertion fault while executing the final UPDATE statement:

<blockquote><verbatim>
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;
</verbatim></blockquote>

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: (text/x-fossil-wiki)
See also ticket [094d39a4c95ee4ab].