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
