|
Title: schema error v3.00.22 Post by: Benjamin G. on December 24, 2015, 10:00:36 am 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 Title: Re: schema error v3.00.22 Post by: Romain W. on January 07, 2016, 03:49:22 pm 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. Title: Re: schema error v3.00.22 Post by: Romain W. on January 13, 2016, 10:39:02 am 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. |