v4.13.0

Notable Changes

PRO DAT-10083 - Added PSQL native executor feature by @abrackx

• You can now use the runWith command to pull in PSQL changesets which require highly specialized SQL that often cannot easily be deployed over JDBC. For more information, see the documentation here.

Enhancements

• Added new liquibase.duplicateFileMode setting by @nvoxland in #3006
• Add additional info in CLI's --version output by @nvoxland in #2942
• Added support for new "searchPath" global configuration by @nvoxland in #2917
• PRO DAT-10575: add labels and contexts parameter to checks run command by @StevenMassaro
• PRO DAT-10803 added sproc support for Snowflake by @KushnirykOleh

Fixes

• Hide CommandFailedException stacktrace when thrown to set exit code (DAT-9608) by @StevenMassaro in #2938
• Update copyright year in txt files; also update links in txt files (DAT-10261) by @StevenMassaro in #2955
• add support for default-catalog-name in SQL Server (DAT-10484) by @StevenMassaro in #2940
• Make additional query for more column information for MariaDB DAT-8693 by @wwillard7800 in #2898
• Include should fail if a parser cannot be found for the specified file by @nvoxland in #2972
• Improved postgresql prepared statement performance by @nvoxland in #2914
• Cleanup relative paths preventing sql files being found by the class loader by @marcsowen in #2932
• Fix missing attributes in serialization by @tms-91 in #2585
• Improved parsing of single-quoted strings by @nvoxland in #2949
• DAT-10260: add outputFile argument in maven plugin for checks.run target by @StevenMassaro in #2975
• Formatted SQL files with uppercase in the liquibase attributes (DAT-10531) by @abrackx in #2985
• handle empty or null input to stripComments method (DAT-10296) by @StevenMassaro in #2970
• Fixed issue with parameter expression parsing by @nvoxland in #2984
• Fixed before/after/at column arguments in addColumn by @nvoxland in #2943
• Adds liquibase.psql.conf example (DAT-10303) by @abrackx in #2939
• [DAT-10093] added schema escaping to getColumns call to jdbc metadata classes by @KushnirykOleh in #2895
• Use "numeric" (without parameters) data type in PostgreSQL by @LonwoLonwo in #1906
• Force "json" resultset formats in Snowflake when running Java 17+ by @nvoxland in #3019
• PRO DAT-9608: Hide CommandFailedException stacktrace when thrown from checks run by @StevenMassaro
• PRO Reenables oracle integration tests by @abrackx
• PRO DAT-10283 Checks should also look at included contexts and labels by @wwillard7800
• PRO DAT-10667: Hide disabled checks from unsupported changeset type list by @StevenMassaro
• PRO DAT-10690 and DAT-10691: Hide validated changelogs and database objects when no license key is provided by @StevenMassaro
• PRO DAT-10296: Handle empty or completely commented out changesets in CheckForSpecificPatternsInSQL check by @StevenMassaro

Updates

Security Updates

No security updates needed in this release.

JDBC Driver and Third-Party Library Updates

• Upgraded jaxb-core from 2.3.0.1 to 4.0.0 by @dependabot in #2962
• Upgraded snowflake-jdbc from 3.13.19 to 3.13.20 by @dependabot in #3001
• Upgraded mariadb-java-client from 3.0.4 to 3.0.5 by @dependabot in #2881
• Upgraded ojdbc8 from 21.5.0.0 to 21.6.0.0.1 by @dependabot in #2987
• Upgraded h2 from 2.1.212 to 2.1.214 by @dependabot in #2944
• PRO Bump proguard-maven-plugin from 2.5.3 to 2.6.0 by @dependabot
• PRO Bump maven-scm-plugin from 1.12.2 to 1.13.0 by @dependabot
• PRO Bump assertj-core from 3.22.0 to 3.23.1 by @dependabot

New Contributors

• @marcsowen made their first contribution in #2932
• @LonwoLonwo made their first contribution in #1906

Full Changelog: v4.12.0...v4.13.0

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 https://learn.liquibase.com/.

Read the Documentation

Please check out and contribute to the continually improving docs, now at https://docs.liquibase.com/.

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

Contribute code
Make doc updates
Help by asking and answering questions
Set up a chat with the Product team

Thanks to everyone who helps make the Liquibase community strong!