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

Informix Indexes should not use default names

    Details

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

      Informix 12.10.FC9DE, but should repro on just about every version of Informix

    • Sprint:

      Description

      Informix index names must begin with a letter. For reasons that elude me, they decided to create "unnamed" indexes (such as those that support constraints) in the format " NNN_XX", i.e. a space, followed by systables.tabid, followed by an incremental number.

      However, when liquibase records these indexes in the changelog, the space in front of the number is lost.

      How to fix this:

      Set DELIMIDENT.

      If you're generating a CREATE INDEX statement and the index name starts with a number, prepend a space and wrap in quotes.

      So:

      CREATE UNIQUE INDEX test1:informix.102_4 ON test1:informix.orders(customer_num)
      

      becomes:

      CREATE UNIQUE INDEX test1:informix." 102_4" ON test1:informix.orders(customer_num)
      

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated: