org.flywaydb:flyway-database-clickhouse

Breaking changes

• (Preview) the preview verb 'diffApply' has been replaced with the verb 'model'

Bug fixes

• Fix error message when using unpopulated default placeholders with configured seperators

• Fixed an issue where the 'Placeholders' configuration erased the 'jdbcProperties' configuration

• Resolved issue where Flyway would fail to publish an event to Flyway Pipelines using a PAT token in conjunction with using an offline permit for licensing

Changes

• collations will now be dropped on postgres

• MySQL schema history table will create using default storage engine instead of being forced to InnoDB

• addTimestamp boolean option for generate and add verbs has been replaced with timestamp=always|auto|never option

New features

• Scoped Namespaces: when configuring on the command line, you can skip namespaces if they match the verb of which you are in the scope of. For example, rather than flyway init -init.projectName=test you can now shortcut to flyway init -projectName=test.

Thanks to Mihitoko and kantselovich for reporting these issues.

Breaking changes

• Removedcheck.url, check.password and check.username. These undocumented historic fields have been deprecated for a while and have confusing impacts (such as not working in all check functionality). It is recommended to use environments to replace this functionality, alternatively, check does support standard url, username and password

Bug fixes

• Fixed an issue that the Repair command was unable to remove failed Repeatable migration entries in schema history table for MongoDB

Changes

• Backup provisioner now puts database into single user mode before restoring

• Legacy Flyway keys (FL0...) are now deprecated

Java compatibility

• Update H2 2.3.224 to 2.3.232

• Upgrade snowflake-jdbc 3.14.3 to 3.20.0 to fix CVE-2024-43382

Performance improvements

• Improved repair performance when removing failed migrations

Bug fixes

• Fix a bug where error messages are produced when check -drift is run without setting deployedSnapshot

• FLYWAY_PIPELINE_ID environment variable was previously broken but is now fixed

Changes

• The 'createSchema' callback is now deprecated and replaced by 'beforeCreateSchema'

Database compatibility

• Support PostgreSQL 17

Java compatibility

• jetty-server 9.4.53.v20231009 to 9.4.56.v20240826 to fix CVE-2024-8184

Thanks to cowwoc for reporting these issues.

Bug fixes

• Issue 3915 Fixed an issue that could cause Flyway to hang when a database connection is unavailable and there are a large number of pending migrations

Changes

• cleanOnValidationError is now deprecated

Database compatibility

• Updated snowflake driver to 3.14.3

New features

• Flyway now supports setting personal access token (PAT) through API

• Added a warning message if 'group' parameter is enabled for databases which don't support DDL transactions

Thanks to Quairix for reporting these issues.

Bug fixes

• Fixed the bug that prevented powershell scripts from running when located in a folder with spaces in the folder name.

• Fixed the issue where schemas might get inadvertently cleaned when running check in MySQL

Database compatibility

• Cassandra taken out of preview and added to OSS edition

New features

• Azure Identity is now a dependency of Flyway for SQL Server Active Directory MSI authentication

• Flyway now supports Environment Overrides for parameters configuration

Bug fixes

• Fix a bug where mongoDb database name was null

• Removed duplicate libraries from the command line

• Issue with ${flyway:workingDirectory} not using configured working directory has been fixed

• Fixed an issue where failed migrations could report a negative execution time

Changes

• The schema model's location is now also specified in schemaModelLocation in the Flyway namespace in Flyway.toml

Bug fixes

• Fixed bug where certain keywords in BigQuery and HSQL were not handled correctly when in lower case.

• Fix a bug where targetSchemaVersion is not set in API and JSON result objects when migrate fails, or no versioned migrations are applied

• Fix the bug preventing users from initiating a trial using the "auth" command

Database compatibility

• Issue 3900 Increase Cloud Spanner support to 2.18.1

• Issue 3905 Increase H2 support to 2.2.224

Java compatibility

• add file helpers

Thanks to credmond-git and BlueIce for reporting these issues.

Bug fixes

• Flyway shouldn't call SqlFluff if there are no pending migrations found

Changes

• Reworded exception messages when executing scripts fails to say "Script ... failed" instead of "Migration ... failed"

• 'beforeEachMigrateStatement' and 'afterEachMigrateStatement' callbacks are now open source features

• Updated wording on Drift Report

New features

• Personal Access Tokens are now supported as a method of authorizing Flyway

• 'versioned' and 'repeatable' can now be used for 'ignoreMigrationPatterns' in the open-source version.

Breaking changes

• Update ErrorCode and ErrorOutput to allow extending in plugins - The ErrorCode enum is now an interface with the base enum now residing in CoreErrorCode. Any Java usage of this enum will need to be updated accordingly.

Bug fixes

• Add support for stream configuration for ClassPath SQL Migrations

Changes

• Continue to improve the way Flyway honors the workingDirectory parameter

• Remove unrelated warning from polyglot engine.

• Broken up the check page into functional sections and reference & explanation material

• shouldExecuteExpression returned from info output in json format contained expression after placeholder replacement, rather than before placeholder replacement.

New features

• Added an init command which will create a project compatible with Flyway Desktop

• Create flyway.communityDBSupportEnabled to turn off community db support database types if desired

Java compatibility

• Update AWS S3 dependency to fix CVE-2024-29025

• Issue 3860 Remove need for java.desktop

Thanks to axelfontaine for reporting these issues.

Bug fixes

• Issue 3841 Fix issue with PostgreSQL when running in a transaction

Database compatibility

• Removed Oceanbase from Flyway CLI. If required, please download from Maven Central .

Changes

• output from flyway info can return the contents of a shouldExecute condition, if provided

• Issue 3835 Downgrade MariaDB Connect/J from 3.3.2 to 2.7.11 to continue to support latest MariaDB without compatibility issues with MySQL. MariaDB 3.X Connect/J requires for permitMysqlScheme flag in the URL

New features

• Provide Regex rules to replace the SQLFluff rules Flyway_L001 and Flyway_L002

Java compatibility

• Upgrade com.nimbusds:[email protected] to fix CVE-2023-52428

Thanks to bhavneshpateloptum for reporting these issues.

Bug fixes

• Flyway errors running check -dryrun for MongoDB

• Fixed a bug with the Oracle PL/SQL parser which caused certain view definitions containing the 'FORCE' keyword to break.

• Issue 3837 Parameter settings through Environment variables got ignored if combined with command line parameter settings

Changes

• Bump Flyway-Community-DB-Support to 10.7.2

• Update AWS secrets manager JDBC dependency to 2.0.2.

• Flyway matches Oracle SQL*Plus behavior when parsing 'SHOW ERR[ORS]'.

Database compatibility

• Add Community DB Support for Oceanbase

Thanks to jerdaane for reporting these issues.