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

Informix Indexes should not use default names

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:

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

becomes:

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

Environment

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

Status

Assignee

Unassigned

Reporter

William Wheeler

Labels

None

Components

Affects versions

3.6.3

Priority

Blocker