Release Notes

To see the release notes for Liquibase 3.0.7 and earlier, refer to Liquibase releases.

Liquibase 4.5.0 Release

Liquibase 4.5.0 is now available on the Download Liquibase page.

This release includes community-contributed pull requests, Liquibase Community and Liquibase Pro bug fixes, and support for 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 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 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]
  • Implement checks 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
  • GenerateChangeLog 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 generateChangeLog 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:

Liquibase 4.4.3 is now available on the Download Liquibase page.

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 are still seeing stack traces, please 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 dropAll 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 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]

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:

Liquibase 4.4.2 is now available on the Download Liquibase page.

This release includes community-contributed pull requests, Liquibase Community and Liquibase Pro bug fixes, and enhancements to the dropAll 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 updateTestingRollback command #1939
  • Added the Maven goal for unexpectedChangeSets #1972

Resolved Liquibase Pro Issues

  • Added the ability to handle special characters in procedures when using the generateChangeLog 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 dropAll command with optional hubConnectionId and hubProjectIdattributes. [DAT-6972]

    • Note: For more information, check our dropAll 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 dropAll command. [DAT-7388]
  • Improved the Liquibase Pro License key messaging. [DAT-7036]
  • Added the ability to handle a declined auto-registration when running the dropAll 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 unexpectedChangeSets
  • 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 updateTestingRollback command

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

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

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

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

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

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

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

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

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

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

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

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

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/v3.10.3

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

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/v3.10.2

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

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/v4.0.0-beta2

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/v3.10.1

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/v3.10.0

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/v3.9.0

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/v4.0.0-beta1

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/v3.8.9

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/v3.8.8

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/v3.8.7

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/v3.8.6

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/v3.8.5

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/v3.8.4

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/v3.8.3

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/v3.8.2

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/v3.8.1

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/liquibase-parent-3.8.0

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/liquibase-parent-3.7.0

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/liquibase-parent-3.6.3

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/liquibase-parent-3.6.2

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/liquibase-parent-3.6.1

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/liquibase-parent-3.6.0

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/3.6.0-beta1

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/liquibase-parent-3.5.5

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/liquibase-parent-3.5.4

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/liquibase-parent-3.5.3

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/liquibase-parent-3.5.2

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/liquibase-parent-3.5.1

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/liquibase-parent-3.5.0

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/liquibase-parent-3.4.2

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/liquibase-parent-3.4.1

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/liquibase-parent-3.4.0

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/liquibase-parent-3.3.5

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/liquibase-parent-3.3.4

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/liquibase-parent-3.3.3

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/liquibase-parent-3.3.2

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/liquibase-parent-3.3.1

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/liquibase-parent-3.3.0

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/liquibase-parent-3.2.3

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/liquibase-parent-3.1.1

For release notes, please visit: https://github.com/liquibase/liquibase/releases/tag/liquibase-parent-3.0.8