BOOLEAN with precision doesn't work anymore with H2 database

[sfrevel]

Search first

• I searched and no similar issues were found

Description

I have the following column definition from an historical changeset. Don't ask me why there is a precision ...

<column name="COLUMNNAME" type="BOOLEAN(1)">
    <constraints nullable="false"/>
</column>

Which gives me the following Error with liquibase 4.21.1

Syntax error in SQL statement "CREATE TABLE TABELNAME (COLUMNNAME BOOLEAN[*](1) NOT NULL)"; expected "ARRAY, INVISIBLE, VISIBLE, NOT NULL, NULL, AS, DEFAULT, GENERATED, ON UPDATE, NOT NULL, NULL, AUTO_INCREMENT, DEFAULT ON NULL, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, COMMENT, PRIMARY KEY, UNIQUE, NOT NULL, NULL, CHECK, REFERENCES, AUTO_INCREMENT, ,, )"

Because formally I struggled with this Bug #3300 and an older Liquibase version I think there has to be a similar handling for the boolean datatype.

Steps To Reproduce

Define a column like this in a changeset

<column name="COLUMNNAME" type="BOOLEAN(1)">
    <constraints nullable="false"/>
</column>

Expected/Desired Behavior

Column with BOOLEAN(x) is correctly translated.

Liquibase Version

4.21.1

Database Vendor & Version

H2 2.1.214

Liquibase Integration

CLI, maven

Liquibase Extensions

No response

OS and/or Infrastructure Type/Provider

MacOS Ventura 13.3.1

Additional Context

No response

Are you willing to submit a PR?

• I'm willing to submit a PR (Thank you!)

[MalloD12]

Removed needs_guidance label, since @sfrevel already provides a PR for this issue. Thank you for that, @sfrevel!