Liquibase Pro

Observability: Update reports

These reports give you insights into your database's status and enable you to quickly find and resolve errors in your automation pipeline. They can also help you detect patterns of failures that you can catch with policy checks or use to inform internal training and education for your teams.

Learn more at: Update Report

Observability: Drift Report extended to diffchangelog command

With our new HTML format, you can quickly see the differences between databases, including detailed object differences. This easy-to-read and shareable report makes it faster than ever to detect and fix database drift.

Learn more at: Drift Report

Convenience: New liquibase connect command

A new command to test your database's url, username, and password are all configured correctly, and that Liquibase can reach your database -- and no changelog required.

Learn more at: The connect command.

Convenience: Global endDelimiters

Global endDelimiters allow you to set a default endDelimiter at the project level. This ensures consistency and saves you time from manually updating this value for each changeset.

Learn more at: pro-global-end-delimiter

Observability: Structured logging enhancement

Thanks to your feedback, we’ve added a new set of keys that improve data analysis capabilities surrounding exceptions and policy checks.

Learn more at: Structured Logging and Structured Logging Keys

Liquibase Open Source and Liquibase Pro

Liquibase capability enhancements

• Added the showSummaryOutput property for the update command.

• Added system properties as an additional way to provide configuration options to the CLI.

• Improve SQL parsing of quoted strings.

• Update generate-ghangelog to properly format generated view definitions for all databases.

• Minor bug fixes related to checksums.

• Various performance and stability improvements.

JDBC driver updates

• Oracle JDBC driver updated from 19.20.0.0 to 19.21.0.0

• PostgreSQL JDBC driver updated from 42.7.0 to 42.7.1

• Snowflake JDBC driver updated from 3.14.1 to 3.14.3

• DB2 JDBC driver updated from 11.5.8.0 to 11.5.9.0

• SQLite JDBC driver updated from 3.43.0.0 to 3.43.2.2

Database platform improvements

H2 Database

• Updated PrimaryKeyExistsPrecondition to require a table name.

MySQL

• Updated boolean datatype from TinyInt(1) to TinyInt following MySQL recommendations.

• Updated default value handling to allow defaultValueComputed for MySQL 5.7.

Oracle

• Liquibase snapshot now includes Oracle Temporary Global tables

• Liquibase snapshot excludes Oracle Queue tables.

SQL Anywhere

• Automatically recompile all views after the last changeset is executed (at the end of an update).

Postgres

• Fix the generated SQL for CHAR datatype.

DB2 LUW

• Corrected determination of the DB2 version for the support of BOOLEAN columns.

Spring and Spring Boot

• Add a property so users can easily switch from ConsoleUiService to LoggerUIService.

• Disable Derby shutdown in Spring Boot context.