Uploaded image for project: 'Liquibase Core'
  1. CORE-3391

Informix BYTE datatype should not have (LENGTH)


    • Type: Bug
    • Status: Open
    • Priority: Blocker
    • Resolution: Unresolved
    • Affects versions: 3.6.3
    • Fix versions: None
    • Components: Database Support
    • Environment:

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

    • Sprint:


      Given this table:

      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:

          <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 name="stock_num" type="SMALLINT">
                      <constraints nullable="false"/>
                  <column name="manu_code" type="CHAR(3)">
                      <constraints nullable="false"/>
                  <column name="cat_descr" type="TEXT"/>
                  <column name="cat_picture" type="BYTE(2147483647)"/>
                  <column name="cat_advert" type="VARCHAR(255)"/>

      The problem is

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

      which should actually be

       <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.




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


              • Created: