/ Ticket Change Details
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference
Overview

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

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

    Consider the following example:

    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
    

    The error that no column c0 exists is surprising, since it has not been deleted.

  3. Change login to "mrigger"
  4. Change mimetype to "text/x-fossil-wiki"
  5. Change severity to "Critical"
  6. Change status to "Open"
  7. Change title to "Unexpected error in DELETE with existing trigger"
  8. Change type to "Code_Defect"