It looks like changing an H2 column to not null requires you to set columnDataType which is not actually required in H2 syntax
see - http://www.h2database.com/html/grammar.html#alter_table_alter
columnDataType should only be required if your both changing the datatype and setting it to not null or nullable.
This should work
but currently the following is required
<dropNotNullConstraint tableName=“TEST” columnName=“TEST_COLUMN” schemaName=“TEST_SCHEMA” columnDataType=“VARCHAR(25)”/>
This seems dangerous because it could lead to someone inadvertently changing the data type when they only meant to drop the not null constraint.
Grant
-
Learn
-
Resources
-
Free Tools
OSS Risk Scanner Database DevOps Risk AssessmentCheat Sheets
Snowflake + Liquibase Databricks + Liquibase -
eBooks
6 Liquibase Community Risks & How to Avoid Guide: SOC 2 Compliance at the Database Layer Guide: Quantify the Value of Liquibase Secure -
Comparison Guides
Liquibase vs. Flyway Liquibase vs. Bytebase Liquibase Community vs Liquibase Secure
-
- Quickstart
- Get Started
- Documentation
- University
-
Resources
- Connect
- Contribute
- Join
- Blog