/ Ticket Change Details
Login
Overview

Artifact ID: 65efc0ddbb746e77bca3e98445f70ae8468d4160ec677a7a71a1f79b3f46df44
Ticket: b41031ea2b5372378cb3d2d43cf9fe2a4a5c2510
ALTER TABLE returns an error on certain schemas
User & Date: drh 2018-09-16 20:03:33
Changes

  1. Change foundin to "3.25.0"
  2. Change icomment to:

    The newly enhanced ALTER TABLE in SQLite 3.25.0 hits an assertion fault when there are operations on an rtree virtual table in the body of the trigger.

    CREATE TABLE t1(a INTEGER PRIMARY KEY, b);
    CREATE VIRTUAL TABLE t2 USING rtree(id,x0,x1);
    CREATE TRIGGER r1 AFTER UPDATE ON t1 BEGIN
       DELETE FROM t2 WHERE id = OLD.a;
    END;
    ALTER TABLE t1 RENAME TO t3;
    
  3. Change login to "drh"
  4. Change mimetype to "text/x-fossil-wiki"
  5. Change severity to "Severe"
  6. Change status to "Open"
  7. Change title to "Assertion fault on ALTER TABLE"
  8. Change type to "Code_Defect"