Thursday, January 30, 2020, 12:24:40 PM, Dominique Devienne <ddevie...@gmail.com> wrote:
> The strange thing though, is that I can't repro on a small example. > Despite using not_there in the trigger, and doing DML and ALTER TABLE, > still doesn't fail the same way as in production. What could be the cause? > --DD I suspect it may only kick-in if you use ALTER TABLE to rename either a table or column. As I understand it, the old behaviour was to JUST rename the table/column; the new behaviour also scan triggers etc. and renames any references to the table/column as well. Since a new column cannot (shouldn't?) be referenced by a trigger, there's no real need to check them. Graham _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
