liquibase/liquibase v4.28.0

on GitHub

Liquibase 4.28.0 is a major release

Notable Changes

[PRO]

DATABASECHANGELOGHISTORY table with Big Query: See all changes that have been applied with Big Query

• Liquibase uses the DATABASECHANGELOGHISTORY (DBCLH) table to record a history of all changes made to the database. Unlike the DATABASECHANGELOG table that 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 Big Query users.
• Learn more https://docs.liquibase.com/databasechangeloghistory

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

• Flow files have been enhanced to allow multi-part args to be expanded from a single variable. Think cmdArgs: { "${COMMAND_ARGS}" }, which allows for more dynamic customization in the flowfile operations. Similarly, variables can include variables when expanded, which will in turn be expanded before processing.
• Learn more https://docs.liquibase.com/flow

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 https://docs.liquibase.com/change-types/home.html#miscellaneous

New --pro-strict flag: Catch missing Pro resource files early!

• A new optional pro parameter which alerts users when specified paths to Pro resource files (flow files, checks settings files, native executor conf files, etc) or rollback scripts are missing or empty.
• Learn more https://docs.liquibase.com/parameters/pro-strict.html

[PRO] Changelog

• DAT-17543: Handle chained checks which have been skipped because of a scope mismatch in https://github.com/liquibase/liquibase-pro/pull/1697 by wwillard7800
• DAT-16275: automatically open generated reports in browser in https://github.com/liquibase/liquibase-pro/pull/1703 by StevenMassaro
• DAT-17485: always show update summary message in update report in https://github.com/liquibase/liquibase-pro/pull/1708 by StevenMassaro
• DAT-17096: Turn on reports by default in https://github.com/liquibase/liquibase-pro/pull/1675 by @abrackx
• DAT-17630: Rework logic for checking for database connection in https://github.com/liquibase/liquibase-pro/pull/1706 by wwillard7800
• DAT-17400: add Snowflake integration tests in https://github.com/liquibase/liquibase-pro/pull/1693 by StevenMassaro
• DAT-17540: Rename MaxRowsAllowed and added two more checks for update and delete in https://github.com/liquibase/liquibase-pro/pull/1686 by wwillard7800
• DAT-17348: add condition evaluation details to conditions which evaluate to true in https://github.com/liquibase/liquibase-pro/pull/1688 by StevenMassaro
• DAT-15920: error if native executor conf file or rollback file is not found and pro-strict is true in https://github.com/liquibase/liquibase-pro/pull/1663 by StevenMassaro
• DAT-17601 Expand variables that are included in flow files https://github.com/liquibase/liquibase-pro/pull/1694 by wwillard7800

🤖 [PRO] Security, Driver and Other Updates

[OSS] Changelog

💥 Breaking Changes

• (#5619) Improve snapshot extensibility for NoSQL databases @fbiville
• (#5729) remove ValueHandlerUtil and improve CLI argument parsing (DAT-15398) @StevenMassaro

Changes

• (#5822) test PR for azure uber @sayaliM0412

🚀 New Features

• (#5899) H2 tests may end up with an incorrect list of the standard DatabaseObject types, so we need to reset the factory @wwillard7800
• (#5897) chore: invoke deprecated methods in default supports method for backwards compatibility @filipelautert
• (#5870) only run drop all if database was used in the test @StevenMassaro
• (#5848) do not allow arguments with default values to be required (DAT-17436) @StevenMassaro
• (#5833) Use Java 8 features @asashour
• (#5767) Ensure a new-line at the end of text files. @asashour
• (#5814) refactor ValidatingVisitor to use factory pattern, error if strict is set and defaults file does not exist (DAT-15920) @StevenMassaro
• (#5716) Fix typos @asashour
• (#5782) Update ChangeSetService to handle new ModifyChangeset creation (DAT-17322) @wwillard7800
• (#5715) Add @Deprecated annotation. @asashour
• (#5828) Improve diffChangelog error message @filipelautert
• (#5799) Add new lifecycle methods for UpdateTestingRollbackCommandStep (DAT-15641) @abrackx
• (#5780) Deprecate ThreadLocalScopeManager as it is no longer required @filipelautert
• (#5714) Introduce a method with a correct name of StringUtil.randomIdentifer(). @asashour
• (#5793) move output file handling into factory pattern (DAT-17290) @StevenMassaro
• (#5741) Implement Customizer for SpringLiquibase. @asashour
• (#5777) Prevent error when unlocking the changelog in MySQL affects zero rows and useAffectedRows is true. Fixes #5502 @mpvvliet
• (#5619) Improve snapshot extensibility for NoSQL databases @fbiville
• (#5658) User lombok Getter and Setter. @asashour
• (#5532) Record current Liquibase version on a RERUN changeset (#5529) @jdvorak001
• (#5745) Add method that can be used to verify database connection (DAT-16600) @vitaliimak
• (#5705) upgrade groovy, spock and mockito to later versions (DAT-10403) @StevenMassaro
• (#5861) Update db2 docker location by @filipelautert
• (#5860) chore: increasing test coverage by @filipelautert
• (#5853) use Apache Commons where possible, instead of homegrown solutions (DAT-17303) by @StevenMassaro
• (#5867) cleanup weekly-integration-tests.yml (DAT-17400) by @StevenMassaro
• (#4240) PD-3241: failOnError syntax by @adrian-velonis1
• (#5871) load shared database fields in tests by @StevenMassaro

🐛 Bug Fixes 🛠

• (#5908) BUGFIX Azure jar wrong suffix @jandroav
• (#5795) Fixes issue with incorrect schema in column exists precondition when checking using a snapshot @mpvvliet
• (#5783) Fixed issue that unique constraint precondition does not honor schemaName attribute on MySQL @mpvvliet
• (#5874) refactor cached prepared statement to become ThreadLocal (#5635) @adaryin
• (#5888) normalize paths in DatabaseChangeLog using commons-io (DAT-17592) @StevenMassaro
• (#5887) Fix ordering of clause for Oracle global temporary tables SQL generation @wwillard7800
• (#5869) Update diff summary results in mdc to not be recalculated (DAT-17096) @abrackx
• (#5756) Fix (MSSQL): end delimiter logic broken by BEGIN DIALOG/BEGIN CONVERSATION @MalloD12
• (#5781) Fix (MSSQL): default end delimiter applied when there is an endDelimiter applied for a given chanset @MalloD12
• (#5883) Issue 5654 includeall min max depth fixes @jasonlyle88
• (#5842) optimize DBCL checksum query and set fetch size on all statements (DAT-17267) @StevenMassaro
• (#5846) DAT-17566 @sayaliM0412
• (#5794) fix calculation of total change sets in update summary (DAT-17262) @StevenMassaro
• (#5792) fix: keep indexes list in the order returned by database @filipelautert
• (#5703) Also replace '@' character in temporary file names DAT-17292 @wwillard7800
• (#5727) fixes #5724: compare normalized file paths @jgarec
• (#5755) detect duplicate jars that do not have a version (DAT-16044) @StevenMassaro
• (#5687) fix: addColumn changes are not respecting Datatypes definitions @filipelautert
• (#5580) Support to generate a ChangeSetStatus with setting all its attributes when a changeset will be skipped @MalloD12
• (#5751) New boolean input logic allows 'off' to be valid, so fix test @wwillard7800
• (#5881) Update codeql.yml by @sayaliM0412
• (#5891)DAT-17618: Update fossa_ai.yml to use authorize by @sayaliM0412

🤖 Security, Driver and Other Updates

New Contributors

• @adaryin made their first contribution 5874

Full Changelog: v4.27.1...v4.28.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!

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
• liquibase-macos-installer-x.y.z.dmg -- Installer for MacOS
• 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