Details

    • Type: New Feature
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects versions: 3.6.3
    • Fix versions: None
    • Components: Database Support
    • Environment:

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

    • Sprint:

      Description

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

      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:

      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:

      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))]
      
      address ADDRESS_T(132) NOT NULL
      

      should be

      address ADDRESS_T
      

        Attachments

          Activity

            People

            • Reporter:
              william.wheeler William Wheeler
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: