MSSQL: precondition primaryKeyExists doesn't work

Description

PK ModelConfigurationDefinition_PK doesn't exist however Liquibase tries to drop it:

<changeSet author="xxx" id="18">
        <preConditions onFail="MARK_RAN">
            <primaryKeyExists tableName="ModelConfigurationDefinition"
                 primaryKeyName="ModelConfigurationDefinition_PK"/>
        </preConditions>
        <dropPrimaryKey tableName="ModelConfigurationDefinition"
            constraintName="ModelConfigurationDefinition_PK"/>
    </changeSet>

SEVERE 11/20/13 3:00 AM:liquibase: changelog.xml: changelog-5.10.001.000.xml::18::xxx: Change Set changelog-5.10.001.000.xml::18::xxx failed. Error: Error executing SQL ALTER TABLE [ModelConfigurationDefinition] DROP CONSTRAINT [ModelConfigurationDefinition_PK]: 'ModelConfigurationDefinition_PK' is not a constraint.
liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE [ModelConfigurationDefinition] DROP CONSTRAINT [ModelConfigurationDefinition_PK]: 'ModelConfigurationDefinition_PK' is not a constraint.

Environment

SQL Server 2008 R2

Activity

Show:

Nathan Voxland December 9, 2013 at 6:22 PM

Working for me. Probably fixed by another 3.0.7 bug

Fixed

Details

Reporter

Dmitry Gil

Fix versions

3.0.8

Affects versions

3.0.7

Priority

Critical

Created November 20, 2013 at 7:32 AM

Updated December 9, 2013 at 6:22 PM

Resolved December 9, 2013 at 6:22 PM

Configure