Release Notes

Liquibase 4.16.0 - September 9, 2022

Full changelog: v4.15.0...v4.16.0

Notable Changes

  • [LABS] The `liquibase flow` command and flow files are still available under the Liquibase Labs license.
  • [PRO] The Quality Checks for Databases are now available to all Pro license users. These checks inspect your active database, or a liquibase-generated snapshot for compliance with your rules. Learn more here: List of Quality Checks
  • Introduces "contextFilter" and "labelFilter" replacement settings by @nvoxland in 2971
    • Liquibase has always had a way to use "labels" and "contexts" and then filter on those attributes in order to control which changesets are considered for execution. The new "contextFilter" and "labelFilter" attributes help simplify workflows and prevent confusion.

Enhancements

  • Added support for changeset references in rollback for Formatted SQL changelogs by @atzawada in #1386
  • Add schemas and includeSchema parameters to maven generateChangeLog by @MalloD12 in #3210
  • [PRO] Two new Pro commands update-one-changeset and update-one-changeset-sql serving as complements to rollback-one-changeset and roll-back-one-changeset-sql

Fixes

  • Fix addColumn on mysql when including a "value" attribute by @nvoxland in #3070
  • Add support for AS <dataType> clause for H2 since version 2.0 by @marcus-nl in #3047
  • Fixed NUMBER not compatible with H2 by @nick318 in #3098
  • SpringResourceAccessor: fix issue with incorrect match pattern for files from classPath root by @danilmalkin in #3095
  • Made liquibase.snapshot.ResultSetCache an extensible class. by @breglerj in #2087
  • Added support for \u2116 symbol win1251 cyrillic symbol of number by @Stuchalin in #1324
  • Tidy ExecutorService code, remove superfluous map access (Issue 1841) by @jamey-clari in #1842
  • Fixed order of enum values on MySQL 8 by @Tantalon in #3150
  • Removed invalid warning in Maven by @nvoxland in #3189
  • [PRO] DAT-10810 QC: checks show changes (--show-cols flag, drop some, etc) by @dyadyushko in #3187

Updates

Security Updates

Updates the snakeyaml dependency shipped in the liquibase-maven-plugin pom to address CVE-2022-25857

JDBC Driver and Third-Party Library Updates

  • Upgraded postgresql from 42.4.0 to 42.4.1 by @dependabot in #3145
  • Upgraded mariadb-java-client from 3.0.6 to 3.0.7 by @dependabot in #3149
  • Upgraded sqlite-jdbc from 3.36.0.3 to 3.39.2.0 by @dependabot in #3148
  • Upgraded mssql-jdbc from 10.2.1.jre8 to 11.2.0.jre8 by @dependabot in #3162
  • Upgraded postgresql from 42.4.1 to 42.5.0 by @dependabot in #3199
  • Upgraded sqlite-jdbc from 3.39.2.0 to 3.39.2.1 by @dependabot in #3198
  • Upgraded snakeyaml from 1.30 to 1.31 by @dependabot in #3224
  • Upgraded snakeyaml in liquibase-maven-plugin from 1.27 to 1.31 by @dependabot in #3263

OWASP Dependency Check: Reported Vulnerabilities

snakeyaml.jar - This is a "medium" vulnerability reported against the snakeyaml library. We are currently on the newest version of snakeyaml and there is no fix for the issue as of yet.

New Contributors

  • @marcus-nl made their first contribution in #3047
  • @nick318 made their first contribution in #3098
  • @danilmalkin made their first contribution in #3095
  • @breglerj made their first contribution in #3087
  • @Stuchalin made their first contribution in #1324
  • @jamey-clari made their first contribution in #1842
  • @Tantalon made their first contribution in #3150
  • @atzawada made their first contribution in #1386
  • @MalloD12 made their first contribution in #3210
  • @dyadyushko made their first contribution in #3187

Liquibase 4.15.0 - August 5, 2022

Full changelog: v4.14.0...v4.15.0

Notable Changes

New liquibase flow command

  • liquibase flow and new flow-file (DAT-10419) by in #2946
  • The liqubase flow command and the Flow File on which it operates allow the user to place multiple commands within a single file so they can all run sequentially with a single command into the CLI. This is currently a Liquibase Labs restricted capability, so please contact mario@liquibase.com to request a license key. Learn more at liquibase flow file and command

Enhancements

Fixes

  • Fix maven plugin pro commands for local developer install by @StevenMassaro in #3101
  • Update Derby reserved words by @andrewhj in #1971
  • Output "may lose settings" warning on mysql/mariadb for more impacted change types by @nvoxland in #3045
  • Improved "include" fix performance: optimized normalizePath method by @lzxgyh in #3063
  • Removed DatabaseInfoAttributes in XSD by @kazz62 in #2239
  • Do not split SQL on delimiters within BEGIN/END blocks by @nvoxland in #1589
  • Set max fractional timestamp digits to 12 for all DB2 editions (fix #2880) by @ctgnz in #2892
  • Fix query for snapshotting views on DB2/Z by @michaelmatthiaskern in #2712
  • Fix for bug 2711: Error when calling a procedure with parameters on DB2Z by @michaelmatthiaskern in #2765
  • Improve CLI error messages by @nvoxland in #3078
  • Improved handling of endDelimiter="/" by @nvoxland in #3118
  • Upgrade installer to ship with jdk 17.0.4+8 by @nvoxland in #3104
  • Improve failure message of RowCountPrecondition to preserve expected row count by @martinspielmann in #3093
  • Changed what sequence attributes are included in diff/generate changelog for Snowflake by @yodzhubeiskyi in #3121
  • Fix columnNames snapshot attribute of uniqueConstraints for Snowflake by @yodzhubeiskyi in #3123

Updates

Security Updates

No security updates needed in this release.

JDBC Driver and Third-Party Library Updates

Upgraded snowflake-jdbc from 3.13.20 to 3.13.21 by @dependabot in #3061

OWASP Dependency Check: Reported Vulnerabilities

None

New Contributors

  • @andrewhj made their first contribution in #1971
  • @lzxgyh made their first contribution in #3063
  • @kazz62 made their first contribution in #2239
  • @ctgnz made their first contribution in #2892
  • @michaelmatthiaskern made their first contribution in #2712
  • @martinspielmann made their first contribution in #3093

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 https://learn.liquibase.com/.

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:

Thanks to everyone who helps make the Liquibase community strong!

File Descriptions

  • Liquibase CLI – Includes open-source and commercial functionality:
  • Primary libraries – For embedding in other software:
    • liquibase-core-<version>.jar – Base Liquibase library (open source)
    • liquibase-commerical-<version>.jar – Additional commercial functionality

      • Note: liquibase-core-<version>.jar contains only the open-source license. If you use Liquibase Pro or other commercial add-ons, you must also install liquibase-commercial-<version>.jar.

  • liquibase-additional-<version>.zip – Contains additional, less commonly used files:
    • Additional libraries such as liquibase-maven-plugin.jar and liquibase-cdi.jar
    • Javadocs for all the libraries
    • Source archives for all the open source libraries
    • ASC/MD5/SHA1 verification hashes for all files
  • Source code (zip) – ZIP archive of this repository's source code
  • Source code (tar.gz) – Tar.gz archive of this repository's source code

Liquibase 4.14.0 - July 25, 2022

Full changelog: v4.13.0...v4.14.0

Notable Changes

Split liquibase-core and liquibase-commercial jar files by @nvoxland in #3050

  • This change affects new downloads of Liquibase Pro. liquibase-core-.jar contains only the open-source license. If you use Liquibase Pro or other commercial add-ons, you must also install liquibase-commercial-.jar.

Added liquibase.changelogParseMode setting by @nvoxland in #3057

Enhancements

  • Warn if XSD version does not match build version in validate command (DAT-9874) by @StevenMassaro in #3016
  • Allow use of pro-only objects for filtering with generateChangeLog (DAT-9542) by @StevenMassaro in #3068
  • Improve connection exception by including underlying driver exception trace by @hessjcg in #3033
  • Add Closeable/AutoCloseable interface to liquibase.database.Database by @zorglube in #2990

Fixes

  • Fixed Formatted SQL "property" parsing by @nvoxland in #3037
  • Ensure Postgresql search_path entries are quoted correctly by @nvoxland in #3009
  • Updated "Change Set" wording to "Changeset" by @kataggart in #3042
  • Improved error when JAVA_HOME is set to invalid value (DAT-10545) by @StevenMassaro in #3074
  • Fixed autoIncrement incrementBy/startWith support in MySQL, H2, HSQLDB, and MariaDB by @tozogabee in #3026
  • Improve renameColumn generated SQL on mssql by @mide25 in #783

Updates

Security Updates

No security updates needed in this release.

JDBC Driver and Third-Party Library Updates

  • Upgraded mariadb-java-client from 3.0.5 to 3.0.6 by @dependabot in #3021
  • Upgraded testcontainers-bom from 1.17.2 to 1.17.3 by @dependabot in #3020
  • Upgraded postgresql from 42.3.4 to 42.4.0 by @dependabot in #2935
  • Bump jaxb-runtime from 2.3.6 to 4.0.0 by @dependabot in #2964

New Contributors

  • @hessjcg made their first contribution in #3033
  • @mehrabisajad made their first contribution in #3059
  • @tozogabee made their first contribution in #3026
  • @mide25 made their first contribution in #783
  • @zorglube made their first contribution in #2990

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 https://learn.liquibase.com/.

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:

Thanks to everyone who helps make the Liquibase community strong!

File Descriptions

  • Liquibase CLI – Includes open-source and commercial functionality:
  • Primary libraries – For embedding in other software:
    • liquibase-core-<version>.jar – Base Liquibase library (open source)
    • liquibase-commerical-<version>.jar – Additional commercial functionality

      • Note: liquibase-core-<version>.jar contains only the open-source license. If you use Liquibase Pro or other commercial add-ons, you must also install liquibase-commercial-<version>.jar.

  • liquibase-additional-<version>.zip – Contains additional, less commonly used files:
    • Additional libraries such as liquibase-maven-plugin.jar and liquibase-cdi.jar
    • Javadocs for all the libraries
    • Source archives for all the open source libraries
    • ASC/MD5/SHA1 verification hashes for all files
  • Source code (zip) – ZIP archive of this repository's source code
  • Source code (tar.gz) – Tar.gz archive of this repository's source code

Liquibase 4.13 - July 11, 2022

Full Changelog:https://github.com/liquibase/liquibase/compare/v4.12.0...v4.13.0

Notable Changes

PRO DAT-10083 - Added PSQL native executor feature by @abrackx

Enhancements

Fixes

Updates

Security Updates

No security updates needed in this release.

JDBC Driver and Third-Party Library Updates

New Contributors

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 https://learn.liquibase.com/.

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:

Thanks to everyone who helps make the Liquibase community strong!

Liquibase 4.12 - June 17, 2022

Full Changelog: https://github.com/liquibase/liquibase/compare/v4.11.0...v4.12.0

Breaking Changes

Support for Snowflake database has been moved from the external extension liquibase-snowflake into the main Liquibase artifact. If you are using the Snowflake extension, remove it from your lib directory or however you are including it in your project. If you are using the Docker image, the snowflakedocker label will no longer be updated so you need to update your reference to either latest or the version tag you prefer. For CLI users, the Snowflake driver also ships out of the box and so you should remove that from the lib directory as well https://github.com/liquibase/liquibase/pull/2841

Enhancements

  • Quality Checks for Databases (DAT-9298) by @StevenMassaro in https://github.com/liquibase/liquibase/pull/2715
    • This capability extends checks from just the changelog to look at the database itself for conditions of compliance, security, and more. This is currently a Liquibase Labs restricted capability, so please contact mario@liquibase.com to request a license key.
  • Added a new "liquibase.showBanner" setting. Setting this value to 'false' will disable the Liquibase startup banner from being shown. By @nvoxland in https://github.com/liquibase/liquibase/pull/2871
  • Added a new "liquibase.missingPropertyMode" setting to control what happens when a changelog contains a ${...} string that doesn't correspond to a set changelog property. The default continues to be "preserve," which leaves it as-is. But other possible values are ERROR or EMPTY which will either stop execution with an error or replace it with an empty string. By @dwieland in https://github.com/liquibase/liquibase/pull/2656
  • Added new "liquibase.preserveSchemaCase" argument to preserve the case of schemas exactly as passed to the various schema settings. Default remains "false" as before. DAT-10027 By @wwillard7800 in https://github.com/liquibase/liquibase/pull/2888
  • Introduced "latest" xsd file path. In addition to http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.12.xsd type XSDs references, you can now also use http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd instead. By using "latest", Liquibase will use the bundled XSD for it's version. The uploaded "latest" XSD will always be the most recent Liquibase release, so note how they can be different and locally cached IDE versions may be different yet. By @nvoxland in https://github.com/liquibase/liquibase/pull/2886
  • Added new ConfiguredValueModifier extension point. This allows extensions to be written which will translate or convert configuration values from what was passed by the user before the value is passed to the internal code. By @mcred in https://github.com/liquibase/liquibase/pull/2252
  • Updated StandardLockService interface to make it more useful for extensions by @Cliftonz in https://github.com/liquibase/liquibase/pull/2785

JDBC Driver and Third-Party Library Updates

Fixes

New Contributors

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 https://learn.liquibase.com/.

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:

Thanks to everyone who helps make the Liquibase community strong!

Full Changelog: https://github.com/liquibase/liquibase/compare/v4.10.0...v4.11.0

Please report any issues to https://github.com/liquibase/liquibase/issues.

Breaking Changes

Starting with 4.11, we moved the global libraries we ship with the CLI from the lib directory to a new internal directory structure. The lib directory is still included in the classpath as the place where users can add the additional global drivers/libraries they need.

The liquibase --version output has been enhanced to also include the third party libraries being used and their versions.

Impacts:

  • If you are upgrading Liquibase by overwriting an existing directory, you will have duplicate libraries between lib and internal/lib. You should manually delete any files in lib which you did not add yourself. Liquibase will continue to work even with the duplicate libraries, but you may not be running the latest version of ones we ship, since the lib files take priority over what is in internal/lib. New installs are not impacted by this.
  • If you have any automation that did anything with our shipped files in lib, update it to reflect the new internal/lib location.

For security reasons, we have also changed what is logged by the CLI to only log liquibase channel messages by default, rather than all log channels. If you are relying on logging from non-Liquibase libraries, you can add channels with the new --log-channels flag, including --log-channels=all to restore the old functionality.

Enhancements

  • Moved shipped jar files out of lib and into a new internal/lib directory by @nvoxland in #2850
  • To help with performance troubleshooting, there is now a --monitor-performance argument for the CLI (and only the CLI) which enables profiling of the Liquibase run. The generated profiling information can help us understand and fix performance issues easier. #2599
  • Upgraded Java shipped with the installers from 11 to 17 by @nvoxland in #2602
  • Added whitelist for CLI log channels by @nvoxland in #2859

Fixes

  • Do not throw a confusing error if a datatype specified as a changelog parameter is not expanded by @nvoxland in #2772
  • Fixed SQLite not correctly snapshotting tables with underscores in the name by @nvoxland in #2778
  • Fixed local XSD lookup by @nvoxland in #2830
  • Standardized "start-h2" commands on "liquibase init start-h2" logic by @nvoxland in #2597
  • Support default values in the format (0)::real by @nvoxland in #2836
  • Fix handling of defaultSchemaName on Postgresql by @nvoxland in #2812
  • Introduce generateStatementsFromRows for extensions by @fbiville in #2686
  • Fixed XSD type of "ordered" and "cycle" attributes to be booleanby @DartVerder in #2725
  • Remove custom log message filtering by @nvoxland in #2777
  • Spring Boot: better support relativeToChangelogfile when ResourceLoaders return FilteredReactiveWebContextResources by @erik-meuwese-topicus in #2758
  • Fix ForeignKeyComparator when foreign key table is not known by @joserebelo in #2565
  • Test System Framework: add support for "liquibase.sdk.testSystem.skip" property by @StevenMassaro in #2838
  • Test System Framework: stop database containers when spock execution ends by @StevenMassaro in #2843

Updates

Security Updates

No security updates needed in this release.

JDBC Driver and Third-Party Library Updates

  • Upgraded picocli from 4.6.1 to 4.6.3 by @dependabot in #2518
  • Upgraded jaxb libraries to the newest 2.3.x versions by @nvoxland in #2793
  • Upgraded snakeyaml from 1.27 to 1.30 by @dependabot in #2498
  • OWASP Dependency Check: Reported Vulnerabilities
  • jcc.jar - This is a vulnerability reported against the IBM DB2 JDBC driver. It is awaiting reanalysis. We are currently on the newest version [CVE-2008-1997] (https://nvd.nist.gov/vuln/detail/CVE-2008-1997)

New Contributors

  • @nikosmoum made their first contribution in #2630
  • @DartVerder made their first contribution in #2725
  • @erik-meuwese-topicus made their first contribution in #2758
  • @joserebelo made their first contribution in #2565

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 https://learn.liquibase.com/.

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:

Thanks to everyone who helps make the Liquibase community strong!

Full Changelog: https://github.com/liquibase/liquibase/compare/v4.9.1...v4.10.0

Please report any issues to https://github.com/liquibase/liquibase/issues.

Breaking Change

Upgraded mssql driver to 10.2.0 by @nvoxland in https://github.com/liquibase/liquibase/pull/2790

End User Impact: The driver changed the encryption default from "false" to "true" between 8.x and 10.x. If you have a self-signed certificate in your database, you must do one of the following: add encrypt=false; add trustServerCertificate=true; or add the server certificate to the java trusted certificate list. For production systems, Liquibase recommends against using self-signed certificates without adding the server certificate to the Java keystore. For more information on installing the trusted certificate, see https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/manage-certificates?view=sql-server-ver15.

Security Updates

Upgraded postgresql from 42.3.2 to 42.3.4 to address [CVE-2022-26520](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2022-26520) by @dependabot in https://github.com/liquibase/liquibase/pull/2769

  • Vulnerability introduced in org.postgresql:postgresql@42.3.2
  • Fixed in org.postgresql:postgresql@42.3.3

JDBC Driver and Third-Party Library Updates

Enhancements

Fixes

New Contributors

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 https://learn.liquibase.com/.

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:

Thanks to everyone who helps make the Liquibase community strong!

[PR#2666] [nvoxland] Liquibase 4.9.1 release is a patch release that fixes the MANIFEST.MF location in the liquibase.jar file for tools that require the MANIFEST.MF file to be the first entry in the jar archive. If the MANIFEST.MF file is not the first entry, java.util.jar.JarInputStream#getManifest() reading the MANIFEST.MF file will not return the manifest information appropriately. The PR fixes issue #2648.

[Issue#2672] Addresses the remaining OSGi-related packaging problems to fully restore Liquibase support in OSGi environments.

Fixes

  • [PR#2651] Fixed the issue with a malicious software alert for the Liquibase macOS Installer preventing from proceeding with the installation. [DAT-9524]
  • [PR#2643] Fixed the handling of non-integer datatypes using a default value with a sequence in snapshot on PostgreSQL [DAT-8670]
  • [PR#2691] Fixed invalid JSON in the example-changelog.json file [DAT-9893]

Contributions

Our community has built a lot. Thanks to everyone who contributes and helps make the Liquibase community strong. To keep contributing:

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 https://learn.liquibase.com/.

Liquibase 4.9.0 Release

Liquibase 4.9.0 is now available on the Download Liquibase page.

This release includes the checks.run and checks.show Maven goals, quality checks JSON object, community-contributed pull requests, Liquibase Community and Liquibase Pro bug fixes, and other notable changes.

Notable Changes

Liquibase 4.9.0 introduces the following functionality:

  • [PR#2558] [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 of 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.

    Note: For more information, see Example Changelogs: XML Format.

  • [PR#2529] [Krzysztof Sierszeń] [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: 
    •                 <preConditions>
    <uniqueConstraintExists constraintName="uq_constraint_name" tableName="test_table"/>
</preConditions>
            
                    <preConditions>
    <uniqueConstraintExists tableName="test_table" columnNames="first_name, last_name"/>
</preConditions>
  • [PR#2339] [nvoxland] [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: 
    •                 <listener>
    <listener-class>liquibase.integration.servlet.LiquibaseJakartaServletListener</listener-class>
</listener>

    The PR fixes issue #2298.

  • [PRO] Quality checks JSON object so that your application can easily parse through the Liquibase output [DAT-9094]

    • Note: For more information, see Quality Checks JSON Object .

Enhancements

  • [PR#2434] [Balázs Dési] 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

    Note: For more information, see Maven validate.

  • Added the ability to use sqlcmd on an instance with multiple databases [DAT-9513]

    Note: For more information, see Using the SQLCMD integration and runWith attribute with Liquibase Pro and MSSQL Server.

  • Added support for Liquibase, Spring Boot, and SQL Plus run with Kerberos [DAT-9409]

    Note: For more information, see Using Liquibase and Spring Boot with SQL Plus and Kerberos Authentication.

  • [PR#2561] [Wesley Willard] Added the --schemas argument to the snapshot command to be able to compare a multi-schema database to its snapshot [DAT-9433]
  • [PR#2606] [Wesley Willard] 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] [Tsvi Zandany] Added the autocomplete option for quality checks commands running on macOS

Fixes

  • [PR#2542] [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] [Inane Mohammed] Fixed the issue with checking the referenceSnapshot parameter instead of referenceDatabase for the potential null value
  • [PR#2521] [Steven Massaro] Added a label, context, and comment to the example-changelog.sql file that comes with the Liquibase installation package [DAT-9325]
  • [PR#2556] [nvoxland] Fixed the CockroachDB processes so that Liquibase checks the URL first rather than proceeding with SQL calls
  • [PR#2569] [Clarence Dimitri CHARLES] Made FormattedSqlChangeLogParser to be reusable for extensions
  • [PR#2377] [devorgpl] Fixed the issue with updating statements when the onlyUpdate attribute is false in the loadUpdateData Change Type for HSQL
  • [PR#1908] [Emiliano Capoccia] 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] [PR#2133] [Saucistophe] [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] [nvoxland] Fixed the quoting for the MANIFEST.MF file for correct versioning
  • [PR#2572] [Steven Massaro] Fixed the issue with generating changelogs for PostgreSQL columns that use SET DEFAULT [DAT-8779]
  • [PR#2589] [nvoxland] [Marcel Blonk] 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.
  • [PR#2592] [nvoxland] Added support for the double precision type in MySQL. The PR fixes issue #2337.
  • [PR#1894] [KushnirykOleh] Fixed the time data type to be precise for PostgreSQL. The PR fixes issue #1774.
  • [PR#2387] [Jenson3210] Fixed the handling of date and time in the loadData Change Type
  • [PR#2566] [nvoxland] Updated OpenCSV from 5.5.2 to 5.6

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:

To keep contributing:

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 https://learn.liquibase.com/.

This release includes the init hub subcommand, Liquibase Pro support for MSSQL Server sqlcmd utility, community-contributed pull requests, and Liquibase Community 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]

    • Note: For more information, see init hub and Get Started with Liquibase Hub.

  • 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 Command Parameters.

  • 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] [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 no class 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 the ClassLoaderResourceAccessor class [LB-2205]

Fixes

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:

To keep contributing:

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 https://learn.liquibase.com/.

This patch release includes community-contributed pull requests, Liquibase Community 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.

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=changeLogProperty attribute not working in a formatted SQL changelog [DAT-4793]
  • [PR#2270] [Nathan Voxland] [Michael Kroll] Fixed the handling of the cacheSize attribute in the createSequence and alterSequence Change 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 columnDataType attribute for the generated setColumnRemarks changesets 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:

To keep contributing:

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 https://learn.liquibase.com/.

Tip: Liquibase Hub introduces the Liquibase Hub DevOps Metrics functionality with four reports that provide the data to optimize your DevOps performance: Deployment Frequency, Change Migration Time, Change Failure Rate, Time to Fix Failing Changes.

This release includes community-contributed pull requests, Liquibase Community and Liquibase Pro bug fixes, and a new command to get started with Liquibase – the init command.

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

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 command line or terminal window. [DAT-8945]

Note: For more information and examples of using init project, see init project.

Additionally, we have updated the Liquibase Getting Started tutorials and sample changelog files in the installation package. From now on, you can use sample SQL, XML, JSON, and YAML changelog files with the corresponding changesets. [LB-2177] [LB-2174]

Note: Check Liquibase Getting Started to see more details.

Enhancements

  • [PRO] Improved the output of the rollback-one-update command [DAT-7590]
  • [PR#2244] [Tsvi Zandany] Enabled the use of the jdbc:edb URL for Liquibase to recognize EnterpriseDB
  • [PR#2225] [Nathan Voxland] [Konstantin] 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.
  • 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] [Andrii Tytarchuk] 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

Fixes

  • Fixed the generate-changelog 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] [smainz] Fixed the loadData Change Type to recognize CSV files when loading data with the path that contains a dot character ('.')
  • [PR#2071] [Nicolas Humblot] [Philipp] Fixed the addNotNullConstraint Change Type causing the "Data too long" error message. The PR fixes PR#1054.
  • [PR#2073] [smainz] Fixed the relativeToChangelogFile attribute for loadData, createProcedure, and createView Change Types
  • [PR#2228] [Nathan Voxland] Updated the logic of the foreign key names that are not always unique
  • [PR#2081] [Jakub Herkel] Fixed OSGI support (manifest and class loading)
  • [PR#2192] [Andrii Tytarchuk] Fixed COLUMN_SIZE for the PostgreSQL NUMERIC[] datatype

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:

To keep contributing:

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 https://learn.liquibase.com/.

This release includes community-contributed pull requests, Liquibase Community and Liquibase Pro bug fixes, and a new quality checks functionality.

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

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 [DAT-8444]

Liquibase 4.6.2 includes the liquibase.sql.log-level 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 <level> parameter in the CLI: 

                            liquibase --sql-log-level <FINE|INFO|SEVERE|WARNING|OFF> --log-level=<FINE|INFO|SEVERE|WARNING|OFF> 
--log-file=log.txt update --changelog-file=<changelog>

You can also set the parameter as follows:

  • liquibase.sql.log-level: <FINE|INFO|SEVERE|WARNING|OFF> in the Liquibase properties file
  • LIQUIBASE_SQL_LOG_LEVEL=<FINE|INFO|SEVERE|WARNING|OFF> as an environment variable [PR#1520] [nvoxland]

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] [mcred]

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. [PR#2185] [nvoxland] [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: <value> in the Liquibase properties file
    • --ddl-lock-timeout=<value> as a CLI global parameter
    • LIQUIBASE_DDL_LOCK_TIMEOUT=<int> as an environment variable [DAT-7649]
  • Improved the output of the SqlUserDefinedPatternCheck quality check copy [DAT-8492]
  • [PR#1817] [stalbrecht] Added the MSSQLDatabase specific error evaluation when creating DATABASECHANGELOGLOCK table
  • [PR#2180] [nvoxland] [eldadko] Added support for MySQL function indexes. The PR fixes PR#1626.
  • [PR#928] [CORE-931] [RG9] Added support for the NOT NULL constraint with an initial default value in the addColumn Change Type

Fixes

  • [PR#2173] [wwillard7800] [deci260] Fixed the issue with handling multi-column indexes during the JSON snapshot. The PR fixes PR#1260.
  • [PR#1793] [janjicandjelka8] Fixed the handling of the remarks attribute in a primary key column tag for MariaDB
  • [PR#1894] [KushnirykOleh] Fixed the time data type to be precise for PostgreSQL. The PR fixes PR#1774.
  • [PR#1970] [nvoxland] Fixed the handling of the addColumn Change Type in SQLite
  • [PR#1995] [szandany] Fixed the generate-changelog command to generate the NUMERIC[] data type for PostgreSQL correctly
  • [PR#1990] [JayWelborn] Fixed the SQL generated by the alterSequence Change Type to be compatible with the Oracle, PostgreSQL, MariaDB, and MSSQL databases
  • [PR#2020] [nvoxland] [dewa-actico] Fixed the handling of nested changelog preconditions. The PR fixes PR#1624.
  • Fixed the naming of the checks settings file shown as null if the file was corrupted [DAT-8553]
  • [PR#2021] [nvoxland] [zamani84] Fixed the issue with Liquibase escaping the backslash in values stored in objects. The PR fixes PR#1598.
  • [PR#2083] [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] [nvoxland] [obovsunivskyii] Fixed the --verbose flag used in the unexpected-changesets command. The PR fixes PR#1987.
  • [PR#2168] [nvoxland] [gilles-gosuin] Fixed the parsing logic for YAMLChangelogParser and changeLogId in a Map. The PR fixes PR#1988.
  • [PR#2102] [prakashseervi] Implemented the handling of the GENERATED ALWAYS AS clause while creating a table for PostgreSQL
  • [PR#2029] [Marcono1234] Fixed the LOCKGRANTED column to include time zone information in the DATABASECHANGELOGLOCK table
  • [PR#2059] [wardvijf] Fixed the support for custom DB2Database implementations. The PR fixes PR#2058.
  • [PR#2171] [logantracyo] Fixed typos in the ColumnConfig.java documentation
  • [PR#2189] [nvoxland] Fixed the classpath to include files with the relativeToChangelog=true parameter for Spring Boot
  • [PR#2216] [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 the Liquibase properties file
    • --strict=false|true as a CLI parameter
    • LIQUBIASE_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]

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:

To keep contributing:

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 https://learn.liquibase.com/.

Note: Liquibase 4.6.0 release has the wrong version of the Liquibase Pro XSD file. Liquibase 4.6.1 release is a patch release that fixes the issue.

Liquibase 4.6.0 Release

This release includes many community-contributed pull requests, Liquibase Community and Liquibase Pro bug fixes.

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

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 documentation. Also, check the page for the cases when you need different drivers. [PR#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 include the bulk-set command [DAT-8289]

    • Tip: For more information, see the bulk-set documentation.

  • New quality checks:

    • 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]

    Tip: For more information, see the List of Quality Checks documentation.

  • 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 documentation to learn more about DevOps metrics that provide the data to optimize your DevOps performance.

Enhancements

  • [PR#1975] [nvoxland] Changed the XSD default errorOnMissingOrEmpty attribute to true for the includeAll attribute in the XML changelog file. The PR fixes PR#1960.
  • [PR#1993] [siudeks] Added support for deferrable primary keys in the createTable Change Type. The PR fixes PR#1597.
  • [PR#1986] [alexey-ivanov-official] [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 and PR#1942.
  • [PR#2114] [nvoxland] Improved code and added tests in the liquibase.util package
  • [PR#1679] [thomseno] Changed the datetime type to datetime2 for the timestamp type on SQL Server.
  • [PR#2144] [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 (liquibase.properties), and LIQUIBASE_FILE_ENCODING=ASCII as an environment variable. The PR fixes PR#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 customize and copy commands to handle directories with spaces [DAT-8389]
  • Fixed the schemas and includeSchema attributes for the generate-changelog 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-8479]
  • 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] [pirocraft] Fixed the issue with Liquibase inserting a wrong default datetime value into MySQL. The PR fixes PR#1395.
  • [PR#1415] [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.
  • [PR#1931] [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] [haster] Fixed the UniqueConstraintSnapshotGenerator class switching to a bulk query after four unique constraints. The PR fixes PR#1996.
  • [PR#1973] [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.
  • [PR#104] [nvoxland] Fixed the drop-all command failing in the PostgreSQL database when the Liquibase-Cassandra extension is in the liquibase/lib directory. The PR fixes PR#47.
  • [PR#2006] [kdenis4] Fixed Liquibase not reading the liquibaseSchemaName and liquibaseCatalogName configuration settings. The PR fixes PR#2000.
  • [PR#1465] [danielthegray] Fixed the issue with Liquibase incorrectly inserting a long CLOB value in the database. Added integration tests.
  • [PR#1974] [gjvoosten] Fixed the issue with Liquibase not handling case-sensitive primary key names in the dropPrimaryKey Change Type for PostgreSQL. The PR fixes PR#1933.
  • [PR#1941] [meisenla] [ckulenkampff] Fixed the sqlFile Change Type to handle the encoding attribute. The PR fixes PR#1760.

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:

To keep contributing:

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 https://learn.liquibase.com/.

This release includes community-contributed pull requests, Liquibase Community and Liquibase Pro bug fixes, and support for Working with Quality Checks .

Quality checks allow you to run checks against SQL, XML, JSON, and YAML changelogs for conditions and configurations important to your organization. More quality checks are forthcoming in future releases; provide feedback on what checks matter most to you.

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

Notable Changes

There is a new family of commands to use to run quality checks:

  • liquibase show to list the available quality checks
  • liquibase 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 quality checks:

  • Implement enable/disable subcommands [DAT-7794]
  • Implement run subcommand for dynamic rules [DAT-7796]
  • Implement customize subcommand [DAT-7797]
  • Implement copy subcommand [DAT-7798]
  • Implement reset subcommand [DAT-7800]
  • Implement show subcommand for dynamic rules [DAT-7801]
  • Implement delete subcommand [DAT-7803]
  • 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]
  • Check for License & Limit gate [DAT-7802]

Resolved Liquibase Issues

  • Fail when creating a Scope with a null-parent #1354. #1377 Treehopper
  • Fixes Postgresql bit column support #1468 nderwin
  • Fix OSGiResourceAccessor failing due to javax.activation #1534 CMoH
  • fixed usage of computed values in prepared insert/update changes #1590 Plunts
  • Ensure that the root scope is initialized correctly regardless of whether a scope manager has been configured yet or not #1768 rudolfv
  • Fix UniqueConstraint snapshot query on db2z #1771 dileepan91
  • generate-changelog on an Oracle db ignores diffIncludeTablespace when creating MissingTableChange #1812 briar354
  • Get Set deleteCascade for serializer mapping #1837 smith-xyz
  • Add support for changeset ids and authors with spaces in formattedsql changelogs. #1845 jpz
  • More efficient XML resource loading #1860
  • Postgresql: Preserve existing search_path when setting the defaultSchemaName #1864
  • Fixed postgresql addPrimaryKey cluster handling #1880
  • CLI no longer reading defaultsFile from classpath #1893
  • Manage parent directory relative to changelog in IncludeAll #1968 Cubid
  • Improve synchronization of LockServiceFactory reset #1991
  • Fix createSequence for h2 when dataType is specified #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 generate-changelog error on Postgresql functions that have long signatures containing any '()' characters [DAT-7894]

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:

This release includes community-contributed pull requests, Liquibase Community and Liquibase Pro bug fixes, and enhancements to Liquibase Hub performance and pipelines.

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

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 still see stack traces, contact us. #1885dertin

Additionally, we fixed bugs in SQL files: #1798pierre2113

  • The sqlFile and relativeToChangelogFileattributes fail when using the logicalFilePathattribute#1277darkcamper
  • The wrong path received if relativeToChangelogFile=true and databaseChangeLog has logicalFilePath != PhisicalFilePath#1353kezhevatov

Resolved Liquibase Issues

  • Added a separate query for DB2 on AS400, which fixed the drop-all command on DB2 for iSeries #1412wardvijf
  • Fixed the logicalFilePathattribute not being serialized #1471tms-91
  • Fixed the SqlParser bug related to parsing UTF-8 valid symbols #1513matteoturra
  • Fixed the invalid update SQL generated for HSQL database in InsertOrUpdateGeneratorHsql.java#1563devorgpl
  • Added a validation error when the customChangeChange Type has no name attribute#1592danielthegray
  • 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. #1875koushikd02
  • Fixed the issue with escaping question marks in PostgreSQL: #1877juszczakn and goostleek
    • SQL changesets are transforming the PostgreSQL ? JSON operator into ??, causing function definitions using this operator to become invalid #1764
    • An error when processing a large Postgres SQL changeset #1507
  • Fixed the issue with ClassCastException in a standard lock service: java.time.LocalDateTime cannot be cast to java.util.Date#1878jocmer-evooq and 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 #1515jasonwjones
  • Added the ability to handle empty lines at the beginning of a formatted SQL #1713smith-xyz
  • Fixed loading the CLOB data into PostgreSQL. Instead of loading the CLOB file name, PostgreSQL loads the content of the CLOB file. #1791jidma
  • Changed the MD5SUM column value from RawSqlStatement to UpdateStatement#1602biryukovpavel
  • Fixed synchronization in ChangeLogHistoryServiceFactory.java#1361Olard
  • Fixed the changeset execution failure related to the DATICAL_SPERRORLOG table when using the runWith=sqlplusattribute 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 drop-all 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]

Contributions

Our community has built a lot. This release includes 15 PRs by 17 authors. Thanks to everyone who contributes and helps make the Liquibase community strong, including the following first-time contributors:

This release includes community-contributed pull requests, Liquibase Community and Liquibase Pro bug fixes, and enhancements to the drop-all command and SQL*Plus.

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

Known Issues

UniqueConstraintSnapshotGenerator does not handle more than four unique constraints. The diff command reports a difference in unique constraints caused by the PostgreSQL database snapshot having fewer unique constraints than the snapshot from another database compared. Also, the issue can cause unreliable diffs and changelog generation for all non-MySQL databases. The fix will be available in the next release. #1996

Resolved Liquibase Community Issues

  • Changed NullPointerException to ChangeLogParseException for the output when there is a typo in a changeSet node #1593
  • Added the support method to DatabaseConnection #1784
  • Fixed the issue with handling serial and bigserial if liquibase.convertDataTypes=false #1883
  • Improved the ConfigurationValueProvider performance #1952
  • Added the ability to allow an empty string for the defaultValue attribute #1963
  • Reintroduced support for the -D arguments in the CLI #1943
  • Restored the update-testing-rollback command #1939
  • Added the Maven goal for unexpected-changesets #1972

Resolved Liquibase Pro Issues

  • Added the ability to handle special characters in procedures when using the generate-changelog command. [DAT-6799]
  • SQL*Plus: Fixed the issue with formatted SQL changesets and runwith:sqlplus being stopped unless Liquibase includes a quit statement. [DAT-7376]
  • SQL*Plus: Fixed the SQL Plus spool log issue. [DAT-7461]

Additional Resolved Issues

  • Extended the drop-all command with optional hubConnectionId and hubProjectIdattributes. [DAT-6972]

    • Note: For more information, check our drop-all command documentation.

  • Fixed nested properties and the substitution of variables in YML changelogs. [DAT-7294]
  • Implemented the ability to use connectionjdbcurl when there is no project or connection ID with the drop-all command. [DAT-7388]
  • Improved the Liquibase Pro License key messaging. [DAT-7036]
  • Added the ability to handle a declined auto-registration when running the drop-all command. [DAT-7489]
  • Fixed auto-registration issues. [DAT-7505]

Contributions

Our community has built a lot. Thanks to everyone who contributes and helps make the Liquibase community strong!

  • danielthegray #1593 Changed NullPointerException to ChangeLogParseException for the output when there is a typo in a changeSet node
  • alexandru-slobodcicov #1784 Added the support method to DatabaseConnection
  • szandany:
    • #1883 Fixed the issue with handling serial and bigserial if liquibase.convertDataTypes=false
    • #1972 Added the Maven goal for unexpected-changesets
  • stuartwdouglas and pmancaux #1952 Improved the ConfigurationValueProvider performance
  • ZwoCa #1963 Added the ability to allow an empty string for the defaultValueattribute
  • Gama11 #1943 Reintroduced support for the -D arguments in the CLI
  • chornota #1939 Restored the update-testing-rollback command

For release notes, visit: https://github.com/liquibase/liquibase/releases/tag/v4.4.1

For release notes, visit: https://github.com/liquibase/liquibase/releases/tag/v4.4.0

For release notes, visit: https://github.com/liquibase/liquibase/releases/tag/v4.3.5

For release notes, visit: https://github.com/liquibase/liquibase/releases/tag/v4.3.4

For release notes, visit: https://github.com/liquibase/liquibase/releases/tag/v4.3.3

For release notes, visit: https://github.com/liquibase/liquibase/releases/tag/v4.3.2

For release notes, visit: https://github.com/liquibase/liquibase/releases/tag/v4.3.1

For release notes, visit: https://github.com/liquibase/liquibase/releases/tag/v4.3.0

For release notes, visit: https://github.com/liquibase/liquibase/releases/tag/v4.2.2

For release notes, visit: https://github.com/liquibase/liquibase/releases/tag/v4.2.1

For release notes, visit: https://github.com/liquibase/liquibase/releases/tag/v4.2.0

For release notes, visit: https://github.com/liquibase/liquibase/releases/tag/v4.1.1