We're updating the issue view to help you get more done. 

Informix BYTE datatype should not have (LENGTH)

Description

Given this table:

1 2 3 4 5 6 7 8 9 10 create table "informix".catalog ( catalog_num serial not null , stock_num smallint not null , manu_code char(3) not null , cat_descr text, cat_picture byte, cat_advert varchar(255,65), primary key (catalog_num) );

Liquibase generates this changelog:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 <changeSet author="wwheeler (generated)" id="1551952714417-2"> <createTable tableName="catalog"> <column autoIncrement="true" name="catalog_num" type="SERIAL"> <constraints primaryKey="true" primaryKeyName="u109_21"/> </column> <column name="stock_num" type="SMALLINT"> <constraints nullable="false"/> </column> <column name="manu_code" type="CHAR(3)"> <constraints nullable="false"/> </column> <column name="cat_descr" type="TEXT"/> <column name="cat_picture" type="BYTE(2147483647)"/> <column name="cat_advert" type="VARCHAR(255)"/> </createTable> </changeSet>

The problem is

1 <column name="cat_picture" type="BYTE(2147483647)"/>

which should actually be

1 <column name="cat_picture" type="BYTE"/>

Ironically, the preceding TEXT column is handled correctly.

You can download a free (requires registration) copy of Informix Innovator Edition or Developer Edition - both have limitations, but both will allow reproduction of this behaviour.

Environment

MacOS X, Informix 12.10.FC9DE (but I'm pretty sure this will repro on any version of Informix above 7.0)

Status

Assignee

Unassigned

Reporter

William Wheeler

Labels

None

Components

Affects versions

3.6.3

Priority

Blocker