org.flywaydb:flyway-core

Bug fixes

• Issue 3418 Fix error where the 'version' command fails to be handled

Thanks to cies for reporting these issues.

Changes

• Update S3 dependency to fix vulnerability

Changes

• Add a failed state for Baseline Migrations

• Update version of Jackson Databind due to GHSA-57j2-w4cx-62h2

• Mask any parameter that ends with 'password' in the logs

• Issue 3414 Ensure we close the connection created during the update stage

Database compatibility

• Issue 3399 Add support for STRICT and LEGACY modes in H2

Thanks to medwards8 and MMaus for reporting these issues.

Bug fixes

• SQL*Plus 'spool' now ignores value of 'feedback' for update statements

• Issue 3413 Script migrations applied previously using Teams Edition no longer cause an error in Community Edition

Java compatibility

• Upgrade jackson-databind to address CVE-2020-36518

Thanks to xmanemran for reporting these issues.

Changes

• Update PostgreSQL driver to fix code injection vulnerability

New features

• Issue 3358 Add 'placeholderSeparator' parameter to allow an alternative to ':' in default placeholders

Thanks to Phil-Factor for reporting these issues.

Breaking changes

• Issue 3405 Update shipped MSSQL JDBC driver to 10.2.0, which defaults 'encrypt' to 'true'

Bug fixes

• Fix issue where post schema clean didn't include correct schemas.

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

• Issue 3396 Maven and Gradle plugins load configuration files from current directory by default

Thanks to caseyhall and lbreuss for reporting these issues.

Bug fixes

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

Changes

• Issue 3403 Add info log saying number of SQL migrations skipped due to invalid naming, if any.

Thanks to sesgoe for reporting these issues.

Bug fixes

• Check if default 'jarDir' exists before using it

Changes

• Update Jackson Databind to 2.12.6

Bug 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'

Changes

• Upgrade PostgreSQL driver to fix RCE vulnerability

• Remove displaying "user 'null'" when using Windows Authentication with SQL Server

Bug fixes

• Fix rare NPE when checking for updates

Changes

• Printing version no longer exits early

Changes

• Bump H2 version to avoid vulnerability

• Removing Autotrial feature

New features

• Add the path to the undo migration in the 'info' JSON output

• Issue 3378 New callback, triggered by migrations with newly applied scripts

Thanks to troosan for reporting these issues.

Bug fixes

• Fix bug in Vault integration where it thinks the user is running Community edition incorrectly

Changes

• Update Google dependencies to fix DoS vulnerability in protobuf

Changes

• Extract Firebird code to plugin. This will need to be added as a new dependency. See Firebird documentation.

• Bump Log4J suggested version to 2.17.1 to mitigate CVE-2021-44832

• Issue 3372 Bump H2 to 2.0.206 due to GHSA-h376-j262-vhq6

Database compatibility

• Issue 3357 Add MariaDB 10.2 support back to Community edition

Thanks to everflux and dblackstock for reporting these issues.

Changes

• Upgrade suggested version of Log4J to 2.17

Thanks to everyone who reported these issues.

Bug fixes

• Issue 3347 Fix NPE when parsing single-line 'BEGIN' statements in SQL Server and detect 'BEGIN CONVERSATION' and 'BEGIN DIALOG'

Changes

• Teams license check no longer requires valid URL

Database compatibility

• Issue 3343 Continue supporting TiDB in Community

New features

• Issue 3365 Allow disabling placeholder replacement on a per-script basis

Thanks to noobgramming, jasouyris and md5 for reporting these issues.

Changes

• Upgrade suggested version of Log4J to 2.16

Changes

• Upgrade suggested version of Log4J to 2.15

• Issue 3339 Upgrade H2 version to 2.0.202

• Issue 3341 Remove unnecessary warning for MariaDB driver when connecting to a MySQL database on compatible database versions

Thanks to zenpaul and hemberger for reporting these issues.

Bug fixes

• Escape db name during doExists in MSSQL

Changes

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

Breaking changes

• Removing 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.

Bug fixes

• Issue 3331 Stop Flyway dropping schemas it did not create

Thanks to chipilov for reporting these issues.

Bug fixes

• Grab DBMS_OUTPUT from Oracle when handling errors

Changes

• Extract SQLServer code to plugin. This will need to be added as a new dependency. See SQL Server documentation .

• Clean XML Schema Collections in SQL Server

• Issue 3329 Allow null values for installed on by using commit timestamp in GCP Cloud Spanner

• Issue 3332 Update GSON to 2.8.9

New features

• Add validation patterns to repair for missing migrations

Thanks to plaflamme and leyuzhu for reporting these issues.

Bug fixes

• fix bug where notice level logs ignored the minimum log level configured

Changes

• Clean XML Schema Collections in SQL Server

• Rename 'FlywayExtension' in the API to 'PluginMetadata'

• Issue 3327 Replace SET SQLBLANKLINES warning with debug message

New features

• Add 'beforeConnect' callback to Teams that executes before Flyway establishes a connection

• Add support for SQL*Plus variable concatenation

Thanks to everyone who reported these issues.

Breaking changes

• Replace 'ApiExtension' with 'ConfigurationExtension'. Instead of calling 'getExtensionConfiguration()' on a Configuration object, you must now call 'getConfigurationExtension()' on 'PluginRegister' which returns a 'ConfigurationExtension'

Bug fixes

• Add look ahead to parser to fix wrapped sql statements

• Fix bug with logs not appearing when using 'jarDirs'

Changes

• add notice log pointing to Flyway Hub on completion of validate command

Bug fixes

• Issue 3304 Fix bug in parsing MySQL with multiple 'CASE' statements inside 'ORDER BY'

• Issue 3310 Fix bug in detecting emptiness in non-existent schemas

• Issue 3311 Fix bug in time function used when updating BigQuery lock

Changes

• Issue 3307 Remove warning around schemas from CockroachDB

Database compatibility

• Issue 3309 Support MariaDB 10.6

• Issue 3313 Add support for PostgreSQL 14

New features

• Add ability to specify 'target=next' to apply just the next migration

• Add Kerberos authentication support for SQL Server

• Issue 3306 Add 'ignoreMigrationPatterns' setter that takes an array of 'ValidatePattern's

Thanks to kevinrjones, cowwoc, todd-dev, A248, geirolz, klesniewski and md5 for reporting these issues.

Changes

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

New features

• Allow wildcard usage of 'ignoreMigrationPatterns' from within Community Edition

Bug fixes

• Fix bug where encoding detection would fail if the file was empty

• Issue 3299 Fix bug in the availability of custom placeholders in script migrations

Changes

• Set 10G field limit to using GCP Spanner in Community Edition

New features

• All Gradle tasks now return a result object

Thanks to Phil-Factor for reporting these issues.

Breaking changes

Flyway V8 introduced breaking changes incrementally over 3 beta releases. Check them below to see all breaking changes when upgrading to Flyway V8.

Bug fixes

• Fix issues in applying new migrations on top of baseline migrations

• Issue 3291 Fix parsing of multiline configuration parameters that contain a '='

• Issue 3292 Fix parsing of empty statements in SQLServer

Thanks to vincentoconnell and brynjulv for reporting these issues.

Breaking changes

• change Configuration boolean getter methods to match Java standard naming convention. (FailOnMissingTarget, DetectEncoding, OutputQueryResults, CreateSchemas and FailOnMissingLocations)

Bug fixes

• Issue 3279 Fix constantly repairing migrations with an empty description

• Issue 3284 HSQLDB not parsing DECLARE CURSOR foo FOR SELECT ... correctly

Changes

• Set 10GB data size limit to using GCP BigQuery in Community Edition

• Rename State Scripts to Baseline Migrations

Database compatibility

• Support latest version of Azure SQL Server in Community Edition

New features

• Add Command-line extensibility point to allow custom CLI verbs

• Add support for DAPR and GCSM Secrets Managers

Java compatibility

• Add base dependencies for Project Lombok

Thanks to StefanA2 for reporting these issues.

Bug fixes

• Issue 3275 Fix parsing of identifiers with quotes in PostgreSQL

• Issue 3279 Repair now checks for an empty description

New features

• Issue 3277 Add default placeholders to script migrations

Performance improvements

• Issue 3278 Remove redundant update check during license check

Thanks to tychokamphuis-accommodatiehuur, ewie, StefanA2 and Phil-Factor for reporting these issues.

Breaking changes

• Remove fields and methods marked as deprecated in V7. This includes the old '-json' flag and 'installedOn' in the JSON output from running info

• Remove android support

Bug fixes

• Issue 3276 Fix issue with output from '-v' not appearing

Changes

• Deprecate old 'ignore' parameters for validate (to be removed in v9)

Database compatibility

• Deprecate Community support for database versions older than 5 years

Thanks to iilei for reporting these issues.

Bug fixes

• Issue 3256 Fix issue with CockroachDB delete lock statement timestamp not updating

New features

• Add the ability to configure which logger to use

• Issue 3257 Added 'connectionRetriesInterval' property to set customizable connection retry interval (Default: 2 minutes)

Thanks to dimw and senthil-yolabs for reporting these issues.

Bug fixes

• Fix unlocking bug in PostgreSQL

• Issue 3258 Adding FUNCTION to the list of special cases for IF EXISTS in HSQL

• Issue 3261 Fix various parsing issues in BigQuery

• Issue 3266 Detecting abstract Java callback classes no longer cause Flyway to fail.

• Issue 3269 Simplify MySQL query to fix compatibility with third party tool Vitess

Thanks to spadger, ferrisnorth, kgroble and JaspreetSinghJassal for reporting these issues.

Bug fixes

• Resolve a nesting issue with BigQuery parsing

• Fix cases of CLI hanging when no credentials are provided

New features

• Add support for placeholders in arbitrary script migrations

Thanks to everyone who reported these issues.

Bug fixes

• Fix casing in Azure Synapse queries

Changes

• Issue 3246 Update support for Oracle wallet

Database compatibility

• Issue 3248 Certified on Percona XtraDb 8

New features

• Introduce State Scripts (also known as "Baseline Migrations") - a single, cumulative script that represents the state of your database after many migrations have been applied.

Thanks to klarajanstova and s-apanasionak for reporting these issues.

Changes

• DatabaseTypeRegister and VersionPrinter always use their class' classloader

New features

• Issue 3111 Add support for -target=next

Thanks to everyone who reported these issues.

Bug fixes

• Issue 3197 Fix resolving resources with the same name in multiple classpath locations

• Issue 3241 Simplify migration sorting to fix 'Comparison method violates its general contract'

Changes

• Add VaultConfiguration object for configuring Vault in Maven and Gradle Plugins

• Release Vault integration to Maven as a separate artifact

New features

• Add Java API extension that allows reading configuration from Vault

Thanks to magicwerk and esauser for reporting these issues.

Bug fixes

• Issue 3165 Fix execution of migrations without a transaction over a single connection

• Issue 3232 Fix Gradle location configuration override order

• Issue 3237 Fix deadlock due to exhausted connections when creating result objects

Thanks to pw-aowen, Leyren and uwolfer for reporting these issues.

Changes

• Issue 3227 Bump GCP Spanner JDBC version to fix CVE

Database compatibility

• Verify support for PostgreSQL 14

Thanks to donna-156 for reporting these issues.

Bug fixes

• Fix in-product links that contain a reference

Changes

• Issue 3227 Bump GCP Spanner JDBC version to fix CVE

Database compatibility

• Include the community DB support package in the CLI

• Issue 3186 Add YugabyteDB (community)

Thanks to donna-156 and ashetkar for reporting these issues.

Changes

• Update Maven version to 3.8.1

• Override vulnerable Jackson versions

• Issue 3214 Make PostgreSQL database classes extendable

• Issue 3229 Fail faster when checking for updates

Thanks to ashetkar and odin568 for reporting these issues.

New features

• Enable Flyway Teams for 28 days for new schemas in CLI

• Remove the need to specify -teams in CLI

Bug fixes

• Issue 3207 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

Changes

• Make GCP Spanner and BigQuery beta publicly available

• Bump MSAL4J to fix transitive dependency CVE

Database compatibility

• Add Cockroach v21.1 support

• Issue 2918 Add community-level TiDB support

• Issue 3221 Verify support for HSQLDB 2.6

Thanks to A248, bb7133, donna-156, dvdtknsn, and johnlinp for reporting these issues.

New features

• Issue 3188 - Add flyway:table placeholder

• Add Cockroach v21.1 support

• Closed beta signup for Google Cloud Platform ( Cloud Spanner & Big Query )

Bug fixes

• Fix issue where Flyway no longer prompts for credentials

Thanks to guillaumBrisard for reporting these issues.

Bug fixes

• Issue 3177 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

Changes

• Issue 3174 Clean schemas before dropping them

Thanks to AigleeK, alexgast, aliusmiles, and polaskj for reporting these issues.

Bug fixes

• Issue 3173 Use the ClassLoader specified to Flyway when using the ServiceLoader

• Oracle - Fix parsing of GOTO statements

• Inline method to fix compatibility with GraalVM

Changes

• Issue 3174 Clean schemas before dropping them

Thanks to AigleeK, alexgast and gastaldi for reporting these issues.

New features

• Issue 2205 Add failOnMissingLocations parameter

• Issue 3155 Allow targets that don't exist with '?'

• Add Flyway update checking in command line

• Add support for auto detecting file encoding for SQL migrations.

• Add Spanner Beta support

Bug fixes

• Issue 3160 Fix parsing of Oracle ACCESSIBLE BY

• Issue 3161 Clean all SQLServer objects in a 2-pass approach

Changes

• Issue 3132 'n rows affected' is now debug level in logs

• Issue 3162 Update MySQL driver version

• Update S3 dependency to fix vulnerabilities in transitive dependencies

• Detect Hikari pooled connections automatically when using Oracle proxy users

Thanks to artjomsimon, jeanremacle, mabako, rbroth, wparuch, and xiagw for reporting these issues.

New features

• Add support for Oracle proxy users when using Hikari pooled connections

• Issue 3139 Add GNU-standard command line help options

Bug fixes

• Issue 3152 Fix MySQL parsing nested blocks with labels

• Issue 3153 Only show warning about missing default schema when relevant

• Fix issue with comparator resulting (rarely) in failure during sorting migrations

Thanks to austek, Eric Sauser and tomikmar for reporting these issues.

Bug fixes

• Issue 3150 Fix a regression in 7.8.0 maven plugin

Thanks to pzygielo for reporting this issue.

Skipped due to a regression.

New features

• Add ignoreMigrationPatterns parameter to customize validate

• Add support for Oracle proxy user connections

Changes

• Issue 3132 Log 0 rows affected at the debug level

Bug fixes

• Issue 3129 SQLServer: Don't accidentally parse identifiers in square brackets as key words

Thanks to rchurchley, wparuch and esauser for reporting these issues.

Bug fixes

• Issue 3130 Fix parsing DISTRIBUTED TRANSACTION in SQL Server

New features

• Allow PROXY_USER_NAME in JDBC properties to create proxy connections to Oracle databases

Bug fixes

• Issue 3123 Use new MariaDB parser

New features

• Issue 3119 Updated MSSQL JDBC driver to allow for interactive authentication

Changes

• Issue 3131 Update MariaDB support to 10.5

• Update dependencies

• Ship MSAL4J dependencies for AAD auth

• Update GCS dependency

• Update DB2 driver

• Update log4j dependency

• Update Amazon SDK dependency

• Make flyway.cmd more robust

Thanks to JD-CSTx and nicregez for reporting these issues.

Bug fixes

• Issue 3110 Correctly parse GO in identifiers

• Issue 3115 Handle NOT ATOMIC statements in MariaDB

• Issue 3116 Fix cleaning of computed columns in SQL Server

• Fix JDBC properties environment variables not trimming underscores

Changes

• Issue 2847 Display link to docs page upon PostgreSQL lock fail

