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

Support for row types

Description

Informix has the ability to create row types, both named and unnamed. This is an example of a named type:

1 2 3 4 5 6 7 create row type "informix".address_t ( address1 char(64), city char(32), state char(32), zipcode integer );

You can then use this to create tables with a standard for of address:

1 2 3 4 5 6 7 create table "informix".employee ( givenname char(32), familyname char(32), address "informix".address_t, phone char(32) );

As an upfront warning of defective behaviour in 3.6.3:

1 Reason: liquibase.exception.DatabaseException: Type (address_t) not found. [Failed SQL: CREATE TABLE test1:informix.employee (givenname CHAR(32), familyname CHAR(32), address ADDRESS_T(132) NOT NULL, phone CHAR(32))]
1 address ADDRESS_T(132) NOT NULL

should be

1 address ADDRESS_T

Environment

Informix 12.10.FC9DE (but probably an issue with any version after 9.0)

Status

Assignee

Unassigned

Reporter

William Wheeler

Labels

None

Components

Affects versions

3.6.3

Priority

Minor