Fixes

• The Ascii table will not be logged if there are no columns.
• Fixed potential parsing bug during 'create package' statement in DB2.
• Always close the underlying Java connection inside a Database object.

Features

• The 'version' command now has JSON output.

Fixes

• Fixed relative locations not being relative to the working directory.
• When using the delimiter keyword the value can be placed on the next line without entering an infinite loop.
• Update checker times out if it doesn't receive a response.
• The filename placeholder no longer causes errors in repeatable SQL migrations.

Features

• Optimized param tokenization.

Fixes

• Updated GCS dependency due to vulnerability.
• Updated AWS ASK, AWS_SECRETSMANAGER-JDBC, Maven Core and MSAL4J dependencies to fix vulnerabilities.

Fixes

• Manually register the Oracle driver so Flyway CLI works with AWS Secrets Manager.
• Fixed NPE in Oracle when 'echo' is set to 'on' during spool.
• Updated recommended Spring JDBC version due to Spring vulnerability.

Fixes

• PLSQL division on new line in package body is no longer classified as a delimiter.
• Fixed bug where connection details set in placeholders were overriding the main details.
• Handle errors (with warning) when cleaning procs on snowflake.

Fixes

• Fixed error where the 'version' command fails to be handled.

Fixes

Features

• Added a failed state for Baseline Migrations.
• Updated version of Jackson Databind due to GHSA-57j2-w4cx-62h2.
• Added the ability to mask any parameter that ends with 'password' in the logs.
• Added support for STRICT and LEGACY modes in H2.

Fixes

• Ensure you close the connection created during the update stage.

Fixes

• SQL*Plus 'spool' now ignores value of 'feedback' for update statements.
• Upgraded jackson-databind to address an issue.

Features

• Added 'placeholderSeparator' parameter to allow an alternative to ':' in default placeholders.

Fixes

• Updated PostgreSQL driver to fix code injection vulnerability.

Features

• Updated shipped MSSQL JDBC driver to 10.2.0, which defaults 'encrypt' to 'true'.

Fixes

• Fixed issue where post schema clean didn't include correct schemas.
• Clean mode now cleans more schemas for SQL Server integrated authentication logins.
• Maven and Gradle plugins load configuration files from current directory by default.

Features

• Added an info log saying number of SQL migrations skipped due to invalid naming, if any.

Fixes

• Clean mode now cleans more schemas for SQL Server integrated authentication logins.

Features

• Updated Jackson Databind to 2.12.6.

Fixes

• Check if default 'jarDir' exists before using it.

Fixes

• Fix exit code in Windows returning as 0 during error.
• Fix possible NPE when no default schema is specified.
• Ensure 'defaultSchema' is used over the first schema in 'schemas'.
• Upgrade PostgreSQL driver to fix RCE vulnerability.
• Remove displaying "user 'null'" when using Windows Authentication with SQL Server.

Fixes

• Fixed rare NPE when checking for updates.
• Printing version no longer exits early.

Features

• Added the ability to add the path to the undo migration in the 'info' JSON output.
• Added new callback which is triggered by migrations with newly applied scripts.
• Removed H2 version to avoid vulnerability.
• Removed Autotrial feature.

Fixes

• Update Google dependencies to fix DoS vulnerability in protobuf.
• Fixed bug in Vault integration where it thinks the user is running Community edition incorrectly.

Features

• Added the ability to extract Firebird code to plugin. This will need to be added as a new dependency.
• Updated Log4J suggested version to 2.17.1 to mitigate CVE-2021-44832.
• Updated H2 to 2.0.206 due to GHSA-h376-j262-vhq6.

Features

• Upgraded suggested version of Log4J to 2.17.

Features

• Added the ability to disable placeholder replacement on a per-script basis.

Fixes

• Fixed NPE when parsing single-line 'BEGIN' statements in SQL Server and detect 'BEGIN CONVERSATION' and 'BEGIN DIALOG'.

Features

• Upgraded suggested version of Log4J to 2.16.

Features

• Upgraded suggested version of Log4J to 2.15.
• Upgraded H2 version to 2.0.202.
• Removed unnecessary warning for MariaDB driver when connecting to a MySQL database on compatible database versions.

Features

• Extract MySQL code to plugin. This will need to be added as a new dependency.

Fixes

• Escape db name during doExists in MSSQL.

Features

• Breaking Change - Removed MySQL Driver from inclusion in Flyway distribution due to License. MariaDB will be used as fallback driver if no MySQL driver is present on the Classpath.

Fixes

• Stop Flyway dropping schemas it did not create.

Features

• Added validation patterns to repair for missing migrations.
• Added the ability to clean XML Schema Collections in Microsoft SQL Server.
• Added the ability to extract SQLServer code to plugin. This will need to be added as a new dependency.
• Added the ability to allow null values for installed on by using commit timestamp in GCP Cloud Spanner.
• Updated GSON to 2.8.9.

Fixes

• Grab DBMS_OUTPUT from Oracle when handling errors.

Features

• Added 'beforeConnect' callback to Teams that executes before Flyway establishes a connection.
• Added support for SQL*Plus variable concatenation.
• Clean XML Schema Collections in Microsoft SQL Server.
• Renamed 'FlywayExtension' in the API to 'PluginMetadata'.
• Replaced SET SQLBLANKLINES warning with debug message.

Fixes

• Fixed bug where notice level logs ignored the minimum log level configured.

Features

• Replaced 'ApiExtension' with 'ConfigurationExtension'. Instead of calling 'getExtensionConfiguration()' on a Configuration object, you must now call 'getConfigurationExtension()' on 'PluginRegister' which returns a 'ConfigurationExtension'
• You can now add notice log pointing to Flyway Hub on completion of validate command.

Fixes

• Add look ahead to parser to fix wrapped SQL statements.
• Fixed bug with logs not appearing when using 'jarDirs'.

Features

• Added the ability to specify 'target=next' to apply just the next migration.
• Added Kerberos authentication support for Microsoft SQL Server.
• Added 'ignoreMigrationPatterns' setter that takes an array of 'ValidatePattern's.
• Added support for MariaDB 10.6.
• Added support for PostgreSQL 14.
• Removed warning around schemas from CockroachDB.

Fixes

• Fixed bug in parsing MySQL with multiple 'CASE' statements inside 'ORDER BY'.
• Fixed bug in detecting emptiness in non-existent schemas.
• Fixed bug in time function used when updating BigQuery lock.

Fixes

• The JSON output for 'flyway migrate' now contains additional information about successful migrations run up to the point of failure when a migration fails.

Features

• All Gradle tasks now return a result object.

Fixes

• Fixed bug where encoding detection would fail if the file was empty.
• Fixed bug in the availability of custom placeholders in script migrations.

Fixes

• Fixed issues in applying new migrations on top of baseline migrations.
• Fixed parsing of multiline configuration parameters that contain a '='.
• Fixed parsing of empty statements in SQL Server.