We're updating the issue view to help you get more done. 

SQL Server Generation script error

Description

I generated with generateChangeLog. The XML has errors in it. I have attached the file. It is because FULL is a reserved word. that was created in as a column name.

C:\Users\sss\Desktop\liquibase-3.6.2>liquibase.bat migrate
Starting Liquibase at Tue, 22 Jan 2019 12:09:25 CST (version 3.6.2 built at 2018-07-03 11:28:09)
Unexpected error running Liquibase: Incorrect syntax near the keyword 'Full'. [Failed SQL: CREATE TABLE FinalCTIMIDLAND (CID float(53), Manufacturer_Name nvarchar(255), Distributor_Name nvarchar(255), Customer_Name nvarchar(255), TankID nvarchar(255), TankType nvarchar(255), MonitorID nvarchar(255), Product nvarchar(255), Offset float(53), Length float(53), Width float(53), Height float(53), Diameter nvarchar(255), Capacity float(53), Full nvarchar(255), pct_full nvarchar(255), pct_empty nvarchar(255), InchesFull nvarchar(255))]
liquibase.exception.MigrationFailedException: Migration failed for change set C:/Temp/ChangeLog.xml::1548180320781-76::steve (generated):
Reason: liquibase.exception.DatabaseException: Incorrect syntax near the keyword 'Full'. [Failed SQL: CREATE TABLE FinalCTIMIDLAND (CID float(53), Manufacturer_Name nvarchar(255), Distributor_Name nvarchar(255), Customer_Name nvarchar(255), TankID nvarchar(255), TankType nvarchar(255), MonitorID nvarchar(255), Product nvarchar(255), Offset float(53), Length float(53), Width float(53), Height float(53), Diameter nvarchar(255), Capacity float(53), Full nvarchar(255),

pct_full nvarchar(255), pct_empty nvarchar(255), InchesFull nvarchar(255))]

Environment

Windows 10
SQL SERVER ENT 2017
mssql-jdbc-7.0.0.jre10.jar

Status

Assignee

Unassigned

Reporter

Stephen Coleman

Labels

None

Components

Affects versions

3.6.2

Priority

Major