On 2018-09-19 2:30 p.m., Brad Spencer wrote:
In sqlite-3.25.0, the release notes say the following:
"Fix table rename feature so that it also updates references to the
renamed table in triggers and views."
...
However, because of this change, the "completely general" procedure on
the ALTER TABLE page no longer works.
>...
Does anybody have any thoughts on whether there needs to be a new
general procedure for performing table alterations that works with the
new ALTER TABLE behaviour?
$ ./sqlite3 :memory: < ~/external/sqlite3/trigger.sql
Before modifications
1|aaa
1|aaa
About to rename new_t2 to t2
Error: near line 34: error in trigger t1_trigger: no such table: main.t2
After modifications
Error: near line 45: no such table: main.t2
1|aaa
Error: near line 47: no such table: t2
Is there a bug in this new behaviour, or have I misunderstood the procedure?
Note that this appears to be independent from the other ALTER TABLE
issue that was repaired in 3.25.1.
Thanks.
--
Brad Spencer
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
