SQLite Forum

ALTER TABLE new_X RENAME TO X issue.
Login
Thank you for the reply.
I am aware the solutions exist.
My intention is moving forward and probably help SQLite be a better product by pointing out potential issues or by giving some suggestions.

So that makes PRAGMA legacy_alter_table = TRUE; not an option for my intention, since with time goes on, software’s modern behavior will finally replace the legacy one.
I think the intermediate rename one will do the trick, and it’s nice idea to solve the issue, thank you for pointing this out, I didn’t see that before.

So if SQLite now behaves like that intentionally, at least part of the 12 steps for altering table in the document I mentioned before is incorrect.
The ‘Drop View’ operation in step 9 should probably move up to before step 7 the ALTER TABLE RENAME TO operation, since in step 7, the error I saw will probably occurs.