seed : 1155061234992720784
Use ".open FILENAME" to reopen on a persistent database
turso> CREATE TABLE t (
n REAL
);
CREATE TABLE t1 (
m TEXT,
d REAL
);
CREATE TRIGGER trg
BEFORE DELETE ON t
BEGIN
UPDATE t1
SET m = 'x'
WHERE m = 'y';
END;
ALTER TABLE t1 DROP COLUMN m;
sqlite:
sqlite> CREATE TABLE t (
n REAL
);
CREATE TABLE t1 (
m TEXT,
d REAL
);
CREATE TRIGGER trg
BEFORE DELETE ON t
BEGIN
UPDATE t1
SET m = 'x'
WHERE m = 'y';
END;
ALTER TABLE t1 DROP COLUMN m;
Runtime error: error in trigger trg after drop column: no such column: m
sqlite>