modifyColumn does not create a not null restriction
Description
Environment
Windows XP
Activity
Show:
Nathan Voxland September 30, 2010 at 7:13 PM
modifyColumn got to be too difficult to manage because it was too open ended. It has been removed from liquibase 2.0 in favor of modifyDataType and other more specific changes. I'd suggest just using <sql> fow now
Example:
Liquibase changeset:
<modifyColumn tableName="lf_financing_scenario">
<column name="name" type="varchar2(1000)">
<constraints nullable="false"/>
</column>
</modifyColumn>
resulting SQL:
ALTER TABLE lf_financing_scenario MODIFY ( name varchar2(1000) );
The changeset has no effect in this case.