modifyColumn does not create a not null restriction

Description

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.

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

Out of Date

Details

Reporter

Affects versions

Priority

Created September 30, 2010 at 8:32 AM
Updated June 20, 2013 at 3:30 AM
Resolved October 25, 2010 at 3:45 PM