Skip to content

Liquibase v4.27.0

Latest
Compare
Choose a tag to compare
@liquibot liquibot released this 27 Mar 20:27
· 94 commits to master since this release
9c8fb14

Liquibase 4.27.0 is a major release

Important

Liquibase 4.27.0 contains several New Capabilities and Notable Enhancements for Liquibase Pro users: DATABASECHANGELOGHISTORY table, Quality Checks Chains, Rollback Reports

Note

See the Liquibase 4.27.0 Release Notes for the complete set of release information.

Notable Changes

[PRO]

Liquibase DATABASECHANGELOGHISTORY table: See all changes that have been applied to your database

  • With the new DatabaseChangeLogHistory (DBCLH) Table, get a complete history of changes made to your database through Liquibase operations, including updates, rollbacks, dropAlls, tags, changelogsyncs, and repeated updates to the same ChangeSet. The DBCLH table is disabled by default, so Users must turn it on to start capturing historical data.
  • Learn more https://docs.liquibase.com/databasechangeloghistory

Quality Checks Chains: Perform multiple policy evaluations with a single Quality Check

  • Chain multiple Quality Checks together with logic conditionals (AND, OR, and NOT) for more flexibility to perform multiple evaluations in a single check. Useful to confirm complex best practices or governance issues. Check Chains are run like traditional single-condition existing Quality Checks
  • Learn more https://docs.liquibase.com/quality-checks

Observability: Rollback Reports: Understand and share the data on the execution of rollback commands

  • Easily scan and understand a high-level overview of the ChangeSets rolled back. Get a detailed view of both successful and failed rollbacks. Collaborate with your team with shareable report in PDF format
  • Learn more https://docs.liquibase.com/observability

Breaking Change

[PRO] Changelog

🤖 [PRO] Security, Driver and Other Updates

39 change * Bump liquibase/build-logic from 0.6.4 to 0.6.6 dependencies github_actions #1616 by dependabot bot
  • Bump org.projectlombok:lombok from 1.18.30 to 1.18.32 #1614 by dependabot bot

  • Bump org.apache.maven.plugins:maven-assembly-plugin from 3.6.0 to 3.7.1 #1613 by dependabot bot

  • Bump org.apache.maven.plugins:maven-compiler-plugin from 3.12.1 to 3.13.0 #1612 by dependabot bot

  • Bump com.networknt:json-schema-validator from 1.3.3 to 1.4.0 #1610 by dependabot bot

  • Bump actions/delete-package-versions from 3 to 5 dependencies github_actions #1551 by dependabot bot

  • Bump org.postgresql:postgresql from 42.7.2 to 42.7.3 #1604 by dependabot bot

  • Bump com.fasterxml.jackson.core:jackson-core from 2.16.2 to 2.17.0 #1597 by dependabot bot

  • Bump com.fasterxml.jackson.module:jackson-module-jaxb-annotations from 2.16.2 to 2.17.0 #1595 by dependabot bot

  • Bump org.sonarsource.scanner.maven:sonar-maven-plugin from 3.10.0.2594 to 3.11.0.3922 #1599 by dependabot bot

  • Bump com.fasterxml.jackson.core:jackson-databind from 2.16.2 to 2.17.0 #1596 by dependabot bot

  • Bump com.fasterxml.jackson.core:jackson-annotations from 2.16.2 to 2.17.0 #1594 by dependabot bot

  • Bump com.github.jsqlparser:jsqlparser from 4.8 to 4.9 #1583 by dependabot bot

  • Bump com.fasterxml.jackson.core:jackson-annotations from 2.16.1 to 2.16.2 #1588 by dependabot bot

  • Bump com.fasterxml.jackson.core:jackson-core from 2.16.1 to 2.16.2 #1586 by dependabot bot

  • Bump com.fasterxml.jackson.module:jackson-module-jaxb-annotations from 2.16.1 to 2.16.2 #1584 by dependabot bot

  • Bump com.fasterxml.jackson.core:jackson-databind from 2.16.1 to 2.16.2 #1585 by dependabot bot

  • Bump ch.qos.logback:logback-classic from 1.5.1 to 1.5.2 #1568 by dependabot bot

  • Bump com.fasterxml.jackson.module:jackson-module-jaxb-annotations from 2.15.3 to 2.16.1 #1449 by dependabot bot

  • Bump com.fasterxml.jackson.core:jackson-annotations from 2.15.3 to 2.16.1 #1450 by dependabot bot

  • Bump com.oracle.database.jdbc:ojdbc8 from 19.21.0.0 to 19.22.0.0 #1563 by dependabot bot

  • Bump org.mariadb.jdbc:mariadb-java-client from 3.2.0 to 3.3.3 #1555 by dependabot bot

  • Bump com.fasterxml.jackson.core:jackson-core from 2.15.3 to 2.16.1 #1451 by dependabot bot

  • Bump com.fasterxml.jackson.core:jackson-databind from 2.15.3 to 2.16.1 #1452 by dependabot bot

  • Bump com.github.jsqlparser:jsqlparser from 4.7 to 4.8 #1558 by dependabot bot

  • Bump com.github.wvengen:proguard-maven-plugin from 2.6.0 to 2.6.1 #1557 by dependabot bot

  • Bump org.apache.maven.plugins:maven-shade-plugin from 3.5.1 to 3.5.2 #1559 by dependabot bot

  • Bump org.codehaus.mojo:flatten-maven-plugin from 1.5.0 to 1.6.0 #1560 by dependabot bot

  • Bump commons-codec:commons-codec from 1.16.0 to 1.16.1 #1561 by dependabot bot

  • Bump org.mvel:mvel2 from 2.5.0.Final to 2.5.2.Final #1562 by dependabot bot

  • Bump com.fasterxml.jackson.dataformat:jackson-dataformat-yaml from 2.15.3 to 2.16.1 #1453 by dependabot bot

  • Bump org.jacoco:jacoco-maven-plugin from 0.8.10 to 0.8.11 dependencies java #1309 by dependabot bot

  • Bump org.apache.maven.plugins:maven-compiler-plugin from 3.11.0 to 3.12.1 #1547 by dependabot bot

  • Bump org.assertj:assertj-core from 3.24.2 to 3.25.3 #1548 by dependabot bot

  • Bump ch.qos.logback:logback-classic from 1.4.11 to 1.5.1 #1543 by dependabot bot

  • Revert * Bump actions/delete-package-versions from 3 to 5 #1546 by StevenMassaro

  • Bump org.postgresql:postgresql from 42.6.0 to 42.7.2 #1530 by dependabot bot

  • Bump org.postgresql:postgresql from 42.6.0 to 42.6.1 in /pro dependencies java #1541 by dependabot bot

  • Bump org.postgresql:postgresql from 42.6.0 to 42.7.2 in /liquibase-pro-extension-testing dependencies java #1527 by dependabot bot

