Liquibase 4.7.1 Release Notes

Liquibase v4.7.1 is a patch release.

See GitHub formatted release notes for more information. Full changelog: 4.7.0–4.7.1 (January 21, 2022)

This patch release includes community-contributed pull requests, Liquibase Open Source bug fixes, and Liquibase Pro bug fixes.

Here is a closer look at what we improved in the latest release.

Known Issues

In version 4.7.0, users that have "edb" in connection URLs but are not using EnterpriseDB experienced errors that caused Liquibase to misinterpret the database dialect. This patch release resolves this issue along with several others.

Enhancements

Added a new quality check – RollbackRequired. The check detects when a changeset does not have a rollback. [DAT-8871]
Enabled SQL parser for the TableColumnLimit check to work with formatted SQL changelogs [DAT-8531]
Implemented the --auto-update quality check parameter, which allows automatic backup and updating of the liquibase.check-settings.conf file when new quality checks are available. [DAT-8752]
- CLI: --auto-update=[on|off]
- Liquibase properties file (liquibase.properties): liquibase.command.checks.show.autoUpdate: [on|off]
- [PRO] Environment variable: LIQUIBASE_COMMAND_CHECKS_SHOW_AUTO_UPDATE=[ON|OFF]

Note: You can use the property not only with the show command but any other quality checks command.

[PR#1932] [Sergeev Viktor] Enabled changeset execution details to be shown in the output [LB-1886]
[PR#2261] [Nathan Voxland] Marked the liquibase-maven-plugin logging configuration as deprecated [LB-2183]
[PR#2217] [Wesley Willard] [Marcono1234] Made lock granted time consistent with date executed time. Modified the list-locks output message. The PR fixes PR#2029. [LB-2126]
[PR#2293] [Nathan Voxland] [ThisOldDog] Added support for the additional information with "double" datatypes in MySQL. The PR fixes PR#2169. [LB-2195]
[PR#2359] [AlexanderSashchenko] Added validation errors for the SQLite and DB2 on z/OS databases [DAT-8906]
[PR#2348] [Steven Massaro] Updated the URLs in the CLI output to direct to the documentation website [DAT-8947]
[PR#2333] [Wesley Willard] Enabled property parsing in FormattedSqlChangeParser [DAT-4793]
[PR#2356] [Steven Massaro] Added the output message which points to the init project command if you miss a supported argument in any command [DAT-8641]

Fixes

[PR#2364] [Nathan Voxland] [M-Koers] Made EnterpriseDBDatabase detection less broad. The implementation of EnterpriseDBDatabase picked up database with "edb" in the URL instead of an actual EDB URL. The PR fixes PR#2363. [LB-2214]
Fixed quality checks with OBJECT_TYPES=TABLE, COLUMN, SEQUENCE specified in the same ObjectNameMustMatch rule to find all matches [DAT-8716]
Fixed the runWith=changeLogPropertyattribute not working in a formatted SQL changelog [DAT-4793]
[PR#2270] [Nathan Voxland] [Michael Kroll] Fixed the handling of the cacheSizeattribute in the createSequence and alterSequenceChange Types for MariaDB. The PR fixes PR#2147. [LB-2191]
[PR#2269] [Nathan Voxland] [Tsvi Zandany] Fixed the handling of the tag-exists command old syntax in Liquibase 4.4 and later (liquibase tag-exists myTag) to correctly convert the pattern into new versions. The PR fixes PR#2109. [LB-2192]
[PR#2188] [Cullen Coyle] Added the columnDataTypeattribute for the generated setColumnRemarkschangesets to fix an error in MySQL [LB-2199]
[#932] [Matthias Wuttke] Added support for sequences in MaxDB [LB-41]
[PR#2282] [AlexanderSashchenko] Fixed the drop column statement generator for DB2 on z/OS [DAT-8744]

Contributions

Our community has built a lot. Thanks to everyone who contributes and helps make the Liquibase community strong, including the following first-time contributors: