Liquibase diff ignores indexes on Oracle foreign key constraints

Description

During processing the database differences with liquibase.diff.DiffResult, the methods addMissingIndexChanges and addUnexpectedIndexChanges ignore indexes associated with foreign key constraints. Since Oracle does not generate indexes on foreign key constraints, the indexes are missing in a Liquibase generated database.

After removing the skip condition

the missing update steps will be generated correct for Oracle databases.

Environment

None

Activity

Show:
Nathan Voxland
October 3, 2013, 4:19 PM

Fixed as part of 3.0 changes. Tested against 3.0.6 and is working

Nathan Voxland
March 31, 2014, 2:28 PM

http://forum.liquibase.org/topic/bug-core-1236-should-be-reopened#49382000001055031 says it is still broken

QUOTE:
am working with liquibase on an Oracle database (11.2.0.1.0). Among the changes between two DB, we have added index on foreign keys which are not mentionned in the DIFF.

We are at version 3.1.1 so the problem should be fixed by [1] since version 3.0.6, but it still occurs. Do you have non regression test to assert this point is solved?

Reporter

Martin Aberle

Components

Affects versions

Priority

Major
Configure