Liquibase 4.8.0 Release Notes
Liquibase v4.8.0 is a major release.
See GitHub formatted release notes for more information. Full changelog: 4.7.1–4.8.0 (February 22, 2022)
This release includes the init hub
subcommand, Liquibase Pro support for MSSQL Server sqlcmd
utility, community-contributed pull requests, and Liquibase Open Source and Liquibase Pro bug fixes.
Notable Changes
Liquibase 4.8.0 introduces the following functionality:
- The
init hub
subcommand that connects your local Liquibase activity to Liquibase Hub and sets up the Liquibase environment to use Liquibase Hub. [DAT-8769]
- [PRO] The
sqlcmd
utility support to process complex SQL for MSSQL Server. Liquibase provides theliquibase.sqlcmd.conf
file to pass arguments to your executor when running Liquibase Pro. [DAT-7447]
Note: For more information, see Use Native Executors with Microsoft SQL Server.
- Changes to the behavior of the XML parser, which no longer allows referencing external DTD files for security reasons. If you use externally defined entities or any other potentially insecure XML feature in your changelogs, set
liquibase.secureParsing=false
. [PR#2384] [LB-2218]
Note: For more information about the ways to set the parameter, see Liquibase Parameters.
- The upgrade of the
postgresql
(from42.2.12
to42.3.2
) andh2
(from2.0.206
to2.1.210
) drivers that Liquibase includes in the installation package. If you use those drivers and upgrade an existing Liquibase installation, remove the earlier versions of drivers from theLIQUIBASE_HOME/lib
directory.
Enhancements
- Implemented the
SimpleObjectConstructor
interface for DB2 on z/OS [DAT-8580] - Included the CLI instructions on how to use the properties file with a nonstandard name when running the
init project
subcommand [DAT-9041] - Improved the output message for
init start-h2
when the H2 database driver is specified, but there is no connection detected [DAT-8992] - Added validation errors for the
enableCheckConstraint
,disableCheckConstraint
,dropPackage
,dropPackageBody
Change Types [DAT-9017] - [PR#2367] [Mike Olivas] Added example rollback scripts to the
example-changelog.sql
file [LB-2220] - [PR#1648] [Daniel Gray] Improved the exception error message for the
customChange
node with noclass
attribute [LB-1144] - [PR#2222] [msimko81] Added the offline mode support for the
rollback-sql <tag>
operation [LB-2198] - [PR#2273] [Tsvi Zandany] Added the autocomplete quality checks commands for macOS
- [PR#2308] [Valentin Blistin] Added the
close
method for theClassLoaderResourceAccessor
class [LB-2205]
Fixes
- Fixed the
renameSequence
Change Type generating an uppercase SQL instead of lowercase and causing failures with case-sensitive databases [LB-1763] - Fixed the
generate-changelog
anddiff
commands to show and generate a proper SQL with autoincrement for PostgreSQL [DAT-8779] - [PR#1320] [PR#2329] [Anatoly S] [Nathan Voxland] [Matteo Turra] Improved the UTF-8 character support in the
<sql>
tags [LB-562] - [PR#2139] [wziebicki] Improved the
UniqueConstraintSnapshotGenerator
class to add a table name to the Oracle database query so that the cache key can contain it, and the unique constraint can be read from cache [LB-2206] - [PR#2335] [erzsebet] Removed duplicated DATABASECHANGELOGLOCK SQL statements when running the
update-sql
command against a new database [LB-2208] - [PR#2505] [Nathan Voxland] [Dries Samyn] [erzsebet] Fixed the OSGI support with the
MANIFEST.MF
file in theliquibase-core-4.7.0.jar
file. The PR fixes PR#2361. - [PR#2366] [Steven Massaro] Made the
sp_rename
function to be lowercase when using MSSQL Server - [PR#2429] [Nathan Voxland] [Mirko Dostmann] [Alex Litovsky] Fixed the Ant and Apache Derby support. The PR fixes PR#2388 and PR#2391. [LB-2222]
- [PR#2397] [Nathan Voxland] [maxencelaurent] Implemented the logging of exceptions in the CDI integration. The PR fixes PR#2354. [LB-2223]
- [PR#2398] [Nathan Voxland] [urvanov-ru] Fixed the handling of schema snapshots with an underscore. The PR fixes PR#1604. [LB-2219]
- [PR#2340] [Nathan Voxland] [nickshoe] Enabled adding the
computed=true
columns with no type set in thecreateTable
Change Type. The PR fixes PR#2283. [LB-2215] - [PR#2372] [Nathan Voxland] [Henrik Sachse] [rburgst] Fixed the autoincrement syntax for H2 2.0 and later versions. The PR fixes PR#2362. [LB-2216]
- [PR#2549] [Nathan Voxland] [jenhae] Added validation errors for Liquibase and MSSQL Server if the
ordered
clause is specified in thecreateSequence
oralterSequence
Change Type. The PR fixes PR#2528. - [PR#2351] [Wesley Willard] [Joseph Cen] Fixed the handling of properties defined with different
dbms
filters. The PR fixes PR#2231. [LB-2217] - [PR#2122] [Tobias Liefke] Fixed the handling of the classpath for resources. The PR fixes PR#2121.
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: