Liquibase: diffChangeLog on DB2 performing out of order steps

Description

Steps to recreate:

Create DB2 DB with DB2_2244.sql
Create DB2 DB with DB2_2245.sql
Generate diffChangeLog

Issue:

PK_IMP_STU_TRANSCR_ERR and P_ROLE_SUB_DOW_ADD_TO_PAY are being created first. This is incorrect because they already exist. Then, they are being delted. Then they are being created again, albeit in a difference fashion.

Expected Behavior:

Changeset 6 and 7 should not be generated.

Note: I performed the same steps with Oracle and the 6 and 7 Changesets in the DB2 diff changelog were not created in the Oracle diff changelog.

Environment

SUSE Linux running DB2

Status

Reporter

Kevin Chappell

Fix versions

Affects versions

Priority

Major
Configure