liquibase/liquibase
### [`v4.9.0`](https://togithub.com/liquibase/liquibase/releases/v4.9.0)
#### Liquibase 4.9.0 release
Please report any issues to .
#### Notable Changes
Liquibase 4.9.0 introduces the following functionality:
- \[PRO] Quality Checks JSON object so that your application can easily parse through the Liquibase output \[DAT-9094]
For more information, see [Quality Checks JSON Object](https://docs.liquibase.com/commands/quality-checks/quality-checks-json-object.html).
- Quality checks for Maven - `checks.run` and `checks.show` goals \[DAT-9033] \[DAT-9034]
For more information, see [Maven checks.run](https://docs.liquibase.com/tools-integrations/maven/commands/maven-checks-run.html) and [Maven checks.show](https://docs.liquibase.com/tools-integrations/maven/commands/maven-checks-show.html).
- \[[PR#2558](https://togithub.com/liquibase/liquibase/pull/2558)] \[[kavya-shastri](https://togithub.com/kavya-shastri)] \[**Breaking Change**]The change in the usage of the Liquibase global configuration for the `secureParsing` parameter to prevent the entity resolver from scanning the network for missing XSDs. If you reference an XSD other than one from Liquibase and have never stored them in your `classpath`, Liquibase will no longer automatically download and use the XSD from the internet for security reasons. The default value for `secureParsing` is `true`, but you can set it to `false` in any of the Liquibase configuration locations. For more information, see [XSD support](https://docs.liquibase.com/concepts/changelogs/xml-format.html).
- \[[PR#2529](https://togithub.com/liquibase/liquibase/pull/2529)] \[[Krzysztof Sierszeń](https://togithub.com/crizzis)] \[LB-1781] The `uniqueConstraintExists` precondition to check for the existence of unique constraints before running the update. You can check the constraint by constraint name or columns:
- \[[PR#2339](https://togithub.com/liquibase/liquibase/pull/2339)] \[[nvoxland](https://togithub.com/nvoxland)] \[[Toukite](https://togithub.com/Toukite)] The support for running the Liquibase Servlet listener in application servers built on the Jakarta Servlet specification and not the Java Servlet specification. To use the new listener, specify the following tag:
liquibase.integration.servlet.LiquibaseJakartaServletListener
The PR fixes issue [#2298](https://togithub.com/liquibase/liquibase/issues/2298).
#### Enhancements
- \[[PR#2434](https://togithub.com/liquibase/liquibase/pull/2434)] \[[Balázs Dési](https://togithub.com/DBaluxa)] Added the Maven `validate` goal to `maven-liquibase-plugin` to provide access to the existing Liquibase `validate` command and be available not only in CLI, but also in Maven
For more information, see [Maven validate](https://docs.liquibase.com/tools-integrations/maven/commands/maven-validate.html).
- Added the ability to use `sqlcmd` on an instance with multiple databases \[DAT-9513]
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).
- Added support for Liquibase, Spring Boot, and SQL Plus run with Kerberos \[DAT-9409]
For more information, see [Using Liquibase and Spring Boot with SQL Plus and Kerberos Authentication](https://docs.liquibase.com/tools-integrations/springboot/using-springboot-sql-plus-kerberos.html).
- \[[PR#2561](https://togithub.com/liquibase/liquibase/pull/2561)] \[[Wesley Willard](https://togithub.com/wwillard7800)] Added the `--schemas` argument to the `snapshot` command to be able to compare a multi-schema database to its snapshot \[DAT-9433]
- \[[PR#2606](https://togithub.com/liquibase/liquibase/pull/2606)] \[[Wesley Willard](https://togithub.com/wwillard7800)] Added a best practice message for the `generate-changelog` command so that you can check if the `splitStatements` attribute works for your environment when generating formatted SQL changelogs \[DAT-9327]
- Added the `StripComments` attribute for the `SQLUserDefinedPatternCheck` quality check to choose the code that the `SQLUserDefinedPatternCheck` searches, including the option for the commented code. The `StripComments` attribute strips comments from SQL before searching for the string. The default value is `N` (no). \[DAT-9098]
- \[[PR#2273](https://togithub.com/liquibase/liquibase/pull/2273)] \[[Tsvi Zandany](https://togithub.com/szandany)] Added the autocomplete option for quality checks commands running on macOS
#### Fixes
- \[[PR#2542](https://togithub.com/liquibase/liquibase/pull/2542)] \[[nvoxland](https://togithub.com/nvoxland)] Fixed the `--should-snapshot-data` CLI parameter to be preserved when the `--data-output-directory` property is not specified in the command
- \[[PR#2330](https://togithub.com/liquibase/liquibase/pull/2330)] \[[Inane Mohammed](https://togithub.com/inanemed)] Fixed the issue with checking the `referenceSnapshot` parameter instead of `referenceDatabase` for the potential null value
- \[[PR#2521](https://togithub.com/liquibase/liquibase/pull/2521)] \[[Steven Massaro](https://togithub.com/StevenMassaro)] Added a label, context, and comment to the `example-changelog.sql` file that comes with the Liquibase installation package \[DAT-9325]
- \[[PR#2556](https://togithub.com/liquibase/liquibase/pull/2556)] \[[nvoxland](https://togithub.com/nvoxland)] Fixed the CockroachDB processes so that Liquibase checks the URL first rather than proceeding with SQL calls
- \[[PR#2569](https://togithub.com/liquibase/liquibase/pull/2569)] \[[Clarence Dimitri CHARLES](https://togithub.com/clarenced)] Made `FormattedSqlChangeLogParser` to be reusable for extensions
- \[[PR#2377](https://togithub.com/liquibase/liquibase/pull/2377)] \[[devorgpl](https://togithub.com/devorgpl)] Fixed the issue with updating statements when the `onlyUpdate` attribute is `false` in the `loadUpdateData` Change Type for HSQL
- \[[PR#1908](https://togithub.com/liquibase/liquibase/pull/1908)] \[[Emiliano Capoccia](https://togithub.com/ecapoccia)] Fixed the issue with retrieving the CockroachDB version. As part of the fix, Liquibase generates version-specific autoincrement SQL statements for CockroachDB identity columns:
- `SMALLSERIAL`, `SERIAL`, and `BIGSERIAL` for versions earlier than 21.2
- `GENERATED BY DEFAULT AS IDENTITY` for version 21.2 or later
- \[[PR#2135](https://togithub.com/liquibase/liquibase/pull/2135)] \[[PR#2133](https://togithub.com/liquibase/liquibase/issues/2133)] \[[Saucistophe](https://togithub.com/Saucistophe)] \[[mkobylarz](https://togithub.com/mkobylarz)] Fixed the issue with the `endDelimiter` attribute not being respected during the Liquibase update. The fix for `endDelimiter` does not break the handling of trailing comments in SQL statements. \[LB-2186]
- \[[PR#2573](https://togithub.com/liquibase/liquibase/pull/2573)] \[[nvoxland](https://togithub.com/nvoxland)] Fixed the quoting for the MANIFEST.MF file for correct versioning
- \[[PR#2572](https://togithub.com/liquibase/liquibase/pull/2572)] \[[Steven Massaro](https://togithub.com/StevenMassaro)] Fixed the issue with generating changelogs for PostgreSQL columns that use `SET DEFAULT` \[DAT-8779]
- \[[PR#2589](https://togithub.com/liquibase/liquibase/pull/2589)] \[[nvoxland](https://togithub.com/nvoxland)] \[[Marcel Blonk](https://togithub.com/leblonk)] Fixed the MD5 checksums generated by older versions of Liquibase to be correctly updated in the DATABASECHANGELOG table when a more recent version of Liquibase executes against the database. The PR fixes issue [#2580](https://togithub.com/liquibase/liquibase/issues/2580).
- \[[PR#2592](https://togithub.com/liquibase/liquibase/pull/2592)] \[[nvoxland](https://togithub.com/nvoxland)] Added support for the double precision type in MySQL. The PR fixes issue [#2337](https://togithub.com/liquibase/liquibase/issues/2337).
- \[[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 issue [#1774](https://togithub.com/liquibase/liquibase/issues/1774).
- \[[PR#2387](https://togithub.com/liquibase/liquibase/pull/2387)] \[[Jenson3210](https://togithub.com/Jenson3210)] Fixed the handling of date and time in the `loadData` Change Type
- \[[PR#2566](https://togithub.com/liquibase/liquibase/pull/2566)] \[[nvoxland](https://togithub.com/nvoxland)] Updated OpenCSV from 5.5.2 to 5.6
**Full Changelog**: https://github.com/liquibase/liquibase/compare/v4.8.0...v4.9.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
- [Balázs Dési](https://togithub.com/DBaluxa)
- [Inane Mohammed](https://togithub.com/inanemed)
- [Clarence Dimitri CHARLES](https://togithub.com/clarenced)
- [kavya-shastri](https://togithub.com/kavya-shastri)
- [Emiliano Capoccia](https://togithub.com/ecapoccia)
- [Saucistophe](https://togithub.com/Saucistophe)
- [mkobylarz](https://togithub.com/mkobylarz)
- [Krzysztof Sierszeń](https://togithub.com/crizzis)
- [Jenson3210](https://togithub.com/Jenson3210)
##### Thanks to everyone who helps make the Liquibase community strong!
Configuration
📅 Schedule: At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
[ ] If you want to rebase/retry this PR, click this checkbox.
This PR contains the following updates:
4.8.0->4.9.0Release Notes
liquibase/liquibase
### [`v4.9.0`](https://togithub.com/liquibase/liquibase/releases/v4.9.0) #### Liquibase 4.9.0 release Please report any issues toConfiguration
📅 Schedule: At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
This PR has been generated by WhiteSource Renovate. View repository job log here.