[OSS] Changelog

💥 Breaking Changes

🚀 New Features

Changes

  • (#5329) Support runWith executors committing after the change set completes @dzeigler

🐛 Bug Fixes 🛠

  • (#5707) [DAT-16135] add new scope flag for modifyChangeSet flow @KushnirykOleh
  • (#5695) Handle empty or null schema for CreateView with replace option DAT-16446 @wwillard7800
  • (#5686) add ignore property to includeAll XSD (DAT-14921) @StevenMassaro
  • (#5700) FIX: SimpleSQLGrammar quote parsing regression @jasonlyle88
  • (#5668) load driver from global argument as well as command argument (DAT-16381) @StevenMassaro
  • (#5634) improve update summary count calculations (DAT-16656 and DAT-16357) @StevenMassaro
  • (#5629) Fix SQL generation when having a column defined with startWith and incrementBy in Postgres @MalloD12
  • (#5626) Add support for SnakeYaml to be able to parse timestamps correctly when timezone is set or not @MalloD12
  • (#5657) [DAT-16428] Reenable ChangelogSyncIntegrationTest tests @filipelautert
  • (#5665) fix: ClearChecksums should not throw Exception in empty databases @filipelautert
  • (#5660) Default implementation of handleInvalidEmptyPreconditionCase added in AbtractFormattedChangeLogParser to avoid breaking extensions @MalloD12
  • (#5555) Fix unique constraint and primary key generator issues for Postgres and H2 @Guschtel
  • (#5583) Add backwards compatibility for procedureBody in createProcedureChange @StevenMassaro
  • (#5617) fix: uses ThreadLocal to prevent concurrent modification on ScopeManager @filipelautert
  • (#5446) Proposed fix for #5442 - command "unexpectedChangesets" always reports at least 1 unexpected changeset with initial tag in database @Tylorjg
  • (#5506) fix: Parse all utf8 symbols @filipelautert
  • (#5606) fix: treats potential nullpointer exception after a lock exception @filipelautert
  • (#5581) Handle stored logic with parameters in the dependency graph DAT-15747 @wwillard7800
  • (#5566) chunk long strings on insert for Oracle (DAT-16774) @StevenMassaro
  • (#5522) MariaDB boolean: back to TINYINT(1) instead of TINYINT (MySQL) @famod
  • (#5524) Don't execute CustomSqlChanges to generate logs @Alf-Melmac
  • (#5498) Add missing OSGI settings @filipelautert
  • (#5391) fix SQLFileChange.generateCheckSum() to calculate checksum without property substitution @jglass524
  • (#5398) Fix issue #3516 addColumn ignores deleteCascade=true @andreiyusupau
  • (#5479) do not skip over duplicate tags when doing rollback (DAT-16277) @StevenMassaro
  • (#5484) Workaround failing test containers startup for mysql by falling back to previous version. @abrackx
  • (#5397) Fix DatabaseFactory db loading when Database implementation is specified (fix for Issues 5371 & 5396 ) @dhsmith1001
  • (#5202) 4464 fix generated default column value using in PostgreSQL and Oracle for char/clob data types @LonwoLonwo
  • (#5350) Fix getSerializableFieldValue when dealing with rollback object @MalloD12
  • (#5414) Fix NPE in generateChangelog and diffChangelog DAT-16534 @wwillard7800
  • (#5267) fix #5266: comma separated dbms-attribute for createProcedure-change triggers validation-check @jclohmann
  • (#5304) Fix for DAT-15716 :: Include 'OR REPLACE' instruction for a view when generate-changelog/diff-changelog command are executed @MalloD12

🤖 Security, Driver and Other Updates

41 changes

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