Liquibase dropDefaultValue causes errors on SQL Server 2005 (mssql)

General Discussion
1
    I have the following changset:
      1.       
      2.    
      3.    
      4.    
      5.        
      6.    
      When this is run against a SQL Server 2005 (mssql) database, liquibase threw a database exception:
      1. <p class="MsoNormal"




      2

      I created https://liquibase.jira.com/browse/CORE-1141 to track the issue


      Nathan

      3

      The code needs to be changed to support 2012 (version 11) but it should handle sql 2005 (version 9) shouldn’t it?

      Nathan

      4

      This problem stems from the logic in DropDefaultValueGenerator.generateSql(…).

      Right now the code assumes that any SQL server version that is not 2005 or 2008 is SQL server 2000.  If you add a third conditional to your productVersion check, it should work.

      5

      Hi


      I’m using SQL server 2012 and really need the code to support this new db version.