Problem with H2 and changing NULLS (dropNotNullConstraint/addNotNullConstraint)

General Discussion
1

When I use a changset like the following with H2 and any of the 1.9X versions of Liquibase

   
       
   

When I do an updateSQL I get the following
ALTER TABLE TEST_SCHEMA.TEST ALTER COLUMN  TEST_COLUMN null NULL;

which doesn’t work as it really needs to be
ALTER TABLE TEST_SCHEMA.TEST ALTER COLUMN  TEST_COLUMN set NULL;

Also the following
   
       
   

produced
ALTER TABLE TEST_SCHEMA.TEST ALTER COLUMN  TEST2_COLUMN null NOT NULL;

when what is required is
ALTER TABLE TEST_SCHEMA.TEST ALTER COLUMN  TEST2_COLUMN set NOT NULL;

These changesets work fine with Oracle so I assume it’s an issue with the H2 sql generation

2

It was just a H2 issue.  It is fixed for the upcoming 2.0.  For the 1.9 branch, you’ll have to fallback to the tags.

Thanks for reporting the issue

Nathan