|
2014-11-05
| ||
| 15:45 | • Ticket [43107840] Assertion fault on UPDATE status still Fixed with 3 other changes (artifact: 22c19255 user: drh) | |
| 15:44 | • Ticket [094d39a4] Assertion fault on CREATE TABLE ... AS SELECT ... status still Open with 6 other changes (artifact: e881c36f user: drh) | |
|
2014-10-29
| ||
| 01:13 | In the OP_Column opcode, when extracting a field that is past the end of a short record (because the row was originally inserted prior to ALTER TABLE ADD COLUMN) then make sure the output register is fully NULL and does not contain leftover flags (such as MEM_Ephem) from its previous use. Fix for ticket [43107840f1c02]. This is a cherrypick of check-in [24780f8ddc1683fc]. (check-in: 304ea6ba user: drh tags: branch-3.8.7) | |
| 00:58 | • Fixed ticket [43107840]: Assertion fault on UPDATE plus 5 other changes (artifact: 224c3ec2 user: drh) | |
| 00:58 | In the OP_Column opcode, when extracting a field that is past the end of a short record (because the row was originally inserted prior to ALTER TABLE ADD COLUMN) then make sure the output register is fully NULL and does not contain leftover flags (such as MEM_Ephem) from its previous use. Fix for ticket [43107840f1c02]. (check-in: 24780f8d user: drh tags: trunk) | |
| 00:27 | • New ticket [43107840] Assertion fault on UPDATE. (artifact: 0c3cdaf3 user: drh) | |
| 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:
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]. | ||||