• Issue 3105 Promote update query debug logs to info logs

• Update various dependencies

• SQL callbacks support shouldExecute

• Fix -target=latest for undo

• Add installedOnUTC field on JSON result for info

• Update copyright headers

Thanks to JD-CSTx, aherkarsatish11, bobdoah, rchurchley, and zikato for reporting these issues.

New features

• Issue 3100 Add flyway:workingDirectory placeholder.

Bug fixes

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

Changes

• Include preceding comments when executing SQL

Thanks to everyone who reported these issues.

New features

• Issue 3084 Allow loading Gradle configuration artifacts outside of a Java project

Bug fixes

• Issue 3090 Fix cleaning SQL Server computed columns which are primary keys

• Issue 3091 Fix exception in migration comparator by sorting ignored migrations by version

• Issue 3092 Fix NPE by checking CodeSource location isn't null

Changes

• Issue 3098 Throw upgrade required exception when using shouldExecute in community

• Remove experimental annotations from Vault parameters

Thanks to eikek, esauser, and johnwright for reporting these issues.

Bug fixes

• Issue 3088 Fix comparator exception in migration comparator

• Issue 3090 Fix cleaning of SQL Server computed columns which are primary keys

• Fix incorrectly updating dropped schema list in clean JSON result

Changes

• Issue 2761 Support SnowflakeDB QUOTED_IDENTIFIERS_IGNORE_CASE = true

• Issue 3071 Support multiline boolean expressions for shouldExecute

• Issue 3081 Log output from script migrations at the info level

Thanks to dvdtknsn, esauser, johnwright, and scottsauber for reporting these issues.

Bug fixes

• Issue 3063 Drop SQLServer types at the database level

• Issue 3071 Support multiline boolean expressions for shouldExecute

Changes

• Issue 3074 Log referenced scripts used when calculating checksums

• Issue 3066 Get MySQL and MariaDB version from the database

• Check that PostgreSQL unlock result is true

Database compatibility

• Issue 3070 Support SQL Server engine edition 9

Thanks to Sam-Redgate, StaffanHorke, TonytheEditor, chakrit, and scottsauber for reporting these issues.

Bug fixes

• Check that PostgreSQL advisory unlock result returns true

• Allow 'pro' in FLYWAY_EDITION environment variable

• Remove warning following tests against Snowflake 5.1

Changes

• Issue 3042 Add fulltext database to SQL Server non-transactional list

• Issue 3060 Add Flyway upgrade exceptions when setting secret management parameters

Thanks to JeanFrancoeur and wilkinsona for reporting these issues.

Bug fixes

• Alpine Docker image rebuilt based on openjdk:16-alpine to fix CVE (as 12-alpine is no longer maintained)

• Issue 3049 HSQLDB: case-sensitivity bug on PROCEDURE fixed

• Issue 3053 HSQLDB: failure to parse END inside a query fixed

Changes

• Vault integration: configuration now allows multiple locations for secrets

• Vault integration: now support V1 of key-value secret engine

Thanks to esauser and Peter Gerrard for reporting these issues.

Bug fixes

• Issue 3037 Only use external authentication if it is required

• Issue 3041 Correctly parse nested multi-line comments

• Issue 3043 Case-insensitive HSQLDB parsing

New features

• Issue 3039 Allow shouldExecute script configuration option to contain boolean expressions

Changes

• Issue -1 Remove warning when using SAP HANA Cloud

Thanks to JeanFrancoeur, calvarius7, esauser, and tanguanpeng1234 for reporting these issues.

Bug fixes

• Issue 3026 Fix parsing of wrapped Oracle SQL

• Issue 3029 Include classpath variable in bash script

• Issue 3034 HSQLDB - successfully parse drop procedure

New features

• Issue 2239 New callback for custom schema creation SQL

• Issue 3028 Support p6spy in URLs

• Support reading configurations from Vault and Conjur

Changes

• Issue 3013 Move LoadableResource and Resource into the API

Thanks to RB14, calvarius7, ericparton, luoy1991, mLarsenAlkaDk, and tobato for reporting these issues.