search

ioana-nicolae / keycloak

Open Source Identity and Access Management For Modern Applications and Services
https://www.keycloak.org
Apache License 2.0
0 stars 0 forks source link

Update dependency org.liquibase:liquibase-core to v4 #260

Open mend-for-github-com[bot] opened 2 years ago

mend-for-github-com[bot] commented 2 years ago

This PR contains the following updates:

Package Type Update Change
org.liquibase:liquibase-core (source) compile major 3.5.5 -> 4.8.0

By merging this PR, the below issues will be automatically resolved and closed:

Severity CVSS Score CVE GitHub Issue
High 9.8 CVE-2022-0839 #237

Release Notes

liquibase/liquibase ### [`v4.8.0`](https://togithub.com/liquibase/liquibase/releases/tag/v4.8.0) [Compare Source](https://togithub.com/liquibase/liquibase/compare/v4.7.1...v4.8.0) #### Liquibase 4.8.0 release Please report any issues to . #### 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] **Note:** For more information, see [init hub](https://docs.liquibase.com/commands/liquibase-start/init-hub.html) and [Getting Started with Liquibase Hub](https://docs.liquibase.com/tools-integrations/liquibase-hub/setup.html). - \[PRO] The `sqlcmd` utility support to process complex SQL for MSSQL Server. Liquibase provides the `liquibase.sqlcmd.conf` file to pass arguments to your executor when running Liquibase Pro. \[DAT-7447] **Note:** For more information, see [Using the SQLCMD integration and runWith attribute with Liquibase Pro and MSSQL Server](https://docs.liquibase.com/concepts/changelogs/attributes/using-sqlcmd-integration.html). - 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](https://togithub.com/liquibase/liquibase/pull/2384)] \[LB-2218] **Note:** For more information about the ways to set the parameter, see [Command Parameters](https://docs.liquibase.com/commands/command-parameters.html). - The upgrade of the `postgresql` (from `42.2.12` to `42.3.2`) and `h2` (from `2.0.206` to `2.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 the `LIQUIBASE_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](https://togithub.com/liquibase/liquibase/pull/2367)] \[[Mike Olivas](https://togithub.com/molivasdat)] Added example rollback scripts to the `example-changelog.sql` file \[LB-2220] - \[[PR#​1648](https://togithub.com/liquibase/liquibase/pull/1648)] \[[Daniel Gray](https://togithub.com/danielthegray)] Improved the exception error message for the `customChange` node with no `class` attribute \[LB-1144] - \[[PR#​2222](https://togithub.com/liquibase/liquibase/pull/2222)] \[[msimko81](https://togithub.com/msimko81)] Added the offline mode support for the `rollback-sql ` operation \[LB-2198] - \[[PR#​2273](https://togithub.com/liquibase/liquibase/pull/2273)] \[[Tsvi Zandany](https://togithub.com/szandany)] Added the autocomplete quality checks commands for macOS - \[[PR#​2308](https://togithub.com/liquibase/liquibase/pull/2308)] \[[Valentin Blistin](https://togithub.com/Delir4um)] Added the `close` method for the `ClassLoaderResourceAccessor` 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` and `diff` commands to show and generate a proper SQL with autoincrement for PostgreSQL \[DAT-8779] - \[[PR#​1320](https://togithub.com/liquibase/liquibase/pull/1320)] \[[PR#​2329](https://togithub.com/liquibase/liquibase/pull/2329)] \[[Anatoly S](https://togithub.com/tolix)] \[[Nathan Voxland](https://togithub.com/nvoxland)] \[[Matteo Turra](https://togithub.com/matteoturra)] Improved the UTF-8 character support in the `` tags \[LB-562] - \[[PR#​2139](https://togithub.com/liquibase/liquibase/pull/2139)] \[[wziebicki](https://togithub.com/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](https://togithub.com/liquibase/liquibase/pull/2335)] \[[erzsebet](https://togithub.com/XDelphiGrl)] Removed duplicated DATABASECHANGELOGLOCK SQL statements when running the `update-sql` command against a new database \[LB-2208] - \[[PR#​2505](https://togithub.com/liquibase/liquibase/pull/2505)] \[[Nathan Voxland](https://togithub.com/nvoxland)] \[[Dries Samyn](https://togithub.com/driessamyn)] \[[erzsebet](https://togithub.com/XDelphiGrl)] Fixed the OSGI support with the `MANIFEST.MF` file in the `liquibase-core-4.7.0.jar` file. The PR fixes [PR#​2361](https://togithub.com/liquibase/liquibase/issues/2361). - \[[PR#​2366](https://togithub.com/liquibase/liquibase/pull/2366)] \[[Steven Massaro](https://togithub.com/StevenMassaro)] Made the `sp_rename` function to be lowercase when using MSSQL Server - \[[PR#​2429](https://togithub.com/liquibase/liquibase/pull/2429)] \[[Nathan Voxland](https://togithub.com/nvoxland)] \[[Mirko Dostmann](https://togithub.com/mirkobeine)] \[[Alex Litovsky](https://togithub.com/alexlitovsky)] Fixed the Ant and Apache Derby support. The PR fixes [PR#​2388](https://togithub.com/liquibase/liquibase/issues/2388) and [PR#​2391](https://togithub.com/liquibase/liquibase/issues/2391). \[LB-2222] - \[[PR#​2397](https://togithub.com/liquibase/liquibase/pull/2397)] \[[Nathan Voxland](https://togithub.com/nvoxland)] \[[maxencelaurent](https://togithub.com/maxencelaurent)] Implemented the logging of exceptions in the CDI integration. The PR fixes [PR#​2354](https://togithub.com/liquibase/liquibase/issues/2354). \[LB-2223] - \[[PR#​2398](https://togithub.com/liquibase/liquibase/pull/2398)] \[[Nathan Voxland](https://togithub.com/nvoxland)] \[[urvanov-ru](https://togithub.com/urvanov-ru)] Fixed the handling of schema snapshots with an underscore. The PR fixes [PR#​1604](https://togithub.com/liquibase/liquibase/issues/1604). \[LB-2219] - \[[PR#​2340](https://togithub.com/liquibase/liquibase/pull/2340)] \[[Nathan Voxland](https://togithub.com/nvoxland)] \[[nickshoe](https://togithub.com/nickshoe)] Enabled adding the `computed=true` columns with no type set in the `createTable` Change Type. The PR fixes [PR#​2283](https://togithub.com/liquibase/liquibase/issues/2283). \[LB-2215] - \[[PR#​2372](https://togithub.com/liquibase/liquibase/pull/2372)] \[[Nathan Voxland](https://togithub.com/nvoxland)] \[[Henrik Sachse](https://togithub.com/0x7d7b)] \[[rburgst](https://togithub.com/rburgst)] Fixed the autoincrement syntax for H2 2.0 and later versions. The PR fixes [PR#​2362](https://togithub.com/liquibase/liquibase/issues/2362). \[LB-2216] - \[[PR#​2549](https://togithub.com/liquibase/liquibase/pull/2549)] \[[Nathan Voxland](https://togithub.com/nvoxland)] \[[jenhae](https://togithub.com/jenhae)] Added validation errors for Liquibase and MSSQL Server if the `ordered` clause is specified in the `createSequence` or `alterSequence` Change Type. The PR fixes [PR#​2528](https://togithub.com/liquibase/liquibase/issues/2528). - \[[PR#​2351](https://togithub.com/liquibase/liquibase/pull/2351)] \[[Wesley Willard](https://togithub.com/wwillard7800)] \[[Joseph Cen](https://togithub.com/JosephCen)] Fixed the handling of properties defined with different `dbms` filters. The PR fixes [PR#​2231](https://togithub.com/liquibase/liquibase/issues/2231). \[LB-2217] - \[[PR#​2122](https://togithub.com/liquibase/liquibase/pull/2122)] \[[Tobias Liefke](https://togithub.com/liefke)] Fixed the handling of the classpath for resources. The PR fixes [PR#​2121](https://togithub.com/liquibase/liquibase/issues/2121). **Full Changelog**: https://github.com/liquibase/liquibase/compare/v4.7.1...v4.8.0 ##### Get Certified Learn all the Liquibase fundamentals from free online courses by Liquibase experts and see how to apply them in the real world at . ##### Read the Documentation Please check out and contribute to the continually improving docs, now at . ##### Meet the Community Our community has built a lot. From extensions to integrations, you’ve helped make Liquibase the amazing open source project that it is today. Keep contributing to making it stronger: - [Contribute code](https://www.liquibase.org/development/contribute.html) - [Make doc updates](https://togithub.com/liquibase/liquibase.github.com/tree/master/documentation) - [Help by asking and answering questions](https://forum.liquibase.org/) - [Set up a chat with the Product team](https://calendly.com/liquibase-outreach/product-feedback) ##### Our first-time contributors - [Anatoly S](https://togithub.com/tolix) - [wziebicki](https://togithub.com/wziebicki) - [msimko81](https://togithub.com/msimko81) - [Dries Samyn](https://togithub.com/driessamyn) - [Mirko Dostmann](https://togithub.com/mirkobeine) - [maxencelaurent](https://togithub.com/maxencelaurent) - [urvanov-ru](https://togithub.com/urvanov-ru) - [nickshoe](https://togithub.com/nickshoe) - [Joseph Cen](https://togithub.com/JosephCen) ##### Thanks to everyone who helps make the Liquibase community strong! ### [`v4.7.1`](https://togithub.com/liquibase/liquibase/releases/tag/v4.7.1) [Compare Source](https://togithub.com/liquibase/liquibase/compare/v4.7.0...v4.7.1) #### Liquibase 4.7.1 is a patch release Please report any issues to ##### 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.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](https://togithub.com/liquibase/liquibase/pull/1932)] \[[Sergeev Viktor](https://togithub.com/sergeevik)] Enabled changeset execution details to be shown in the output \[LB-1886] - \[[PR#​2261](https://togithub.com/liquibase/liquibase/pull/2261)] \[[Nathan Voxland](https://togithub.com/nvoxland)] Marked the `liquibase-maven-plugin` logging configuration as deprecated \[LB-2183] - \[[PR#​2217](https://togithub.com/liquibase/liquibase/pull/2217)] \[[Wesley Willard](https://togithub.com/wwillard7800)] \[[Marcono1234](https://togithub.com/Marcono1234)] Made lock granted time consistent with date executed time. Modified the `listLocks` output message. The PR fixes [PR#​2029](https://togithub.com/liquibase/liquibase/issues/2029). \[LB-2126] - \[[PR#​2293](https://togithub.com/liquibase/liquibase/pull/2293)] \[[Nathan Voxland](https://togithub.com/nvoxland)] \[[ThisOldDog](https://togithub.com/ThisOldDog)] Added support for the additional information with "double" datatypes in MySQL. The PR fixes [PR#​2169](https://togithub.com/liquibase/liquibase/issues/2169). \[LB-2195] - \[[PR#​2359](https://togithub.com/liquibase/liquibase/pull/2359)] \[[AlexanderSashchenko](https://togithub.com/AlexanderSashchenko)] Added validation errors for the SQLite and DB2 on z/OS databases \[DAT-8906] - \[[PR#​2348](https://togithub.com/liquibase/liquibase/pull/2348)] \[[Steven Massaro](https://togithub.com/StevenMassaro)] Updated the URLs in the CLI output to direct to the documentation website \[DAT-8947] - \[[PR#​2333](https://togithub.com/liquibase/liquibase/pull/2333)] \[[Wesley Willard](https://togithub.com/wwillard7800)] Enabled property parsing in `FormattedSqlChangeParser` \[DAT-4793] - \[[PR#​2356](https://togithub.com/liquibase/liquibase/pull/2356)] \[[Steven Massaro](https://togithub.com/StevenMassaro)] 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](https://togithub.com/liquibase/liquibase/pull/2364)] \[[Nathan Voxland](https://togithub.com/nvoxland)] \[[M-Koers](https://togithub.com/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](https://togithub.com/liquibase/liquibase/issues/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=changeLogProperty` attribute not working in a formatted SQL changelog \[DAT-4793] - \[[PR#​2270](https://togithub.com/liquibase/liquibase/pull/2270)] \[[Nathan Voxland](https://togithub.com/nvoxland)] \[[Michael Kroll](https://togithub.com/mickroll)] Fixed the handling of the `cacheSize` attribute in the `createSequence` and `alterSequence` Change Types for MariaDB. The PR fixes [PR#​2147](https://togithub.com/liquibase/liquibase/issues/2147). \[LB-2191] - \[[PR#​2269](https://togithub.com/liquibase/liquibase/issues/2109)] \[[Nathan Voxland](https://togithub.com/nvoxland)] \[[Tsvi Zandany](https://togithub.com/szandany)] Fixed the handling of the `tag-exists` command old syntax in Liquibase 4.4 and later (`liquibase tagExists myTag`) to correctly convert the pattern into new versions. The PR fixes [PR#​2109](https://togithub.com/liquibase/liquibase/issues/2109). \[LB-2192] - \[[PR#​2188](https://togithub.com/liquibase/liquibase/pull/2188)] \[[Cullen Coyle](https://togithub.com/coylecullen)] Added the `columnDataType` attribute for the generated `setColumnRemarks` changesets to fix an error in MySQL \[LB-2199] - \[[#​932](https://togithub.com/liquibase/liquibase/pull/932)] \[[Matthias Wuttke](https://togithub.com/wuttke)] Added support for sequences in MaxDB \[LB-41] - \[[PR#​2282](https://togithub.com/liquibase/liquibase/pull/2282)] \[[AlexanderSashchenko](https://togithub.com/AlexanderSashchenko)] Fixed the drop column statement generator for DB2 on z/OS \[DAT-8744] **Full Changelog**: https://github.com/liquibase/liquibase/compare/v4.7.0...v4.7.1 ##### Get Certified Learn all the Liquibase fundamentals from free online courses by Liquibase experts and see how to apply them in the real world at . ##### Read the Documentation Please check out and contribute to the continually improving docs, now at . ##### Meet the Community Our community has built a lot. From extensions to integrations, you’ve helped make Liquibase the amazing open source project that it is today. Keep contributing to make it stronger: - [Contribute code](https://www.liquibase.org/development/contribute.html) - [Make doc updates](https://togithub.com/liquibase/liquibase.github.com/tree/master/documentation) - [Help by asking and answering questions](https://forum.liquibase.org/) - [Set up a chat with the Product team](https://calendly.com/liquibase-outreach/product-feedback) ##### Our first-time contributors - [Sergeev Viktor](https://togithub.com/sergeevik) - [](https://togithub.com/philhinco)[Marcono1234](https://togithub.com/Marcono1234) - [Michael Kroll](https://togithub.com/mickroll) - [ThisOldDog](https://togithub.com/ThisOldDog) - [Cullen Coyle](https://togithub.com/coylecullen) - [Matthias Wuttke](https://togithub.com/wuttke) ##### Thanks to everyone who helps make the Liquibase community strong! ### [`v4.7.0`](https://togithub.com/liquibase/liquibase/releases/tag/v4.7.0) [Compare Source](https://togithub.com/liquibase/liquibase/compare/v4.6.2...v4.7.0) #### Liquibase 4.7.0 release Please report any issues to ##### Notable Changes Liquibase 4.7.0 introduces the `init` command with the `project` and `start-h2` subcommands. - The `init project` subcommand helps to set configuration files for using Liquibase or, if you already use Liquibase, create new project files with minimal input. \[DAT-8640] - The `init start-h2` subcommand helps to start the included in-memory H2 database. The subcommand needs to be run in a new terminal window. \[DAT-8945] **Note:** For more information and examples of using `init` project, see [init project](https://docs.liquibase.com/commands/liquibase-start/init-project.html). Additionally, we have updated the Liquibase Getting Started tutorials, sample changelog files, and the example H2 database in the installation package. From now on, you can use sample SQL, XML, JSON, and YAML changelog files with the corresponding changesets and the latest version of H2. \[LB-2177] \[LB-2174] **Note:** Check Liquibase [Getting Started](https://docs.liquibase.com/start/getting-started-with-liquibase-and-sql-on-windows.html) to see more details. ##### Enhancements - \[PRO] Improved the output of the `rollback-one-update` command \[DAT-7590] - \[[PR#​2244](https://togithub.com/liquibase/liquibase/pull/2244)] \[[Tsvi Zandany](https://togithub.com/szandany)] Enabled the use of the `jdbc:edb` URL for Liquibase to recognize EnterpriseDB \[LB-2185] - \[[PR#​2225](https://togithub.com/liquibase/liquibase/pull/2225)] \[[Nathan Voxland](https://togithub.com/nvoxland)] \[[Konstantin](https://togithub.com/catholic-indulgence-vaper)] Enabled the use of lowercase `sys.synonyms` objects for the `generate-changelog` and `diff-changelog` commands in Liquibase and SQL Server. The PR fixes [PR#​2044](https://togithub.com/liquibase/liquibase/issues/2044). \[LB-2175] - Added DB2 on z/OS database type and Java classes for Liquibase \[DAT-8575] - Upgraded H2 to the later version – 2.0.206 - \[[PR#​2197](https://togithub.com/liquibase/liquibase/pull/2197)] \[[Andrii Tytarchuk](https://togithub.com/andrulban)] Added optional SQL Plus properties to the `liquibase.sqlplus.conf` file and put the file in the `examples/sql` folder \[DAT-7618] - liquibase.sqlplus.args - liquibase.sqlplus.keep.temp.path - liquibase.sqlplus.keep.temp.name - \[[PR#​2215](https://togithub.com/liquibase/liquibase/pull/2215)] \[[Nathan Voxland](https://togithub.com/nvoxland)] Improved MySQL `loadData` performance \[LB-2173] ##### Fixes - Fixed the `generateChangeLog` wrong dependency order: the `addPrimaryKey` Change Type appeared before its base table in PostgreSQL \[DAT-8256] - Fixed the quality checks settings file to be created using both relative and absolute paths \[DAT-8275] - Fixed quality checks reporting only the first failure for a changeset to report all failures in outputs \[DAT-8630] - \[[PR#​2066](https://togithub.com/liquibase/liquibase/pull/2066)] \[[smainz](https://togithub.com/smainz)] Fixed the `loadData` Change Type to recognize CSV files when loading data with the path that contains a dot character ('.') \[LB-2178] - \[[PR#​2071](https://togithub.com/liquibase/liquibase/pull/2071)] \[[Nicolas Humblot](https://togithub.com/nhumblot)] \[[Philipp](https://togithub.com/philhinco)] Fixed the `addNotNullConstraint` Change Type causing the "Data too long" error message. The PR fixes [PR#​1054](https://togithub.com/liquibase/liquibase/issues/1054). \[LB-2187] - \[[PR#​2073](https://togithub.com/liquibase/liquibase/pull/2073)] \[[smainz](https://togithub.com/smainz)] Fixed the `relativeToChangelogFile` attribute for `loadData`, `createProcedure`, and `createView` Change Types \[LB-2179] - \[[PR#​2228](https://togithub.com/liquibase/liquibase/pull/2228)] \[[Nathan Voxland](https://togithub.com/nvoxland)] Updated the logic of the foreign key names that are not always unique \[LB-2176] - \[[PR#​2081](https://togithub.com/liquibase/liquibase/pull/2081)] \[[Jakub Herkel](https://togithub.com/jherkel)] Fixed OSGI support (manifest and class loading) \[LB-2184] - \[[PR#​2192](https://togithub.com/liquibase/liquibase/pull/2192)] \[[Andrii Tytarchuk](https://togithub.com/andrulban)] Fixed `COLUMN_SIZE` for the PostgreSQL `NUMERIC[]` datatype *** **Full Changelog**: https://github.com/liquibase/liquibase/compare/v4.6.2...v4.7.0 ##### Get Certified Learn all the Liquibase fundamentals from free online courses by Liquibase experts and see how to apply them in the real world at . ##### Read the Documentation Please check out and contribute to the continually improving docs, now at . ##### Meet the Community Our community has built a lot. From extensions to integrations, you’ve helped make Liquibase the amazing open source project that it is today. Keep contributing to make it stronger: - [Contribute code](https://www.liquibase.org/development/contribute.html) - [Make doc updates](https://togithub.com/liquibase/liquibase.github.com/tree/master/documentation) - [Help by asking and answering questions](https://forum.liquibase.org/) - [Set up a chat with the Product team](https://calendly.com/liquibase-outreach/product-feedback) ##### Our first-time contributors - [Nicolas Humblot](https://togithub.com/nhumblot) - [Philipp](https://togithub.com/philhinco) - [Konstantin](https://togithub.com/catholic-indulgence-vaper) - [Jakub Herkel](https://togithub.com/jherkel) ##### Thanks to everyone who helps make the Liquibase community strong! ### [`v4.6.2`](https://togithub.com/liquibase/liquibase/releases/tag/v4.6.2) [Compare Source](https://togithub.com/liquibase/liquibase/compare/v4.6.1...v4.6.2) #### Liquibase 4.6.2 is a patch release Please report any issues to ##### Notable Changes Liquibase 4.6.2 introduces the multiple objects quality check that allows you to define and check the naming pattern for multiple types of objects rather than one type of object. For example, you do not want to have a dash in the table, column, and sequence names. With the multiple objects check, you can specify a pattern to check for dashes and choose tables, columns, and sequences as the objects to check. In version 4.6.2, the check is available for: - Table - Column - Sequence **Note:** For more information, see [Multiple Objects Quality Check](https://docs.liquibase.com/commands/community/quality-checks/multiple-objects.html) \[DAT-8444] ##### The logging of SQL statements and execution output Liquibase 4.6.2 includes the `liquibase.sql.logLevel` configuration option to control the level at which SQL is logged. The default value is `FINE`. You can run the `--sql-log-level` parameter with the `--log-level ` parameter in the CLI: ```text liquibase --sql-log-level --log-level= --log-file=log.txt update --changelog-file= ``` You can also set the parameter as follows: - `liquibase.sql.logLevel: ` in your `liquibase.properties` file - `LIQUIBASE_SQL_LOG_LEVEL=` as an environment variable \[[PR#​1520](https://togithub.com/liquibase/liquibase/pull/1520)] \[[nvoxland](https://togithub.com/nvoxland)] ##### An additional `liquibase_libs` directory When you run Liquibase in the CLI, the executables generate a classpath with the `.jar` files from the `LIQUIBASE_HOME` and `LIQUIBASE_HOME/lib` directories. Liquibase 4.6.2 adds the ability to load an additional directory of `liquibase_libs` in the current working directory to the classpath. With the `liquibase_libs` directory located in the `/lib` directory, projects can have separate extensions, drivers, and versions specific to a project \[[PR#​2015](https://togithub.com/liquibase/liquibase/pull/2015)] \[[mcred](https://togithub.com/mcred)] ##### The `validate` command in automation From now on, the exit code for the `validate` command running in automation shows `1` when there is an error. The PR fixes [PR#​1006](https://togithub.com/liquibase/liquibase/issues/1006). \[[PR#​2185](https://togithub.com/liquibase/liquibase/pull/2185)] \[[nvoxland](https://togithub.com/nvoxland)] \[[christf](https://togithub.com/christf)] ##### Enhancements - \[PRO] Added the ability to configure the `DDL_LOCK_TIMEOUT` parameter for Oracle without SQL Plus and define the connection timeout. You can configure `DDL_LOCK_TIMEOUT` as follows: - `liquibase.ddlLockTimeout: ` in your `liquibase.properties` file - `--ddl-lock-timeout=` as a CLI global parameter - `LIQUIBASE_DDL_LOCK_TIMEOUT=` as an environment variable \[DAT-7649] - Improved the output of the `SqlUserDefinedPatternCheck` quality check copy \[DAT-8492] - \[[PR#​1817](https://togithub.com/liquibase/liquibase/pull/1817)] \[[stalbrecht](https://togithub.com/stalbrecht)] Added the `MSSQLDatabase` specific error evaluation when creating DATABASECHANGELOGLOCK table - \[[PR#​2180](https://togithub.com/liquibase/liquibase/pull/2180)] \[[nvoxland](https://togithub.com/nvoxland)] \[[eldadko](https://togithub.com/eldadko)] Added support for MySQL function indexes. The PR fixes [PR#​1626](https://togithub.com/liquibase/liquibase/issues/1626). - \[[PR#​928](https://togithub.com/liquibase/liquibase/pull/928)] \[[CORE-931](https://liquibase.jira.com/browse/CORE-931)] \[[RG9](https://togithub.com/RG9)] Added support for the `NOT NULL` constraint with an initial default value in the `addColumn` Change Type ##### Fixes - \[[PR#​2173](https://togithub.com/liquibase/liquibase/pull/2173)] \[[wwillard7800](https://togithub.com/wwillard7800)] \[[deci260](https://togithub.com/deci260)] Fixed the issue with handling multi-column indexes during the JSON snapshot. The PR fixes [PR#​1260](https://togithub.com/liquibase/liquibase/issues/1260). - \[[PR#​1793](https://togithub.com/liquibase/liquibase/issues/1793)] \[[janjicandjelka8](https://togithub.com/janjicandjelka8)] Fixed the handling of the `remarks` attribute in a primary key column tag for MariaDB - \[[PR#​1894](https://togithub.com/liquibase/liquibase/pull/1894)] \[[KushnirykOleh](https://togithub.com/KushnirykOleh)] Fixed the time data type to be precise for PostgreSQL. The PR fixes [PR#​1774](https://togithub.com/liquibase/liquibase/issues/1774). - \[[PR#​1970](https://togithub.com/liquibase/liquibase/pull/1970)] \[[nvoxland](https://togithub.com/nvoxland)] Fixed the handling of the `addColumn` Change Type in SQLite - \[[PR#​1995](https://togithub.com/liquibase/liquibase/issues/1995)] \[[szandany](https://togithub.com/szandany)] Fixed the `generate-changelog` command to generate the `NUMERIC[]` data type for PostgreSQL correctly - \[[PR#​1990](https://togithub.com/liquibase/liquibase/issues/1990)] \[[JayWelborn](https://togithub.com/JayWelborn)] Fixed the SQL generated by the `alterSequence` Change Type to be compatible with the Oracle, PostgreSQL, MariaDB, and MSSQL databases - \[[PR#​2020](https://togithub.com/liquibase/liquibase/pull/2020)] \[[nvoxland](https://togithub.com/nvoxland)] \[[dewa-actico](https://togithub.com/dewa-actico)] Fixed the handling of nested changelog preconditions. The PR fixes [PR#​1624](https://togithub.com/liquibase/liquibase/issues/1624). - Fixed the naming of the checks settings file shown as null if the file was corrupted \[DAT-8553] - \[[PR#​2021](https://togithub.com/liquibase/liquibase/pull/2021)] \[[nvoxland](https://togithub.com/nvoxland)] \[[zamani84](https://togithub.com/zamani84)] Fixed the issue with Liquibase escaping the backslash in values stored in objects. The PR fixes [PR#​1598](https://togithub.com/liquibase/liquibase/issues/1598). - \[[PR#​2083](https://togithub.com/liquibase/liquibase/issues/2083)] \[[jamey-clari](https://togithub.com/jamey-clari)] Enabled the update operations to continue if the DATABASECHANGELOGLOCK table already exists, which helps to serialize all processes following schema creation. - \[[PR#​2167](https://togithub.com/liquibase/liquibase/pull/2167)] \[[nvoxland](https://togithub.com/nvoxland)] \[[obovsunivskyii](https://togithub.com/obovsunivskyii)] Fixed the `--verbose` flag used in the `unexpected-changesets` command. The PR fixes [PR#​1987](https://togithub.com/liquibase/liquibase/issues/1987). - \[[PR#​2168](https://togithub.com/liquibase/liquibase/pull/2168)] \[[nvoxland](https://togithub.com/nvoxland)] \[[gilles-gosuin](https://togithub.com/gilles-gosuin)] Fixed the parsing logic for `YAMLChangelogParser` and `changeLogId` in a Map. The PR fixes [PR#​1988](https://togithub.com/liquibase/liquibase/issues/1988). - \[[PR#​2102](https://togithub.com/liquibase/liquibase/pull/2102)] \[[prakashseervi](https://togithub.com/prakashseervi)] Implemented the handling of the `GENERATED ALWAYS AS` clause while creating a table for PostgreSQL - \[[PR#​2029](https://togithub.com/liquibase/liquibase/issues/2029)] \[[Marcono1234](https://togithub.com/Marcono1234)] Fixed the `LOCKGRANTED` column to include time zone information in the DATABASECHANGELOGLOCK table - \[[PR#​2059](https://togithub.com/liquibase/liquibase/pull/2059)] \[[wardvijf](https://togithub.com/wardvijf)] Fixed the support for custom `DB2Database` implementations. The PR fixes [PR#​2058](https://togithub.com/liquibase/liquibase/issues/2058). - \[[PR#​2171](https://togithub.com/liquibase/liquibase/pull/2171)] \[[logantracyo](https://togithub.com/logantracyo)] Fixed typos in the `ColumnConfig.java` documentation - \[[PR#​2189](https://togithub.com/liquibase/liquibase/pull/2189)] \[[nvoxland](https://togithub.com/nvoxland)] Fixed the classpath to include files with the `relativeToChangelog=true` parameter for Spring Boot - \[[PR#​2216](https://togithub.com/liquibase/liquibase/pull/2216)] \[[tkalmar](https://togithub.com/tkalmar)] Fixed the log message for PostgreSQL versions - \[PRO] Fixed the `snapshot` command failing against CockroachDB with the Liquibase Pro license key applied \[DAT-8253] - Fixed the dependency order for a changelog file with the `addPrimaryKey` Change Type generated by the `generate-changelog` command for PostgreSQL \[DAT-8256] - \[PRO] Fixed the following environment variables `LIQUIBASE_COMMAND_CHECKS_CONFIGURE_CHECKS_SETTINGS_FILE`, `LIQUIBASE_COMMAND_CHECKS_RUN_CHECKS_SETTINGS_FILE`, and `LIQUIBASE_COMMAND_CHECKS_SHOW_CHECKS_SETTINGS_FILE` to be detected when running the quality checks commands \[DAT-8546] - Fixed the default value of the `strict` parameter. The default value is `false`. You can set the `strict` parameter as follows: - `liquibase.strict=false|true` in your liquibase.properties file - `--strict=false|true` as a CLI parameter - `LIQUIBASE_STRICT=false|true` as an environment variable \[DAT-8547] - Fixed quality checks reporting only the first failure in a changeset to report all failures found \[DAT-8583] - Fixed the Liquibase Cassandra extension failing when username and password are enabled \[LB-2115] ##### Get Certified Learn all the Liquibase fundamentals from free online courses by Liquibase experts and see how to apply them in the real world at . ##### Read the Documentation Please check out and contribute to the continually improving docs, now at . ##### Meet the Community Our community has built a lot. From extensions to integrations, you’ve helped make Liquibase the amazing open source project that it is today. Keep contributing to make it stronger: - [Contribute code](https://www.liquibase.org/development/contribute.html) - [Make doc updates](https://togithub.com/liquibase/liquibase.github.com/tree/master/documentation) - [Help by asking and answering questions](https://forum.liquibase.org/) - [Set up a chat with the Product team](https://calendly.com/liquibase-outreach/product-feedback) ##### Our first-time contributors - [zamani84](https://togithub.com/zamani84) - [dewa-actico](https://togithub.com/dewa-actico) - [gilles-gosuin](https://togithub.com/gilles-gosuin) - [obovsunivskyii](https://togithub.com/obovsunivskyii) - [cypressious](https://togithub.com/cypressious) - [christf](https://togithub.com/christf) - [eldadko](https://togithub.com/eldadko) - [RG9](https://togithub.com/RG9) - [janjicandjelka8](https://togithub.com/janjicandjelka8) - [JayWelborn](https://togithub.com/JayWelborn) - [Marcono1234](https://togithub.com/Marcono1234) - [prakashseervi](https://togithub.com/prakashseervi) - [stalbrecht](https://togithub.com/stalbrecht) - [logantracyo](https://togithub.com/logantracyo) - [tkalmar](https://togithub.com/tkalmar) - [deci260](https://togithub.com/deci260) ##### Thanks to everyone who helps make the Liquibase community strong! ### [`v4.6.1`](https://togithub.com/liquibase/liquibase/releases/tag/v4.6.1) [Compare Source](https://togithub.com/liquibase/liquibase/compare/v4.6.0...v4.6.1) #### Liquibase 4.6.1 is a patch release Please report any issues to https://github.com/liquibase/liquibase/issues. #### Notable Changes - Liquibase 4.6.0 release has the wrong version of the Liquibase Pro XSD file. This release fixes that issue. ### [`v4.6.0`](https://togithub.com/liquibase/liquibase/releases/tag/v4.6.0) [Compare Source](https://togithub.com/liquibase/liquibase/compare/v4.5.0...v4.6.0) #### Liquibase 4.6.0 is a major release Please report any issues to #### Notable Changes Starting with version 4.6.0, the Windows and Mac/Linux Liquibase installers and the .tar.gz and .zip installation files include the most common JDBC drivers in the installation package: - DB2 - Firebird - H2 - HSQLDB - PostgreSQL - MariaDB - MSSQL - Oracle - SQLite To use the available drivers, see the [Adding and Updating Liquibase Drivers](https://docs.liquibase.com/workflows/liquibase-community/adding-and-updating-liquibase-drivers.html) documentation. Also, check the page for the cases when you need different drivers. \[[PR#​2031](https://togithub.com/liquibase/liquibase/pull/2031)] \[DAT-7438] **Note:** Since Liquibase 4.6.0 provides driver jar files, the size of the installation package is bigger than the size of the installation package in earlier versions. #### Liquibase Pro Changes - [Quality checks have configurable severity and exit codes](https://docs.liquibase.com/concepts/advanced/using-quality-checks-in-automation-severity-and-exit-code.html) \[DAT-8171] - [The quality checks bulk-set command](https://docs.liquibase.com/commands/pro/checks-bulk-set.html) \[DAT-8289] - [New quality checks](https://docs.liquibase.com/concepts/advanced/configuring-quality-checks.html): - Static check: Warn when a table truncation is detected \[DAT-7933] - Dynamic check: Warn when granting specific privileges \[DAT-7972] - Static check: Warn when the `GRANT WITH ADMIN OPTION` statement is detected \[DAT-7955] - Static check: Warn when the `GRANT WITH GRANT OPTION` statement is detected \[DAT-7995] - The `liquibase.checks-settings.conf` file is unencoded in version 4.6.0 and later versions for easier inspection that allows you to resolve a merge conflict in source control. Liquibase backs up encoded files in the working directory, and you can still use previous versions by specifying the `--checks-settings-file` parameter in the CLI, as an environment variable, or as a property in the liquibase.properties file. \[DAT-8473] If you use Liquibase Hub, check the [Liquibase Hub DevOps metrics](https://docs.liquibase.com/tools-integrations/liquibase-hub/devops-metrics.html) documentation to learn more about DevOps metrics that provide the data to optimize your DevOps performance. #### Enhancements - \[[PR#​1975](https://togithub.com/liquibase/liquibase/pull/1975)] \[[nvoxland](https://togithub.com/nvoxland)] Changed the XSD default `errorOnMissingOrEmpty` attribute to `true` for the `includeAll` attribute in the XML *changelog* file. The PR fixes [PR#​1960](https://togithub.com/liquibase/liquibase/issues/1960). - \[[PR#​1993](https://togithub.com/liquibase/liquibase/pull/1993)] \[[siudeks](https://togithub.com/siudeks)] Added support for deferrable primary keys in the `createTable` Change Type. The PR fixes [PR#​1597](https://togithub.com/liquibase/liquibase/issues/1597) - \[[PR#​1986](https://togithub.com/liquibase/liquibase/pull/1986)] \[[alexey-ivanov-official](https://togithub.com/alexey-ivanov-official)] \[[parthdesai21google](https://togithub.com/parthdesai21google)] Added support for the `constraintName` attribute in the `dropNotNullConstraint` attribute. Updated the `addNotNullConstraint` rollback logic to pass the constraint name to the generated `dropNotNullConstraint` change. The PR fixes [PR#​1492](https://togithub.com/liquibase/liquibase/issues/1492) and [PR#​1942](https://togithub.com/liquibase/liquibase/issues/1942). - \[[PR#​2114](https://togithub.com/liquibase/liquibase/pull/2114)] \[[nvoxland](https://togithub.com/nvoxland)] Improved code and added tests in the `liquibase.util` package - \[[PR#​1679](https://togithub.com/liquibase/liquibase/pull/1679)] \[[thomseno](https://togithub.com/thomseno)] Changed the `datetime` type to `datetime2` for the `timestamp` type on SQL Server. - \[[PR#​2144](https://togithub.com/liquibase/liquibase/pull/2144)] \[[matejsp](https://togithub.com/matejsp)] Changed the default encoding to UTF-8. Added a new global `liquibase.fileEncoding` setting, which you can set as `--file-encoding=ASCII` in the CLI, `liquibase.fileEncoding: ASCII` in the liquibase.properties file, and `LIQUIBASE_FILE_ENCODING=ASCII` as an environment variable. The PR fixes [PR#​1445](https://togithub.com/liquibase/liquibase/issues/1445). - \[PRO] Added a message to warn Liquibase Pro users when they have noncompliant Liquibase environment variables if the `strict` attribute is set to `true` \[DAT-6946] #### Fixes - \[PRO] Fixed the issue with Liquibase 4.4.0 and later versions to prompt if the Liquibase Pro license key is expired or invalid. \[DAT-7862] - \[PRO] Fixed Liquibase Pro SQL Plus *changesets* failures with the Kerberos setup \[DAT-8102] - \[PRO] Fixed the `snapshot` command using for CockroachDB with Liquibase Pro license key \[DAT-8253] - Fixed an issue with running quality checks on Windows when using a configuration file created on Linux/macOS \[DAT-8298] - Fixed the `ChangesetCommentCheck` check to handle a lack of comments in the `tagDatabase` Change Type \[DAT-8313] - Fixed the default severity for the existing `liquibase.checks-settings.conf` files \[DAT-8328] - Fixed the `checks customize` and `checks copy` commands to handle directories with spaces \[DAT-8389] - Fixed the `schemas` and `includeSchema` attributes for the `generateChangeLog` command in Liquibase 4.4 and later versions \[DAT-8133] - Fixed the quality checks customization issue when using Git Bash \[DAT-8392] - Fixed the message for the quality checks severity customization \[DAT-8415] - Fixed the quality checks halting execution when the checks settings file contains entries for rules which do not exist in the system. Liquibase skips unknown checks and continues the execution \[DAT-8507]. - \[[PR#​1407](https://togithub.com/liquibase/liquibase/pull/1407)] \[[pirocraft](https://togithub.com/pirocraft)] Fixed the issue with Liquibase inserting a wrong default datetime value into MySQL. The PR fixes [PR#​1395](https://togithub.com/liquibase/liquibase/issues/1395). - \[[PR#​1415](https://togithub.com/liquibase/liquibase/pull/1415)] \[[Alex1OPS](https://togithub.com/Alex1OPS)] Fixed the `insert` Change Type with the `valueSequenceNext` and `valueSequenceCurrent` attributes to use the schema specified on a statement level of a *changeset*. The PR fixes [PR#​1304](https://togithub.com/liquibase/liquibase/issues/1304). - \[[PR#​1931](https://togithub.com/liquibase/liquibase/pull/1931)] \[[nvoxland](https://togithub.com/nvoxland)] Fixed the issue with Liquibase throwing a null pointer exception in the CLI if the `LicenseService` interface cannot be loaded because of the missing `jaxb` dependencies - \[[PR#​2001](https://togithub.com/liquibase/liquibase/pull/2001)] \[[haster](https://togithub.com/haster)] Fixed the `UniqueConstraintSnapshotGenerator` class switching to a bulk query after four unique constraints. The PR fixes [PR#​1996](https://togithub.com/liquibase/liquibase/issues/1996). - \[[PR#​1973](https://togithub.com/liquibase/liquibase/issues/1973)] \[[doakd](https://togithub.com/doakd)] Fixed the issue with Liquibase formatted SQL *changesets* that are skipped if there is a space in the `--changeset` line. The PR fixes [PR#​1919](https://togithub.com/liquibase/liquibase/issues/1919). - \[[PR#​104](https://togithub.com/liquibase/liquibase/pull/104)] \[[nvoxland](https://togithub.com/nvoxland)] Fixed the `dropAll` command failing in the PostgreSQL database when the Liquibase-Cassandra extension is in the `liquibase/lib` directory. The PR fixes [PR#​47](https://togithub.com/liquibase/liquibase-cassandra/pull/47). - \[[PR#​2006](https://togithub.com/liquibase/liquibase/pull/2006)] \[[kdenis4](https://togithub.com/kdenis4)] Fixed Liquibase not reading the `liquibaseSchemaName` and `liquibaseCatalogName` configuration settings. The PR fixes [PR#​2000](https://togithub.com/liquibase/liquibase/issues/2000). - \[[PR#​1465](https://togithub.com/liquibase/liquibase/pull/1465)] \[[danielthegray](https://togithub.com/danielthegray)] Fixed the issue with Liquibase incorrectly inserting a long CLOB value in the database. Added integration tests. - \[[PR#​1974](https://togithub.com/liquibase/liquibase/pull/1974)] \[[gjvoosten](https://togithub.com/gjvoosten)] Fixed the issue with Liquibase not handling case-sensitive primary key names in the `dropPrimaryKey` attribute for PostgreSQL. The PR fixes [PR#​1933](https://togithub.com/liquibase/liquibase/issues/1933). - \[[PR#​1941](https://togithub.com/liquibase/liquibase/pull/1941)] \[[meisenla](https://togithub.com/meisenla)] \[[ckulenkampff](https://togithub.com/ckulenkampff)] Fixed the `sqlFile` Change Type to handle the `encoding` attribute. The PR fixes [PR#​1760](https://togithub.com/liquibase/liquibase/issues/1760). ##### Get Certified Learn all the Liquibase fundamentals from free online courses by Liquibase experts and see how to apply them in the real world at . ##### Read the Documentation Please check out and contribute to the continually improving docs, now at . ##### Meet the Community Our community has built a lot. From extensions to integrations, you’ve helped make Liquibase the amazing open source project that it is today. Keep contributing to make it stronger: - [Contribute code](https://www.liquibase.org/development/contribute.html) - [Make doc updates](https://togithub.com/liquibase/liquibase.github.com/tree/master/documentation) - [Help by asking and answering questions](https://forum.liquibase.org) - [Setup a chat with the Product team](https://calendly.com/liquibase-outreach/product-feedback) ##### Our first-time contributors - [doakd](https://togithub.com/doakd) - [kdenis4](https://togithub.com/kdenis4) - [siudeks](https://togithub.com/siudeks) - [alexey-ivanov-official](https://togithub.com/alexey-ivanov-official) - [parthdesai21google](https://togithub.com/parthdesai21google) - [matejsp](https://togithub.com/matejsp) - [meisenla](https://togithub.com/meisenla) ##### Thanks to everyone who helps make the Liquibase community strong! ### [`v4.5.0`](https://togithub.com/liquibase/liquibase/releases/tag/v4.5.0) [Compare Source](https://togithub.com/liquibase/liquibase/compare/v4.4.3...v4.5.0) ### v4.5.0 Liquibase 4.5.0 is now available at [Liquibase.org](https://www.liquibase.org/download). Here is a closer look at what we improved in the latest release. #### Liquibase 4.5.0 is a major release Please report any issues to . #### Notable Changes Liquibase 4.5.0 includes support for Liquibase Quality Checks, which allow you to run checks against *changelogs* and SQL scripts by flagging conditions and configurations you need. There is a new family of commands to use to run quality checks: - `liquibase checks show` to list the available quality checks - `liquibase checks run` to run the available quality checks - along with `enable`, `disable`, `customize`, `copy`, `reset`, and ` delete options, and `liquibase checks --help\` to learn more The following is a list of changes related to Liquibase Quality Checks: - Implement checks enable/disable subcommands \[DAT-7794] - Implement checks run subcommand for dynamic rules \[DAT-7796] - Implement checks customize subcommand \[DAT-7797] - Implement checks copy subcommand \[DAT-7798] - Implement checks reset subcommand \[DAT-7800] - Implement checks show subcommand for dynamic rules \[DAT-7801] - Check for License & Limit gate \[DAT-7802] - Implement checks delete subcommand \[DAT-7803] - Initial write of the check-settings-config file \[DAT-7858] - Add shortname to basic rules \[DAT-7876] - Add ID to basic rules \[DAT-7877] - Implement a Dynamic Rule \[DAT-7883] - STATIC CHECK :: Changeset Must Have A Label \[DAT-7924] - STATIC CHECK :: Changeset Must Have A Context \[DAT-7925] - STATIC CHECK :: Changeset Must Have A Comment \[DAT-7926] - STATIC CHECK :: Warn When "DROP TABLE" Detected \[DAT-7928] - STATIC CHECK :: Warn When "DROP COLUMN" Detected \[DAT-7930] - STATIC CHECK :: Warn When Data Type Modification is Detected \[DAT-7934] - STATIC CHECK :: Warn when 'GRANT' Statement Detected \[DAT-7953] - STATIC CHECK :: Warn when 'REVOKE' Statement Detected \[DAT-7954] - DYNAMIC CHECK :: Warn when Tables have more than n columns \[DAT-7983] - QC subcommand help lists incorrect environment variable format. \[DAT-8005] - Change name of default settings file for checks to liquibase.checks-settings.conf \[DAT-8017] - Core: Checks should be run in numeric order (ASC) \[DAT-8040] - QC: BUG - \[Y/n] defaults to n, but should default to \[Y]es \[DAT-8132] - QC: Update the priorities for 3 Liquibase checks (labels, contexts, comments) \[DAT-8134] #### Bugfixes - Fail when creating a Scope with a null-parent [#​1354](https://togithub.com/liquibase/liquibase/issues/1354). [#​1377](https://togithub.com/liquibase/liquibase/pull/1377) [Treehopper](https://togithub.com/Treehopper) - Fixes Postgresql bit column support [#​1468](https://togithub.com/liquibase/liquibase/pull/1468) [nderwin](https://togithub.com/nderwin) - Fix OSGiResourceAccessor failing due to javax.activation [#​1534](https://togithub.com/liquibase/liquibase/pull/1534) [CMoH](https://togithub.com/CMoH) - fixed usage of computed values in prepared insert/update changes [#​1590](https://togithub.com/liquibase/liquibase/pull/1590) [Plunts](https://togithub.com/Plunts) - Ensure that the root scope is initialized correctly regardless of whether a scope manager has been configured yet or not [#​1768](https://togithub.com/liquibase/liquibase/pull/1768) [rudolfv](https://togithub.com/rudolfv) - Fix UniqueConstraint snapshot query on db2z [#​1771](https://togithub.com/liquibase/liquibase/pull/1771) [dileepan91](https://togithub.com/dileepan91) - Update MissingTableChangeGenerator.java [#​1812](https://togithub.com/liquibase/liquibase/pull/1812) [briar354](https://togithub.com/briar354) - Get Set deleteCascade for serializer mapping [#​1837](https://togithub.com/liquibase/liquibase/pull/1837) [smith-xyz](https://togithub.com/smith-xyz) - Add support for changeset ids and authors with spaces in formattedsql changelogs. [#​1845](https://togithub.com/liquibase/liquibase/pull/1845) [jpz](https://togithub.com/jpz) - More efficient XML resource loading [#​1860](https://togithub.com/liquibase/liquibase/pull/1860) - Postgresql: Preserve existing search_path when setting the defaultSchemaName [#​1864](https://togithub.com/liquibase/liquibase/pull/1864) - Fixed postgresql addPrimaryKey cluster handling [#​1880](https://togithub.com/liquibase/liquibase/pull/1880) - CLI no longer reading defaultsFile from classpath [#​1893](https://togithub.com/liquibase/liquibase/pull/1893) - Manage parent directory relative to changelog in IncludeAll [#​1968](https://togithub.com/liquibase/liquibase/pull/1968) [Cubid](https://togithub.com/Cubid) - Improve synchronization of LockServiceFactory reset [#​1991](https://togithub.com/liquibase/liquibase/pull/1991) - Fix createSequence for h2 when dataType is specified [#​1992](https://togithub.com/liquibase/liquibase/pull/1992) - \[PRO] Pro Enhancement Request: set 'splitStatements' to 'false' for Stored Logic changesets when generating a Formatted SQL changelog \[DAT-7391] - \[PRO] Allow users to indicate names and location of their spool files when using runWith:sqlplus \[DAT-7580] - \[PRO] Cannot update MariaDB expand based storage after first liquibase update \[DAT-7879] - \[PRO] Liquibase PRO generateChangeLog error on Postgresql functions that have long signatures containing any '()' characters \[DAT-7894] ##### Get Certified Learn all the Liquibase fundamentals from free online courses by Liquibase experts and see how to apply them in the real world at: . ##### Read the documentation Please check out and contribute to the continually improving docs, now at: . ##### Meet the Community Our community has built a lot. From extensions to integrations, you’ve helped make Liquibase the amazing open source project that it is today. Keep contributing to make it stronger: - Contribute code - - Make doc updates - - Help by asking and answering questions -- [https://forum.liquibase.org](https://forum.liquibase.org/) - Setup a chat with the Product team -- ##### Our first-time contributors - [briar354](https://togithub.com/briar354) - [CMoH](https://togithub.com/CMoH) - [Cubid](https://togithub.com/Cubid) - [dileepan91](https://togithub.com/dileepan91) - [jpz](https://togithub.com/jpz) - [nderwin](https://togithub.com/nderwin) - [Plunts](https://togithub.com/Plunts) - [rudolfv](https://togithub.com/rudolfv) #### Thanks to everyone who helps make the Liquibase community strong! ### [`v4.4.3`](https://togithub.com/liquibase/liquibase/releases/tag/v4.4.3) [Compare Source](https://togithub.com/liquibase/liquibase/compare/v4.4.2...v4.4.3) Liquibase 4.4.3 is now available at [Liquibase.org](https://www.liquibase.org/download). Here is a closer look at what we improved in the latest release. #### Liquibase 4.4.3 is a patch release This release includes many community-contributed pull requests, Liquibase Community and Liquibase Pro bug fixes, and enhancements to Liquibase Hub performance and pipelines. #### Notable Changes In Liquibase 4.4.3, there are improvements to the `FileSystemAlreadyExistsException` output message. The original `FileSystemNotFoundException` warning was changed to be an `info` message that does not include logs of stack traces. If you are still seeing stack traces, please [contact us](https://www.liquibase.org/contact). [#​1885](https://togithub.com/liquibase/liquibase/pull/1885) [dertin](https://togithub.com/dertin) Additionally, we fixed bugs in SQL files: [#​1798](https://togithub.com/liquibase/liquibase/pull/1798) - The `sqlFile` and `relativeToChangelogFile` attributes fail when using the `logicalFilePath` attribute [#​1277](https://togithub.com/liquibase/liquibase/issues/1277) [darkcamper](https://togithub.com/darkcamper) - The wrong path received if `relativeToChangelogFile=true` and `databaseChangeLog` has `logicalFilePath != PhisicalFilePath` [#​1353](https://togithub.com/liquibase/liquibase/issues/1353) [kezhevatov](https://togithub.com/kezhevatov) #### Bugfixes - Added a separate query for DB2 on AS400, which fixed the `dropAll` command on DB2 for iSeries [#​1412](https://togithub.com/liquibase/liquibase/pull/1412) [wardvijf](https://togithub.com/wardvijf) - Fixed the `logicalFilePath` attribute not being serialized [#​1471](https://togithub.com/liquibase/liquibase/pull/1471) [tms-91](https://togithub.com/tms-91) - Fixed the `SqlParser` bug related to parsing UTF-8 valid symbols [#​1513](https://togithub.com/liquibase/liquibase/pull/1513) [matteoturra](https://togithub.com/matteoturra) - Fixed the invalid update SQL generated for HSQL database in `InsertOrUpdateGeneratorHsql.java` [#​1563](https://togithub.com/liquibase/liquibase/issues/1563) [devorgpl](https://togithub.com/devorgpl) - Added a validation error when the `customChange` Change Type has no `name` attribute [#​1592](https://togithub.com/liquibase/liquibase/issues/1592) [danielthegray](https://togithub.com/danielthegray) - Fixed the issue with Liquibase failing to create a DATABASECHANGELOGLOCK record and apply *changesets* into Firebird 3. `isNumericBoolean` now checks the `Firebird3Database` instance type and returns Boolean for Firebird 3. [#​1875](https://togithub.com/liquibase/liquibase/pull/1875) [koushikd02](https://togithub.com/koushikd02) - Fixed the issue with escaping question marks in PostgreSQL: [#​1877](https://togithub.com/liquibase/liquibase/pull/1877) [juszczakn](https://togithub.com/juszczakn) and [goostleek](https://togithub.com/goostleek) - SQL *changesets* are transforming the PostgreSQL `?` JSON operator into `??`, causing function definitions using this operator to become invalid [#​1764](https://togithub.com/liquibase/liquibase/issues/1764) - An error when processing a large Postgres SQL *changeset* [#​1507](https://togithub.com/liquibase/liquibase/issues/1507) - Fixed the issue with `ClassCastException` in a standard lock service: `java.time.LocalDateTime` cannot be cast to `java.util.Date` [#​1878](https://togithub.com/liquibase/liquibase/pull/1878) [jocmer-evooq](https://togithub.com/jocmer-evooq) and [haidiiii](https://togithub.com/haidiiii) - Added the MySQL reserved word `CUBE` to the list of Liquibase reserved columns for the schema migration to work. `CUBE` is a reserved word as of MySQL 8.0.1 [#​1515](https://togithub.com/liquibase/liquibase/pull/1515) [jasonwjones](https://togithub.com/jasonwjones) - Added the ability to handle empty lines at the beginning of a formatted SQL [#​1713](https://togithub.com/liquibase/liquibase/pull/1713) [smith-xyz](https://togithub.com/smith-xyz) - Fixed loading the `CLOB` data into PostgreSQL. Instead of loading the `CLOB` file name, PostgreSQL loads the content of the `CLOB` file. [#​1791](https://togithub.com/liquibase/liquibase/pull/1791) [jidma](https://togithub.com/jidma) - Changed the MD5SUM column value from `RawSqlStatement` to `UpdateStatement` [#​1602](https://togithub.com/liquibase/liquibase/pull/1602) [biryukovpavel](https://togithub.com/biryukovpavel) - Fixed synchronization in `ChangeLogHistoryServiceFactory.java` [#​1361](https://togithub.com/liquibase/liquibase/pull/1361) [Olard](https://togithub.com/Olard) - Fixed the *changeset* execution failure related to the `DATICAL_SPERRORLOG` table when using the `runWith=sqlplus` attribute and executing operations as a user with only `SELECT`, `UPDATE` and `INSERT` permissions \[DAT-7410] - Combined Liquibase GitHub Action examples into the `liquibase/liquibase-github-action-example` repository \[DAT-6679] - Enabled the `dropAll` report to work with a registered *changelog* with no extra arguments and send the information to Liquibase Hub \[DAT-7554] - Renamed the `tablespaceName` parameter to `liquibaseTablespaceName` \[DAT-7676] ##### Get Certified Learn all the Liquibase fundamentals from free online courses by Liquibase experts and see how to apply them in the real world at: . ##### Read the documentation Please check out and contribute to the continually improving docs, now at: . ##### Meet the Community Our community has built a lot. From extensions to integrations, you’ve helped make Liquibase the amazing open source project that it is today. Keep contributing to make it stronger: - Contribute code - https://www.liquibase.org/development/contribute.html - Make doc updates - https://github.com/liquibase/liquibase.github.com/tree/master/documentation - Help by asking and answering questions -- https://forum.liquibase.org - Setup a chat with the Product team -- https://calendly.com/liquibase-outreach/product-feedback #### Our first-time contributors - [darkcamper](https://togithub.com/darkcamper) - [kezhevatov](https://togithub.com/kezhevatov) - [pierre2113](https://togithub.com/pierre2113) - [tms-91](