SQLite

Ticket Change Details
Login
Overview

Artifact ID: f06e8c9d7b4326051f6894fae7f87dfbacae4616a58df73a74f15bb0f3661387
Ticket: 17db54d7440281f2c24848f4571f83ab9fca1197
Unexpected error in DELETE with existing trigger
User & Date: mrigger 2019-08-14 19:47:19
Changes

  1. foundin changed to: "3.29.0"
  2. icomment:
    Consider the following example:
    
    <pre>
    CREATE TABLE t0(c0);
    CREATE TRIGGER tr0 AFTER DELETE ON t0 WHEN c0 BEGIN DELETE FROM t0; END;
    DELETE FROM t0; -- unexpected: no such column: c0
    </pre>
    
    The error that no column c0 exists is surprising, since it has not been deleted.
    
  3. login: "mrigger"
  4. mimetype: "text/x-fossil-wiki"
  5. severity changed to: "Critical"
  6. status changed to: "Open"
  7. title changed to: "Unexpected error in DELETE with existing trigger"
  8. type changed to: "Code_Defect"