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

Informix BYTE datatype should not have (LENGTH)

    Details

    • 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:

      Description

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

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

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated: