• Concept
  • Release notes

Liquibase 4.33.0 release notes

Liquibase 4.33.0 is a minor release. This release delivers important updates across Policy Checks, Change Automation, and other areas of platform enhancement, along with critical bug fixes and improvements to MongoDB, PostgreSQL, and DB2 on Z/OS support.

Notable changes

Liquibase Pro

Change automation

  • PostgreSQL composite TYPE support in database inspection. Liquibase Pro now includes support for inspecting PostgreSQL Composite TYPE objects during database inspection operations, such as snapshot and diff. This enhancement ensures Composite TYPEs appear in inspection outputs, helping users manage and track changes to complex data structures more effectively. [INT-1249] [INT-135]

  • PostgreSQL composite TYPE cupport in generate-changelog and diff-changelog. Liquibase Pro now includes support for detecting PostgreSQL composite TYPE objects during generate-changelog and diff-changelog operations. This enhancement ensures that composite TYPE definitions, used to group multiple fields into a custom data structure, are captured and modeled alongside other schema elements, helping users manage and track changes more comprehensively. [INT-1251]

  • PostgreSQL password escaping enhancement. Liquibase now escapes special characters in PostgreSQL passwords when using the psql native executor. Previously, if a password included characters requiring percent-encoding (such as @, %, or #), the executor would fail with a psql: error: invalid percent-encoded token message. [DAT-20254]

  • DB2 on Z/OS JCL executor. Liquibase Pro now includes the ability to submit JCL jobs to the mainframe via Db2 DSNUTILU stored procedure. This enables users to automate more sophisticated procedures by integrating system-level and database activities in a standard changelog format. This feature is enabled by a runwith:JCL decoration on applicable changesets containing properly formatted JCL.[INT-573, INT-1217]

  • Improved persistent spool file behavior for SQLPlus executor. The SQLPlus executor ensures that spool files are always retained when --sqlplus-create-spool=true, giving users consistent access to output files. Previously, spool file retention was tied to the --sqlplus-keep-temp setting; now, this setting applies only to temporary SQL files, not spool files. This decoupling improves clarity and gives users more control—if a spool file is created, it will remain unless users opt out by setting --sqlplus-create-spool=false. [DAT-18983

Policy checks

  • MongoChangetypeAttributes policy check. Introduced a new quality check named MongoChangetypeAttributes, allowing users to enforce specific values or patterns for attributes within MongoDB-specific changetypes. Users can select a single Mongo changetype (e.g., createIndex, dropCollection) and specify expected values or patterns for its attributes. The check triggers if a specified attribute is present but does not match the defined value or regex—ensuring consistent standards across Mongo changesets. This supports validation across key changetypes attributes like adminCommand, createCollection, insertOne, and enhances control and quality enforcement in MongoDB deployment pipelines. [DAT-18275]

Notable changes

Liquibase Open Source

Important dependency updates

  • Liquibase OSS 4.33+ has Java 24 core build support.

  • The liquibase-cdi and liquibase-cdi-jakarta modules have been removed and are no longer supported in Liquibase 4.33.0 and later.

Liquibase Pro changelog

Bug fixes

  • DAT-20176 and DAT-20202Liquibase displays SQL compiler errors if they occur.
  • DAT-20193: Correctly labeled the AWS and RDS documentation to reflect that it is available to OSS users by @AMBERMW13
  • DAT-20244: When a formatted SQL changelog is parsed and is found to have multiple header lines, the message will display: Duplicate formatted SQL header at line X
  • DAT-20282: The deployment summary no longer includes internal DATABASECHANGELOG updates in the "Rows affected" count. This prevents inconsistencies when no customer data is changed, but the summary previously showed rows affected due to internal tracking.
  • DAT-18983: SQLPlus Spool file saves if you set –sqlplus-create-spool: true or –sql-plus-keep-temp=true. Learn more here: runWithSpoolFile

Changelog

Liquibase Open Source

New features

  • (#7059) Java 24 core build support @filipelautert

  • (#7046) feat: add rawDateValue field to store unprocessed date input in ColumnConfig @filipelautert

  • (#7036) Complain and throw an exception when multiple header lines are found in a formatted SQL changelog DAT-20244 @wwillard7800

  • (#6987) Added reportsEnabled property for Maven plugin @wwillard7800 DAT-20185

  • (#7031) Added property for disabling command tests at runtime @wwillard7800

  • (#6840) Comments field from CreateProcedure change renamed to 'comment' @MalloD12

  • (#6916) Added new argument to AbstractFormattedChangeLogParser.handleAdditionalLines method @wwillard7800

  • (#7032) Refactor: last-wins local parameters search in changeLog hierarchy by @boolivar

  • (#7017) Allow showSqlWarnings message to be overridden in JdbcExecutor [DAT-20202] by @wwillard7800

  • (#6990) Add application name to JDBC properties for Snowflake [DAT-20202] by @wwillard7800

  • (#7071) Pass the database instance in scope when parsing the changelog [DAT-20378]by @wwillard7800

  • (#7063) Do not count DBCL queries in rows affected message [DAT-20282] by @StevenMassaro

  • (#7065) Added default implementation of getVisibleUrl to DatabaseConnection to be used when the URL gets displayed by @wwillard7800

  • (#7053) Do not show the output file saved message unless the exit code is 0 by @wwillard7800

  • (#6995) feat(DEVX-12): Removal of liquibase-cdi and liquibase-cdi-jakarta modules @filipelautert

Bug fixes

  • (#7062) Fix issue in DBMS skip check that caused a regression @wwillard7800

  • (#7048) Do not reset the changeset execType when looping through the changes @wwillard7800

  • (#7049) fix: resolve inconsistency in StandardLockService by ensuring table snapshot is validated before processing changes @filipelautert

  • (#6827) Error handling support added to prevent XML changelog format from having other than the databaseChangeLog tag as the root element @MalloD12

  • (#7001) Restore UniqueConstraintExistsPrecondition logic, Github issue 6984 @wwillard7800

  • (#6844) Exclude static fields from changelog serialization @evilbc

  • (#7002) Fix: Improve URI normalization logic for resource paths inside jars @filipelautert

  • (#6986) Only destroy lock service if drop-all succeeds (DAT-13088) @StevenMassaro

  • (#6925) Fix for YAML changelogs with many references to be parsed successfully with snakeyaml @MalloD12

  • (#7056) Fix: Update snapshot logic to handle null snapshot returns by @filipelautert

  • (#7085) Fix: do not snapshot index type for cockroach DB as indexes behave different on this database and we don't know where to find it. by @filipelautert

  • (#7062) Fix issue in DBMS skip check that caused a regression by @wwillard7800

  • (#7069) Handle situation where DBCL presence was not detected due to permissions [DAT-20314] by @wwillard7800

Security, driver, and other updates

  • (#7038) chore(deps-dev): bump org.xerial:sqlite-jdbc from 3.49.1.0 to 3.50.1.0 @dependabot

  • (#6997) chore(deps): bump org.testcontainers:testcontainers-bom from 1.21.0 to 1.21.1 @dependabot

  • (#7040) chore(deps-dev): bump org.postgresql:postgresql from 42.7.5 to 42.7.7 in /liquibase-dist @dependabot

  • (#7082) chore(deps): bump org.apache.maven.plugins:maven-enforcer-plugin from 3.5.0 to 3.6.0 by @dependabot

  • (#7068) chore(deps): bump org.junit.jupiter:junit-jupiter from 5.12.2 to 5.13.2 by @dependabot

  • (#7067) chore(deps): bump org.junit.platform:junit-platform-suite from 1.11.4 to 1.13.2 by @dependabot

  • (#7066) chore(deps): bump junit-jupiter.version from 5.12.2 to 5.13.2 by @dependabot

  • (#7064) chore(deps-dev): bump com.microsoft.sqlserver:mssql-jdbc from 12.10.0.jre8 to 12.10.1.jre8 by @dependabot

  • (#7073) chore(deps-dev): bump org.xerial:sqlite-jdbc from 3.50.1.0 to 3.50.2.0 by @dependabot

  • (#7061) chore(deps): bump com.opencsv:opencsv from 5.11 to 5.11.2 by @dependabot

  • (#7060) chore(deps): bump org.codehaus.mojo:flatten-maven-plugin from 1.7.0 to 1.7.1 by @dependabot

  • (#7072) chore(deps): bump org.testcontainers:testcontainers-bom from 1.21.1 to 1.21.3 by @dependabot

  • (#7026) chore(deps): bump targetMavenVersion from 3.9.9 to 3.9.10 by @dependabot

  • (#7075) chore(deps-dev): bump org.mariadb.jdbc:mariadb-java-client from 3.5.3 to 3.5.4 by @dependabot

  • (#7023) chore(deps): bump org.codehaus.mojo:build-helper-maven-plugin from 3.6.0 to 3.6.1 by @dependabot

  • (#7022) chore(deps): bump digicert/ssm-code-signing from 1.0.0 to 1.0.1 by @dependabot

  • (#7008) chore(deps-dev): bump net.snowflake:snowflake-jdbc from 3.24.0 to 3.24.2 by @dependabot

  • (#7010) chore(deps-dev): bump org.firebirdsql.jdbc:jaybird from 5.0.7.java8 to 5.0.8.java8 by @dependabot

  • (#6988) chore(deps): bump groovy.version from 4.0.26 to 4.0.27 by @dependabot

Full changelog

You can view a full changelog and compare Liquibase v4.31.0 to 4.32.0 on our GitHub.

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 Liquibase University.

Read the documentation

Please check out and contribute to the continually improving docs.

Join 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:

File descriptions

  • Liquibase CLI - Includes open source + commercial functionality.

  • liquibase-x.y.z.tar.gz - Archive in tar.gz format.

  • liquibase-x.y.z.zip - Archive in zip format.

  • liquibase-windows-x64-installer-x.y.z.exe - Installer for Windows.

  • Primary Libraries - For embedding in other software.

  • liquibase-core-x.y.z.jar - Base Liquibase library (open source).

  • liquibase-commerical-x.y.z.jar - Additional commercial functionality.

  • liquibase-additional-x.y.z.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.

PreviousRelease notesNextLiquibase 4.32.0 release notes