Liquibase 4.28.0 release notes

Liquibase 4.28.0 is a major release. Liquibase 4.28.0 contains several notable enhancements for Liquibase Pro users: Support for the DATABASECHANGELOGHISTORY table on Google BigQuery, more advanced variable functionality in flow files, support for include and includeAll in formatted SQL changelogs, and a new --pro-strict parameter to verify the existence of your Liquibase Pro resource files and rollback scripts.

See GitHub formatted release notes for more information. Full changelog: 4.27.0–4.28.0 (May 21, 2024)

Liquibase Pro

DATABASECHANGELOGHISTORY table with Google BigQuery: See all changes that have been applied

  • Liquibase uses the DATABASECHANGELOGHISTORY (DBCLH) table to record a history of all database changes. Unlike the DATABASECHANGELOG (DBCL) table, which only shows active changes, the DBCLH shows all historical changes, including those that have been rolled back, dropped, or cleared. The DBCLH is now available for Google BigQuery users.

  • Learn more: DATABASECHANGELOGHISTORY table.

Flow file usage enhancements: Full strings as single variable values, and nested variables for double-expansion

  • Flow files have been enhanced to expand multi-part arguments from a single variable. Think cmdArgs: { "${COMMAND_ARGS}" }, which provides for more dynamic customization in the flow file operations. Similarly, variables can include other variables when expanded, which will in turn be expanded before processing.

  • Learn more: Flow Variables.

Formatted SQL changelog enhanced with include/includeAll functionality

  • Bringing parity to Formatted SQL users, we are happy to announce include and includeAll capabilities from within formatted SQL changelogs.

  • Learn more: include and includeAll.

New --pro-strict parameter: Catch missing Liquibase Pro resource files early

  • A new optional Liquibase Pro parameter alerts users when paths to Liquibase Pro resource files (such as flow files, check settings files, and native executor configuration files) and rollback scripts are missing or empty.

  • Learn more: pro-strict.

Liquibase Open Source and Liquibase Pro

Database platform improvements

SQL Server

  • Stop appending an extra semicolon to Formatted SQL statements.

  • Fix the parsing error that occurred in SQL containing BEGIN DIALOG/BEGIN CONVERSATION.

Oracle

  • Fix the ordering of the Oracle SQL for global temporary tables from TEMPORARY GLOBAL to GLOBAL TEMPORARY.

  • Add support for the ON COMMIT clause.

MySQL

  • Update the uniqueConstraintExists precondition to honor the schemaName attribute.

  • Update the columnExists precondition to have the correct schema when checking against a snapshot.

JDBC driver updates

  • SQLite JDBC Driver to 3.45.3.0

  • Snowflake JDBC driver to 3.16.0

Liquibase 4.28.0 release notes - Liquibase