Call 'Reorg table' after modifyDataType on DB2

Description

After the data type of a column is modified using modifyDataType, no Reorg Table is called on DB2.
This results in an error the next time the table is used.

Example:

Modify the data type of a column:
<modifyDataType
columnName="BASEQUANTITYAMOUNT"
newDataType="DECIMAL(12,4)"
tableName="STFBUS_ACCOUNTINGTYPE"/>

Use the table in a subsequent change set:
<addForeignKeyConstraint baseTableName="STFCRT_OFFERPOSITIONDISCOUNT" baseColumnNames="ACCOUNTINGTYPEID" referencedTableName="STFBUS_ACCOUNTINGTYPE" referencedColumnNames="ID" constraintName="FK_STFCRT_OFFERPOSDISCOUNT_001"/>

This results in the following error:
Error executing SQL ALTER TABLE STFCRT_OFFERPOSITIONDISCOUNT ADD CONSTRAINT FK_STFCRT_OFFERPOSDISCOUNT_001 FOREIGN KEY (ACCOUNTINGTYPEID) REFERENCES STFBUS_ACCOUNTINGTYPE (ID): DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016, SQLERRMC=7;SMDB.STFBUS_ACCOUNTINGTYPE, DRIVER=4.16.53

If I call the following SQL statement between those two change sets, everything is OK:
<sql>CALL SYSPROC.ADMIN_CMD('REORG TABLE STFBUS_ACCOUNTINGTYPE')</sql>

So i guess Reorg Table is not called by LiquiBase after the modifyDataType command.

Environment

Win7 x64, DB2 10.1

Status

Reporter

Marco Perazzo

Fix versions

Affects versions

Priority

Blocker
Configure