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]
Note: You can use the property not only with the show command but any other quality checks command.
[PR#1932] [Sergeev Viktor] Enabled changeset execution details to be shown in the output [LB-1886]
[PR#2261] [Nathan Voxland] Marked the liquibase-maven-plugin logging configuration as deprecated [LB-2183]
[PR#2217] [Wesley Willard] [Marcono1234] Made lock granted time consistent with date executed time. Modified the listLocks output message. The PR fixes PR#2029. [LB-2126]
[PR#2359] [AlexanderSashchenko] Added validation errors for the SQLite and DB2 on z/OS databases [DAT-8906]
[PR#2348] [Steven Massaro] Updated the URLs in the CLI output to direct to the documentation website [DAT-8947]
[PR#2333] [Wesley Willard] Enabled property parsing in FormattedSqlChangeParser [DAT-4793]
[PR#2356] [Steven Massaro] Added the output message which points to the init project command if you miss a supported argument in any command [DAT-8641]
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=changeLogProperty attribute not working in a formatted SQL changelog [DAT-4793]
[PR#2270] [Nathan Voxland] [Michael Kroll] Fixed the handling of the cacheSize attribute in the createSequence and alterSequence Change 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 tagExists myTag) to correctly convert the pattern into new versions. The PR fixes PR#2109. [LB-2192]
[PR#2188] [Cullen Coyle] Added the columnDataType attribute for the generated setColumnRemarks changesets to fix an error in MySQL [LB-2199]
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/.
Mark liquibase-maven-plugin logging configuration as deprecated (#2261)
Added validation errors for SQLite and DB2z databases (#2359)
Changes in version 4.7.0 (2022.01.07)
Liquibase 4.7.0 introduces the init command with the project subcommand, which helps to build the necessary
configuration files for using Liquibase or, if you already use Liquibase, create new project files with minimal input.[DAT-8640]
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.
Enhancements
[PRO] Improved the output of the rollback-one-update command
[PR#2244] [szandany] Enabled the use of the jdbc:edb URL for Liquibase to recognize EnterpriseDB
[PR#2225] [nvoxland] [catholic-indulgence-vaper] 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
Upgrade h2 to newer version 2.0.206
Fixes
Fixed the generateChangeLog wrong dependency order: the addPrimaryKey Change 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
Fixed quality checks reporting only the first failure for a changeset to report all failures in outputs
PR#2066] [smainz] Fixed the loadData Change Type to recognize CSV files when loading data with the path that contains a dot character ('.')
[PR#2071] [nhumblot] [philhinco] Fixed the addNotNullConstraint Change Type causing the "Data too long" error message. The PR fixes PR#1054.
[PR#2073] [smainz] Fixed the relativeToChangelogFile attribute for loadData, createProcedure, and createView Change Types
[PR#2228] Handle the fact that FK names are not always unique
[PR#2081] fix OSGI support (manifest, class loading)
[PR#928] addColumn should support not-null constraint
Changes in version 4.6.2(2021.11.30)
Liquibase 4.6.2 introduces the multiple objects name quality check that allows you to define and check the naming pattern for several objects rather than one object.
For example, you do not want to have a dash in the table, column, and sequence names. With the multiple objects name 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:
Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.
Dependabot commands and options
You can trigger Dependabot actions by commenting on this PR:
- `@dependabot rebase` will rebase this PR
- `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it
- `@dependabot merge` will merge this PR after your CI passes on it
- `@dependabot squash and merge` will squash and merge this PR after your CI passes on it
- `@dependabot cancel merge` will cancel a previously requested merge and block automerging
- `@dependabot reopen` will reopen this PR if it is closed
- `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
- `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
- `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
- `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)
Bumps liquibase-core from 4.5.0 to 4.7.1.
Release notes
Sourced from liquibase-core's releases.
... (truncated)
Changelog
Sourced from liquibase-core's changelog.
... (truncated)
Commits
235f70a
Added 4.7.1 changelog notes157707b
Merge pull request #2364 from liquibase/edb-check-too-broad0d9c95f
Merge pull request #2282 from liquibase/DAT-874422963c0
Merge pull request #2359 from liquibase/DAT-8906548da8a
Determine if connection is EDB by calling version()a91a8c7
Determine if connection is EDB by calling version()9cdf0f5
Merge branch 'master' into edb-check-too-broada9b2c81
point users to init project command if they forget a supported argument in an...99f59c5
Add Sonar scanning to builds (#2365)f7571ab
Merge pull request #1932 from sergeevik/update_log_to_uiDependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting
@dependabot rebase
.Dependabot commands and options
You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot merge` will merge this PR after your CI passes on it - `@dependabot squash and merge` will squash and merge this PR after your CI passes on it - `@dependabot cancel merge` will cancel a previously requested merge and block automerging - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually - `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)