Hello, right now as a default behavior Liquibase commits transactions after each changelog. If there are multiple changesets for migration from version A to B and if one of the changesets fails, then the database will be in an inconsistent state neither version A nor version B can be deployed.
I am aware that for some databases due to DDL auto-commit, clean transactional migration may not be possible. But it is possible some other databases like PostgreSQL and all DDL and DML scripts can be combined in the same transaction and whenever one script is failed, all migrations scripts will be rolled back and the previous version can be deployed immediately.
So I am looking for a customization flag for migration to run all changesets in the same transaction for a better deployment process. Actually in Flyway group
flag is used for this purpose. I like to use Liquibase and this will be a good enhancement.
Thanks in advance.