diffChangelog does not consider index field order
Description
Environment
Oracle 11g
Activity
Show:
Martin Aberle January 19, 2011 at 1:45 PM
Index order was corrected with CORE-808. The constraint field sort should be removed too in Diff.removeDuplicateIndexes().
generateChangeLog / diffChangelog generates a createIndex statement with the wrong order of the attributes (alphabetic order).
Example:
Index in the Database:
INK_M_KNFVZ
POS 1: ID
POS 2: TEILNEHMER
POS 3: TRANSAKTIONTYP
POS 4: INDIKATOR_TEST
Generated changeLog:
Same problem with the order of constraint fields:
Constraint C_PRPTY.UNQ_C_PRPTY_0:
POS 1: KEY
POS 2: CONTEXT
Generated changeLog: