org.flywaydb:flyway-community-db-support

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.