SQLite Forum

Apparent bug in ALTER TABLE
> IMHO this is definitely a bug.

Without getting into the whys and wherefores of your "bug" claim, do you have some complaint or improvement suggestion for how ALTER TABLE works after "PRAGMA legacy_alter_table = 1" is run or when the library is compiled with that as the default?

If your "bug" claim is a dispute with the legacy behavior, I would simply point out that there is an unknown number of library users who would be as dissatisfied as you, if not more so, were that behavior to conform to your wishes. There is an excellent chance that those users outnumber you by a lot.