org.flywaydb:flyway-sqlserver

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.