Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects versions: 3.6.2
    • Fix versions: None
    • Environment:

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

    • Sprint:

      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), ChangeLog2.xml pct_full nvarchar(255), pct_empty nvarchar(255), InchesFull nvarchar(255))]

        Attachments

          Activity

            People

            • Reporter:
              stephenscoleman Stephen Coleman
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: