next »

[Benjamin G.]

Hi,

SCHEMA file (4db) are not correct for indexes when columns are created with option DESC.

e.g.: (dbschema)

  create index "informix".i01_tccsvt on "informix".tccsvt (numcli,datapl desc,heuapl desc) using btree ;

      (result 4db)

  </Table>
  <Table name="tccsvt" status="U">
    <Column name="numapl" ....
    <Index name="i01_tccsvt" indexConstraint="index" status="U" indexColumns="numcli"/>
  </Table>

missing columns  "datapl" and "heuapl"


Regards

[Romain W.]

Hi Benjamin,
I'll provide an answer to your request through the normal support process. I'll post a summary to the forum once the issue will be finalized. Thanks for understanding.
Regards,
Romain W.

[Romain W.]

Hi,
Just for information, a new defect has been posted on this (#GST-12778 - Columns referenced with keyword DESC on Index creation are not mentioned when extracting DB schema). Will be fixed in next version.
Thanks.
Best regards,
Romain W.