org.flywaydb:flyway-database-mongodb

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

Java compatibility

• Bump SQLServer JDBC to 12.6.3 to fix breaking change with MSAL4j 1.15.1

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 no longer makes repeated calls to the same Vault secret. This allows using dynamic roles from the Vault database engine.

Changes

• Flyway will not auto-install SQLFluff 1.2.1 for Enterprise customers when running code analysis

• The 'Rules Location' parameter of Flyway Check command will now honor 'workingDirectory' configuration

Bug fixes

• Flyway should only send qualified migration files to code analysis when no url is configured rather than all the '.sql' files

Changes

• Improve the code analysis major/minor rule violation error output

• the default Code Analysis Rule RX001 won't require the 'drop table' statement to appear at the start of a SQL statement

• Updated wording on Drift Report

• Flyway won't print out the whole sql statement responsible for a migration failure unless debug mode enabled

• If Cherry Pick is configured in OSS or Community Edition, Flyway will give 'upgrade required' prompt

Database compatibility

• Added support for Databricks in Flyway - thanks to the community for the contribution

New features

• add outputProgress support to legacy (conf) projects

Java compatibility

• Use Temurin 17.0.11+9 JRE for Flyway Command Line

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.

Bug fixes

• Issue 3866 set System Properties as String rather than Boolean

Changes

• Update license header plugin

• When running the SQL*Plus '@' command, Flyway will honor 'workingDirectory' configuration when looking for runnable scripts

Thanks to BusyByte for reporting these issues.

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.

Changes

• Improve the way Flyway honors the workingDirectory parameter

• Flyway OSS won't throw any exception for unknown parameters if the TOML contains non-flyway namespaces.

Bug fixes

• Fix issue with MySQL not falling back to MariaDB driver when official driver is unavailable

• Fix duplicate migration pattern error when running 'check -drift' or 'check -changes' on a database with multiple schema creation rows.

Bug fixes

• Fixing issue where placeholders are not merged properly when using TOML configuration files.

Changes

• Update Flyway-Community-DB-Support version to 10.8.0

Database compatibility

• Reintroduce OceanBase

• Cassandra support added as a preview feature in Redgate edition.

Java compatibility

• Update Mongo JDBC driver to 1.19

• Update postgres to 42.7.2 for CVE-2024-1597

• Increase dependency software.amazon.awssdk:s3 to 2.21.46 to fix CVE-2023-44487

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:nimbus-jose-jwt@9.37.2 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.

Breaking changes

• The Flyway Commandline package no longer includes dependencies for Apache Derby. This is due to CVE-2022-46337. Apache have not released Java-17 compatible jars with the vulnerability fixed, so users will have to acquire their own Derby dependencies. See Flyway Derby database support for details

• Due to a change in the latest version of the MariaDB driver, MySQL users will either have to set 'permitMysqlScheme=true' in their connection string or download the MySQL driver. See here for more details.

Bug fixes

• Fix to filter on Cloud Spanner table schema name when selecting all foreign key constraints. This is to make sure that no system constraints are included in the results if they were to be added in the future. Additionally if Cloud Spanner starts supporting named user schemas, the listed foreign keys are consistent with the tables that are used, which are all filtered based on an empty schema name.

• Fixed issues caused by dollar signs and backslashes in property resolver values.

• Fix configuring JDBC Properties in command line environment configuration

Changes

• Improved formatting of Dry Run report.

• The configFiles parameter respects interpreting your configuration in the appropriate format

• Make Flyway "Output Query Results" an open source feature

Database compatibility

• Added support for Clickhouse in Flyway - thanks to the community for the contribution

• To help increase Flyway's community contribution support, flyway-community-db-support/ has been moved to separate repository: flyway/flyway-community-db-support . Any new PRs for database support additions need to be raised there and any existing PRs in flyway/flyway will need to be transferred by the author.

• Issue 3821 Flyway now supports Snowflake up to version 8.3.

• Issue 3822 Increase MariaDB JDBC driver to version 3.3.2 and add support for MariaDB 11.2

New features

• If Working Directory is set, Flyway will now use that location to check for default Flyway configuration files in addition to its previous functionality. See updated documentation for more information on default command line configuration order.

• allow onEachMigrateOrUndoStatementEvent callback to block statement execution

Thanks to EugenMayer and frichtarik for reporting these issues.

Bug fixes

• Resolve RedgateCompare toml being read incorrectly.

Changes

• Improved auth logging to be more concise

• Make Flyway "Target" an open source feature

• Make Flyway Detect Encoding an open source feature

• Make Flyway Batch an open source feature

• Make Flyway Stream an open source feature

Java compatibility

• Adding API friendly method to getEngines

New features

• adding support to configure environments via command line

New features

• Allow build environments to be processed by resolvers

Bug fixes

• Use instance variable of defaultProperties in DriverDataSource constructor instead of parameter variable

Database compatibility

• Add additional connection attributes when connecting to SingleStore

Thanks to AdalbertMemSQL for reporting these issues.

Breaking changes

• The clean command will also drop services and queues in SQL Server.

Bug fixes

• Correct redgate-compare options when using TOML with check and drift or changes.

• Fixed reports not displaying Teams and Enterprise level features

Database compatibility

• Issue 3806 Correct HSQLDB support message and increase driver support to 2.7.2

Thanks to ashtonbatty for reporting these issues.

Bug fixes

• Fix parsing of boolean comparison options

• Fixed a bug where comma-separated lists for configuration parameters passed in via command line would fail with a parsing error

Changes

• Update document on setting environment parameter through environment variable

• Upgrade version of Maven dependencies used by the Flyway Maven plugin to 3.9.6.

• Make datasource in classic config environment aware

• Improve error message for misconfigured environment variables in TOML config.

• Issue 3797 Use latest version of Apache Derby dependencies to avoid CVE-2022-46337.

Database compatibility

• Added support for cleaning table snapshots and table clones in Google BigQuery.

New features

• Can now start a trial with the auth command

• add supported-databases command.

Java compatibility

• Move flyway-sqlserver into flyway-database folder space

Thanks to fage88 for reporting these issues.

Bug fixes

• Correct urls for fetching offline permits

• Fix dropping views from GCP Spanner when running clean.

• Add new groupId to flyway-gradle-plugin

• Issue 3793 Fix index out of bounds issue in ConfigUtils

Database compatibility

• Flyway now supports PostgreSQL version 16.

• MongoDB 7.0 support available. Currently shipped as preview in Redgate edition CLI.

Breaking changes

• Updated to use dotnet 8 which drops support for RHEL 7 - this only impacts the check verb (drift and changes)

New features

• Flyway now uses Schema History Table locking to allow parallel migrations in Google Cloud Spanner.

Thanks to AlejandroYuste for reporting these issues.