Release Notes

Liquibase 4.19.0 – January 17, 2023

Liquibase v4.19.0 is a patch release with an XSD upgrade.

Full changelog: v4.18.0...v4.19.0

Enhancements

  • Simplify assert calls and replaced with simpler and equivalent calls. by @arturobernalg in #3497
  • Delete unused import statement. by @arturobernalg in #3522
  • Added call to modifyChangeSet during execute method to allow the changeSet to be correctly set on the executor DAT-12388 by @wwillard7800 in #3511
  • Remove unnecessary local variables that add nothing to the comprehensibility of a method. by @arturobernalg in #3373
  • Allow loading gzipped data files by @mike-seger in #3379
  • Use try-with-resources Statement when is possible. by @arturobernalg in #3374
  • Define and reuse constants. Use an empty array styles to convert a collection to an array. by @arturobernalg in #3500
  • Add support for block comment rollback commands on SQL changesets by @krishnaenugandula in #1399
  • Allow primary key on addColumn for H2 by @nick318 in #3372
  • Additional (optional) tableType attribute on the CreateTableChange by @MartinRied in #3108
  • Include "path" in databasechangelog's description column for all change types with "path" attributes by @MichaelKern-IVV in #3244
  • #1466: Add ignore:true changeset attribute to Formatted SQL changeLogs by @skrivenko in #3377
  • #1290: Forbid empty changeSet id and author by @skrivenko in #3397
  • Allow to drop and create a view for a Postgres database if replacing the view would fail by @rozenshteyn in #3399
  • Rename DatabaseObjectComparator class to be DatabaseObjectCollectionComparator for clarity DAT-10112 by @wwillard7800 in #3544
  • Do not lower case the ProvidedValue description if the string is capitalized, i.e. it starts with 2 upper-case characters DAT-12614 by @wwillard7800 in #3589
  • Use 'Integer.compare' instead by @arturobernalg in #3528
  • Simplify 'Map' operations. by @arturobernalg in #3527
  • Remove unnecessary semicolon. by @arturobernalg in #3571
  • Missing Override annotations. by @arturobernalg in #3558
  • Prevents redundant loop iterations. Early loop exit in 'if' condition. by @arturobernalg in #3547
  • DAT 6635 - Implement TagCommand by @filipelautert in #3570
  • DAT-12576 update release workflow to attach artifact by run_id by @ap-liquibase in #3629
  • DAT-12365 update install4j script to version 10.x by @jnewton03 in #3641
  • Upgrades installer JDK version for next release. by @filipelautert in #3440
  • remove licenses that were moved to individual extensions (DAT-12784) by @StevenMassaro in #3646
  • DAT-12597 include commercial sources and javadoc in reversion by @ap-liquibase in #3671

Security, Driver and other updates

  • Upgrade mockito-inline from 4.8.0 to 4.8.1 by @dependabot in #3382
  • Upgrade actions/cache from 3.0.8 to 3.0.11 by @dependabot in #3370
  • Bump robinraju/release-downloader from 1.5 to 1.6 by @dependabot in #3423
  • Upgrade postgresql driver from 42.5.0 to 42.5.1 by @dependabot in #3501
  • Bump maven-plugin-plugin from 3.6.4 to 3.7.0 by @dependabot in #3450
  • Bump sqlite-jdbc from 3.39.3.0 to 3.39.4.0 by @dependabot in #3451
  • Bump maven-shade-plugin from 3.4.0 to 3.4.1 by @dependabot in #3422
  • Bump gmavenplus-plugin from 1.13.1 to 2.1.0 by @dependabot in #3391
  • Bump picocli from 4.6.3 to 4.7.0 by @dependabot in #3432
  • Bump jcc from 11.5.7.0 to 11.5.8.0 by @dependabot in #3414
  • Upgrade testcontainers-bom from 1.17.3 to 1.17.5 by @dependabot in #3341

Fixes

  • Fixes generate-changelog view comments for Postgres (DAT-9410) by @abrackx in #3403
  • Adds DefaultChangeExecListener, catches and handles migration errors (DAT-9372) by @abrackx in #3431
  • Fixes nullpointer when dealing with LiquibaseException on updates. by @filipelautert in #3447
  • Resets changelog cache upon acquiring lock by @filipelautert in #3396
  • Allows createSequence field "dataType" to be use with DB2 as the database supports it. by @filipelautert in #3328
  • Defines "-- rollback empty" as the way to specify "no rollback needed". by @filipelautert in #3324
  • Fix create index on Postgresql and MSSQL using wrong column names when generating a changelog by @filipelautert in #3366
  • Fixed input string handling in CompareControl constructor by @filipelautert in #3309
  • Add 'ifExists' parameter to the dropView statement by @gzsombor in #3301
  • Fix getResourceAccessor logic to avoid setting changeLogDirectory when searchPath has already set by @MalloD12 in #3347
  • Ensures that Postgresql works with blob types bytea and oid (large objects) by @filipelautert in #3381
  • Improve int/tinyint/smallint/bigint handling in H2 by @MalloD12 in #3274
  • The onSqlOutput attribute does not work for preconditions in formatted SQL changelog. by @dyadyushko in #3436
  • [DAT-11899] Modifies deploy plugin and distribution management. by @jnewton03 in #3457
  • Adds ChangeExecListener properties to Maven plugin (DAT-12219) by @abrackx in #3443
  • make BufferedLogService thread safe by @StevenMassaro in #3470
  • Improved Sybase ASE Support by @carlos940513 in #665
  • Do not write output files for computed columns when executing dbDoc. Fixes #1088 by @rozenshteyn in #3398
  • Sequence owned by a table field must be included in database snapshot by @filipelautert in #3335
  • Fixes snapshot of case-sensitive views by @filipelautert in #3329
  • Fix include/includeAll to correct track relativeToChangelog=true paths using ./ or ../ by @nvoxland in #3355
  • Improved readability in the createCDILiquibaseConfig method. by @musttafayildirim in #3316
  • testing main and sha builds by @jnewton03 in #3481
  • Fix Postgresql autoIncrement Information in snapshot by @filipelautert in #3361
  • Treat "," as "or" when parsing context expressions. Fixes #1103 by @rozenshteyn in #3426
  • CORE-1127: Filter by context when doing a rollback. by @berryh in #898
  • Implement tagExists Maven command (Fix issue 1063) by @rozenshteyn in #3385
  • Fixes transaction handling within changesets on DB2 on z/OS by @MichaelKern-IVV in #3342
  • Improve dropAllForeignKeyConstraints performance by @Spindl in #2155
  • Adds error handling for updateCount (DAT-11950) by @abrackx in #3463
  • Adds error handling to update-to-tag (DAT-11951) by @abrackx in #3468
  • Adds error handling for update-testing-rollback command and updateTestingRollback goal (DAT-11952) by @abrackx in #3474
  • Fixes behaviour of includeAll by keeping the trailing slash on the path by @filipelautert in #3506
  • Restore FileSystemResourceAccessor and add tests. by @filipelautert in #3499
  • Simplify if statements to a single assignment. Avoid extra works. by @arturobernalg in #3375
  • Fixed resolveSibling method by updating URL resource type by @MalloD12 in #3413
  • Fix dependency query for PostgreSQL 15 by @Domm98CZ in #3456
  • Release liquibase-nochangeloglock extension with the others by @nvoxland in #3452

New Contributors

  • @gzsombor made their first contribution in #3301
  • @carlos940513 made their first contribution in #665
  • @rozenshteyn made their first contribution in #3398
  • @musttafayildirim made their first contribution in #3316
  • @berryh made their first contribution in #898
  • @Spindl made their first contribution in #2155
  • @arturobernalg made their first contribution in #3375
  • @Domm98CZ made their first contribution in #3456

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

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:

Thanks to everyone who helps make the Liquibase community strong!

File Descriptions

Full changelog:v4.17.2...v4.18.0

Breaking Changes

  • Use PathHandler for writing log files, which allows using S3 and other extensions (DAT-11515) by @abrackx in #3438

Notable Changes

[PRO] Hashicorp Vault extension and Liquibase Pro

Use together for increased security and convenience of centralized properties

  • Security: Vaults offer much greater security than defaults files or environment variables
  • Centralization: Secure your database credentials, Liquibase Pro license key, secure URLs, and more in one central location. Update your critical properties in one place, and all linked tools and jobs use the new values

[PRO] rollback-on-error command argument for update command

  • When set to true will attempt to roll back a failed update operation.
  • Note: changesets marked failOnError=false, do not count as error, and so do not run rollback-on-error

[OSS] Liquibase Environment variables

Enhancements

Security, Driver and other updates

  • Upgrade mockito-inline from 4.8.0 to 4.8.1 by @dependabot in #3382
  • Upgrade actions/cache from 3.0.8 to 3.0.11 by @dependabot in #3370
  • Bump robinraju/release-downloader from 1.5 to 1.6 by @dependabot in #3423
  • Upgrade postgresql driver from 42.5.0 to 42.5.1 by @dependabot in #3501
  • Bump maven-plugin-plugin from 3.6.4 to 3.7.0 by @dependabot in #3450
  • Bump sqlite-jdbc from 3.39.3.0 to 3.39.4.0 by @dependabot in #3451
  • Bump maven-shade-plugin from 3.4.0 to 3.4.1 by @dependabot in #3422
  • Bump gmavenplus-plugin from 1.13.1 to 2.1.0 by @dependabot in #3391
  • Bump picocli from 4.6.3 to 4.7.0 by @dependabot in #3432
  • Bump jcc from 11.5.7.0 to 11.5.8.0 by @dependabot in #3414
  • Upgrade testcontainers-bom from 1.17.3 to 1.17.5 by @dependabot in #3341

Fixes

  • Fixes generate-changelog view comments for Postgres (DAT-9410) by @abrackx in #3403
  • Adds DefaultChangeExecListener, catches and handles migration errors (DAT-9372) by @abrackx in #3431
  • Fixes nullpointer when dealing with LiquibaseException on updates. by @filipelautert in #3447
  • Resets changelog cache upon acquiring lock by @filipelautert in #3396
  • Allows createSequence field "dataType" to be use with DB2 as the database supports it. by @filipelautert in #3328
  • Defines "-- rollback empty" as the way to specify "no rollback needed". by @filipelautert in #3324
  • Fix create index on Postgresql and MSSQL using wrong column names when generating a changelog by @filipelautert in #3366
  • Fixed input string handling in CompareControl constructor by @filipelautert in #3309
  • Add 'ifExists' parameter to the dropView statement by @gzsombor in #3301
  • Fix getResourceAccessor logic to avoid setting changeLogDirectory when searchPath has already set by @MalloD12 in #3347
  • Ensures that Postgresql works with blob types bytea and oid (large objects) by @filipelautert in #3381
  • Improve int/tinyint/smallint/bigint handling in H2 by @MalloD12 in #3274
  • The onSqlOutput attribute does not work for preconditions in formatted SQL changelog. by @dyadyushko in #3436
  • [DAT-11899] Modifies deploy plugin and distribution management. by @jnewton03 in #3457
  • Adds ChangeExecListener properties to Maven plugin (DAT-12219) by @abrackx in #3443
  • make BufferedLogService thread safe by @StevenMassaro in #3470
  • Improved Sybase ASE Support by @carlos940513 in #665
  • Do not write output files for computed columns when executing dbDoc. Fixes #1088 by @rozenshteyn in #3398
  • Sequence owned by a table field must be included in database snapshot by @filipelautert in #3335
  • Fixes snapshot of case-sensitive views by @filipelautert in #3329
  • Fix include/includeAll to correct track relativeToChangelog=true paths using ./ or ../ by @nvoxland in #3355
  • Improved readability in the createCDILiquibaseConfig method. by @musttafayildirim in #3316
  • testing main and sha builds by @jnewton03 in #3481
  • Fix Postgresql autoIncrement Information in snapshot by @filipelautert in #3361
  • Treat "," as "or" when parsing context expressions. Fixes #1103 by @rozenshteyn in #3426
  • CORE-1127: Filter by context when doing a rollback. by @berryh in #898
  • Implement tagExists Maven command (Fix issue 1063) by @rozenshteyn in #3385
  • Fixes transaction handling within changesets on DB2 on z/OS by @MichaelKern-IVV in #3342
  • Improve dropAllForeignKeyConstraints performance by @Spindl in #2155
  • Adds error handling for updateCount (DAT-11950) by @abrackx in #3463
  • Adds error handling to update-to-tag (DAT-11951) by @abrackx in #3468
  • Adds error handling for update-testing-rollback command and updateTestingRollback goal (DAT-11952) by @abrackx in #3474
  • Fixes behaviour of includeAll by keeping the trailing slash on the path by @filipelautert in #3506
  • Restore FileSystemResourceAccessor and add tests. by @filipelautert in #3499
  • Simplify if statements to a single assignment. Avoid extra works. by @arturobernalg in #3375
  • Fixed resolveSibling method by updating URL resource type by @MalloD12 in #3413
  • Fix dependency query for PostgreSQL 15 by @Domm98CZ in #3456
  • Release liquibase-nochangeloglock extension with the others by @nvoxland in #3452

New Contributors

  • @gzsombor made their first contribution in #3301
  • @carlos940513 made their first contribution in #665
  • @rozenshteyn made their first contribution in #3398
  • @musttafayildirim made their first contribution in #3316
  • @berryh made their first contribution in #898
  • @Spindl made their first contribution in #2155
  • @arturobernalg made their first contribution in #3375
  • @Domm98CZ made their first contribution in #3456

Full changelog: v4.17.1...v4.18.2

This is a patch release that upgrades the HSQL driver to remove a security vulnerability.

Note: The newest HSQL driver requires Java 11, so if you use HSQL and JAVA 8, you will need to upgrade your Java.

Security Updates

No security updates are necessary

JDBC Driver and Third-Party Library Updates

  • Upgrade hsqldb from 2.5.2 to 2.7.1 by @dependabot here
  • [opencsv-upgrade] Updates opencsv to 5.7.1 by @abrackx here

OWASP Dependency Check: Reported Vulnerabilities

  • hsqldb.jar - This is a vulnerability reported against the HSQLDB driver. We are currently on the newest version of HSQLDB and there is no fix for the issue as of yet.
  • snakeyaml.jar - This is a vulnerability reported against the snakeyaml. We are currently on snakeyaml 1.33 and this issue has been fixed in 1.32.

Full changelog: v4.17.0...v4.17.1

Fixes

  • fix: Use default localhost finder for MacOs - fix #2098 by @grzi in #2134
  • Allow renameColumn on newer SQLite versions by @MalloD12 in #3264
  • Implement logic to validate dbms set at changeset and stored procedure levels by @MalloD12 in #3291
  • Fixed URIResource.resolveSibling by @nvoxland in #3354
  • Use liquibase StringUtil not lang3.StringUtils by @nvoxland in #3338
  • Handle absolute path in getAll method by @wwillard7800 in #3369

Updates

Security Updates

None

JDBC Driver and Third-Party Library Updates

  • Upgraded ojdbc8 from 21.6.0.0.1 to 21.7.0.0 by @dependabot in #3223
  • Upgraded maven-shade-plugin from 3.3.0 to 3.4.0 by @dependabot in #3276
  • Upgraded slf4j-jdk14 from 2.0.2 to 2.0.3 by @dependabot in #3321
  • Upgraded snakeyaml maven reference from 1.32 to 1.33 by @nvoxland in #3359
  • Upgraded commons text transitive dependency by @abrackx in #338

OWASP Dependency Check: Reported Vulnerabilities

  • hsqldb.jar – This is a vulnerability reported against the HSQLDB driver. We are currently on the newest version of HSQLDB and there is no fix for the issue as of yet.
  • snakeyaml.jar – This is a vulnerability reported against the snakeyaml. We are currently on snakeyaml 1.33 and this issue has been fixed in 1.32.

New Contributors

  • @grzi made their first contribution in #2134

Full changelog: v4.16.1...v4.17.0

Notable Changes

  • [PRO] The liquibase flow command and flow files are available with a Liquibase Pro license. It allows you to create portable, platform-independent Liquibase workflows that can run across different tools without modifying each workflow.
    • Learn more about flow here: flow
    • If you want to provide feedback on this capability, please email mario@liquibase.com.
  • [PRO] Pro license users can now integrate Amazon S3 with Liquibase. You can extend Liquibase to use remote file locations to enable secure, centralized file management. Learn more here: S3
  • [PRO] Pro license users can use searchpath to find files located on S3 that cannot be found by an absolute path.

API Breaking Changes

  • The liquibase.resource.ResourceAccessor APIs were updated to take advantage of the new liquibase.resource.Resource abstraction that was introduced. Code that USES the existing ResourceAccessor methods will continue to work as before with no changes, but if you have written custom implementations of ResourceAccessor there are new and changed methods to implement. For more information, see javadocs.liquibase.com

Enhancements

  • Created new liquibase.resource.Resource interface by @nvoxland in #3064
  • Created ThreadLocalScopeManager by @nvoxland in #3240
  • Create liquibase_autocomplete.zsh by @szandany in #3130

Fixes

  • AlterSequence: include NOORDER clause ordered="false" is specified by @LeBezout in #1044
  • Upper case result columns only for case-insensitive databases by @fbiville in #3102
  • Postgresql: Fix for case when current search_path is an empty string by @gadget in #3233
  • Fix missing catalog on add column rollback by @jandurovec in #921
  • Fix an error which can occur if getAutoCommit is called on a closed connection by @gpsfl in #3135
  • Apply sqlVisitors to CompoundStatements on DB2z by @MichaelKern-IVV in #3220
  • Improved message when precondition onFail: MARK_RAN is set by @MultiM25 in #2238
  • Add default catalog condition to SequenceSnapshotGenerator for Oracle by @gabrielnardes in #3152
  • Fixed issue with H2 loadUpdateData not correctly handling values with the string " values " in the inserted data by @tomyy in #1831
  • Fix the smallserial issue not being parsed as a SmallInt type for Postgres by @MalloD12 in #3234
  • Remove Snowflake unsupported logging from snapshot command (DAT-11291) by @abrackx in #3277
  • Fix "double" handling with H2 by @MalloD12 in #3273
  • Firebird: fix createIndex missing space around "computed" by @Markus-Patt in #1500
  • Test Race Condititons During Liquibase Locking by @schrieveslaach in #2327
  • Use configuration to get 'altTablespace', 'altSchema' and 'altCatalog… by @mehrabisajad in #3124
  • Add missing generator for parameterized SQL statements by @fbiville in #3225
  • Add catalog null check to fix initializing a MSSQL db issue by @MalloD12 in #3235
  • PD-2838: pointing DB list to docs by @adrian-velonis1 in #3280
  • Addition of liquibase.update() Enhancement Request #1614 by @Betlista in #1638
  • Fixed createView handling of replaceIfExists=true when the string "replace" exists in the view definition by @filipelautert in #3305
  • DAT-11407: replace backslashes in NotFoundResource URI by @StevenMassaro in #3322
  • Fix generateChangeLog and diffChangeLog logic to avoid including default schema name when it should not by @MalloD12 in #3246

Updates

Security Updates

None

JDBC Driver and Third-Party Library Updates

  • Upgraded snowflake-jdbc from 3.13.21 to 3.13.22 by @dependabot in #3196
  • Upgraded opencsv from 5.6 to 5.7.0 by @dependabot in #3243
  • Upgraded installer to use JDK 17.0.4.1 by @nvoxland in #3266
  • Upgraded sqlite-jdbc from 3.39.2.1 to 3.39.3.0 by @dependabot in #3267
  • Upgraded jaxb-core from 4.0.0 to 4.0.1 by @dependabot in #3292
  • Upgraded mariadb-java-client from 3.0.7 to 3.0.8 by @dependabot in #3293
  • Upgraded jaxb-runtime from 4.0.0 to 4.0.1 by @dependabot in #3294
  • Upgraded snakeyaml from 1.32 to 1.33 by @dependabot in #3310

OWASP Dependency Check: Reported Vulnerabilities

