Cannot use array on h2 with liquibase while in postgres works perfectly

General Discussion
1

Hello,

I’m using this change set:

 <changeSet author=“marco_scarpa” id=“pg-101” dbms=“postgresql, h2”

               failOnError=“false”>

       

           

               

           

           

               

           

           

               

           

           

               

           

            <column  name=“sym_name_values” type=“VARCHAR(255) ARRAY” defaultValue=“NULL”>

               

           

       

   

In postgres the array is correctly created (i got INFO 07/05/18 19.07: liquibase: classpath:/db/changelog/db.changelog-master.xml: classpath:/db/changelog/db.changelog-master.xml::pg-101::marco_scarpa: Table SYM_NAMES created

INFO 07/05/18 19.07: liquibase: classpath:/db/changelog/db.changelog-master.xml: classpath:/db/changelog/db.changelog-master.xml::pg-101::marco_scarpa: ChangeSet classpath:/db/changelog/db.changelog-master.xml::pg-101::marco_scarpa ran successfully in 263ms).

In h2 i get such error:

INFO 07/05/18 19.19: liquibase: classpath:/db/changelog/db.changelog-master.xml: classpath:/db/changelog/db.changelog-master.xml::pg-101::marco_scarpa: Change set classpath:/db/changelog/db.changelog-master.xml::pg-101::marco_scarpa failed, but failOnError was false.  Error: Syntax error in SQL statement "CREATE TABLE PUBLIC.SYM_NAMES (LABEL VARCHAR(255) NOT NULL, PROFILE_PALLET VARCHAR(255) NOT NULL, MANDANTE VARCHAR(64) NOT NULL, UNIT VARCHAR(255), SYM_NAME_VALUES VARCHAR(255) ARRAY[*] DEFAULT NULL, CONSTRAINT PK_SYM_NAMES PRIMARY KEY (LABEL, PROFILE_PALLET, MANDANTE)) "; expected “FOR, UNSIGNED, NOT, NULL, AS, DEFAULT, GENERATED, NOT, NULL, AUTO_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, , )”; SQL statement:

CREATE TABLE PUBLIC.SYM_NAMES (label VARCHAR(255) NOT NULL, profile_pallet VARCHAR(255) NOT NULL, mandante VARCHAR(64) NOT NULL, unit VARCHAR(255), sym_name_values VARCHAR(255) ARRAY DEFAULT null, CONSTRAINT PK_SYM_NAMES PRIMARY KEY (label, profile_pallet, mandante)) [42001-191] [Failed SQL: CREATE TABLE PUBLIC.SYM_NAMES (label VARCHAR(255) NOT NULL, profile_pallet VARCHAR(255) NOT NULL, mandante VARCHAR(64) NOT NULL, unit VARCHAR(255), sym_name_values VARCHAR(255) ARRAY DEFAULT null, CONSTRAINT PK_SYM_NAMES PRIMARY KEY (label, profile_pallet, mandante))]

It looks it adds randomly ARRAY[*] to the query and I don’t know why.