Features

• The AWS-Secrets JDBC driver included in the Commandline package has been upgraded to 2.0.0.
• Added "END CASE" support in Google BigQuery SQL script.
• Updated newest supported version of Snowflake to 7.33

Fixes

• Keep software.amazon.awssdk:s3 on latest 2.20.X release to get fix for CVE-2023-4586.
• Upgrade software.amazon.awssdk:s3@2.20.94 to software.amazon.awssdk:s3@2.20.158 to fix CWE-295.

Features

• Updated Java 17 JRE included in Flyway CLI.
• Updated CockroachDB support to V22.2.

Fixes

• Now correctly parses Oracle wrapped statements.
• Fixed filter file option detection.
• Fixed invalid flags not correctly erroring at the end of the arguments.

Features

• Code Analysis will now honor 'BaselineVersion' configuration if SchemaHistory table is absent.

Fixes

• Fixed issue with 'check.reportFilename' parameter.

Features

• Added support for Oracle 21c.
• Added support for MariaDB H2 compatibility mode.
• Added support for external browser SSO in Snowflake.
• Upgraded Jackson to 2.15.2.
• check.buildUrl, check.buildUser and check.buildPassword are now deprecated. These will be replaced by check.buildEnvironment in Flyway 10.0.

Features

• Added working directory variable to config.
• When running the SQL*Plus '@' command, Flyway will now also search 'SQLPATH' and 'ORACLE_PATH' for runnable scripts. It will also attempt to load from absolute paths.
• Upgraded H2 to 2.2.220.

Features

• Dropped B Script functionality from teams into OSS.

Fixes

• Fix handling of plugin string array properties.
• Previously, when migrating using Flyway's SQL*Plus feature, Flyway parsed the first statement of the migration script before reading 'login.sql'/'glogin.sql' files. These files are now fully read beforehand.

Features

• Added table feedback for SQL Plus.
• Java compatibility:
  • flyway-core now has a dependency on jackson-dataformat-toml.

Fixes

• Updated Maven Version check to use Maven Metadata to avoid website deprecation issues.
• Java compatibility:
  • Upgraded AWS SDK to fix SNYK issue.
  • Upgraded google-cloud-spanner.
  • Upgraded Google Cloud Secretmanager to 2.22.5.
  • Upgraded Google Cloud Storage to 2.22.5.
  • Updated AWS Java SDK to 2.20.69.

Features

• Added RGCompare for MySQL.
• Now supports the latest version of Microsoft SQL Server 2022.

Fixes

• Fixed incorrect license shown above correct license.
• Fixed parsing of boolean values in configuration.

Fixes

• Fixed missing Jackson-Annotation dependency in CLI bundle.

Fixes

• Improved parsing of CASE expressions inside function bodies.
• Fixed a bug encountered when cleaning Azure Synapse instances where Flyway referred to 'sys.xml_schema_collections` which only exists in SQL Server.

Features

• Flyway's SQLPlus 'FEEDBACK' output wording has been adjusted to match Oracle SQLPlus.
• The SQLite driver shipped with the Flyway CLI has been updated to 3.41.2.2.

Fixes

• Fixed exit code when report is disabled and error occurs.
• Fixed an issue where IF(..) function calls in MySQL functions could cause the statement parser to incorrectly split the function in two.

Features

• Added 'driver()' method to 'FluentConfiguration'.
• Extracted Oracle code to plugin. This will need to be added as a new dependency.
• Changed error code on migration failure to be more specific and include script path and line number of failure in JSON error output.
• Disabled 'GET_LOCK' on MariaDB connections when 'WSRERP=ON' is present. This is to allow for usage of MariaDB with Galera clusters.
• An event connection will now be created to handle callbacks, and this connection will be released instantly after the event handle work is done.
• Baseline scripts with the same version number as an applied '<< Flyway Baseline >>' are now put in the 'Ignored (Baseline)' state. Also, migrations in this state appear before the '<< Flyway Baseline >>' in the info output instead of being put at the end.
• Updated RGCompare version to 1.11.2.9265.

Features

• Now lets you define PostgreSQL functions using 'BEGIN ATOMIC'.
• All undo migrations will no longer have their own rows in the ASCII-table output.
• Baseline migrations now have a 'baseline' category in info output.
• Only warns if reports are unable to write to the default location rather than print an error.

Fixes

• Avoid hanging indefinitely during 'check' comparisons when running on Windows.
• Running 'check -changes' or 'check -drift' now handles schema creation rows in the schema history table.
• Bumped maven version to address an issue.
• Updated documentation to provide solution to Snowflake JDBC JRE16+ issues.

Features

• Added new Info report - You can now get a report of an 'info' call as a tab in a Flyway HTML report.
• Improved support for 'WHENEVER SQLERROR EXIT' in Oracle SQL*Plus. This now works on its own and no longer needs to be followed by 'FAILURE' or 'SQL.SQLCODE'.
• Added new migration report.
• Added new Flyway reports - Single file HTML reports that expose important details and stats about your Flyway pipeline in an easy to read and share format.
• Undo migrations which have not been applied will no longer cause validation to fail.
• Added direct support for Alpine Linux.
• Removed unused Edition flags documentation, e.g. '-community' or '-teams'. These flags are no longer used by Flyway and have been marked for deprecation. These flags will be removed in V10.
• Ensured Flyway uses ALL_CREDENTIALS when using versions of Oracle where ALL_SCHEDULER_CREDENTIALS is deprecated. This is to avoid continuing to rely on functionality only retained in Oracle for backwards compatibility.
• Removed redundant 'HTML' extension on automatically generated reports and prevented generation of reports for currently unsupported verbs.
• Updated version of snowflake-jdbc to 3.13.29.
• Bumped Snowflake JDBC to 3.13.30.
• Bumped SQLite JDBC to 3.41.2.1.
• Bumped MariaDB JDBC to 2.7.9.

Fixes

• Fixed the issue causing empty dry run reports when running flyway using the Maven plugin.
• The Snowflake SQL parser can now handle escaping single quotes inside strings using backslash.

Fixes

• Removed placeholder text from report summary.
• Fix Nullpointer exception on empty exception in reports.

Features

• Updated Postgres password change regex to use latest form.
• Updated msal4j.
• Reduced allocations from class loading through FeatureDetector.

Fixes

• Removed unwanted SLF4J messages on stderr.
• EnvironmentModel: swap back connectRetries and connectRetriesInterval default values.

Features

• Drift report titles have been renamed from 'Before' and 'After' to 'Expected' and 'Actual'.
• Updated `flyway-bom` to use correct versioning system and deploy to Maven Central.

Fixes

• Fixed reading in configuration from standard input in Teams and Enterprise edition.
• Fixed a parsing error caused by begin transaction statements in Snowflake.

Features

• When running 'check' commands with involve database comparison (i.e. '-drift' and '-changes') and Flyway has debug enabled, debug output from the Redgate Compare engine will now be logged as well.

Fixes

• SQL errors with configured overrides no longer cause the Oracle SQLPlus spool output to close prematurely and lead to a null pointer exception.
• Further improvements to the Snowflake parser when detecting conditionally creatable objects.
• Updated Ant dependency version to address a few vulnerabilities.

Features

• If Flyway encounters a SQL exception while Oracle Spool is set, the error information is now written to the Spool output.

Fixes

• Allow the Snowflake parser to handle more conditionally creatable objects.

Features

• Added a flyway-bom pom for Maven. This BOM includes all modules of Flyway which are compatible with each other to be used in Maven dependency management.
• When Flyway is running in Oracle SQLPlus mode, character escaping is now disabled by default in order to be consistent with Oracle's SQLPlus command-line tool.

Fixes

• Fixed a bug where migration patterns display names incorrectly changed case depending on default locale.

Features

• Database compatibility
  • Updated latest supported MariaDB version to 10.10.
  • Added support for Snowflake versions up to 7.1.
• New features
  • Added 'NON_EMPTY_SCHEMA_WITHOUT_SCHEMA_HISTORY_TABLE' as a new error code.
• Java compatibility
  • Redgate are introducing Multi-Release builds for Flyway which will support Java 8 and Java 17. This allows access to modern Java practices and technologies. This is with the aim to move fully to Java 17 in the next major release.

Fixes

• Fixed issues with the Snowflake SQL parser which failed to correctly parse scripting blocks containing 'if' and 'for' statements.
• Fixed issue with code analysis reports not generating when major or minor tolerance threshold has been passed and set build to fail.

Features

• Regex Rule code analysis results now include the line and column number of where violations occurred.
• 'check' reports now produce all successful reports and fail on the first non-successful report.
• Updated RGCompare engine to 1.6.0.7325.

Fixes

• Explicitly drop Oracle package bodies so that package bodies not tied to an existing package are also cleaned.

Features

• Version operations (`version` or `-v` or `--version`) will now list the versions of all plugins (and if they are correctly licensed).
• Updated AWS dependency.

Fixes

• Resolved migration resolvers not fully supporting instances for API users.

Features

• Updated RG Compare to 1.3.1.7159.

Fixes

• Flyway includes a custom SQL Fluff plugin, containing extra rules for enterprise users. Previously, if this custom plugin failed to install it would fail the whole process citing an absence of the correct SQL Fluff installation. It now only gives a warning so core SQL Fluff rules can still be run.
• Incorrectly errored when validating the configuration for the 'check -changes' command, when using a URL and a snapshot.
• Config parameter `flyway.executeInTransaction` should now correctly set when doing so via an environment variable.
• Fix missing `setBaselineVersion(MigrationVersion baselineVersion)` on ClassicConfiguration.

Features

• Added a new configuration parameter ('flyway.executeInTransaction') which determines whether SQL execution in a transaction is enabled.

Fixes

• Fix NPE that results when configuring either 'workingDirectory' or 'jarDirs'.

Features

• Support for BigQuery is now out of beta and in GA.
• The version of the Postgres driver included in the CLI has been increased to 42.4.3.
• Updated error message for invalid CLI argument to reflect possible fixes.
• The bundled Regex Rules are now case insensitive.

Fixes

• Removed the parsing of nested multiline comments from Oracle. This is in line with their documentation that states nested multiline comments are not supported.
• Drift results now appear in the JSON and HTML reports when 'failOnDrift' is set and drift is present.
• Fix documentation to use correct method to configure url, user and password in API.

Fixes

• The version of RG compare included with Flyway has been increased to 1.2.2.6628. This avoids a bug in which 'check' produced empty change/drift reports for certain SQL Server URLs.
• Upgrade the version of the Apache Ignite core dependency to avoid a new vulnerability.

Features

• Check reports are now written when an exception occurs.

Fixes

• Fix issue with Regex Rules looking in the wrong directory by default.
• Fixed parsing error with batch statements in GCP Spanner.

Features

• The JSON result for the 'check' command now includes the paths to any generated report.
• SingleStoreDB JDBC driver is now shipped in the CLI.
• Flyway now allows a configuration ('flyway.check.failOnDrift') to trigger an error if drift is detected with `check -drift` allowing the build to be halted should drift exist.
• Added SingleStoreDB support at the Teams level.
• Cockroach DB is now supported up to the latest version of 22.1.
• 'jackson-dataformat-toml' is now used to read TOML config files, instead of 'night-config'.
• All 'check' results now include the operation in the JSON result.
• The code analysis engine's name is now included in the summary logs.
• Bumped the version of Redgate Compare to 1.0.0.6319.
• Moved documentation to main repo.
• Created a Dialect configuration to allow configuration of rules engine dialect via Flyway.
• Added descriptions to shipped Regex Rules in the check report.
• Bundled Regex Rules are now enabled by default.
• The version of 'jackson-dataformat' bundled in the CLI package has been bumped to 2.14.0.
• Breaking changes - Logic for the undo command has been moved into the separate 'flyway-proprietary' module, which will need to be present on the classpath in order to use the undo command. This also means that undo migrations will now be resolved in Community edition, and migrations may be marked as undone in the info output, though running the undo migrations still requires a Teams or Enterprise license. Lastly, when implementing undo migrations as java migrations, they should extend 'UndoJavaMigration' instead of 'BaseJavaMigration'.

Fixes

• Fixed an issue where 'clean.mode' would not be detected in Enterprise.

Features

• Added bundled Code Analasys RegEx rules for Enterprise tiers.
• Added a new rule to the Flyway SQL Fluff plugin, which is applied when running code analysis. This rule checks that all tables created in TSQL have an 'MS_Description' extended property set in the same file.
• Added REGEX rules engine to `-code` for Enterprise tier.
• Rule codes are now visible in Code Analysis HTML Reports.
• Updated version of MSAL4J.
• Updated AWS SecretsManager.

Fixes

• Help output for 'check' no longer returns 'null' when 'outputType=json'.
• Fix Snowflake parser to handle nested 'BEGIN...END' statements.

Features

• Added an Apple Mac CLI for ARM64 CPUs.
• Added error override behavior which excludes the full error/warning message and only shows the SQL state and error code.
• Moved SQLFluff specific components into own module.
• Increased hsqldb version from 2.6.1 to 2.7.1.
• PostgreSQL history table indexes and constraints now use the configured tablespace.
• Dropped PostgreSQL DOMAINs with 'CASCADE'.

Features

• Removed in-product warnings when using PostgreSQL 15.

Features

• Added custom code analysis rule that requires tables to have a primary key.
• Added syntax highlighting to dry run reports.
• Replaced SQLPlus placeholders that begin with a double '&'.
• Added support for PostgreSQL 15.
• Ensured correct version of SQL Fluff is installed.
• Updated version of 'commons-text'.
• Added edition to the version model.
• When urls are unsupported by check, ascertain which ones are unsupported, and include them as part of the exception.

Features

• Added support for Microsoft SQL Server 2022.
• Added a configuration to allow flyway to fail when sqlfluff finds issues when running `check code`.
• Code analysis is now available in Community Edition.

Fixes

• Fixed cases of 'cherryPick' causing issues with change and drift reports.
• Fixed bug where 'installedBy' wasn't always populated during a baseline.
• Fixed bug when checking for changes or drift when multiple schemas are configured.

Features

• Closed the Teams preview access to Change and Drift report.

Fixes

• Fixed issues with Community Fallback.
• Fixed Windows paths with spaces causing classpath issues.

Features

• Added Community fallback warning to JSON output object.
• Now shows correct validation message when checking for license keys that have expired

Features

• Schemas are now created if the user has edited flyway.schemas after an initial migration.

Fixes

• Fixed issue with Flyway not running correctly on Macs with a path that has a space.
• Added null-check to avoid NPE when scanning inaccessible locations.
• Fixed bug in 'check' when comparing non-Oracle databases with configured schemas.
• Dropped MariaDB JDBC driver back to major version 2 to enable MySQL compatibility.

Features

• Check Report UI improvements.
• Change and drift reports now fail for incompatible database types.
• Updated to support Snowflake 6 and Snowflake scripting.
• Java compatibility:
  • Remove JNA dependency as no longer needed by MariaDB.
  • Increase MariaDB driver version to 3.0.7.
  • Move 'flyway-commandline' runtime dependency to correct scope.

Features

• Improved the 'check' report.
• Removed the error information from 'CompareResult' so that the existing JSON error handling is used.
• Java compatibility:
  • Removed unnecessary dependencies.
  • Moved Undo command into flyway-proprietary.
  • Removed unnecessary maven-model dependency.
  • Made 'CompositeResult' generic.
  • Transitive GAX dependency is now included in CLI.

Fixes

• Fixed problems when appending to code analysis reports.
• Fixed bug in 'check -code' where multiple SQL files were not being correctly linted.
• Configured suffixes are now case insensitive.

Features

• Code analysis now auto detects the dialect if a URL is provided, otherwise a '.sqlfluff' configuration file is needed.

Fixes

• connectRetriesInterval now defaults to 120 instead of 0 on the Maven plugin.

