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

Blocker
Configure