[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.
------------------------------------------------------------------------------

_______________________________________________
Liquibase-user mailing list
Liquibase-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/liquibase-user