Features

• Added SQLFluff to Redgate/Flyway Docker image for use with new integrations.

Features

• Added 'dryrun' to check as a report that can be generated.
• Updated dependencies to fix vulnerabilities.

Features

• Added access to Community features for Teams and Enterprise artifacts when no license key is given.
• PostgreSQL session locks now use one connection.
• Added support for H2 2.1.214.

Features

• Added support for PgBouncer transaction pooling - You can now use transactional locks in PostgreSQL by default, which enables support for PgBouncer (session locks can be enabled again by setting 'flyway.postgresql.transactional.lock=false').
• Updated bundled JRE to latest version of Java 11 to include security updates.

Fixes

• Check includes all transitive dependencies so it runs out of the box.
• BigQuery procedures containing `END AS` are not cut off early.
• Update ensured support to latest documented versions for Oracle and Snowflake.

Fixes

• Change reports now HTML encode SQL.

Features

• Improved tab styling of check reports.

Fixes

• Change reports now HTML encode SQL.
• JSON output for 'drift' now always shows the 'driftDetected' field.

Features

• Multiple 'check' reports now appear as tabs.
• Added the ability to serialize the 'LocalDateTime' field (in check JSON results) as a string.
• No longer includes '.html' when generating JSON results for a report.
• bash entrypoint now adds 'native' folder to library path for use on Microsoft Windows.
• Now only prints the version information in Flyway once per execution.
• No longer displays the underlying 'DELETE' rows during 'info'.
• License check now occurs when a Flyway object is constructed.

Fixes

• Fixed cases where validation fails saying checksums of '0' are now 'null'.

Features

• Added '-migrationIds' flag to 'info' in order to get a comma-separated list of versions or descriptions for repeatables.
• Added the 'check' command to the Flyway CLI (command line interface) for generating deployment reports.
• Changes:
  • Info filter 'infoOfState' now allows multiple states as a comma-separated list.
  • You can now handle errors (with warning) when cleaning procs on Snowflake.
  • 'flyway/flyway-azure' Docker images are now deprecated and have been replaced with 'flyway/flyway:*-azure'.
• Database compatibility:
  • H2 1.4 is now in Teams.
  • Oracle 12.2 is now in Teams.
  • MariaDB 10.2 is now in Teams.
  • HSQLDB 2.4 is now in Teams.
  • Flyway CLI now bundles version 2.6.1 of the HSQLDB driver.
• Breaking changes:
  • Migration patterns that are version numbers are now treated as numbers rather than strings when matching to migrations.
  • Script and Java migrations are no longer executed during a dry run.
  • 'getResolvedMigration' method on Java Migrations interface now takes a StatementInterceptor.
  • Don't clear the Url/Pass/Username when setting a data source.
  • Changed default of cleanDisabled to true.
  • Removed deprecated parameters for configuring secrets managers.
  • Removed parameter 'oracleKerberosConfigFile' as it has been replaced by 'kerberosConfigFile'.
  • Removed parameters 'ignorePendingMigrations', 'ignoreMissingMigrations', 'ignoreIgnoredMigrations' and 'ignoreFutureMigrations' as they have been replaced by 'ignoreMigrationPatterns'.
  • 'MigrationType' have been moved into 'extensibility' package as an enum and replaced with 'CoreMigrationType'.
  • 'SQL__BASELINE' and 'JDBC__BASELINE' migration types have been removed from 'flyway-core'.
  • 'CoreMigrationType' enum field 'baselineMigration' is now called 'baseline', for which the type 'BASELINE' now returns true.
  • 'baselineMigrationPrefix' has been removed from Configuration.
  • You now need to use 'BaselineJavaMigration' from the 'flyway-proprietary' package to make Java-based Baseline Migrations.
  • Removed 'isUndo' and 'isBaselineMigration' from 'ResolvedMigration'.
  • 'Context' in 'resolveMigrations' on a 'MigrationResolver' is now a class which also has 'ResourceProvider', 'SqlScriptFactory' and 'SqlScriptExecutorFactory'.