Uploaded image for project: 'Liquibase Core'
  1. CORE-3394

INTERVAL data type not handled correctly

    Details

    • Type: Bug
    • Status: Open
    • Priority: Blocker
    • Resolution: Unresolved
    • Affects versions: 3.6.3
    • Fix versions: None
    • Components: Database Support
    • Environment:

      Informix 12.10.FC9DE by probably will repro with any version after 9.0

    • Sprint:

      Description

      Given the following table:

      create table "informix".manufact
        (
          manu_code char(3),
          manu_name char(15),
          lead_time interval day(3) to day,
          primary key (manu_code)
        );
      

      Liquibase generates the following changelog:

          <changeSet author="wwheeler (generated)" id="1551952714417-9">
              <createTable tableName="manufact">
                  <column name="manu_code" type="CHAR(3)">
                      <constraints primaryKey="true" primaryKeyName="u103_7"/>
                  </column>
                  <column name="manu_name" type="CHAR(15)"/>
                  <column name="lead_time" type="INTERVAL DAY TO DAY(836)(836) day to day"/>
              </createTable>
          </changeSet>
      

      This is a problem:

      <column name="lead_time" type="INTERVAL DAY TO DAY(836)(836) day to day"/>
      
      Unexpected error running Liquibase: A syntax error has occurred. [Failed SQL: CREATE TABLE test1:informix.manufact (manu_code CHAR(3) NOT NULL, manu_name CHAR(15), lead_time INTERVAL DAY TO DAY(836)(836) DAY TO DAY(836) DAY TO DAY day to day, PRIMARY KEY (manu_code) CONSTRAINT u103_7)]
      

      lead_time INTERVAL DAY TO DAY(836)(836) DAY TO DAY(836) DAY TO DAY day to day

        Attachments

          Activity

            People

            • Reporter:
              william.wheeler William Wheeler
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: