liquibase

Main Liquibase Source

APACHE-2.0 License

Stars
4.4K
Committers
749
View Code on GitHub Visit Website View on X
Ecosystems: MySQL, MariaDB, Java, sql-server

Bot releases are hidden (Show)

liquibase - v4.6.0

Published by suryaaki2 almost 3 years ago

Liquibase 4.6.0 is a major release

Please report any issues to https://github.com/liquibase/liquibase/issues

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 have configurable severity and exit codes [DAT-8171]
  • The quality checks bulk-set command [DAT-8289]
  • 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]
  • 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 errorOnMissingOrEmpty attribute to true for the includeAll attribute in the XML changelog file. The PR fixes PR#1960.
  • [PR#1993] [siudeks] Added support for deferrable primary keys in the createTable Change Type. The PR fixes PR#1597
  • [PR#1986] [alexey-ivanov-official] [parthdesai21google] Added support for the constraintName attribute in the dropNotNullConstraint attribute. 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, 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 strict attribute 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 tagDatabase Change Type [DAT-8313]
  • Fixed the default severity for the existing liquibase.checks-settings.conf files [DAT-8328]
  • Fixed the checks customize and checks copy commands to handle directories with spaces [DAT-8389]
  • Fixed the schemas and includeSchema attributes for the generateChangeLog 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-8415]
  • 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 insert Change Type with the valueSequenceNext and valueSequenceCurrent attributes 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 dropAll 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 dropPrimaryKey attribute for PostgreSQL. The PR fixes PR#1933.
  • [PR#1941] [meisenla] [ckulenkampff] Fixed the sqlFile Change Type to handle the encoding attribute. The PR fixes PR#1760.

Get Certified

Learn all the Liquibase fundamentals from free online courses by Liquibase experts and see how to apply them in the real world at https://learn.liquibase.com/.

Read the Documentation

Please check out and contribute to the continually improving docs, now at https://docs.liquibase.com/.

Meet the Community

Our community has built a lot. From extensions to integrations, you’ve helped make Liquibase the amazing open source project that it is today. Keep contributing to make it stronger:

Our first-time contributors

Thanks to everyone who helps make the Liquibase community strong!

liquibase - v4.5.0

Published by suryaaki2 about 3 years ago

v4.5.0

Liquibase 4.5.0 is now available at Liquibase.org.

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

Liquibase 4.5.0 is a major release

Please report any issues to https://github.com/liquibase/liquibase/issues.

Notable Changes

Liquibase 4.5.0 includes support for Liquibase Quality Checks, which allow you to run checks against changelogs and SQL scripts by flagging conditions and configurations you need.

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

  • liquibase checks show to list the available quality checks
  • liquibase checks 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 Liquibase Quality Checks:

  • Implement checks enable/disable subcommands [DAT-7794]
  • Implement checks run subcommand for dynamic rules [DAT-7796]
  • Implement checks customize subcommand [DAT-7797]
  • Implement checks copy subcommand [DAT-7798]
  • Implement checks reset subcommand [DAT-7800]
  • Implement checks show subcommand for dynamic rules [DAT-7801]
  • Check for License & Limit gate [DAT-7802]
  • Implement checks delete subcommand [DAT-7803]
  • Initial write of the check-settings-config file [DAT-7858]
  • Add shortname to basic rules [DAT-7876]
  • Add ID to basic rules [DAT-7877]
  • Implement a Dynamic Rule [DAT-7883]
  • 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]
  • QC subcommand help lists incorrect environment variable format. [DAT-8005]
  • Change name of default settings file for checks to liquibase.checks-settings.conf [DAT-8017]
  • Core: Checks should be run in numeric order (ASC) [DAT-8040]
  • QC: BUG - [Y/n] defaults to n, but should default to [Y]es [DAT-8132]
  • QC: Update the priorities for 3 Liquibase checks (labels, contexts, comments) [DAT-8134]

Bugfixes

  • Fail when creating a Scope with a null-parent #1354. #1377 Treehopper
  • Fixes Postgresql bit column support #1468 nderwin
  • Fix OSGiResourceAccessor failing due to javax.activation #1534 CMoH
  • fixed usage of computed values in prepared insert/update changes #1590 Plunts
  • Ensure that the root scope is initialized correctly regardless of whether a scope manager has been configured yet or not #1768 rudolfv
  • Fix UniqueConstraint snapshot query on db2z #1771 dileepan91
  • Update MissingTableChangeGenerator.java #1812 briar354
  • Get Set deleteCascade for serializer mapping #1837 smith-xyz
  • Add support for changeset ids and authors with spaces in formattedsql changelogs. #1845 jpz
  • 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 #1968 Cubid
  • 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 generateChangeLog error on Postgresql functions that have long signatures containing any '()' characters [DAT-7894]

Get Certified

Learn all the Liquibase fundamentals from free online courses by Liquibase experts and see how to apply them in the real world at: https://learn.liquibase.com/.

Read the documentation

Please check out and contribute to the continually improving docs, now at: https://docs.liquibase.com/.

Meet the Community

Our community has built a lot. From extensions to integrations, you’ve helped make Liquibase the amazing open source project that it is today. Keep contributing to make it stronger:

Our first-time contributors

Thanks to everyone who helps make the Liquibase community strong!

liquibase - v4.4.3

Published by nvoxland about 3 years ago

Liquibase 4.4.3 is now available at Liquibase.org.

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

Liquibase 4.4.3 is a patch release

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

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 are still seeing stack traces, please contact us. #1885 dertin

Additionally, we fixed bugs in SQL files: #1798

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

Bugfixes

  • Added a separate query for DB2 on AS400, which fixed the dropAll command on DB2 for iSeries #1412 wardvijf
  • Fixed the logicalFilePath attribute not being serialized #1471 tms-91
  • Fixed the SqlParser bug related to parsing UTF-8 valid symbols #1513 matteoturra
  • Fixed the invalid update SQL generated for HSQL database in InsertOrUpdateGeneratorHsql.java #1563 devorgpl
  • Added a validation error when the customChange Change Type has no name attribute #1592 danielthegray
  • 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. #1875 koushikd02
  • Fixed the issue with escaping question marks in PostgreSQL: #1877 juszczakn 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 #1878 jocmer-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 #1515 jasonwjones
  • Added the ability to handle empty lines at the beginning of a formatted SQL #1713 smith-xyz
  • Fixed loading the CLOB data into PostgreSQL. Instead of loading the CLOB file name, PostgreSQL loads the content of the CLOB file. #1791 jidma
  • Changed the MD5SUM column value from RawSqlStatement to UpdateStatement #1602 biryukovpavel
  • Fixed synchronization in ChangeLogHistoryServiceFactory.java #1361 Olard
  • Fixed the changeset execution failure related to the DATICAL_SPERRORLOG table when using the runWith=sqlplus attribute 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 dropAll 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]

Get Certified

Learn all the Liquibase fundamentals from free online courses by Liquibase experts and see how to apply them in the real world at: https://learn.liquibase.com/.

Read the documentation

Please check out and contribute to the continually improving docs, now at: https://docs.liquibase.com/.

Meet the Community

Our community has built a lot. From extensions to integrations, you’ve helped make Liquibase the amazing open source project that it is today. Keep contributing to make it stronger:

Our first-time contributors

Thanks to everyone who helps make the Liquibase community strong!

liquibase - v4.4.2

Published by suryaaki2 about 3 years ago

Liquibase 4.4.2 is now available here and through our website.
Here is a closer look at what we improved in the latest release.

Liquibase 4.4.2 is a patch release

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

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

Liquibase Open Source Issues

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

Liquibase Pro Issues

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

Additional Issues

  • DAT-6972 Extended the dropAll command with optional hubConnectionId and hubProjectId attributes. For more information, check our dropAll command documentation.
  • DAT-7294 Fixed nested properties and the substitution of variables in YML changelogs.
  • DAT-7388 Implemented the ability to use connectionjdbcurl when there is no project or connection ID with the dropAll command.
  • DAT-7036 Improved the Liquibase Pro License key messaging.
  • DAT-7489 Added the ability to handle a declined auto-registration when running the dropAll command.
  • DAT-7505 Fixed auto-registration issues.

Get Certified

Learn all the Liquibase fundamentals from free online courses by Liquibase experts and see how to apply them in the real world at: https://learn.liquibase.com/.

Read the documentation

Please check out and contribute to the continually improving docs, now at: https://docs.liquibase.com/.

Meet the Community

Our community has built a lot. From extensions to integrations, you’ve helped make Liquibase the amazing open source project that it is today. Keep contributing to make it stronger:

Thanks to everyone who helps make the Liquibase community strong!

liquibase - v4.4.1

Published by suryaaki2 over 3 years ago

Liquibase 4.4.1 is now available here and through our website.
Here’s a closer look at what's included in the latest release.

Liquibase 4.4.1 includes bug fixes and updates

This release introduces SQL*Plus fixes for Liquibase Pro users, addresses some Liquibase Hub integration issues, along with some other bugs listed below.

Bug fixes

  • HubUpdater releases lock even though registration is skipped #1869
  • Only snapshot tables/columns in loadData #1861
  • [LB-704] fixed generating sequences for Postgres versions prior to 10 #1843
  • Fixes MySQL Snapshot/Generated ChangeLog output for table key constraints when multiple tables #1829
  • Postgres: Rollback of rename target fails due to malformed SQL.
  • Liquibase Hub registerChangeLog messaging fixes
  • Liquibase Hub, Maven, and liquibase.properties file fixes
  • Using --liquibaseProLicenseKey is on the left side of the command
  • Update Liquibase installer adoptopenjdk from 11.0.10 to 11.0.11
  • [PRO] SQL Plus handles backslashes in changeset attributes' values
  • [PRO] SQL Plus passing arguments during runtime fixes
  • [PRO] SQL Plus handles Oracle proxy user setups
  • [PRO] SQL Plus improve temp file handling
  • [PRO] Fixes snapshot on MySQL Stored Logic Objects with Integer Types

Get Certified

Learn all the Liquibase fundamentals from free online courses by Liquibase experts and see how to apply them in the real world at: https://learn.liquibase.com/.

Read the documentation

Please check out and contribute to the continually improving docs, now at: https://docs.liquibase.com/.

Meet the Community

Our community has built a lot. From extensions to integrations, you’ve helped make Liquibase the amazing open source project that it is today. Keep contributing to make it stronger:

Thanks to everyone who helps make the Liquibase community strong!

liquibase - v4.4.0

Published by suryaaki2 over 3 years ago

Liquibase 4.4.0 is now available here through Liquibase.org.
Here’s a closer look at what's included in the latest release.

Liquibase 4.4.0 is a major release

While there are significant changes in important Configuration and Command APIs, and a new CLI library, this release should be 100% backwards compatible. Please report any issues to https://github.com/liquibase/liquibase/issues

Key changes

  • Refactor Configuration API
    • [PRO] Including native use of Environment variables
  • Refactor Command API
  • Rewrote CLI to use new library
    • including new command options and --help content

