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

Artifact ID: dd9f8d3e0ee32e7e375831cb49806a84e4ebcea3773e7f8b16f27afe900d8d77
Ticket: 17db54d7440281f2c24848f4571f83ab9fca1197
Unexpected error in DELETE with existing trigger
User & Date: dan 2019-08-14 19:55:58
Changes

  1. Change icomment to:

    This seems to be working as designed. The "no such column" error refers to the "c0" in the trigger. In this context "old.c0" would work, but there is no column that can be referred to as just "c0".

    The error occurs when the DELETE is prepared, not when the trigger is created, as SQLite does not resolve column or table references when triggers and views are created, only when they are used. This can be surprising.

  2. Change login to "dan"
  3. Change mimetype to "text/x-fossil-wiki"
  4. Change priority to "Immediate"
  5. Change resolution to "Not_A_Bug"
  6. Change status to "Closed"
  7. Change subsystem to "Unknown"