MSSQLServer: 'REAL' dataype is returned with unnecessary size modifier during generateChangeLog

Description

TO REPRODUCE

  • Create a table with a column that has a datatype of 'REAL'

  • Use Liquibase 3.0.2 -> generateChangeLog vs. your database

  • Attempt to use the changelog.xml file to create the table in another database

EXPECTED RESULT

Table is recreated without issue

ACTUAL RESULT

Table creation fails with the following error:

SEVERE 8/1/13 11:32 AM:liquibase: Change Set Changelog/changelog.xml::1375373692960-2:ete failed. Error: Error executing SQL CREATE TABLE [dbo].[real_table_2] ([real_column] REAL(24)): Column, parameter, or variable #1: Cannot specify a column width on data type real.
liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[real_table_2] ([real_column] REAL(24)): Column, parameter, or variable #1: Cannot specify a column width on data type real.

NOTES

If you remove the width specifier and try again, the table is recreated without issue.

Environment

Liquibase Client: Windows 7 x64
Liquibase Install: 3.0.2
Database: SQL Server 2008 SP2 on Windows Server 2008

Reporter

Peter Pickerill

Fix versions

Affects versions

Priority

Major
Configure