H2 ALTER TABLE ADD COLUMN BEFORE/AFTER According to H2 syntax documentation available here I should be able to execute a query like:

ALTER TABLE EMPLOYEE ADD COLUMN SECOND_NAME VARCHAR (124) AFTER FIRST_NAME;


However apparently only this query works:

ALTER TABLE EMPLOYEE ADD COLUMN SECOND_NAME VARCHAR (124);


Is it a mistake in the documentation or am I missing something?
The BEFORE and AFTER parameters would be useful to me.
It works for me. The H2 change log says it was added in version 1.3.171. Here is the original bug

alter table credentials add column domain VARCHAR(255) after credentialType;


What didn't work for me was having multiple adds inside one alter.