Re: [sqlite] Problematic new ALTER TABLE behaviour in 3.25.1

2018-09-25 Thread Brad Spencer
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" pro

Re: [sqlite] Problematic new ALTER TABLE behaviour in 3.25.0

2018-09-19 Thread Brad Spencer
On 2018-09-19 2:30 PM, Brad Spencer wrote: Disclaimer: I haven't yet tried this with the pre-release version of sqlite-3.25.1, but I wanted to report it before the 24 hours of that release notice expired. I grabbed https://www.sqlite.org/2018/sqlite-src-3250100.zip and tried this and result

[sqlite] Problematic new ALTER TABLE behaviour in 3.25.0

2018-09-19 Thread Brad Spencer
ing back and rewriting previous database schema patches that no longer run under sqlite-3.25.0. Perhaps at least there should be a pragma or configuration flag to turn this new behaviour off? -- Brad Spencer ___ sqlite-users mailing list sqlite-users@ma