GenerateChangeLog on MSSQL exports a SMALLINT(5) - smallint does not allow precision

Description

GenerateChangeLog creates XML file with...(notice ORDER field):

<changeSet author="desarrollo (generated)" id="1371601920812-2">
<createTable tableName="SELECTION_PROCESS_CANDIDATES">
<column autoIncrement="true" name="ID" type="INT">
<constraints primaryKey="true" primaryKeyName="SELECTION_PROCESS_CANDIDATES_PK"/>
</column>
<column name="SELECTION_PROCESS_ID" type="INT">
<constraints nullable="false"/>
</column>
<column name="TYPE" type="VARCHAR(10)">
<constraints nullable="false"/>
</column>
<column name="RATING" type="INT">
<constraints nullable="false"/>
</column>
<column name="STATE" type="INT">
<constraints nullable="false"/>
</column>
<column name="ORDER" type="SMALLINT(5)"/>
<column name="SUBSCRIPTION_DATE" type="datetime">
<constraints nullable="false"/>
</column>
</createTable>
</changeSet>

But running UPDATE raises error since SMALLINT doesn't allow precision parameter.

Generating SQL from MS SQL Server Studio gives:

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SELECTION_PROCESS_CANDIDATES]') AND type in (N'U'))
BEGIN^M
CREATE TABLE [dbo].[SELECTION_PROCESS_CANDIDATES](
[ID] [int] IDENTITY(1,1) NOT NULL,
[SELECTION_PROCESS_ID] [int] NOT NULL,
[TYPE] [varchar](10) NOT NULL,
[RATING] [int] NOT NULL,
[STATE] [int] NOT NULL,
[ORDER] [smallint] NULL,
[SUBSCRIPTION_DATE] [datetime] NOT NULL,
CONSTRAINT [SELECTION_PROCESS_CANDIDATES_PK] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

Environment

MSSQL 2005 using JTDS Driver
Win7 + Java6
Liquibase 3.0.1

Reporter

Roman Garcia

Fix versions

Affects versions

Priority

Critical
Configure