INTERVAL data type not handled correctly
Description
Given the following table:
1
2
3
4
5
6
7
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:
1
2
3
4
5
6
7
8
9
<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:
1
<column name="lead_time" type="INTERVAL DAY TO DAY(836)(836) day to day"/>1
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
Environment
Informix 12.10.FC9DE by probably will repro with any version after 9.0
Status
Assignee
Unassigned
Reporter
William Wheeler
Labels
None
Components
Affects versions
3.6.3
Priority
BlockerConfigure