ID 493743 - Downgrading a database from v29 to v28 does not update the schema, causing issues during the re-upgrade

 

Problem summary
Downgrading a database from v29 to v28 does not update the schema. This causes issues when trying to then re-upgrade since the changes the upgrade entails are already present, and MySQL throws an error.

Customer reported version
6.3.7

Customer reported platform

Steps to reproduce

1) Install Flix database v29 (Flix 6.3.7)
2) Downgrade to database v28 (Flix 6.3.6)

3) Re-upgrade to v29.

Expected behaviour
Database version and schema should be updated to match what is expected by Flix 6.3.6; reupgrading should work fine.


Actual behaviour
The database version is updated, but not the database schema. Upgrading will not be possible as it will cause MySQL to throw errors.

Reproduced by support
This bug has been reproduced in:
Flix 6.3.7