A new topic, 'Bug in modifyColumn', has been made on a board you are watching.

You can see it at
http://liquibase.org/forum/index.php?topic=116.new#new

The text of the topic is shown below:

When using Liquibase to alter a column from nullable to not nullable I get an 
error.

The Liquibase xml is this:
Code:
        <modifyColumn tableName="ParameterGroupReference">
            <column name="PersistentEntityMetaDataID" type="gtSmallIntID">
                <constraints nullable="false" />
            </column>
        </modifyColumn>


Liquibase gives me this SQL:
Code:
ALTER TABLE [ParameterGroupReference] ALTER COLUMN PersistentEntityMetaDataID 
gtSmallIntID;


but I expected this SQL:
Code:
alter table ParameterGroupReference alter column PersistentEntityMetaDataID 
gtSmallIntID not null;


It seems as if Liquibase forgets about the constraints tag.

Problem occurs in both v 1.9.3 and v 1.9.4.
My dbms is MSSQL2K5

Unsubscribe to new topics from this board by clicking here: 
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0

Regards,
The LiquiBase Community Forum Team.
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user

Reply via email to