On Tue, 28 Jun 2022 at 05:32, Julien Rouhaud <rjuju123@gmail.com> wrote:
I think that supporting at least a way to specify the logical order during the table creation should be easy to implement (there shouldn't be any question on whether it needs to invalidate any cache or what lock level to use), and could also be added in the initial submission without much extra efforts, which could help with the testing.
I think the meaning of “logical order” (well, the meaning it has for me, at least) implies that the logical order of a table after CREATE TABLE is the order in which the columns were given in the table creation statement.
If there needs to be a way of specifying the physical order separately, that is a different matter.
ALTER TABLE ADD … is another matter. Syntax there to be able to say BEFORE or AFTER an existing column would be nice to have. Presumably it would physically add the column at the end but set the logical position as specified.