Bugfixes

  • Fixes an issue with Maven logs and username password (#1859)
  • Fixes an issue with resolving properties files (#1723)
  • Fixes an issue with diffChangelog dependency order (#1722)
  • Fixes an issue with generating changlogs with DB2 on z/OS (#1506)
  • Fixes an issue with long table names in Postgres (#1483)
  • Fixes an issue with update flags for Postegres(#1213)
  • Fixes an issue with loadData and loadUpdateData(#964)

Get Certified

Learn all the Liquibase fundamentals from free online courses by Liquibase experts and see how to apply them in the real world at: https://learn.liquibase.com/.

Read the documentation

Please check out and contribute to the continually improving docs, now at: https://docs.liquibase.com/.

Meet the Community

Our community has built a lot. From extensions to integrations, you’ve helped make Liquibase the amazing open source project that it is today. Keep contributing to make it stronger:

Thanks to everyone who helps make the Liquibase community strong!

liquibase - v4.3.5

Published by nvoxland over 3 years ago

Liquibase 4.3.5 is now available here through Liquibase.org.
Here’s a closer look at what's included in the latest release.

Liquibase 4.3.5 is a Pro error handling release

Bugfixes

Liquibase Pro only:

  • Better error handling in runWith=sqlplus when user doesn't have create/drop table permissions

Get Certified

Learn all the Liquibase fundamentals from free online courses by Liquibase experts and see how to apply them in the real world at: https://learn.liquibase.com/.

Read the documentation

Please check out and contribute to the continually improving docs, now at: https://docs.liquibase.com/.

Meet the Community

Our community has built a lot. From extensions to integrations, you’ve helped make Liquibase the amazing open source project that it is today. Keep contributing to make it stronger:

Thanks to everyone who helps make the Liquibase community strong!

liquibase - v4.3.4

Published by nvoxland over 3 years ago

Liquibase 4.3.4 is now available here through Liquibase.org.

Here’s a closer look at what's included in the latest release.

Liquibase 4.3.4 is a bugfix release

Bugfixes

  • DiffChangeLog/GenerateChangeLog produces invalid XML in 4.3.3 (#1803)

REVERTED FROM 4.3.3:

  • Fixes issue with diffChangeLog and addColumn --> addPrimaryKey ordering (#1722)

Get Certified

Learn all the Liquibase fundamentals from free online courses by Liquibase experts and see how to apply them in the real world at: https://learn.liquibase.com/.

Read the documentation

Please check out and contribute to the continually improving docs, now at: https://docs.liquibase.com/.

Meet the Community

Our community has built a lot. From extensions to integrations, you’ve helped make Liquibase the amazing open source project that it is today. Keep contributing to make it stronger:

Thanks to everyone who helps make the Liquibase community strong!

liquibase - v4.3.3

Published by nvoxland over 3 years ago

Liquibase 4.3.3 is now available here through Liquibase.org.
Here’s a closer look at what's included in the latest release.

Liquibase 4.3.3 is a bugfix release

Bugfixes

Thanks to everyone who helps make the Liquibase community strong!

  • Fixes an issue with changelogsync and Hub
  • Fixes an issue with dropAll and Postgres (#1212)
  • Fixes an issue with diff and NullPointerException (#1631)
  • Fixes an issue with NullPointerException and DateTimeType (#1366)
  • Fixes issue with Maven resolving/using properties file (#1723)
  • Fixes issue with diffChangeLog and addColumn --> addPrimaryKey ordering (#1722)

Pull Requests Merged into 4.3.3

https://github.com/liquibase/liquibase/pull/1649
https://github.com/liquibase/liquibase/pull/1758
https://github.com/liquibase/liquibase/pull/1367
https://github.com/liquibase/liquibase/pull/1744
https://github.com/liquibase/liquibase/pull/1733

Special 4.3.3 shout-outs

Big thanks to the Liquibase community, especially stevesaliman, wwillard7800, mironbalcerzak, molivasdat, ro-rah and others!

Get Certified

Learn all the Liquibase fundamentals from free online courses by Liquibase experts and see how to apply them in the real world at: https://learn.liquibase.com/.

Read the documentation

Please check out and contribute to the continually improving docs, now at: https://docs.liquibase.com/.

Meet the Community

Our community has built a lot. From extensions to integrations, you’ve helped make Liquibase the amazing open source project that it is today. Keep contributing to make it stronger:

Thanks to everyone who helps make the Liquibase community strong!

liquibase - v4.3.2

Published by nvoxland over 3 years ago

Liquibase 4.3.2 is now available here through Liquibase.org.
Here’s a closer look at what's included in the latest release.
​

Liquibase 4.3.2 offers both enhancements and bugfixes

​

Enhancements

  • Added new changelogSyncToTag command
  • Added new deactivatechangelog command for CLI and Maven users of Liquibase Hub. (Read the docs.)
  • Added ability to create Hub projects with parameters instead of only via prompts for CLI and Maven users
    ​

Bugfixes

​
This release merges many community-contributed pull requests. Thanks to everyone who helps make the Liquibase community strong!
​

  • Only enable console prompting when explicitly enabled by the CLI #1711 #1689
  • Handle includeAll better in spring boot #1595 and #1436
  • Changed JRE bundled with installers to use the latest LTS version
  • Better handle dropAll on postgresql partitioned tables #1650
  • Fixed sample liquibase.sqlplus.conf file #1448 and #1416
  • Fixed loadData's usePreparedStatement attribute #1098
  • Send hub logs at the same log level as configured in the CLI
    ​
    ​

Pull Requests Merged into 4.3.2

https://github.com/liquibase/liquibase/pull/1133
https://github.com/liquibase/liquibase/pull/1711
https://github.com/liquibase/liquibase/pull/1689
https://github.com/liquibase/liquibase/pull/1595
https://github.com/liquibase/liquibase/pull/1436
https://github.com/liquibase/liquibase/pull/1650
https://github.com/liquibase/liquibase/pull/1448
https://github.com/liquibase/liquibase/pull/1416
https://github.com/liquibase/liquibase/pull/1098
​
​

Special 4.3.2 shout-outs

Big thanks to the Liquibase community, especially suilven, ilopmar, nvpxland, chadoc, jglink, stevesaliman, malathit, szandany, jdhmoreno, molivasdat, ro-rah and others!
​
​

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: http://learn.liquibase.com/.
​

Read the documentation

Please check out and contribute to the continually improving docs, now at: http://docs.liquibase.org/.
​
​

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:

Thanks to everyone who helps make the Liquibase community strong!

liquibase - v4.3.1

Published by nvoxland over 3 years ago

Liquibase 4.3.1 is a quick bugfix release to address:

  • Fixed handling of classpath*: in includeAll #1595
  • ClassCastException on moving to mysql-connector-java 8.0.23 #1639
  • Passwords sent to Hub when using jTDS driver
  • ChangeExecListener cannot be used due to HubChangeExecListener #1651
  • RelativePathError when using includeAll tag and Spring Boot #1657
  • Liquibase 4.3.0 throws NullPointerExceptions without snakeyaml in the classpath #1682
liquibase - v4.3.0

Published by nvoxland over 3 years ago

This release includes many community-contributed pull requests, bug fixes, and an enhancement to Liquibase Hub integration represented by two new capabilities — optional auto-registration to Liquibase Hub from the CLI and Liquibase Hub report links presented in CLI.

Also, MariaDB is now fully certified for Liquibase Pro users.

Bug fixes

  • Fixed NullPointerException when an output writer is null #1625
  • Fixed filename + Id + author to be treated as unique in ValidatingVisitor.findChangeSet method #1622
  • Fixed EntityResolver to check the classpath even if the standard ResourceAccessor does not include it #1621
  • Fixed HistoryCommandTest to run on systems having a non-US default locale #1078
  • Added quotes around ${JAVA_PATH} in Liquibase shell script to avoid spaces in path issues #1062
  • Fixed the issue with automatic dropping of default values on MS SQL #1003
  • Allowed --changeset to have a space after -- in formatted sql files

Improvements

  • Updated the snakeyaml driver (that is packaged with Liquibase installer files) to address the CVE-2017-18640 vulnerability #1608
  • Modified SetColumnRemarks support for MySQL #942
  • Implemented boolean data type support for DB2 LUW #966
  • Added deprecated LogFactory.getInstance() to make it easier for users who use the third party extension code to upgrade to 4.x #1642 and #1641
  • Included the existing dropPrimaryKey.dropIndex attribute in XSD #1629
  • Implemented auto-registration and operation report capabilities for Liquibase Hub
  • Certified MariaDB and Liquibase Pro functionality. Determined and documented MariaDB Oracle-compatible PL/SQL stored logic objects along with minimum GRANTs to leverage Liquibase Pro with MariaDB 10.4. See Liquibase Pro and MariaDB GRANT Best Practices.
liquibase - v4.2.2

Published by nvoxland almost 4 years ago

Liquibase 4.2.2 is a quick bugfix release to address:

  • Handle null statement objects coming from JdbcConnection objects #1576

which impacted the Liquibase-Hibernate extension

liquibase - v4.2.1

Published by nvoxland almost 4 years ago

This is mostly a bug release which offers fixes for both Liquibase Pro and Liquibase Open Source, and an enhancement to Liquibase Hub integration.

  • Fixed invalid casting to JdbcConnection in CockroachDatabase #1536
  • Fixed missing unique constraints in snapshot #1477
  • Fixed unexpectedChangeSets command throwing a null pointer exception
  • If error occurs during generating SQL, Liquibase stops and does not send POST to Hub
  • Use ConcurrentHashMap in ExecutorService #1402
  • DropDefaultValue on postgresql now drops the default value vs. setting the default value to null #931
  • Updated banner to reference to hub.liquibase.com
  • [PRO] GenerateChangeLog on postgresql stored logic now hashes parameters in filenames instead of listing them all out
  • [PRO] Fix in postgresql check constraints snapshot
  • [HUB] Enhancement: The registerChangeLog command now supports YAML & JSON changelog files

Liquibase Pro Key Included!

A trial Liquibase Pro Key for you to use immediately is included in the sample liquibase.properties files in the /example/sql and /examples/xml directories. Simply un-comment the liquibaseProLicenseKey to accept the terms at https://www.liquibase.com/terms-of-use and start enjoying the powers of Liquibase Pro.

The Pro key below expires on Dec 31, 2020 but is easily and freely renewed at https://www.liquibase.com/protrial

liquibase - v4.2.0

Published by nvoxland almost 4 years ago

This major release offers significant enhancements and bug fixes for both Liquibase Open Source and Pro users and supports further Liquibase Hub integration.

Improvements

  • [PRO] certified support for MySQL 5.7 and 8.0, including enhanced support for stored logic
  • CockroachDB support (check out our CockroachDB tutorial)
  • New "allowUpdate" attribute on loadData columns #373

Bugfixes

  • Improved Maven support for Liquibase Hub
  • Fix xsd, remove surplus space after validateForeignKey in 4.1.xsd / 4.2.xsd #1523
  • MySql 8.0 requires create and drop of temporary tables to run generateChangeLog #1510
  • Move banner.txt to new location #1496
  • Fix issue with loadUpdateData #1495
  • loadUpdateData broken for clob/text fields in 3.10.3 #1489
  • XML Export adds ',xxx' instead of ',' #1438
  • Precondition onFail="WARN" doesn't work properly #1389
  • Update Ant Tasks to use DatabaseFactory rather than create connection itself #1427

Shoutouts

We'd like to give a shoutout to the following community members for all of their contributions to this release: d.volkov, Leonardo Arcari, Timur Tibeyev, Stéphane Nicoll, Pankaj Kumar, Pavlo Tytarchuk, Matt Bertolini, Erzsebet Carmean, Wes Willard, Mike Olivas, Nathan Voxland, Ronak Rahman, Caroline Hunt.

liquibase - v4.1.1

Published by nvoxland about 4 years ago

Liquibase 4.1.1 is a bugfix release

Changes

This release brings the 3.10.3 fixes into 4.1 as well as introduces a couple 4.1 specific fixes.

liquibase - v3.10.3

Published by nvoxland about 4 years ago

Liquibase 3.10.3 is a bugfix release

Changes

This release merges many community-contributed pull requests. Thanks to everyone who helps make the Liquibase community strong!

Special 3.10.3 shout-outs

Mike Olivas, mrgrew, Robert Reeves, FrankHoellering, Steven C. Saliman, thomas, Ruud Welling, Sudipto Sarkar, alexander.schuetz, ningyu, Wes Willard and others!

liquibase - v4.1.0

Published by nvoxland about 4 years ago

Liquibase 4.1 connects local Liquibase operations to Liquibase Hub

This release powers Liquibase Hub, now available in Beta. This free, secure SaaS portal provides status reporting, monitoring, and insights into your Liquibase database release automation. Learn more about Liquibase Hub Beta.

New Commands

  • registerchangelog — This interactive CLI command will register the specified changelog to a Project in your Liquibase Hub organization. You can create a Project from the CLI, or choose one already created.
  • synchub — Synchronizes your local DATABASECHANGELOG table with its Liquibase Hub counterpart.

New Concepts

  • Organizations — An Organization in Hub is the overall collection of all the elements used in the Liquibase Hub system. This includes Projects, changelogs and their changesets, connections, Operation reports, and your team members. A user can have more than one Organization and be in more than one Organization.

  • Projects — A Project in Liquibase Hub is the structured collection of the resources used by Liquibase Open Source or Liquibase Pro 4.1+. This includes changelogs, changesets, connections (e.g., JDBC URLs) and the commands run on these elements included in reports.

  • Operation reports — These reports include data sent from Liquibase Open Source or Liquibase Pro when it performs various commands on a registered changelog.

  • Users — A person who has an account in Liquibase Hub and owns one or more API Keys.

  • API Key — This key connects your Liquibase usage to specific Hub Organizations. A user can use one or more API keys in each organization. Users add the API key to their liquibase.properties or Maven POM.

Changes

  • Added support for hub.liquibase.com to CLI and Maven integrations
  • New registerChangeLog command
  • New syncHub command
  • Added hubApiKey argument
  • Added hubConnectionId argument
  • CLI commands and arguments are now case insensitive
liquibase - v3.10.2

Published by nvoxland about 4 years ago

Liquibase 3.10.2 is a bugfix release

Changes

This release merges many community-contributed pull requests. Thanks to everyone who helps make the Liquibase community strong!

  • Dependency cycle error during generateChangeLog with --diffTypes=tables,columns,data
  • liquibase maven:: unable to run tests on java > 8
  • Add Banner in log out put that directs users to online resources.
  • GH PR#980 - fixed invalid carriage return coming from oracle ojdbc8 12.2.0.1
  • GH PR#976 - Changes databasechangelog sql to use legacy mode
  • Add support for java.sql.Types.TIMESTAMP_WITH_TIMEZONE (CORE-3525)
  • GH PR#929 - Fix #CORE-3493 Inconsistent resolution of ChangeLogParameters in liqu…
  • GH PR#744 - Informix data type generation with Default Value cause
  • GH PR#1176 - Add MariaDB sequence support to the 3.10.x branch
  • GH PR#1177 - CORE-3643: fixed the 'shouldValidateX' methods in the Constraints
  • GH PR#1201 - H2 unknown reserved word
liquibase - v4.0.0

Published by nvoxland over 4 years ago

In this major version release, we are making Liquibase 4.0 available as a stable and production-ready release. This version contains the code previously released in 4.0 Beta and 4.0 Beta 2, as well as code released in 3.x versions, up to 3.10.1.

Improvements and Bugfixes

While Liquibase 4.0 contains code from all previous releases, please see these individual releases for detailed lists of the most recent and consequential improvements and bugfixes:

Package Rankings
Top 1.97% on Repo1.maven.org
Top 8.17% on Proxy.golang.org
Badges
Extracted from project README
Build and Test Quality Gate Status
Related Projects
fluentmigrator

Fluent migrations framework for .NET

01 Apr 2010 3,115
migrator

Super fast and lightweight DB migration & evolution tool written in Go

16 Feb 2016 18
MariaDB4j

MariaDB Embedded in Java JAR

04 Feb 2012 806
yuniql

Free and open source schema versioning and database migration made natively with .NET/6. NEW THIS...

06 Oct 2019 418
liquibase-r2dbc-spring-boot-starter

This repository demonstrates how 2 implement Liquibase R2DBC Spring Boot starter. Stack: Liquibas...

02 Jun 2022 13