None

New Contributors

  • @trentdm made their first contribution in #3227
  • @gadget made their first contribution in #3233
  • @jandurovec made their first contribution in #921
  • @gpsfl made their first contribution in #3135
  • @MichaelKern-IVV made their first contribution in #3220
  • @MultiM25 made their first contribution in #2238
  • @gabrielnardes made their first contribution in #3152
  • @tomyy made their first contribution in #1831
  • @neilnaveen made their first contribution in #2997
  • @Markus-Patt made their first contribution in #1500
  • @adrian-velonis1 made their first contribution in #3280
  • @Betlista made their first contribution in #1638
  • @filipelautert made their first contribution in #3305

Full changelog: v4.15.0...v4.16.0

Notable Changes

  • [LABS] The liquibase flow command and flow files are still available under the Liquibase Labs license.
    • Documentation on flow is here: flow
    • If you want to provide feedback on this capability, please email mario@liquibase.com.
  • [PRO] The Quality Checks for Databases are now available to all Pro license users. These checks inspect your active database, or a Liquibase-generated snapshot for compliance with your rules. Learn more here: List of Quality Checks
  • Introduces "contextFilter" and "labelFilter" replacement settings by @nvoxland in 2971
    • Liquibase has always had a way to use "labels" and "contexts" and then filter on those attributes in order to control which changesets are considered for execution. The new "contextFilter" and "labelFilter" attributes help simplify workflows and prevent confusion.

Enhancements

Fixes

  • Fix addColumn on mysql when including a "value" attribute by @nvoxland in #3070
  • Add support for AS <dataType> clause for H2 since version 2.0 by @marcus-nl in #3047
  • Fixed NUMBER not compatible with H2 by @nick318 in #3098
  • SpringResourceAccessor: fix issue with incorrect match pattern for files from classPath root by @danilmalkin in #3095
  • Made liquibase.snapshot.ResultSetCache an extensible class. by @breglerj in #2087
  • Added support for \u2116 symbol win1251 Cyrillic symbol of number by @Stuchalin in #1324
  • Tidy ExecutorService code, remove superfluous map access (Issue 1841) by @jamey-clari in #1842
  • Fixed order of enum values on MySQL 8 by @Tantalon in #3150
  • Removed invalid warning in Maven by @nvoxland in #3189
  • [PRO] DAT-10810 QC: checks show changes (--show-cols flag, drop some, etc) by @dyadyushko in #3187

Updates

Security Updates

Updates the snakeyaml dependency shipped in the liquibase-maven-plugin POM to address CVE-2022-25857

JDBC Driver and Third-Party Library Updates

  • Upgraded postgresql from 42.4.0 to 42.4.1 by @dependabot in #3145
  • Upgraded mariadb-java-client from 3.0.6 to 3.0.7 by @dependabot in #3149
  • Upgraded sqlite-jdbc from 3.36.0.3 to 3.39.2.0 by @dependabot in #3148
  • Upgraded mssql-jdbc from 10.2.1.jre8 to 11.2.0.jre8 by @dependabot in #3162
  • Upgraded postgresql from 42.4.1 to 42.5.0 by @dependabot in #3199
  • Upgraded sqlite-jdbc from 3.39.2.0 to 3.39.2.1 by @dependabot in #3198
  • Upgraded snakeyaml from 1.30 to 1.31 by @dependabot in #3224
  • Upgraded snakeyaml in liquibase-maven-plugin from 1.27 to 1.31 by @dependabot in #3263

OWASP Dependency Check: Reported Vulnerabilities

snakeyaml.jar – This is a "medium" vulnerability reported against the snakeyaml library. We are currently on the newest version of snakeyaml and there is no fix for the issue as of yet.

New Contributors

  • @marcus-nl made their first contribution in #3047
  • @nick318 made their first contribution in #3098
  • @danilmalkin made their first contribution in #3095
  • @breglerj made their first contribution in #3087
  • @Stuchalin made their first contribution in #1324
  • @jamey-clari made their first contribution in #1842
  • @Tantalon made their first contribution in #3150
  • @atzawada made their first contribution in #1386
  • @MalloD12 made their first contribution in #3210
  • @dyadyushko made their first contribution in #3187

Full changelog: v4.14.0...v4.15.0

Notable Changes

New liquibase flow command

  • liquibase flow and new flow-file (DAT-10419) by in #2946
  • The liqubase flow command and the Flow File on which it operates allow the user to place multiple commands within a single file so they can all run sequentially with a single command into the CLI. This is currently a Liquibase Labs restricted capability, so please contact mario@liquibase.com to request a license key. Learn more at flow

Enhancements

Fixes

  • Fix Maven plugin pro commands for local developer install by @StevenMassaro in #3101
  • Update Derby reserved words by @andrewhj in #1971
  • Output "may lose settings" warning on mysql/mariadb for more impacted change types by @nvoxland in #3045
  • Improved "include" fix performance: optimized normalizePath method by @lzxgyh in #3063
  • Removed DatabaseInfoAttributes in XSD by @kazz62 in #2239
  • Do not split SQL on delimiters within BEGIN/END blocks by @nvoxland in #1589
  • Set max fractional timestamp digits to 12 for all DB2 editions (fix #2880) by @ctgnz in #2892
  • Fix query for snapshotting views on DB2/Z by @michaelmatthiaskern in #2712
  • Fix for bug 2711: Error when calling a procedure with parameters on DB2Z by @michaelmatthiaskern in #2765
  • Improve CLI error messages by @nvoxland in #3078
  • Improved handling of endDelimiter="/" by @nvoxland in #3118
  • Upgrade installer to ship with JDK 17.0.4+8 by @nvoxland in #3104
  • Improve failure message of RowCountPrecondition to preserve expected row count by @martinspielmann in #3093
  • Changed what sequence attributes are included in diff/generatechangelog for Snowflake by @yodzhubeiskyi in #3121
  • Fix columnNames snapshot attribute of uniqueConstraints for Snowflake by @yodzhubeiskyi in #3123

Updates

Security Updates

No security updates needed in this release.

JDBC Driver and Third-Party Library Updates

Upgraded snowflake-jdbc from 3.13.20 to 3.13.21 by @dependabot in #3061

OWASP Dependency Check: Reported Vulnerabilities

None

New Contributors

  • @andrewhj made their first contribution in #1971
  • @lzxgyh made their first contribution in #3063
  • @kazz62 made their first contribution in #2239
  • @ctgnz made their first contribution in #2892
  • @michaelmatthiaskern made their first contribution in #2712
  • @martinspielmann made their first contribution in #3093

Full changelog: v4.13.0...v4.14.0

Notable Changes

Split liquibase-core and liquibase-commercial JAR files by @nvoxland in #3050

  • This change affects new downloads of Liquibase Pro. liquibase-core-<version>.jar contains only the open-source license. If you use Liquibase Pro or other commercial add-ons, you must also install liquibase-commercial-<version>.jar.

Added liquibase.changelogParseMode setting by @nvoxland in #3057

Enhancements

  • Warn if XSD version does not match build version in validate command (DAT-9874) by @StevenMassaro in #3016
  • Allow use of Pro-only objects for filtering with generateChangeLog (DAT-9542) by @StevenMassaro in #3068
  • Improve connection exception by including underlying driver exception trace by @hessjcg in #3033
  • Add Closeable/AutoCloseable interface to liquibase.database.Database by @zorglube in #2990

Fixes

  • Fixed Formatted SQL "property" parsing by @nvoxland in #3037
  • Ensure Postgresql search_path entries are quoted correctly by @nvoxland in #3009
  • Updated "Change Set" wording to "Changeset" by @kataggart in #3042
  • Improved error when JAVA_HOME is set to invalid value (DAT-10545) by @StevenMassaro in #3074
  • Fixed autoIncrement incrementBy/startWith support in MySQL, H2, HSQLDB, and MariaDB by @tozogabee in #3026
  • Improve renameColumn generated SQL on mssql by @mide25 in #783

Updates

Security Updates

No security updates needed in this release.

JDBC Driver and Third-Party Library Updates

  • Upgraded mariadb-java-client from 3.0.5 to 3.0.6 by @dependabot in #3021
  • Upgraded testcontainers-bom from 1.17.2 to 1.17.3 by @dependabot in #3020
  • Upgraded postgresql from 42.3.4 to 42.4.0 by @dependabot in #2935
  • Bump jaxb-runtime from 2.3.6 to 4.0.0 by @dependabot in #2964

New Contributors

  • @hessjcg made their first contribution in #3033
  • @mehrabisajad made their first contribution in #3059
  • @tozogabee made their first contribution in #3026
  • @mide25 made their first contribution in #783
  • @zorglube made their first contribution in #2990

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

Notable Changes

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

Enhancements

  • Added new liquibase.duplicateFileMode setting by @nvoxland in #3006
  • Add additional info in CLI --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.11.0...v4.12.0

Breaking Changes

Support for Snowflake database has been moved from the external extension liquibase-snowflake into the main Liquibase artifact. If you are using the Snowflake extension, remove it from your lib directory or however you are including it in your project. If you are using the Docker image, the snowflake docker label will no longer be updated so you need to update your reference to either latest or the version tag you prefer. For CLI users, the Snowflake driver also ships out of the box and so you should remove that from the lib directory as well #2841

Enhancements

  • Quality Checks for Databases (DAT-9298) by @StevenMassaro in #2715
    • This capability extends checks from just the changelog to look at the database itself for conditions of compliance, security, and more. This is currently a Liquibase Labs restricted capability, so please contact mario@liquibase.com to request a license key.
  • Added a new "liquibase.showBanner" setting. Setting this value to 'false' will disable the Liquibase startup banner from being shown. By @nvoxland in #2871
  • Added a new "liquibase.missingPropertyMode" setting to control what happens when a changelog contains a ${...} string that doesn't correspond to a set changelog property. The default continues to be "preserve," which leaves it as-is. But other possible values are ERROR or EMPTY which will either stop execution with an error or replace it with an empty string. By @dwieland in #2656
  • Added new "liquibase.preserveSchemaCase" argument to preserve the case of schemas exactly as passed to the various schema settings. Default remains "false" as before. DAT-10027 By @wwillard7800 in #2888
  • Introduced "latest" xsd file path. In addition to http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.12.xsd type XSDs references, you can now also use http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd instead. By using "latest", Liquibase will use the bundled XSD for its version. The uploaded "latest" XSD will always be the most recent Liquibase release, so note how they can be different and locally cached IDE versions may be different yet. By @nvoxland in #2886
  • Added new ConfiguredValueModifier extension point. This allows extensions to be written which will translate or convert configuration values from what was passed by the user before the value is passed to the internal code. By @mcred in #2252
  • Updated StandardLockService interface to make it more useful for extensions by @Cliftonz in #2785

JDBC Driver and Third-Party Library Updates

  • Added connector-api.jar to internal/lib by @nvoxland in #2873
  • Upgraded mysql-connector-java from 8.0.28 to 8.0.29 by @dependabot in #2798
  • Move opencsv to be non-shaded by @nvoxland in #2903
  • Added Snowflake driver to CLI by @nvoxland in #2931
  • Upgraded mssql-jdbc from 10.2.0.jre8 to 10.2.1.jre8 by @dependabot in #2846

Fixes

  • Fixed BLOBs in loadData for MySQL/MariaDB by @MichaelCkr in #2595
  • Fixed getting ENUM column values from Mysql database having multiple schemas by @akatiyar in #2616
  • Added logic to Derby.getDefaultDriver() to check for availability of different driver classes by @AlexanderSashchenko in #2571
  • Fixed TableOutput spaces when using long words (DAT-10069) by @StevenMassaro in #2879
  • Fixed addAutoIncrement startValue and incrementBy support on Postgresql by @nvoxland in #2588
  • Support non-classpath: protocols in Spring by @reallyinsane in #2524
  • Fixed #2780: AddColumnChange with schema and NOT NULL constraint fails by @MartinRied in #2781
  • Make extension matching for SQL parsers case-insensitve DAT-10265 by @wwillard7800 in #2884
  • Restored outputDefaultSchema and outputDefaultCatalog command arguments by @nvoxland in #2834
  • Quote liquibase.jar path in bash launcher by @nvoxland in #2885
  • Fix for working with Firebird 2 and newer versions. Fixes nullables and boolean type. by @mngsgoncalves in #2277
  • Fixed issue if change changelog object is null by @kamalnigam in #2837
  • Filter out license key strings for Hub communication DAT-10522 by @wwillard7800 in #2926
  • Specify which parameter is missing in the error message by @bendem in #2567
  • Split license information into OSS vs. Pro directories by @nvoxland in #2868
  • Use the method setBlob to insert blob data by @xjodoin in #605
  • Smooth out differences in "./" paths by @nvoxland in #2915
  • Include inherited labels in DATABASECHANGELOG table by @nvoxland in #2870
  • Restored OSGi headers by @nvoxland in #2924
  • Working on better Git Bash console solution DAT-10230 by @wwillard7800 in #2882
  • Close InputStream in SQLFileChange (DAT-9855) by @StevenMassaro in #2920
  • Support prepared statements for query by @fbiville in #2913
  • Implement NOT VALID for Postgres databases by @coenvk in #2600

New Contributors

  • @MichaelCkr made their first contribution in #2595
  • @akatiyar made their first contribution in #2616
  • @Cliftonz made their first contribution in #2785
  • @reallyinsane made their first contribution in #2524
  • @MartinRied made their first contribution in #2781
  • @dwieland made their first contribution in #2656
  • @mngsgoncalves made their first contribution in #2277
  • @kamalnigam made their first contribution in #2837
  • @bendem made their first contribution in #2567
  • @xjodoin made their first contribution in #605
  • @abrackx made their first contribution in #2934
  • @coenvk made their first contribution in #2600

Full Changelog: v4.10.0...v4.11.0

Breaking Changes

Starting with 4.11, we moved the global libraries we ship with the CLI from the lib directory to a new internal directory structure. The lib directory is still included in the classpath as the place where users can add the additional global drivers/libraries they need.

The liquibase --version output has been enhanced to also include the third party libraries being used and their versions.

Impacts:

  • If you are upgrading Liquibase by overwriting an existing directory, you will have duplicate libraries between lib and internal/lib. You should manually delete any files in lib which you did not add yourself. Liquibase will continue to work even with the duplicate libraries, but you may not be running the latest version of ones we ship, since the lib files take priority over what is in internal/lib. New installs are not impacted by this.
  • If you have any automation that did anything with our shipped files in lib, update it to reflect the new internal/lib location.

For security reasons, we have also changed what is logged by the CLI to only log Liquibase channel messages by default, rather than all log channels. If you are relying on logging from non-Liquibase libraries, you can add channels with the new --log-channels flag, including --log-channels=all to restore the old functionality.

Enhancements

  • Moved shipped JAR files out of lib and into a new internal/lib directory by @nvoxland in #2850
  • To help with performance troubleshooting, there is now a --monitor-performance argument for the CLI (and only the CLI) which enables profiling of the Liquibase run. The generated profiling information can help us understand and fix performance issues easier. #2599
  • Upgraded Java shipped with the installers from 11 to 17 by @nvoxland in #2602
  • Added whitelist for CLI log channels by @nvoxland in #2859

Fixes

  • Do not throw a confusing error if a datatype specified as a changelog parameter is not expanded by @nvoxland in #2772
  • Fixed SQLite not correctly snapshotting tables with underscores in the name by @nvoxland in #2778
  • Fixed local XSD lookup by @nvoxland in #2830
  • Standardized "start-h2" commands on "liquibase init start-h2" logic by @nvoxland in #2597
  • Support default values in the format (0)::real by @nvoxland in #2836
  • Fix handling of defaultSchemaName on Postgresql by @nvoxland in #2812
  • Introduce generateStatementsFromRows for extensions by @fbiville in #2686
  • Fixed XSD type of "ordered" and "cycle" attributes to be boolean by @DartVerder in #2725
  • Remove custom log message filtering by @nvoxland in #2777
  • Spring Boot: better support relativeToChangelogFile when ResourceLoaders return FilteredReactiveWebContextResources by @erik-meuwese-topicus in #2758
  • Fix ForeignKeyComparator when foreign key table is not known by @joserebelo in #2565
  • Test System Framework: add support for "liquibase.sdk.testSystem.skip" property by @StevenMassaro in #2838
  • Test System Framework: stop database containers when spock execution ends by @StevenMassaro in #2843

Updates

Security Updates

No security updates needed in this release.

JDBC Driver and Third-Party Library Updates

  • Upgraded picocli from 4.6.1 to 4.6.3 by @dependabot in #2518
  • Upgraded jaxb libraries to the newest 2.3.x versions by @nvoxland in #2793
  • Upgraded snakeyaml from 1.27 to 1.30 by @dependabot in #2498
  • OWASP Dependency Check: Reported Vulnerabilities
  • jcc.jar – This is a vulnerability reported against the IBM DB2 JDBC driver. It is awaiting reanalysis. We are currently on the newest version, CVE-2008-1997

New Contributors

  • @nikosmoum made their first contribution in #2630
  • @DartVerder made their first contribution in #2725
  • @erik-meuwese-topicus made their first contribution in #2758
  • @joserebelo made their first contribution in #2565

Full Changelog: v4.9.1...v4.10.0

Breaking Change

Upgraded mssql driver to 10.2.0 by @nvoxland in #2790

End User Impact: The driver changed the encryption default from "false" to "true" between 8.x and 10.x. If you have a self-signed certificate in your database, you must do one of the following: add encrypt=false; add trustServerCertificate=true; or add the server certificate to the java trusted certificate list. For production systems, Liquibase recommends against using self-signed certificates without adding the server certificate to the Java keystore. For more information on installing the trusted certificate, see Certificate Management (SQL Server Configuration Manager).

Security Updates

Upgraded Postgresql from 42.3.2 to 42.3.4 to address CVE-2022-26520 by @dependabot in #2769

  • Vulnerability introduced in org.postgresql:postgresql@42.3.2
  • Fixed in org.postgresql:postgresql@42.3.3

JDBC Driver and Third-Party Library Updates

  • Upgraded oracle driver to 21.5.0.0 by @nvoxland in #2791
  • Upgraded jcc from 11.5.6.0 to 11.5.7.0 by @dependabot in #2421
  • Upgraded mssql driver to 10.2.0 by @nvoxland in #2790
  • Upgraded h2 from 2.1.210 to 2.1.212 by @dependabot in #2740
  • Upgraded sqlite-jdbc from 3.34.0 to 3.36.0.3 by @dependabot in #2412
  • Upgraded jaybird from 4.0.3.java8 to 4.0.6.java8 by @dependabot in #2802
  • Upgraded hsqldb from 2.4.0 to 2.5.2 by @nvoxland in #2797
  • Updated information in "licenses" directory by @nvoxland in #2795
  • Upgraded mariadb driver to 3.0.4 by @nvoxland in #2789

Enhancements

  • Quality checks for Maven - checks.run and checks.show goals [DAT-9033] [DAT-9034]
  • Allow CompositeResourceAccessor to have a non-fixed size list of ResourceAccessor so that the list can be added to/removed from by @wwillard7800 in #2650
  • Correctly handle null class package names in the logging system by @nvoxland in #2763
  • Handle URLs correctly in error conditions DAT-9882 by @wwillard7800 in #2709
  • Validate formatted SQL changelog for invalid patterns DAT-7721 by @wwillard7800 in #2761

Fixes

  • [PRO] Diff commands correctly recognizing triggers as changed/different in Postgresql10 [DAT-9559]
  • Fix EnterpriseDB database recognition by @nvoxland in #2767
  • Fix start failure with NullPointerException when Environment contains empty string Key (fix Issue 2631) by @feltonma91 in #2636
  • Fix createTable on Mysql not preserving primary key information when remarks also defined on the column by @nvoxland in #2752
  • Updated information in "licenses" directory by @nvoxland in #2795

New Contributors

  • @kataggart made their first contribution in #2577
  • @feltonma91 made their first contribution in #2636

[PR#2666] [nvoxland] Liquibase 4.9.1 release is a patch release that fixes the MANIFEST.MF location in the liquibase.jar file for tools that require the MANIFEST.MF file to be the first entry in the jar archive. If the MANIFEST.MF file is not the first entry, java.util.jar.JarInputStream#getManifest() reading the MANIFEST.MF file will not return the manifest information appropriately. The PR fixes issue #2648.

[Issue#2672] Addresses the remaining OSGi-related packaging problems to fully restore Liquibase support in OSGi environments.

Fixes

  • [PR#2651] Fixed the issue with a malicious software alert for the Liquibase macOS Installer preventing from proceeding with the installation. [DAT-9524]
  • [PR#2643] Fixed the handling of non-integer datatypes using a default value with a sequence in snapshot on PostgreSQL [DAT-8670]
  • [PR#2691] Fixed invalid JSON in the example-changelog.json file [DAT-9893]

Liquibase 4.9.0 is now available on the Download Liquibase page.

This release includes the checks.run and checks.show Maven goals, quality checks JSON object, community-contributed pull requests, Liquibase Open Source and Liquibase Pro bug fixes, and other notable changes.

Notable Changes

Liquibase 4.9.0 introduces the following functionality:

  • Quality checks for Maven – checks.run and checks.show goals [DAT-9033] [DAT-9034]

    • Note: For more information, see Maven checks.run and Maven checks.show.

  • [PR#2558] [kavya-shastri] [Breaking Change] The change in the usage of the Liquibase global configuration for the secureParsing parameter to prevent the entity resolver from scanning the network for missing XSDs. If you reference an XSD other than one of Liquibase and have never stored them in your classpath, Liquibase will no longer automatically download and use the XSD from the internet for security reasons. The default value for secureParsing is true, but you can set it to false in any of the Liquibase configuration locations.

    Note: For more information, see Example Changelogs: XML Format.

  • [PR#2529] [Krzysztof Sierszeń] [LB-1781] The uniqueConstraintExists precondition to check for the existence of unique constraints before running the update. You can check the constraint by constraint name or columns:
    • <preConditions>
<uniqueConstraintExists constraintName="uq_constraint_name" tableName="test_table"/>
</preConditions>

        <preConditions>
<uniqueConstraintExists tableName="test_table" columnNames="first_name, last_name"/>
</preConditions>
  • [PR#2339] [nvoxland] [Toukite] The support for running the Liquibase Servlet listener in application servers built on the Jakarta Servlet specification and not the Java Servlet specification. To use the new listener, specify the following tag:
    • <listener>
<listener-class>liquibase.integration.servlet.LiquibaseJakartaServletListener</listener-class>
</listener>

    The PR fixes issue #2298.

  • [PRO] Quality checks JSON object so that your application can easily parse through the Liquibase output [DAT-9094]

    • Note: For more information, see Quality Checks JSON Object.

Enhancements

  • [PR#2434] [Balázs Dési] Added the Maven validate goal to maven-liquibase-plugin to provide access to the existing Liquibase validate command and be available not only in CLI, but also in Maven

    Note: For more information, see Maven validate.

  • Added the ability to use sqlcmd on an instance with multiple databases [DAT-9513]

    Note: For more information, see Use SQLCMD and runWith on MSSQL Server.

  • Added support for Liquibase, Spring Boot, and SQL Plus run with Kerberos [DAT-9409]

    Note: For more information, see Using Liquibase and Spring Boot with SQL Plus and Kerberos Authentication.

  • [PR#2561] [Wesley Willard] Added the --schemas argument to the snapshot command to be able to compare a multi-schema database to its snapshot [DAT-9433]
  • [PR#2606] [Wesley Willard] Added a best practice message for the generate-changelog command so that you can check if the splitStatementsattribute works for your environment when generating formatted SQL changelogs [DAT-9327]
  • Added the StripCommentsattribute for the SQLUserDefinedPatternCheck quality check to choose the code that the SQLUserDefinedPatternCheck searches, including the option for the commented code. The StripCommentsattribute strips comments from SQL before searching for the string. The default value is N (no). [DAT-9098]
  • [PR#2273] [Tsvi Zandany] Added the autocomplete option for quality checks commands running on macOS

Fixes

  • [PR#2542] [nvoxland] Fixed the --should-snapshot-data CLI parameter to be preserved when the --data-output-directory property is not specified in the command
  • [PR#2330] [Inane Mohammed] Fixed the issue with checking the referenceSnapshot parameter instead of referenceDatabase for the potential null value
  • [PR#2521] [Steven Massaro] Added a label, context, and comment to the example-changelog.sql file that comes with the Liquibase installation package [DAT-9325]
  • [PR#2556] [nvoxland] Fixed the CockroachDB processes so that Liquibase checks the URL first rather than proceeding with SQL calls
  • [PR#2569] [Clarence Dimitri CHARLES] Made FormattedSqlChangeLogParser to be reusable for extensions
  • [PR#2377] [devorgpl] Fixed the issue with updating statements when the onlyUpdateattribute is false in the loadUpdateDataChange Type for HSQL
  • [PR#1908] [Emiliano Capoccia] Fixed the issue with retrieving the CockroachDB version. As part of the fix, Liquibase generates version-specific autoincrement SQL statements for CockroachDB identity columns:
    • SMALLSERIAL, SERIAL, and BIGSERIAL for versions earlier than 21.2
    • GENERATED BY DEFAULT AS IDENTITY for version 21.2 or later
  • [PR#2135] [PR#2133] [Saucistophe] [mkobylarz] Fixed the issue with the endDelimiterattribute not being respected during the Liquibase update. The fix for endDelimiter does not break the handling of trailing comments in SQL statements. [LB-2186]
  • [PR#2573] [nvoxland] Fixed the quoting for the MANIFEST.MF file for correct versioning
  • [PR#2572] [Steven Massaro] Fixed the issue with generating changelogs for PostgreSQL columns that use SET DEFAULT [DAT-8779]
  • [PR#2589] [nvoxland] [Marcel Blonk] Fixed the MD5 checksums generated by older versions of Liquibase to be correctly updated in the DATABASECHANGELOG table when a more recent version of Liquibase executes against the database. The PR fixes issue #2580.
  • [PR#2592] [nvoxland] Added support for the double precision type in MySQL. The PR fixes issue #2337.
  • [PR#1894] [KushnirykOleh] Fixed the time data type to be precise for PostgreSQL. The PR fixes issue #1774.
  • [PR#2387] [Jenson3210] Fixed the handling of date and time in the loadDataChange Type
  • [PR#2566] [nvoxland] Updated OpenCSV from 5.5.2 to 5.6

Contributions

Our community has built a lot. Thanks to everyone who contributes and helps make the Liquibase community strong, including the following first-time contributors:

This release includes the init hub subcommand, Liquibase Pro support for MSSQL Server sqlcmd utility, community-contributed pull requests, and Liquibase Open Source and Liquibase Pro bug fixes.

Notable Changes

Liquibase 4.8.0 introduces the following functionality:

  • The init hub subcommand that connects your local Liquibase activity to Liquibase Hub and sets up the Liquibase environment to use Liquibase Hub. [DAT-8769]

    • Note: For more information, see init hub and Get Started with Liquibase Hub.

  • [PRO] The sqlcmd utility support to process complex SQL for MSSQL Server. Liquibase provides the liquibase.sqlcmd.conf file to pass arguments to your executor when running Liquibase Pro. [DAT-7447]

    • Note: For more information, see Use SQLCMD and runWith on MSSQL Server.

  • Changes to the behavior of the XML parser, which no longer allows referencing external DTD files for security reasons. If you use externally defined entities or any other potentially insecure XML feature in your changelogs, set liquibase.secureParsing=false. [PR#2384] [LB-2218]

    • Note: For more information about the ways to set the parameter, see Liquibase Parameters.

  • The upgrade of the postgresql (from 42.2.12 to 42.3.2) and h2 (from 2.0.206 to 2.1.210) drivers that Liquibase includes in the installation package. If you use those drivers and upgrade an existing Liquibase installation, remove the earlier versions of drivers from the LIQUIBASE_HOME/lib directory.

Enhancements

  • Implemented the SimpleObjectConstructor interface for DB2 on z/OS [DAT-8580]
  • Included the CLI instructions on how to use the properties file with a nonstandard name when running the init project subcommand [DAT-9041]
  • Improved the output message for init start-h2 when the H2 database driver is specified, but there is no connection detected [DAT-8992]
  • Added validation errors for the enableCheckConstraint, disableCheckConstraint, dropPackage, dropPackageBodyChange Types [DAT-9017]
  • [PR#2367] [Mike Olivas] Added example rollback scripts to the example-changelog.sql file [LB-2220]
  • [PR#1648] [Daniel Gray] Improved the exception error message for the customChange node with no classattribute [LB-1144]
  • [PR#2222] [msimko81] Added the offline mode support for the rollback-sql <tag> operation [LB-2198]
  • [PR#2273] [Tsvi Zandany] Added the autocomplete quality checks commands for macOS
  • [PR#2308] [Valentin Blistin] Added the close method for the ClassLoaderResourceAccessor class [LB-2205]

Fixes

Contributions

Our community has built a lot. Thanks to everyone who contributes and helps make the Liquibase community strong, including the following first-time contributors:

This patch release includes community-contributed pull requests, Liquibase Open Source bug fixes, and Liquibase Pro bug fixes.

Here is a closer look at what we improved in the latest release.

Known Issues

In version 4.7.0, users that have "edb" in connection URLs but are not using EnterpriseDB experienced errors that caused Liquibase to misinterpret the database dialect. This patch release resolves this issue along with several others.

Enhancements

  • Added a new quality check – RollbackRequired. The check detects when a changeset does not have a rollback. [DAT-8871]
  • Enabled SQL parser for the TableColumnLimit check to work with formatted SQL changelogs [DAT-8531]
  • Implemented the --auto-update quality check parameter, which allows automatic backup and updating of the liquibase.check-settings.conf file when new quality checks are available. [DAT-8752]
    • CLI: --auto-update=[on|off]
    • Liquibase properties file (liquibase.properties): liquibase.command.checks.show.autoUpdate: [on|off]
    • [PRO] Environment variable: LIQUIBASE_COMMAND_CHECKS_SHOW_AUTO_UPDATE=[ON|OFF]

    • Note: You can use the property not only with the show command but any other quality checks command.

Fixes

  • [PR#2364] [Nathan Voxland] [M-Koers] Made EnterpriseDBDatabase detection less broad. The implementation of EnterpriseDBDatabase picked up database with "edb" in the URL instead of an actual EDB URL. The PR fixes PR#2363. [LB-2214]
  • Fixed quality checks with OBJECT_TYPES=TABLE, COLUMN, SEQUENCE specified in the same ObjectNameMustMatch rule to find all matches [DAT-8716]
  • Fixed the runWith=changeLogPropertyattribute not working in a formatted SQL changelog [DAT-4793]
  • [PR#2270] [Nathan Voxland] [Michael Kroll] Fixed the handling of the cacheSizeattribute in the createSequence and alterSequenceChange Types for MariaDB. The PR fixes PR#2147. [LB-2191]
  • [PR#2269] [Nathan Voxland] [Tsvi Zandany] Fixed the handling of the tag-exists command old syntax in Liquibase 4.4 and later (liquibase tag-exists myTag) to correctly convert the pattern into new versions. The PR fixes PR#2109. [LB-2192]
  • [PR#2188] [Cullen Coyle] Added the columnDataTypeattribute for the generated setColumnRemarkschangesets to fix an error in MySQL [LB-2199]
  • [#932] [Matthias Wuttke] Added support for sequences in MaxDB [LB-41]
  • [PR#2282] [AlexanderSashchenko] Fixed the drop column statement generator for DB2 on z/OS [DAT-8744]

Contributions

Our community has built a lot. Thanks to everyone who contributes and helps make the Liquibase community strong, including the following first-time contributors:

Tip: Liquibase Hub introduces the Liquibase Hub DevOps Metrics functionality with four reports that provide the data to optimize your DevOps performance: Deployment Frequency, Change Migration Time, Change Failure Rate, Time to Fix Failing Changes.

This release includes community-contributed pull requests, Liquibase Open Source and Liquibase Pro bug fixes, and a new command to get started with Liquibase – the init command.

Here is a closer look at what we improved in the latest release.

Notable Changes

Liquibase 4.7.0 introduces the init command with the project and start-h2 subcommands:

  • The init project subcommand helps to set configuration files for using Liquibase or, if you already use Liquibase, create new project files with minimal input. [DAT-8640]
  • The init start-h2 subcommand helps to start the included in-memory H2 database. The subcommand needs to be run in a new command line or terminal window. [DAT-8945]

Note: For more information and examples of using init project, see init project.

Additionally, we have updated the Liquibase Getting Started tutorials and sample changelog files in the installation package. From now on, you can use sample SQL, XML, JSON, and YAML changelog files with the corresponding changesets. [LB-2177] [LB-2174]

Note: Check Liquibase Getting Started to see more details.

Enhancements

  • [PRO] Improved the output of the rollback-one-update command [DAT-7590]
  • [PR#2244] [Tsvi Zandany] Enabled the use of the jdbc:edb URL for Liquibase to recognize EnterpriseDB
  • [PR#2225] [Nathan Voxland] [Konstantin] Enabled the use of lowercase sys.synonyms objects for the generate-changelog and diff-changelog commands in Liquibase and SQL Server. The PR fixes PR#2044.
  • Added DB2 on z/OS database type and Java classes for Liquibase [DAT-8575]
  • Upgraded H2 to the later version – 2.0.206
  • [PR#2197] [Andrii Tytarchuk] Added optional SQL Plus properties to the liquibase.sqlplus.conf file and put the file in the examples/sql folder [DAT-7618]
    • liquibase.sqlplus.args
    • liquibase.sqlplus.keep.temp.path
    • liquibase.sqlplus.keep.temp.name

Fixes

  • Fixed the generate-changelog wrong dependency order: the addPrimaryKeyChange Type appeared before its base table in PostgreSQL [DAT-8256]
  • Fixed the quality checks settings file to be created using both relative and absolute paths [DAT-8275]
  • Fixed quality checks reporting only the first failure for a changeset to report all failures in outputs [DAT-8630]
  • [PR#2066] [smainz] Fixed the loadDataChange Type to recognize CSV files when loading data with the path that contains a dot character ('.')
  • [PR#2071] [Nicolas Humblot] [Philipp] Fixed the addNotNullConstraintChange Type causing the "Data too long" error message. The PR fixes PR#1054.
  • [PR#2073] [smainz] Fixed the relativeToChangelogFileattribute for loadData, createProcedure, and createViewChange Types
  • [PR#2228] [Nathan Voxland] Updated the logic of the foreign key names that are not always unique
  • [PR#2081] [Jakub Herkel] Fixed OSGI support (manifest and class loading)
  • [PR#2192] [Andrii Tytarchuk] Fixed COLUMN_SIZE for the PostgreSQL NUMERIC[] datatype

Contributions

Our community has built a lot. Thanks to everyone who contributes and helps make the Liquibase community strong, including the following first-time contributors:

This release includes community-contributed pull requests, Liquibase Open Source and Liquibase Pro bug fixes, and a new quality checks functionality.

Here is a closer look at what we improved in the latest release.

Notable Changes

Liquibase 4.6.2 introduces the multiple objects quality check that allows you to define and check the naming pattern for multiple types of objects rather than one type of object. For example, you do not want to have a dash in the table, column, and sequence names. With the multiple objects check, you can specify a pattern to check for dashes and choose tables, columns, and sequences as the objects to check. In version 4.6.2, the check is available for:

  • Table
  • Column
  • Sequence

Note: For more information, see Multiple Objects Quality Check [DAT-8444]

Liquibase 4.6.2 includes the liquibase.sql.log-level configuration option to control the level at which SQL is logged. The default value is FINE.

You can run the --sql-log-level parameter with the --log-level <level> parameter in the CLI:

                liquibase --sql-log-level <FINE|INFO|SEVERE|WARNING|OFF> --log-level=<FINE|INFO|SEVERE|WARNING|OFF> 
--log-file=log.txt update --changelog-file=<changelog>

You can also set the parameter as follows:

  • liquibase.sql.log-level: <FINE|INFO|SEVERE|WARNING|OFF> in the Liquibase properties file
  • LIQUIBASE_SQL_LOG_LEVEL=<FINE|INFO|SEVERE|WARNING|OFF> as an environment variable [PR#1520] [nvoxland]

When you run Liquibase in the CLI, the executables generate a classpath with the .jar files from the LIQUIBASE_HOME and LIQUIBASE_HOME/lib directories. Liquibase 4.6.2 adds the ability to load an additional directory of liquibase_libs in the current working directory to the classpath. With the liquibase_libs directory located in the /lib directory, projects can have separate extensions, drivers, and versions specific to a project [PR#2015] [mcred]

From now on, the exit code for the validate command running in automation shows 1 when there is an error. The PR fixes PR#1006. [PR#2185] [nvoxland] [christf]

Enhancements

  • [PRO] Added the ability to configure the DDL_LOCK_TIMEOUT parameter for Oracle without SQL Plus and define the connection timeout. You can configure DDL_LOCK_TIMEOUT as follows:
    • liquibase.ddlLockTimeout: <value> in the Liquibase properties file
    • --ddl-lock-timeout=<value> as a CLI global parameter
    • LIQUIBASE_DDL_LOCK_TIMEOUT=<int> as an environment variable [DAT-7649]
  • Improved the output of the SqlUserDefinedPatternCheck quality check copy [DAT-8492]
  • [PR#1817] [stalbrecht] Added the MSSQLDatabase specific error evaluation when creating DATABASECHANGELOGLOCK table
  • [PR#2180] [nvoxland] [eldadko] Added support for MySQL function indexes. The PR fixes PR#1626.
  • [PR#928] [CORE-931] [RG9] Added support for the NOT NULL constraint with an initial default value in the addColumnChange Type

Fixes

  • [PR#2173] [wwillard7800] [deci260] Fixed the issue with handling multi-column indexes during the JSON snapshot. The PR fixes PR#1260.
  • [PR#1793] [janjicandjelka8] Fixed the handling of the remarksattribute in a primary key column tag for MariaDB
  • [PR#1894] [KushnirykOleh] Fixed the time data type to be precise for PostgreSQL. The PR fixes PR#1774.
  • [PR#1970] [nvoxland] Fixed the handling of the addColumnChange Type in SQLite
  • [PR#1995] [szandany] Fixed the generate-changelog command to generate the NUMERIC[] data type for PostgreSQL correctly
  • [PR#1990] [JayWelborn] Fixed the SQL generated by the alterSequenceChange Type to be compatible with the Oracle, PostgreSQL, MariaDB, and MSSQL databases
  • [PR#2020] [nvoxland] [dewa-actico] Fixed the handling of nested changelog preconditions. The PR fixes PR#1624.
  • Fixed the naming of the checks settings file shown as null if the file was corrupted [DAT-8553]
  • [PR#2021] [nvoxland] [zamani84] Fixed the issue with Liquibase escaping the backslash in values stored in objects. The PR fixes PR#1598.
  • [PR#2083] [jamey-clari] Enabled the update operations to continue if the DATABASECHANGELOGLOCK table already exists, which helps to serialize all processes following schema creation.
  • [PR#2167] [nvoxland] [obovsunivskyii] Fixed the --verbose flag used in the unexpected-changesets command. The PR fixes PR#1987.
  • [PR#2168] [nvoxland] [gilles-gosuin] Fixed the parsing logic for YAMLChangelogParser and changeLogId in a Map. The PR fixes PR#1988.
  • [PR#2102] [prakashseervi] Implemented the handling of the GENERATED ALWAYS AS clause while creating a table for PostgreSQL
  • [PR#2029] [Marcono1234] Fixed the LOCKGRANTED column to include time zone information in the DATABASECHANGELOGLOCK table
  • [PR#2059] [wardvijf] Fixed the support for custom DB2Database implementations. The PR fixes PR#2058.
  • [PR#2171] [logantracyo] Fixed typos in the ColumnConfig.java documentation
  • [PR#2189] [nvoxland] Fixed the classpath to include files with the relativeToChangelog=true parameter for Spring Boot
  • [PR#2216] [tkalmar] Fixed the log message for PostgreSQL versions
  • [PRO] Fixed the snapshot command failing against CockroachDB with the Liquibase Pro license key applied [DAT-8253]
  • Fixed the dependency order for a changelog file with the addPrimaryKeyChange Type generated by the generate-changelog command for PostgreSQL [DAT-8256]
  • [PRO] Fixed the following environment variables LIQUIBASE_COMMAND_CHECKS_CONFIGURE_CHECKS_SETTINGS_FILE, LIQUIBASE_COMMAND_CHECKS_RUN_CHECKS_SETTINGS_FILE, and LIQUIBASE_COMMAND_CHECKS_SHOW_CHECKS_SETTINGS_FILE to be detected when running the quality checks commands [DAT-8546]
  • Fixed the default value of the strict parameter. The default value is false. You can set the strict parameter as follows:
    • liquibase.strict=false|true in the Liquibase properties file
    • --strict=false|true as a CLI parameter
    • LIQUBIASE_STRICT=false|true as an environment variable [DAT-8547]
  • Fixed quality checks reporting only the first failure in a changeset to report all failures found [DAT-8583]
  • Fixed the Liquibase Cassandra extension failing when username and password are enabled [LB-2115]

Contributions

Our community has built a lot. Thanks to everyone who contributes and helps make the Liquibase community strong, including the following first-time contributors:

Note: Liquibase 4.6.0 release has the wrong version of the Liquibase Pro XSD file. Liquibase 4.6.1 release is a patch release that fixes the issue.

Liquibase 4.6.0 Release

This release includes many community-contributed pull requests, Liquibase Open Source and Liquibase Pro bug fixes.

Here is a closer look at what we improved in the latest release.

Notable Changes

Starting with version 4.6.0, the Windows and Mac/Linux Liquibase installers and the .tar.gz and .zip installation files include the most common JDBC drivers in the installation package:

  • DB2
  • Firebird
  • H2
  • HSQLDB
  • PostgreSQL
  • MariaDB
  • MSSQL
  • Oracle
  • SQLite

To use the available drivers, see the Adding and Updating Liquibase Drivers documentation. Also, check the page for the cases when you need different drivers. [PR#2031] [DAT-7438]

Note: Since Liquibase 4.6.0 provides driver jar files, the size of the installation package is bigger than the size of the installation package in earlier versions.

Liquibase Pro Changes

  • Quality checks include the bulk-set command [DAT-8289]

    • Tip: For more information, see the bulk-set documentation.

  • New quality checks:

    • Static check: Warn when a table truncation is detected [DAT-7933]
    • Dynamic check: Warn when granting specific privileges [DAT-7972]
    • Static check: Warn when the GRANT WITH ADMIN OPTION statement is detected [DAT-7955]
    • Static check: Warn when the GRANT WITH GRANT OPTION statement is detected [DAT-7995]

    Tip: For more information, see the List of Quality Checks documentation.

  • The liquibase.checks-settings.conf file is unencoded in version 4.6.0 and later versions for easier inspection that allows you to resolve a merge conflict in source control. Liquibase backs up encoded files in the working directory, and you can still use previous versions by specifying the --checks-settings-file parameter in the CLI, as an environment variable, or as a property in the Liquibase properties file. [DAT-8473]

If you use Liquibase Hub, check the Liquibase Hub DevOps Metrics documentation to learn more about DevOps metrics that provide the data to optimize your DevOps performance.

Enhancements

  • [PR#1975] [nvoxland] Changed the XSD default errorOnMissingOrEmptyattribute to true for the includeAllattribute in the XML changelog file. The PR fixes PR#1960.
  • [PR#1993] [siudeks] Added support for deferrable primary keys in the createTableChange Type. The PR fixes PR#1597.
  • [PR#1986] [alexey-ivanov-official] [parthdesai21google] Added support for the constraintNameattribute in the dropNotNullConstraintattribute. Updated the addNotNullConstraint rollback logic to pass the constraint name to the generated dropNotNullConstraint change. The PR fixes PR#1492 and PR#1942.
  • [PR#2114] [nvoxland] Improved code and added tests in the liquibase.util package
  • [PR#1679] [thomseno] Changed the datetime type to datetime2 for the timestamp type on SQL Server.
  • [PR#2144] [matejsp] Changed the default encoding to UTF-8. Added a new global liquibase.fileEncoding setting, which you can set as --file-encoding=ASCII in the CLI, liquibase.fileEncoding: ASCII in the Liquibase properties file (liquibase.properties), and LIQUIBASE_FILE_ENCODING=ASCII as an environment variable. The PR fixes PR#1445.
  • [PRO] Added a message to warn Liquibase Pro users when they have noncompliant Liquibase environment variables if the strictattribute is set to true [DAT-6946]

Fixes

  • [PRO] Fixed the issue with Liquibase 4.4.0 and later versions to prompt if the Liquibase Pro license key is expired or invalid. [DAT-7862]
  • [PRO] Fixed Liquibase Pro SQL Plus changesets failures with the Kerberos setup [DAT-8102]
  • [PRO] Fixed the snapshot command using for CockroachDB with Liquibase Pro license key [DAT-8253]
  • Fixed an issue with running quality checks on Windows when using a configuration file created on Linux/macOS [DAT-8298]
  • Fixed the ChangesetCommentCheck check to handle a lack of comments in the tagDatabaseChange Type [DAT-8313]
  • Fixed the default severity for the existing liquibase.checks-settings.conf files [DAT-8328]
  • Fixed the customize and copy commands to handle directories with spaces [DAT-8389]
  • Fixed the schemas and includeSchemaattributes for the generate-changelog command in Liquibase 4.4 and later versions [DAT-8133]
  • Fixed the quality checks customization issue when using Git Bash [DAT-8392]
  • Fixed the message for the quality checks severity customization [DAT-8479]
  • Fixed the quality checks halting execution when the checks settings file contains entries for rules which do not exist in the system. Liquibase skips unknown checks and continues the execution. [DAT-8507]
  • [PR#1407] [pirocraft] Fixed the issue with Liquibase inserting a wrong default datetime value into MySQL. The PR fixes PR#1395.
  • [PR#1415] [Alex1OPS] Fixed the insertChange Type with the valueSequenceNext and valueSequenceCurrentattributes to use the schema specified on a statement level of a changeset. The PR fixes PR#1304.
  • [PR#1931] [nvoxland] Fixed the issue with Liquibase throwing a null pointer exception in the CLI if the LicenseService interface cannot be loaded because of the missing jaxb dependencies
  • [PR#2001] [haster] Fixed the UniqueConstraintSnapshotGenerator class switching to a bulk query after four unique constraints. The PR fixes PR#1996.
  • [PR#1973] [doakd] Fixed the issue with Liquibase formatted SQL changesets that are skipped if there is a space in the --changeset line. The PR fixes PR#1919.
  • [PR#104] [nvoxland] Fixed the drop-all command failing in the PostgreSQL database when the Liquibase-Cassandra extension is in the liquibase/lib directory. The PR fixes PR#47.
  • [PR#2006] [kdenis4] Fixed Liquibase not reading the liquibaseSchemaName and liquibaseCatalogName configuration settings. The PR fixes PR#2000.
  • [PR#1465] [danielthegray] Fixed the issue with Liquibase incorrectly inserting a long CLOB value in the database. Added integration tests.
  • [PR#1974] [gjvoosten] Fixed the issue with Liquibase not handling case-sensitive primary key names in the dropPrimaryKeyChange Type for PostgreSQL. The PR fixes PR#1933.
  • [PR#1941] [meisenla] [ckulenkampff] Fixed the sqlFileChange Type to handle the encodingattribute. The PR fixes PR#1760.

Contributions

Our community has built a lot. Thanks to everyone who contributes and helps make the Liquibase community strong, including the following first-time contributors:

This release includes community-contributed pull requests, Liquibase Open Source and Liquibase Pro bug fixes, and support for Working with Quality Checks.

Quality checks allow you to run checks against SQL, XML, JSON, and YAML changelogs for conditions and configurations important to your organization. More quality checks are forthcoming in future releases; provide feedback on what checks matter most to you.

Here is a closer look at what we improved in the latest release.

Notable Changes

There is a new family of commands to use to run quality checks:

  • liquibase show to list the available quality checks
  • liquibase run to run the available quality checks

along with enable, disable, customize, copy, reset, and delete options, and liquibase checks --help to learn more.

The following is a list of changes related to quality checks:

  • Implement enable/disable subcommands [DAT-7794]
  • Implement run subcommand for dynamic rules [DAT-7796]
  • Implement customize subcommand [DAT-7797]
  • Implement copy subcommand [DAT-7798]
  • Implement reset subcommand [DAT-7800]
  • Implement show subcommand for dynamic rules [DAT-7801]
  • Implement delete subcommand [DAT-7803]
  • STATIC CHECK :: Changeset Must Have A Label [DAT-7924]
  • STATIC CHECK :: Changeset Must Have A Context [DAT-7925]
  • STATIC CHECK :: Changeset Must Have A Comment [DAT-7926]
  • STATIC CHECK :: Warn When "DROP TABLE" Detected [DAT-7928]
  • STATIC CHECK :: Warn When "DROP COLUMN" Detected [DAT-7930]
  • STATIC CHECK :: Warn When Data Type Modification is Detected [DAT-7934]
  • STATIC CHECK :: Warn when 'GRANT' Statement Detected [DAT-7953]
  • STATIC CHECK :: Warn when 'REVOKE' Statement Detected [DAT-7954]
  • DYNAMIC CHECK :: Warn when Tables have more than n columns [DAT-7983]
  • Check for License & Limit gate [DAT-7802]

Resolved Liquibase Issues

  • Fail when creating a Scope with a null-parent #1354. #1377Treehopper
  • Fixes Postgresql bit column support #1468nderwin
  • Fix OSGiResourceAccessor failing due to javax.activation #1534CMoH
  • fixed usage of computed values in prepared insert/update changes #1590Plunts
  • Ensure that the root scope is initialized correctly regardless of whether a scope manager has been configured yet or not #1768rudolfv
  • Fix UniqueConstraint snapshot query on db2z #1771dileepan91
  • generate-changelog on an Oracle db ignores diffIncludeTablespace when creating MissingTableChange #1812briar354
  • Get Set deleteCascade for serializer mapping #1837smith-xyz
  • Add support for changeset ids and authors with spaces in formatted SQL changelogs. #1845jpz
  • More efficient XML resource loading #1860
  • Postgresql: Preserve existing search_path when setting the defaultSchemaName #1864
  • Fixed Postgresql addPrimaryKey cluster handling #1880
  • CLI no longer reading defaultsFile from classpath #1893
  • Manage parent directory relative to changelog in includeAll #1968Cubid
  • Improve synchronization of LockServiceFactory reset #1991
  • Fix createSequence for H2 when dataType is specified #1992
  • [PRO] Pro Enhancement Request: set 'splitStatements' to 'false' for Stored Logic changesets when generating a Formatted SQL changelog [DAT-7391]
  • [PRO] Allow users to indicate names and location of their spool files when using runWith:sqlplus [DAT-7580]
  • [PRO] Cannot update MariaDB expand based storage after first liquibase update [DAT-7879]
  • [PRO] Liquibase Pro generate-changelog error on Postgresql functions that have long signatures containing any '()' characters [DAT-7894]

Contributions

Our community has built a lot. Thanks to everyone who contributes and helps make the Liquibase community strong, including the following first-time contributors:

This release includes community-contributed pull requests, Liquibase Open Source and Liquibase Pro bug fixes, and enhancements to Liquibase Hub performance and pipelines.

Here is a closer look at what we improved in the latest release.

Notable Changes

In Liquibase 4.4.3, there are improvements to the FileSystemAlreadyExistsException output message. The original FileSystemNotFoundException warning was changed to be an info message that does not include logs of stack traces. If you still see stack traces, contact us. #1885dertin

Additionally, we fixed bugs in SQL files: #1798pierre2113

  • The sqlFile and relativeToChangelogFileattributes fail when using the logicalFilePathattribute#1277darkcamper
  • The wrong path received if relativeToChangelogFile=true and databaseChangeLog has logicalFilePath != PhisicalFilePath#1353kezhevatov

Resolved Liquibase Issues

  • Added a separate query for DB2 on AS400, which fixed the drop-all command on DB2 for iSeries #1412wardvijf
  • Fixed the logicalFilePathattribute not being serialized #1471tms-91
  • Fixed the SqlParser bug related to parsing UTF-8 valid symbols #1513matteoturra
  • Fixed the invalid update SQL generated for HSQL database in InsertOrUpdateGeneratorHsql.java#1563devorgpl
  • Added a validation error when the customChangeChange Type has no name attribute#1592danielthegray
  • Fixed the issue with Liquibase failing to create a DATABASECHANGELOGLOCK record and apply changesets into Firebird 3. isNumericBoolean now checks the Firebird3Database instance type and returns Boolean for Firebird 3. #1875koushikd02
  • Fixed the issue with escaping question marks in PostgreSQL: #1877juszczakn and goostleek
    • SQL changesets are transforming the PostgreSQL ? JSON operator into ??, causing function definitions using this operator to become invalid #1764
    • An error when processing a large Postgres SQL changeset #1507
  • Fixed the issue with ClassCastException in a standard lock service: java.time.LocalDateTime cannot be cast to java.util.Date#1878jocmer-evooq and haidiiii
  • Added the MySQL reserved word CUBE to the list of Liquibase reserved columns for the schema migration to work. CUBE is a reserved word as of MySQL 8.0.1 #1515jasonwjones
  • Added the ability to handle empty lines at the beginning of a formatted SQL #1713smith-xyz
  • Fixed loading the CLOB data into PostgreSQL. Instead of loading the CLOB file name, PostgreSQL loads the content of the CLOB file. #1791jidma
  • Changed the MD5SUM column value from RawSqlStatement to UpdateStatement#1602biryukovpavel
  • Fixed synchronization in ChangeLogHistoryServiceFactory.java#1361Olard
  • Fixed the changeset execution failure related to the DATICAL_SPERRORLOG table when using the runWith=sqlplusattribute and executing operations as a user with only SELECT, UPDATE, and INSERT permissions [DAT-7410]
  • Combined Liquibase GitHub Action examples into the liquibase/liquibase-github-action-example repository [DAT-6679]
  • Enabled the drop-all report to work with a registered changelog with no extra arguments and send the information to Liquibase Hub [DAT-7554]
  • Renamed the tablespaceName parameter to liquibaseTablespaceName [DAT-7676]

Contributions

Our community has built a lot. This release includes 15 PRs by 17 authors. Thanks to everyone who contributes and helps make the Liquibase community strong, including the following first-time contributors:

This release includes community-contributed pull requests, Liquibase Open Source and Liquibase Pro bug fixes, and enhancements to the drop-all command and SQL*Plus.

Here is a closer look at what we improved in the latest release.

Known Issues

UniqueConstraintSnapshotGenerator does not handle more than four unique constraints. The diff command reports a difference in unique constraints caused by the PostgreSQL database snapshot having fewer unique constraints than the snapshot from another database compared. Also, the issue can cause unreliable diffs and changelog generation for all non-MySQL databases. The fix will be available in the next release. #1996

Resolved Liquibase Open Source Issues

  • Changed NullPointerException to ChangeLogParseException for the output when there is a typo in a changeSet node #1593
  • Added the support method to DatabaseConnection #1784
  • Fixed the issue with handling serial and bigserial if liquibase.convertDataTypes=false#1883
  • Improved the ConfigurationValueProvider performance #1952
  • Added the ability to allow an empty string for the defaultValueattribute#1963
  • Reintroduced support for the -D arguments in the CLI #1943
  • Restored the update-testing-rollback command #1939
  • Added the Maven goal for unexpected-changesets #1972

Resolved Liquibase Pro Issues

  • Added the ability to handle special characters in procedures when using the generate-changelog command. [DAT-6799]
  • SQL*Plus: Fixed the issue with formatted SQL changesets and runwith:sqlplus being stopped unless Liquibase includes a quit statement. [DAT-7376]
  • SQL*Plus: Fixed the SQL Plus spool log issue. [DAT-7461]

Additional Resolved Issues

  • Extended the drop-all command with optional hubConnectionId and hubProjectIdattributes. [DAT-6972]

    • Note: For more information, check our drop-all command documentation.

  • Fixed nested properties and the substitution of variables in YML changelogs. [DAT-7294]
  • Implemented the ability to use connectionjdbcurl when there is no project or connection ID with the drop-all command. [DAT-7388]
  • Improved the Liquibase Pro License key messaging. [DAT-7036]
  • Added the ability to handle a declined auto-registration when running the drop-all command. [DAT-7489]
  • Fixed auto-registration issues. [DAT-7505]

Contributions

Our community has built a lot. Thanks to everyone who contributes and helps make the Liquibase community strong!

  • danielthegray#1593 Changed NullPointerException to ChangeLogParseException for the output when there is a typo in a changeSet node
  • alexandru-slobodcicov#1784 Added the support method to DatabaseConnection
  • szandany:
    • #1883 Fixed the issue with handling serial and bigserial if liquibase.convertDataTypes=false
    • #1972 Added the Maven goal for unexpected-changesets
  • stuartwdouglas and pmancaux#1952 Improved the ConfigurationValueProvider performance
  • ZwoCa#1963 Added the ability to allow an empty string for the defaultValueattribute
  • Gama11#1943 Reintroduced support for the -D arguments in the CLI
  • chornota#1939 Restored the update-testing-rollback command

For release notes, visit: v4.4.1

For release notes, visit: v4.4.0

For release notes, visit: v4.3.5

For release notes, visit: v4.3.4

For release notes, visit: v4.3.3

For release notes, visit: v4.3.2

For release notes, visit: v4.3.1

For release notes, visit: v4.3.0

For release notes, visit: v4.2.2

For release notes, visit: v4.2.1

For release notes, visit: v4.2.0

For release notes, visit: v4.1.1

For release notes, visit: v3.10.3

For release notes, visit: v4.1.0

For release notes, visit: v3.10.2

For release notes, visit: v4.0.0

For release notes, visit: v4.0.0-beta2

For release notes, visit: v3.10.1

For release notes, visit: v3.10.0

For release notes, visit: v3.9.0

For release notes, visit: v4.0.0-beta1

For release notes, visit: v3.8.9

For release notes, visit: v3.8.8

For release notes, visit: v3.8.7

For release notes, visit: v3.8.6

For release notes, visit: v3.8.5

For release notes, visit: v3.8.4

For release notes, visit: v3.8.3

For release notes, visit: v3.8.2

For release notes, visit: v3.8.1

For release notes, visit: v3.8.0

For release notes, visit: v3.7.0

For release notes, visit: v3.6.3

For release notes, visit: v3.6.2

For release notes, visit: v3.6.1

For release notes, visit: v3.6.0

For release notes, visit: v3.6.0-beta1

For release notes, visit: v3.5.5

For release notes, visit: v3.5.4

For release notes, visit: v3.5.3

For release notes, visit: v3.5.2

For release notes, visit: v3.5.1

For release notes, visit: v3.5.0

For release notes, visit: v3.4.2

For release notes, visit: v3.4.1

For release notes, visit: v3.4.0

For release notes, visit: v3.3.5

For release notes, visit: v3.3.4

For release notes, visit: v3.3.3

For release notes, visit: v3.3.2

For release notes, visit: v3.3.1

For release notes, visit: v3.3.0

For release notes, visit: v3.2.3

For release notes, visit: v3.1.1

For release notes, visit: v3.0.8

For release notes, visit: v2.0.5

For release notes, visit: v1.9.5