Including filenames containing the underscore (_) character

We are using Liquibase 4.31.1, open source, and are attempting a deployment of a changelog in yml format, using the include tag to reference individual .sql files that need to be run in order. The referenced files have similar names, but are individualized by the underscore character. For example: sqlfile_function.sql, sqlfile_procedure.sql, etc.

When executing Liquibase to run the yaml changelog, it was noted that the files did not run in the correct order. While troubleshooting the issue, however, we removed the _ character from the file names and the files then ran in the correct order.

We are wondering if this is a known or documented issue? I was not able to find anything by looking in the Liquibase documentation, so I wanted to try and gather more details about why this may be happening or if there is a known limitation.

Thank you!

Welcome to the forums @earlgreyj2 ! It sounds like a bug in how we determine file order. I recommend that you file an issue in the Liquibase GitHub repo. We’ll triage and prioritize it.

Thank you. I’ll do that

1 Like

Sounds like a BUG to me! Especially with the existence of the underscore (_) character in the file-names. That should make NO difference in the execution order AT ALL. This should be a BUG escalated to Liquibase Development!

Thanks for the feedback @ekalwa. We’re in agreement! That is why I recommended the original poster file an issue on our GitHub repo where all of issues are tracked in the open.