[Liquibase-user] New Topic: Liquibase 2.0: java.sql.Types.DOUBLE problems on MSSQL 2008

[Liquibase Community Forum]

A new topic, 'Liquibase 2.0: java.sql.Types.DOUBLE problems on MSSQL 2008', has been made on a board you are watching.

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

The text of the topic is shown below:

I'm trying to run the following liquibase command on MSSQL 2008 and liquibase is generating SQL that the server doesn't like. I've also included the generated SQL below. In Liquibase 1.9.1 the datatype generated for the value column was FLOAT, rather than DOUBLE. Is there any workaround for this? Also, am I using the tool incorrectly or is this a bug?

Code: (Liquibase Command)
<createTable tableName="TableName">
<column name="id" type="char(32)">
<constraints primaryKey="true" nullable="false"/>
</column>
<column name="value" type="java.sql.Types.DOUBLE">
<constraints nullable="false"/>
</column>
</createTable>


Code: (Generated SQL)
CREATE TABLE [dbo].[TableName]
(
[id] CHAR(32) NOT NULL,
[value] DOUBLE NOT NULL,
CONSTRAINT [PK_FORMINSTANCEDATADECIMAL] PRIMARY KEY ([id])
)

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.