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?
CREATE TABLE [dbo].Name]
[id] CHAR(32) NOT NULL,
[value] DOUBLE NOT NULL,
CONSTRAINT [PK_TABLENAME] PRIMARY KEY ([id])