Features

• Added the ability to configure which logger to use.
• Added 'connectionRetriesInterval' property to set customizable connection retry interval (Default: 2 minutes).

Fixes

• Fixed issue with CockroachDB delete lock statement timestamp not updating.

Fixes

• Fixed unlocking bug in PostgreSQL.
• Adding FUNCTION to the list of special cases for IF EXISTS in HSQL.
• Fixed various parsing issues in BigQuery.
• Detecting abstract Java callback classes no longer cause Flyway to fail.
• Simplify MySQL query to fix compatibility with third party tool Vitess.

Features

• Added support for placeholders in arbitrary script migrations.

Fixes

• Fixed cases of CLI hanging when no credentials are provided.
• Resolved a nesting issue with BigQuery parsing.

Features

• Added support for State Scripts - a single, cumulative script that represents the state of your database after many migrations have been applied.
• Certified on Percona XtraDb 8.
• Updated support for Oracle wallet.

Fixes

• Fixed casing in Azure Synapse queries.

Features

• DatabaseTypeRegister and VersionPrinter always use their class' classloader.
• Added support for -target=next.

Features

• Added Java API extension that allow you to read the configuration from Vault.
• Added VaultConfiguration object for configuring Vault in Maven and Gradle Plugins.
• Released Vault integration to Maven as a separate artifact.

Fixes

• Fixed resolving resources with the same name in multiple classpath locations.
• Simplified migration sorting to fix 'Comparison method violates its general contract'.

Fixes

• Fixed execution of migrations without a transaction over a single connection.
• Fixed Gradle location configuration override order.
• Fixed deadlock due to exhausted connections when creating result objects.

Features

• Verified support for PostgreSQL 14.

Fixes

• Bump GCP Spanner JDBC version to fix CVE.

Features

• Included the community DB support package in the CLI.
• Added support for YugabyteDB (community).

Fixes

• Fix in-product links that contain a reference.
• Bump GCP Spanner JDBC version to fix CVE.

Features

• Updated Maven version to 3.8.1.
• You can now override vulnerable Jackson versions.
• Made PostgreSQL database classes extendable.

Fixes

• Fail faster when checking for updates.

Features

• You can now enable Flyway Teams for 28 days for new schemas in CLI.
• Removed the need to specify -teams in CLI.
• Made GCP Spanner and BigQuery beta publicly available.
• Added Cockroach v21.1 support.
• Added community-level TiDB support.
• Verified support for HSQLDB 2.6.

Fixes

• Fix interleaved repeatable migrations running indefinitely.
• Ensure that (g)login.sql doesn't fail name validation in SQL*Plus.
• Fix copyright symbol for better platform compatibility.
• Bump MSAL4J to fix transitive dependency CVE.

Features

• Added flyway:table placeholder
• Added Cockroach v21.1 support.
• Closed beta signup for Google Cloud Platform (Cloud Spanner & Big Query).

Fixes

• Fixed issue where Flyway no longer prompts for credentials.

Fixes

• Use an instance of DatabaseTypeRegister when getting the ClassLoader.
• Fix connecting to Snowflake with role which has special characters.
• Fix handling of PL/SQL / "slash" delimiters that are not in first column.
• Clean schemas before dropping them.

Fixes

• Use the ClassLoader specified to Flyway when using the ServiceLoader.
• Oracle - Fix parsing of GOTO statements.
• Inline method to fix compatibility with GraalVM.
• Clean schemas before dropping them.

Features

• Added failOnMissingLocations parameter.
• Added the ability to allow targets that don't exist with '?'.
• Added Flyway update checking in command line.
• Added support for auto detecting file encoding for SQL migrations.
• Added Spanner Beta support.
• Updated MySQL driver version.
• Updated S3 dependency to fix vulnerabilities in transitive dependencies.
• Added the ability to detect Hikari pooled connections automatically when using Oracle proxy users.
• 'n rows affected' is now debug level in logs.

Fixes

• Fixed parsing of Oracle ACCESSIBLE BY.
• Clean all SQLServer objects in a 2-pass approach.

Features

• Added support for Oracle proxy users when using Hikari pooled connections.
• Added GNU-standard command line help options.

Fixes

• Fixed MySQL parsing nested blocks with labels.
• Only show warning about missing default schema when relevant.
• Fixed issue with comparator resulting (rarely) in failure during sorting migrations.

Fixes

• Log 0 rows affected at the debug level.

Features

• Added ignoreMigrationPatterns parameter to customize validate.
• Added support for Oracle proxy user connections.

Fixes

• Log 0 rows affected at the debug level.
• SQLServer: Don't accidentally parse identifiers in square brackets as key words.

Features

• Added the ability to allow PROXY_USER_NAME in JDBC properties to create proxy connections to Oracle databases" %}.

Fixes

• Fixed parsing DISTRIBUTED TRANSACTION in SQL Server.

Features

• Updated MSSQL JDBC driver to allow for interactive authentication.
• Updated MariaDB support to 10.5.
• Updated dependencies.
• Added the ability to use the new MariaDB parser.
• You can now ship MSAL4J dependencies for AAD auth.
• Updated GCS dependency.
• Updated DB2 driver.
• Updated log4j dependency.
• Updated Amazon SDK dependency.
• Made flyway.cmd more robust.

Features

• Promoted update query debug logs to info logs.
• Updated various dependencies.
• SQL callbacks now support shouldExecute.
• Added installedOnUTC field on JSON result for info.
• Updated copyright headers.

Fixes

• Correctly parse GO in identifiers.
• Handle NOT ATOMIC statements in MariaDB.
• Fixed cleaning of computed columns in SQL Server.
• Fixed with JDBC properties environment variables not trimming underscores.
• Fixed -target=latest for undo.
• Display link to docs page upon PostgreSQL lock fail.

Features

• Added flyway:workingDirectory placeholder.
• You can now include preceding comments when executing SQL.

Fixes

• Clean SQL Server indexes in a 2-pass approach to avoid dependency errors.

Features

• Added the ability to load Gradle configuration artifacts outside of a Java project.

Fixes

• Fixed cleaning SQL Server computed columns which are primary keys.
• Fixed exception in migration comparator by sorting ignored migrations by version.
• Fixed NPE by checking CodeSource location isn't null.
• Throw upgrade required exception when using shouldExecute in community.
• Removed experimental annotations from Vault parameters.

Features

• Added SnowflakeDB support for 'QUOTED_IDENTIFIERS_IGNORE_CASE = true'.
• Added multi-line boolean expressions support for 'shouldExecute'.
• You can now log output from script migrations at the info level.

Fixes

• Fixed comparator exception in migration comparator.
• Fixed cleaning of SQL Server computed columns which are primary keys.
• Fixed incorrectly updating dropped schema list in clean JSON result.

Fixes

• Drop SQLServer types at the database level.
• Support multiline boolean expressions for shouldExecute.
• Log referenced scripts used when calculating checksums.
• Get MySQL and MariaDB version from the database.
• Check that PostgreSQL unlock result is true.
• Support SQL Server engine edition 9.

Features

• Added fulltext database to Microsoft SQL Server non-transactional list.
• Added Flyway upgrade exceptions when setting secret management parameters.

Fixes

• Check that PostgreSQL advisory unlock result returns true.
• Allow 'pro' in FLYWAY_EDITION environment variable.
• Removed warning following tests against Snowflake 5.1.

Features

• Vault integration: configuration now allows multiple locations for secrets.
• Vault integration: now supports V1 of key-value secret engine.

Fixes

• Alpine Docker image rebuilt based on openjdk:16-alpine to fix CVE (as 12-alpine is no longer maintained).
• HSQLDB: case-sensitivity bug on PROCEDURE has been fixed.
• HSQLDB: failure to parse END inside a query has been fixed.