Migrate a not null column

[Sanju P Ommen]

Hi,

I have a table t1 with column c1 and c2 in both dev and test database. dev environment has 0 data but test environment has data.

I modified t1 in dev with a column c3 and is not null. Now i want to migrate the change to test environment.

In this case, we generally handle this by adding alter script with null condition and then update or migrate and then add the not null conditions, there should be a way to handle these exceptional flows in LiquiBase.

Thanks in advance