Hi sqliters,

Is this a bug?

sqlite> SELECT sqlite_version();
3.25.1
sqlite> CREATE TABLE x(f1 integer NOT NULL PRIMARY KEY);
sqlite> CREATE VIEW y AS SELECT f1 AS f1 FROM x;
sqlite> CREATE TRIGGER t INSTEAD OF UPDATE OF f1 ON y BEGIN UPDATE x SET f1
= NEW.f1; END;
sqlite> CREATE TABLE z (f1 integer NOT NULL PRIMARY KEY);
sqlite> ALTER TABLE z RENAME TO z2;
Error: error in trigger t: no such column: NEW.f1

My expectation is the new alter table logic would notice this is an instead
of trigger where NEW has special significance and not block my attempt to
rename an unrelated table.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to