/ Ticket Change Details
Login
Overview

Artifact ID: de9d04b2b31ffb9154cb5879f11f634829dcb465a2d7b9d1e6644566fa4d865d
Ticket: c2432ef9089ee73bd0d3885576c0e1f6b1ad02e9
Assertion fault due to column cache malfunction
User & Date: drh 2018-06-11 11:14:57
Changes

  1. Change icomment to:

    The following SQL causes an assertion fault in SQLite 3.19.0 and later:

    CREATE TABLE t1(a INTEGER PRIMARY KEY,b UNIQUE);
    CREATE INDEX x1 ON t1(-b=b);
    INSERT INTO t1 VALUES(1,5),(6,2);
    REPLACE INTO t1 SELECT b,0 FROM t1;
    

    The assertion faults begin with check-in [e6e36b288fdf2]. However, further analysis suggests that that check-in merely exposed the problem and is not the actual cause of the problem. The underlying problem appears to be that the column-cache is attempting to reuse the value of a register that was never initialized to that column in the first place.

    This fault was found by OSSFuzz.

  2. Change login to "drh"
  3. Change mimetype to "text/x-fossil-wiki"
  4. Change severity to "Critical"
  5. Change status to "Open"
  6. Change title to "Assertion fault due to column cache malfunction"
  7. Change type to "Code_Defect"