org.flywaydb:flyway-reports

Bug fixes

• Fixed an issue where the TLS auto-configuration failed to recognize a supported object type in the client PEM file

• flyway will raise an error if a provisioner is requested to be used when dry run is set

• The PostgreSQL parser now supports CASE statements within a BEGIN ATOMIC statement

Changes

• Deprecate detectUserByUrl and detectPasswordByUrl methods from the DatabaseType API

Database compatibility

• Issue 4055 Add support for STREAMLIT objects to Snowflake parser

New features

• Native Connectors now supports the afterConnect callback. This will function similarly to initSql which this will be replacing

Library upgrades

• Upgraded RgCompare.Cli from 1.30.2.26351 to 1.30.2.26414

• Upgraded sqlfluff from 3.3.1 to 3.4.0

Thanks to andreir229 for reporting these issues.

Bug fixes

• MongoDB Native Connectors can now use the database from the url instead of the default test database

New features

• Issue 4033: Add support for the AWS Wrapper with PostgreSQL

Library upgrades

• Upgraded RgCompare.Cli from 1.30.2.26299 to 1.30.2.26351

• Update databricks-jdbc to 2.7.1

• Update jetty-server to 9.4.57.v20241219 to fix CVE-2024-6763

Thanks to heikkis, swarna7602, lambdaupb, and oimo23 for reporting these issues.

Changes

• Native Connectors for Oracle now supports clean

• Added new error code FAILED_BASELINE_MIGRATION to convey failure when migration a baseline

Library upgrades

• Upgraded RgCompare.Cli from 1.30.2.26158 to 1.30.2.26299

• Upgraded azure-identity 1.14.2 -> 1.15.4

• Upgraded msal4j 1.15.1 -> 1.20.0

New features

• Flyway now supports Native Connectors mode for Oracle Database

Bug fixes

• Fixed an issue where diff comparisons of empty schema models to empty would use the SqlServer comparison engine

• Fixed an issue where the MongoDB connection string's 'authSource' parameter was not being correctly applied

• Fixed an issue where performing a dry run on non-Native Connectors databases triggered a misleading Native Connector warning message

Library upgrades

• Upgraded RgCompare.Cli from 1.30.2.26104 to 1.30.2.26158

Changes

• The shape of the JSON object during an error has changed to include 'sqlState' and 'sqlErrorCode' for conveying the SQL state and error code from a database-level exception

Library upgrades

• Upgraded RgCompare.Cli from 1.30.1.26056 to 1.30.2.26104

Changes

• If Mongosh is available, Flyway Redgate Edition will default to using the Native Connectors Mode for MongoDB

Library upgrades

• Upgraded RgCompare.Cli from 1.30.0.26008 to 1.30.1.26056

Bug fixes

• Rule and configuration TOML files now support a BOM character at the start of the file

New features

• Added support for change reports to projects deploying from a Schema model. This can be enabled by setting '-check.changesSource=schemaModel' when running 'check -changes'

• (preview) add support for migration tags. Tags can be used to cherry pick groups of migrations.

Java compatibility

• Update Snowflake to 3.23.1 to fix CVE-2025-27496

Library upgrades

• Upgraded RgCompare.Cli from 1.29.0.25860 to 1.30.0.25967

Bug fixes

• Fixed an issue where Flyway would fail to fall back to 'flywayDesktop.schemaModel' during 'diff'

• Issue 4039 Fix OpenTelemetry dependencies not being shipped with GCP Spanner in open source

Changes

• Renamed error codes returned for database comparison errors

Java compatibility

• Issue 4039 Update OpenTelemetry dependencies to 1.42.1

Thanks to tomwinget for reporting these issues.

Bug fixes

• Fixed an issue where Flyway incorrectly examined an unused permit on disk and gave a misleading warning message

• fixed an issue where check filterFile was not being used for check actions

New features

• shouldExecute expressions are validated before being evaluated

Bug fixes

• Fixed missing Oracle Wallet dependencies after upgrading to ojdbc11

• fixed an issue where clean, backup and snapshot provisioners would not use configured properties from the flyway namespace. This fixes an issue where script callbacks would not be called for the subset of flyway operations directly caused by these provisioners running.

• Fixes issue where specifying an empty cherry pick list to the diff build database property would be treated as if cherry pick was not specified. This fixes an issue seen in the check reports when deploying to an empty target for the first time.

Changes

• Nested resolver definitions are disallowed and will result in an error

New features

• Flyway Enterprise now automatically configures 'javax.net.ssl.keyStore' and 'javax.net.ssl.trustStore' for MongoDB TLS connections in Native Connectors mode

• Added user defined placeholder resolver

Bug fixes

• Fixed an issue with the reports where previous reports before the current report displayed invalid results

• Issue 3771 Fixed an issue where the Flyway 'configuration' API returned Configuration objects with shared references instead of deep copies

Changes

• The deploy command will now succeed with a warning if the deployment script does not exist, allowing for smoother chaining with the prepare command.

Database compatibility

• CosmosDB added

• AWS DocumentDB added

New features

• Native Connectors now supports transactions for MongoDB with .json migrations

Java compatibility

• Update Cassandra JDBC Wrapper to 4.13

• Update AWS S3 SDK to 2.30.18

• Update Netty Common and Netty Handler to 4.1.118.Final to fix CVE-2025-25193 and CVE-2025-24970

Thanks to KarolRoman for reporting these issues.

Java compatibility

• Upgrade snowflake-jdbc 3.20.0 to 3.22.0 to fix CVE-2025-24790

Changes

• Converted FlywayTelemetryManager to use the plugin interface

Database compatibility

• Add Community DB Support for Timeplus and DuckDB

New features

• Flyway now supports certain Callbacks with Native Connectors

Java compatibility

