Liquibase 4.4.3 Release Notes

Liquibase v4.4.3 is a patch release.

See GitHub formatted release notes for more information. Full changelog: 4.4.2–4.4.3 (August 6, 2021)

This release includes community-contributed pull requests, Liquibase Open Source 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: