liquibase/liquibase
### [`v4.7.1`](https://togithub.com/liquibase/liquibase/releases/v4.7.1)
##### Liquibase 4.7.1 is a patch release
Please report any issues to
##### 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.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.
- \[[PR#1932](https://togithub.com/liquibase/liquibase/pull/1932)] \[[Sergeev Viktor](https://togithub.com/sergeevik)] Enabled changeset execution details to be shown in the output \[LB-1886]
- \[[PR#2261](https://togithub.com/liquibase/liquibase/pull/2261)] \[[Nathan Voxland](https://togithub.com/nvoxland)] Marked the `liquibase-maven-plugin` logging configuration as deprecated \[LB-2183]
- \[[PR#2217](https://togithub.com/liquibase/liquibase/pull/2217)] \[[Wesley Willard](https://togithub.com/wwillard7800)] \[[Marcono1234](https://togithub.com/Marcono1234)] Made lock granted time consistent with date executed time. Modified the `listLocks` output message. The PR fixes [PR#2029](https://togithub.com/liquibase/liquibase/issues/2029). \[LB-2126]
- \[[PR#2293](https://togithub.com/liquibase/liquibase/pull/2293)] \[[Nathan Voxland](https://togithub.com/nvoxland)] \[[ThisOldDog](https://togithub.com/ThisOldDog)] Added support for the additional information with "double" datatypes in MySQL. The PR fixes [PR#2169](https://togithub.com/liquibase/liquibase/issues/2169). \[LB-2195]
- \[[PR#2359](https://togithub.com/liquibase/liquibase/pull/2359)] \[[AlexanderSashchenko](https://togithub.com/AlexanderSashchenko)] Added validation errors for the SQLite and DB2 on z/OS databases \[DAT-8906]
- \[[PR#2348](https://togithub.com/liquibase/liquibase/pull/2348)] \[[Steven Massaro](https://togithub.com/StevenMassaro)] Updated the URLs in the CLI output to direct to the documentation website \[DAT-8947]
- \[[PR#2333](https://togithub.com/liquibase/liquibase/pull/2333)] \[[Wesley Willard](https://togithub.com/wwillard7800)] Enabled property parsing in `FormattedSqlChangeParser` \[DAT-4793]
- \[[PR#2356](https://togithub.com/liquibase/liquibase/pull/2356)] \[[Steven Massaro](https://togithub.com/StevenMassaro)] 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](https://togithub.com/liquibase/liquibase/pull/2364)] \[[Nathan Voxland](https://togithub.com/nvoxland)] \[[M-Koers](https://togithub.com/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](https://togithub.com/liquibase/liquibase/issues/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](https://togithub.com/liquibase/liquibase/pull/2270)] \[[Nathan Voxland](https://togithub.com/nvoxland)] \[[Michael Kroll](https://togithub.com/mickroll)] Fixed the handling of the `cacheSize` attribute in the `createSequence` and `alterSequence` Change Types for MariaDB. The PR fixes [PR#2147](https://togithub.com/liquibase/liquibase/issues/2147). \[LB-2191]
- \[[PR#2269](https://togithub.com/liquibase/liquibase/issues/2109)] \[[Nathan Voxland](https://togithub.com/nvoxland)] \[[Tsvi Zandany](https://togithub.com/szandany)] 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](https://togithub.com/liquibase/liquibase/issues/2109). \[LB-2192]
- \[[PR#2188](https://togithub.com/liquibase/liquibase/pull/2188)] \[[Cullen Coyle](https://togithub.com/coylecullen)] Added the `columnDataType` attribute for the generated `setColumnRemarks` changesets to fix an error in MySQL \[LB-2199]
- \[[#932](https://togithub.com/liquibase/liquibase/pull/932)] \[[Matthias Wuttke](https://togithub.com/wuttke)] Added support for sequences in MaxDB \[LB-41]
- \[[PR#2282](https://togithub.com/liquibase/liquibase/pull/2282)] \[[AlexanderSashchenko](https://togithub.com/AlexanderSashchenko)] Fixed the drop column statement generator for DB2 on z/OS \[DAT-8744]
**Full Changelog**: https://github.com/liquibase/liquibase/compare/v4.7.0...v4.7.1
##### 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 .
##### Read the Documentation
Please check out and contribute to the continually improving docs, now at .
##### 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 make it stronger:
- [Contribute code](https://www.liquibase.org/development/contribute.html)
- [Make doc updates](https://togithub.com/liquibase/liquibase.github.com/tree/master/documentation)
- [Help by asking and answering questions](https://forum.liquibase.org/)
- [Set up a chat with the Product team](https://calendly.com/liquibase-outreach/product-feedback)
##### Our first-time contributors
- [Sergeev Viktor](https://togithub.com/sergeevik)
- [](https://togithub.com/philhinco)[Marcono1234](https://togithub.com/Marcono1234)
- [Michael Kroll](https://togithub.com/mickroll)
- [ThisOldDog](https://togithub.com/ThisOldDog)
- [Cullen Coyle](https://togithub.com/coylecullen)
- [Matthias Wuttke](https://togithub.com/wuttke)
##### Thanks to everyone who helps make the Liquibase community strong!
### [`v4.7.0`](https://togithub.com/liquibase/liquibase/releases/v4.7.0)
#### Liquibase 4.7.0 release
Please report any issues to
##### 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 terminal window. \[DAT-8945]
**Note:** For more information and examples of using `init` project, see [init project](https://docs.liquibase.com/commands/liquibase-start/init-project.html).
Additionally, we have updated the Liquibase Getting Started tutorials, sample changelog files, and the example H2 database in the installation package. From now on, you can use sample SQL, XML, JSON, and YAML changelog files with the corresponding changesets and the latest version of H2. \[LB-2177] \[LB-2174]
**Note:** Check Liquibase [Getting Started](https://docs.liquibase.com/start/getting-started-with-liquibase-and-sql-on-windows.html) to see more details.
##### Enhancements
- \[PRO] Improved the output of the `rollback-one-update` command \[DAT-7590]
- \[[PR#2244](https://togithub.com/liquibase/liquibase/pull/2244)] \[[Tsvi Zandany](https://togithub.com/szandany)] Enabled the use of the `jdbc:edb` URL for Liquibase to recognize EnterpriseDB \[LB-2185]
- \[[PR#2225](https://togithub.com/liquibase/liquibase/pull/2225)] \[[Nathan Voxland](https://togithub.com/nvoxland)] \[[Konstantin](https://togithub.com/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](https://togithub.com/liquibase/liquibase/issues/2044). \[LB-2175]
- 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](https://togithub.com/liquibase/liquibase/pull/2197)] \[[Andrii Tytarchuk](https://togithub.com/andrulban)] 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
- \[[PR#2215](https://togithub.com/liquibase/liquibase/pull/2215)] \[[Nathan Voxland](https://togithub.com/nvoxland)] Improved MySQL `loadData` performance \[LB-2173]
##### 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 \[DAT-8275]
- Fixed quality checks reporting only the first failure for a changeset to report all failures in outputs \[DAT-8630]
- \[[PR#2066](https://togithub.com/liquibase/liquibase/pull/2066)] \[[smainz](https://togithub.com/smainz)] Fixed the `loadData` Change Type to recognize CSV files when loading data with the path that contains a dot character ('.') \[LB-2178]
- \[[PR#2071](https://togithub.com/liquibase/liquibase/pull/2071)] \[[Nicolas Humblot](https://togithub.com/nhumblot)] \[[Philipp](https://togithub.com/philhinco)] Fixed the `addNotNullConstraint` Change Type causing the "Data too long" error message. The PR fixes [PR#1054](https://togithub.com/liquibase/liquibase/issues/1054). \[LB-2187]
- \[[PR#2073](https://togithub.com/liquibase/liquibase/pull/2073)] \[[smainz](https://togithub.com/smainz)] Fixed the `relativeToChangelogFile` attribute for `loadData`, `createProcedure`, and `createView` Change Types \[LB-2179]
- \[[PR#2228](https://togithub.com/liquibase/liquibase/pull/2228)] \[[Nathan Voxland](https://togithub.com/nvoxland)] Updated the logic of the foreign key names that are not always unique \[LB-2176]
- \[[PR#2081](https://togithub.com/liquibase/liquibase/pull/2081)] \[[Jakub Herkel](https://togithub.com/jherkel)] Fixed OSGI support (manifest and class loading) \[LB-2184]
- \[[PR#2192](https://togithub.com/liquibase/liquibase/pull/2192)] \[[Andrii Tytarchuk](https://togithub.com/andrulban)] Fixed `COLUMN_SIZE` for the PostgreSQL `NUMERIC[]` datatype
***
**Full Changelog**: https://github.com/liquibase/liquibase/compare/v4.6.2...v4.7.0
##### Get Certified
Learn all the Liquibase fundamentals from free online courses by Liquibase experts and see how to apply them in the real world at .
##### Read the Documentation
Please check out and contribute to the continually improving docs, now at .
##### 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 make it stronger:
- [Contribute code](https://www.liquibase.org/development/contribute.html)
- [Make doc updates](https://togithub.com/liquibase/liquibase.github.com/tree/master/documentation)
- [Help by asking and answering questions](https://forum.liquibase.org/)
- [Set up a chat with the Product team](https://calendly.com/liquibase-outreach/product-feedback)
##### Our first-time contributors
- [Nicolas Humblot](https://togithub.com/nhumblot)
- [Philipp](https://togithub.com/philhinco)
- [Konstantin](https://togithub.com/catholic-indulgence-vaper)
- [Jakub Herkel](https://togithub.com/jherkel)
##### Thanks to everyone who helps make the Liquibase community strong!
Configuration
📅 Schedule: At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
[ ] If you want to rebase/retry this PR, click this checkbox.
This PR contains the following updates:
4.6.2
->4.7.1
Release Notes
liquibase/liquibase
### [`v4.7.1`](https://togithub.com/liquibase/liquibase/releases/v4.7.1) ##### Liquibase 4.7.1 is a patch release Please report any issues toConfiguration
📅 Schedule: At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
This PR has been generated by WhiteSource Renovate. View repository job log here.