• Updated the ojdbc8 driver to ojdbc11 21.1

Breaking changes

• Removed ARM V7 support from docker images

Bug fixes

• check changes will not require a target url/environment when provided with snapshots

• Converting .conf files to toml using flyway init now preserves conf defaults

• Fixed issue where converting a .conf file to toml in place via flyway init might not rename the original .conf file to .conf.bak

• Native connectors respects set schema for Mongodb using Mongosh

• Fixed an issue where callbacks were incorrectly loaded as migrations when Native Connectors mode was enabled

• check no longer fails for SQLServer with the error: "Database passed into LiveSQLProvider needs to have DbConnectionInstructions"

Changes

• check changes will now prefer using a given deployment snapshot over the live environment. In cases where drift appears in the live environment, this will mean that drift will now be excluded from the change report when possible.

• the default filter file created upon SqlServer project initialization now ignores certificates

• Issue 4010 Snowflake now supports COMMENT IF EXISTS

Database compatibility

• Update databricks to 10.16.4

• Issue 4005 Update Databricks JDBC driver to 2.6.40

New features

• placeholders support in Native Connectors

• Include ARM 64 in the Alpine docker image

Java compatibility

• Updated Java version shipped with Docker and CLI to 21

Thanks to nicolashenry and mlorek for reporting these issues.

Bug fixes

• the shouldExecuteExpression field now displays the expression correctly in the JSON output of the info command

• Fixed an issue where 'deploy' could fail due to null results despite having executed correctly

Changes

• Native Connectors now supports validateMigrationNaming

• Issue 3986 ship library org-reactive-streams

Thanks to ExtraClock for reporting these issues.

Breaking changes

• Upgraded to .NET 9. Existing workflows that do not depend on .NET should not need to change

Changes

• Improve error output of un-parsable TOML configuration to display line and point of failure

• Issue 3438 Snowflake will only drop USER PROCEDURES instead of all PROCEDURES

• Issue 3601 Snowflake will now drop stages when running clean

Database compatibility

• Native connectors for MongoDB released and enabled in OSS edition - Native connectors blog post

Thanks to iapethus and vgw-chriskruger for reporting these issues.

Changes

• Issue 3432 Increase block depth for WHILE, LOOP and REPEAT keywords in HSQLDB

• Issue 3986 Update azure-identity to 1.14.2

Thanks to wangbfqq and ExtraClock for reporting these issues.

Breaking changes

• Stop deploying to deprecated org.flywaydb.enterprise group ID on the Redgate Maven Repository . Please use com.redgate.flyway

• cleanOnValidationError function and configuration has been removed. An error will be thrown if this feature is configured

• Flyway will no longer provide an interactive method to input database usernames and passwords. Please use other configuration or URL methods

• Environments used with the 'check' command must have a provisioner defined or the '-cleanDisabled=false' parameter must instead be specified when running the check command. Please see here for more information.

New features

• The prepare and deploy flyway commands have been added, enabling a state-based deployment directly from a schema model or another database

• The following flyway commands are now out of preview: 'add', 'diff', 'model', 'diffText' and 'generate'

• Issue 3970 Add AWS Advanced MySQL wrapper support

Thanks to seungdangdang for reporting these issues.

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

• Remove erroneous Guava import

• Fixed an issue where Flyway incorrectly displayed a warning about missing locations, even when locations were properly configured per environment

New features

• Enable out of process change detection for all license tiers when publishing results to Flyway Service

• Drift results are now sent to Flyway Service when the service is enabled

Thanks to gsmet and tdg5 for reporting these issues.

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.

Breaking changes

• Extracted FlywayMigrateException to its own class

Database compatibility

• Add support for DB2 ZOS

• DB2 and Redshift now support AWS Secrets Manager

New features

• The following flyway commands are now available in preview: add, diff, diffApply, diffText and generate.

Java compatibility

• Upgrade google-cloud-spanner-jdbc 2.18.1 to 2.22.1 to fix CVE-2024-7254

• Upgrade google-cloud-secretmanager 2.20.0 to 2.51.0 to fix CVE-2024-7254

• Upgrade google-cloud-storage version 2.22.5 to 2.43.1 to fix CVE-2024-7254

Bug fixes

• Resolved cascading failure when reporting results to Flyway Pipelines

• Fix issue with createStatement override not being used in DB2 Z/OS

Bug fixes

• Fixed the issue that 'Check' command should throw an Exception if current environment and build environment are the same

• Issue 3812 Fixed the bug that Flyway failed to load Callbacks which are configured as a 'classpath'

• Issue 3812 Fixed the bug that Flyway failed to load Callbacks from default path 'db/callback'

Java compatibility

• Update Parser createStatement method signature

• Retire usage of https://nexus.flywaydb.org

Thanks to liununu 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

• Add NOLOCK to SQL Server query to reduce blocking

• Fix result publishing when chaining commands

• Issue 3947 skipExecutingMigrations now works for OSS

Thanks to catostrophe for reporting these issues.

Bug fixes

• Fixed the issue that Flyway errors when running 'check -code' with 'classpath' locations

• Fixed the issue where the classpath could not be resolved when running the 'check' command

Bug fixes

• Fixed the issue that Repeatables apply placeholders when calculating checksum even when 'placeholderReplacement' is set to false in script config file

• Fixed the issue where setting placeholderReplacement to true in the script configuration had no effect when it was false in the global configuration.

• Issue 3934 Fix org.flywaydb:flyway-database-cassandra artifact on Maven Central

Changes

• Script migration is now available as an open source feature of Flyway

New features

• Support Environment Overrides for the 'jarDirs' parameter

• Add suggestions for incorrect configurations within the Flyway namespace

Java compatibility

• Move report function and assets to their own module

Thanks to janhicken for reporting these issues.