Upgrade from 4.8 to 4.27 filename issue

1

We have upgraded liquibase v4.8 to v4.27

With v4.8, The filename column in databasechangelog table had values like **/**db/changelog/procs/changelog.yaml

But with v4.27, the filenames are now db/changelog/procs/changelog.yaml

When we run liquibase update,

UPDATE DATABASECHANGELOG SET COMMENTS = ‘’, CONTEXTS = NULL, DATEEXECUTED = GETDATE(), DEPLOYMENT_ID = ‘1234’, EXECTYPE = ‘RERAN’, LABELS = NULL, MD5SUM = ‘9:2232’, ORDEREXECUTED = 1825 WHERE ID = ‘procs_1’ AND AUTHOR = ‘a’ AND FILENAME = ‘db/changelog/procs/changelog.yaml’

For the procs which are marked as runAlways= true, the DATABASECHANGELOG filename is
/db/changelog/procs/changelog.yaml and the above query doesnt update the DATABASECHANGELOG as the filename in the where condition doesnt match.

Is there any support provided for this issue by liquibase?

2

There are times where logic to reference filename are modified in the Liquibase code. I seem to recall a change in a recent version that removed the asterisks to simplify the path.

In these cases you would need to manually update the rows in your databasechangelog table to match the new functionality.

I have had to do this a few times over the years. One other time was when updating from 3.x to 4.x, which was a major change to filename references.