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!