org.flywaydb:flyway-core

New features

• Issue 2953 Exponential backoff scheme for connect intervals

Bug fixes

• Issue 2932 Add a timeout to Flyway's custom table lock

• Issue 2987 Display all validate messages in exceptions

• Issue 2999 Allow 'alter type' in transactions for PostgreSQL 12 and up

• Issue 2698 Execute migrations in cherryPick defined order

Changes

• Issue 3005 Only drop PostgreSQL extensions owned by current user

• Issue 2914 Full filename in filename default placeholder

Thanks to AigleeK, OliverDTM, axelfontaine, gendolf3d, holgerstolzenberg, and scranen for reporting these issues.

New features

• Issue 960 Read MySQL credentials from option files

• Issue 2914 Add filename as a default placeholder

• Option to filter info by migration state

Bug fixes

• Issue 2987 Display all validate messages in exceptions

• Issue 2987 Ignore superseded repeatables when validating

Performance Improvements

• Issue 2993 Improve performance of migrate

Changes

• Arbitrary script callbacks no longer require a description

Thanks to AigleeK, OliverDTM, ToBeReplaced, kasgilpofi, and wilkinsona for reporting these issues.

Bug fixes

• Issue 2991 Fix Teams upgrade exception incorrectly appearing in Community edition

Performance Improvements

• Issue 2989 Cache oracle database metadata

Changes

• Issue 2988 Don't name primary key constraint on MariaDB

Thanks to kasgilpofi, wilkinsona, and willy0275 for reporting these issues.

Skipped due to a regression in Community edition, see this issue .

New features

• Issue 960 Support pgpass for authentication

• Issue 2847 Allow number of lock retries to be configured.

• Issue 2984 Support for SLF4J v1.8+

• Issue 2967 Add schema support for Cockroach 20.2

• Issue 2694 Add windows native folder

• Issue 2881 Allow for filtering info output by date or version

• Allow arbitrary script callbacks

Changes

• Issue 2820 Add validate error codes and improve validate result object

• Issue 2986 Create the schema history table when using skipExecutingMigrations without baseline

• Make validate fix suggestions copy-pastable.

Bug fixes

• Issue 2987 only mark latest repeatable as deleted

Thanks to A248, AigleeK, ToBeReplaced, aherkarsatish11, cheppsn, and yarhamjohn for reporting these issues.

Bug fixes

• Fix cherryPick feature name in exception

• Fix issue with licensing

Thanks to everyone who reported these issues.

Bug fixes

• Issue 2921 Support for Log4J v2

• Issue 2966 Passwords embedded in Flyway URLs redacted analogously to flyway.password parameter

• Issue 2977 MySQL parser: BEGIN [WORK] not being parsed correctly

Database compatibility

• Flyway now ships with MySQL driver 8.0.20, following Whitesource recommendation

Thanks to Dan Carley and sniperrifle2004 for reporting these issues.

Bug fixes

• Issue 2969 Drop support for setting s3 client via fluent configuration

• Issue 2907 Log instead of throwing exception when PostgreSQL advisory locking fails

Thanks to josephlbarnett for reporting these issues.

Skipped due to a regression, see this comment .

Database compatibility

• Issue 2952 Confirm PostgreSQL 13 support

New features

• Issue 2921 Add Log4J v2 support

• Issue 2919 Allow custom S3Client to be supplied

Changes

• Issue 2871 Double quote migration names in logs

• Issue 2957 Make AWS S3 SDK optional

Bug fixes

• Issue 2898 Don't prompt for credentials with H2 in-memory databases

• Issue 2949 Fix table locking retry logic

• Issue 2954 Fix getting Oracle database name

• Issue 2959 Fix handling of wrapped SQL in Oracle parser

• Issue 2961 Fix SQLServer parser block handling

• Make outputQueryResults public

Performance Improvements

• Issue 2965 Remove unnecessary linebreak trimming

Thanks to AigleeK, TheSench, gendolf3d, mLarsenAlkaDk, peng-ran, and pyrocks for reporting these issues.

Changes

• Introduce Flyway Teams edition

• Make validate messages suggest actions

New features

• Issue 2507 Add machine readable output for all commands

• Issue 2780 Add jdbc-secretsmanager support

• Oracle SQL*Plus support for glogin.sql

• Make cherry pick work for repair

Bug fixes

• Issue 2208 clean assemblies at the database level

• Issue 2924 Improve mysql parser block handling

• Issue 2926 Reapply java repeatables when checksum changes from null

• Issue 2928 Fix parser error when using repeated placeholders

• Issue 2940 Fix sql server parser error

• Issue 2448 Drop extensions in PostgreSQL when running clean

• Issue 2736 Reintroduce Testcontainers support

• Issue 2872 Batch SQL doesn't error out

• Issue 2917 Resolve maven configuration files relatively

• Make dry run work for repair

• Add envvar support for validate migration naming

Read about more features that were released in the beta .

Thanks to AigleeK, JeanRev, LuisUrrutia, amccarthy, belugabehr, cdalexndr, hauntingEcho, lbreuss, mschirmacher, sdchhabaria, stankiewicz, will-sargent-eero, and yarhamjohn for reporting these issues.

New features

• Issue 1986 Allow skipping the execution of a migration

• Issue 2458 Support for SQL migrations in AWS S3 storage

• Issue 2594 Postgres driver updated to support SCRAM authentication

• Issue 2133 Add new callbacks beforeRepeatables and afterVersioned

• Issue 2688 Enable passing JDBC properties through to clients

• Support for SQL migrations in Google Cloud Storage

• Oracle SQL*Plus support for login.sql

• Allow cherry picking which migrations to run

• Support deleting migrations

Changes

• Update gradle plugin to 6.1.1

• Command-line option -json superseded by -outputType=json

• Issue 2805 The CLI default flyway.conf now specifies the location filesystem:sql

• Issue 2808 Placeholder names are now case insensitive

• Issue 1801 Ignore hidden directories on the classpath when finding resources

• Issue 2785 Allow loading callbacks by scanning a provided package

Database compatibility

• Issue 2324 Invalid targets now cause an error

• Issue 2859 Only load from std in when a config file with the name '-' is given

• Non existent migration locations now display an error in the output

• Deprecated command-line argument -logFile removed (see -outputFile for replacement)

• Deprecated migration types SPRING_JDBC, UNDO_SPRING_JDBC removed (use JDBC, UNDO_JDBC instead)

• Deprecated dots as location path separators

Changes

• Issue 2805 The CLI default flyway.conf now specifies the location filesystem:sql

• Issue 2808 Placeholder names are now case insensitive

• Issue 1801 Ignore hidden directories on the classpath when finding resources

• Issue 2785 Allow loading callbacks by scanning a provided package

• Update gradle plugin to 6.1.1

• Command-line option -json superseded by -outputType=json

Database compatibility

• Issue 2806 Add support for Azure Synapse

• Issue 2466 Support for several older databases moved into Enterprise

• HSQLDB 2.3 (2010)

• PostgreSQL 9.4 (2014)

• Sybase ASE 16.0 (2014)

• Sybase ASE 16.1 (2015)

Docker images

• Docker images updated to be based on JDK 12: respectively adoptopenjdk:12-jre-hotspot and openjdk:12-alpine

Thanks to JonLally, KrzysztofMadejski, Me1gireesh, PetterKraabol, belugabehr, fkoehler, hdgarrood, leoherbie, nelvadas, qoomon, stankiewicz, olavloite, laurentgrangier, jitu1983, and radzimir for reporting these issues and/or submitting pull requests.

Changes

• Issue 2936 Update postgres driver version because of XXE vulnerability

Bug fixes

• Issue 2924 Improve mysql block handling further

Thanks to amccarthy and sstrang for reporting these issues and/or submitting pull requests.

Bug fixes

• Issue 2924 Improve mysql block handling

• Issue 2928 Fix parser bug when using multiple placeholders of the same name

• Issue 2872 Make batches errors fail fast

Thanks to amccarthy, hauntingEcho, and sdchhabaria for reporting these issues.

Bug fixes

• Issue 2903 Fix resource resolving logic to be more performant

Thanks to leoherbie for reporting these issues and/or submitting pull requests.

Changes

• Issue 2900 Make scanner resource look up case insensitive

Bug fixes

• Issue 2901 Fix performance degradation due to getting the absolute path earlier

Thanks to ekennedy247 for reporting these issues and/or submitting pull requests.

Bug fixes

• Issue 2887 Oracle SQL*Plus: Support @-style import of script file with absolute path

• Issue 2889 SnowflakeDB: Support //-style single-line comments in scripts

Bug fixes

• Issue 2865 Remove unhelpful warning re. MariaDB driver / MySQL server following driver update

• Issue 2875 Migration fails when placeholder value is much shorter than its name

• Issue 2879 Documentation update to clarify script config file location

• Issue 2883 Percona XtraDB: support strict mode MASTER similarly to ENFORCING

• Issue 2884 Oracle parser: failure parsing package with no trailing /

Thanks to anake1, ankos, Mauro Molinari and t-kwasniewski for reporting these issues and/or submitting pull requests.

Bug fixes

• Issue 2866 MySQL parser: fixed error around CREATE TABLE IF NOT EXISTS

• Issue 2867 SQL*Plus: SPOOL now produces output during migration/callback to requested file

Docker images

• Issue Docker images updated to be based on JDK 12: respectively adoptopenjdk:12-jre-hotspot and openjdk:12-alpine

Thanks to Nathan Ginther and Yvette Cook for reporting these issues and/or submitting pull requests.

New features

• Issue 2350 Added a config option to disable automatic schema creation

• Issue 2766 Allow script encoding to be set on a per-script basis

• Issue 2838 Make ResourceProvider and ClassProvider configurable

Bug fixes

• Issue 2853 Fix MySQL support for multiline IF statements

• Issue 2854 Fix MariaDB support for ROW END

• Issue 2856 Improve DB2 module clean

• Issue 2860 Fix Oracle parsing issue

• Issue 2861 Fix MySQL support for IF with AS

Thanks to Sourav1407, XhstormR, geoand, htto, lwasylow, mikhailRo, monmallonga, and wkiszka for reporting these issues and/or submitting pull requests.

Bug fixes

• Issue 2832 Fix bug with cleaning modules in DB2

• Issue 2837 Fix bugs related to reading config from standard input

• Issue 2843 Improved Snowflake support for $$ string literals

Changes

• Issue 2513 Upgrade the Oracle drivers version 19.6

• Issue 2849 Add CockroachDB 20.1 support

Thanks to intacctvaler, monmallonga, and srjonemed for reporting these issues.

Bug fixes

• Issue 2559 Improve SQL*PLUS SET FEEDBACK support

• Issue 2813 Fix cleaning a SQL Server table with a FILESTREAM column

• Issue 2817 Fix PostgreSQL parser handling of escaped strings

• Issue 2819 Support blank sql version prefix

• Issue 2821 Fix REPAIR issues

• Issue 2828 MySQL handle multiple IF EXISTS in one statement

Thanks to angusholder, davidjeddy, joachimvda, philippedurocher, and zjwu2000 for reporting these issues.

Changes

• Issue 2810 CockroachDB history table locking

Bug fixes

• Issue 2800 Report inner exceptions for more context on failures

• Issue 2807 Fix MySQL parser bug

• Issue 2812 DB2 parser handle LOOP

Thanks to Kenny2912 and LHCGreg for reporting these issues.

Changes

• Issue 2588 Ship Snowflake drivers

Bug fixes

• Issue 2795 Unable to decrease block depth below 0 error in version 6.4.0

• Issue 2794 ADD COLUMN IF NOT EXISTS in MariaDB generates a Flyway Parsing Error

• Issue 2796 Parse error using MySQL 8 since flyway 6.3

• Issue 2781 Delimiter changed inside statement

• Issue 2786 Delimiter changed inside statement on delimiter change right after comment

• Issue 2774 Parser issue for Sybase ASE for keyword GOTO

• Issue 2783 End of package body not detected with Oracle

Thanks to ChristianFischerJena, Nathan Ginther, Marc Bennewitz, Frank Huster, Damjan Vujnovic, Andreas Müller, laurentgrangier, and Wesley Leung for reporting these issues.

Bug fixes

• Issue 2701 Oracle parser: Improve support for oracle statements separated by a /

• Issue 2716 Oracle parser: Don't suppress comments after Sqlplus PROMPT

• Issue 2737 MySQL parser: Fix support for block statements with multiple cases denoted by THEN

• Issue 2743 Fix memory leak

• Issue 2748 DB2 parser: Support CREATE IF NOT EXISTS and DROP IF EXISTS

Thanks to JFNGO, JamesGuthrie, SamuraiPrinciple, netsrotr, rafael-trevisan, and sergey-selivanov for reporting these issues.

Bug fixes

• Issue 2132 Command line should not prompt for values if user and/or password are in PostgreSQL JDBC URL

• Issue 2720 MySQL parser: block depth error with IF NOT EXISTS

• Issue 2724 SAP HANA parser: error on creating function

• Issue 2726 MySQL parser: error when delimiter changed inside statement

• Issue 2727 Flyway shouldn't try to colorize output when no System.console()

• Issue 2733 SAP HANA parser: error on CASE ... END; IF ...

Thanks to Al Johri, Damjan Vujnovic, James Ball, Jonas Karlsson and stesix for reporting these issues.

Changes

• Issue 2709 flyway.url must be set when running command but already set in flyway.conf

• Issue 2447 Cleaning dry-runs

Bug fixes

• Issue 2699 Default placeholder is not populated

• Issue 2702 Building against enterprise flyway command line with gradle fails

• Issue 2707 Flyway does not execute SQL in a migration to create a MySQL procedure when it contains DROP TABLE IF EXISTS

• Issue 2715 Flyway parsing bug: unable to decrease block depth below 0 in version 6.3.0

Thanks to AigleeK, feoktant, James Ball, Nick Edwards, Rafael Trevisan, for reporting these issues and/or submitting pull requests.

New features

• Issue 1780 Flyway api load configuration files from the default locations

• Issue 2022 Support for workingDirectory parameter added to clients which didn't already have it

• Issue 2177/2685 Repeatable migrations with placeholders re-run when placeholder value changes

• Issue 2555 Support for multiple lines in flyway.conf

• Issue 2700 Add support for a timestamp placeholder

Changes

• Issue 2527 Baselining with empty history table now throws error

• Issue 2692 Providing a license key to the community edition is now a warning instead of an error

Bug fixes

• Issue 2447 Fix cleaning SQL Server partition schemes/functions when there are cross-schema dependencies

• Issue 2605 Flyway not able to create the schema history in Sybase with DDL IN TRAN = OFF

• Issue 2684 Fix cleaning a Redshift schema containing procedures

• Issue 2687 Fix mysql parser comment before DROP IF EXISTS

• Issue 2689 Support putting comments and newlines within the package definition

• Issue 2693 Add support for TEMPORARY TABLE in the mysql parser

Thanks to Komurugesan, artjomsimon, bjornhilstad, fumal4evr, goranpaues-tradedoubler, jakaarl, esauser, jaa2261, kippm, philci52, shadowmanos, and vitas for reporting these issues.

Bug fixes

• Issue 2674 Oracle SQL*Plus parsing extended to support SPOOL

• Issue 2675 MySQL parsing bug

• Issue 2676 MySQL CREATE TABLE IF EXISTS parsing bug

• Issue 2677 Snowflake no longer needs dummy password if using key-based authentication

• Issue 2679 Password prompt for SQL Server integration auth

• Issue 2681 NullPointerException when running flyway info -json

• Issue 2682 Print Flyway version in 'productVersion' property with -json

Thanks to emarcellus, Jonathan Putney, Slaiman Ahmdshah, Sreejith Madhavan, and Valdemar Grange for reporting these issues.

Changes

• Issue 2642 Package Oracle drivers

Bug fixes

• Issue 2650 MariaDB with MaxScale is unable to determine version

• Issue 2665 Dryrun scripts for CockroachDB are invalid

• Issue 2666 Support control flow keywords in MySQL

• Issue 2669 Oracle package parsing bug

• Issue 2673 DB2 parsing bug

Thanks to marcobehler, mbreevoort, and wjtkp for reporting these issues.

New features

• Issue 2663 CockroachDB retrying mechanism

Bug fixes

• Issue 2653 MariaDB does not clean system versioned tables

• Issue 2655 MariaDB jdbc driver logs errors on startup

• Issue 2657 MariaDB dry run script contains invalid comment syntax

Thanks to the development team at CockroachDB for their assistance with issue 2663, and dohrayme for reporting MariaDB issues.

Database compatibility

• Issue 2645 Support for Snowflake 4.2 verified

Bug fixes

• Issue 2567 Undo + ErrorOverride throws exception but fails to record in schema_history table

• Issue 2612 Oracle: Package body initialization section with implicit END

• Issue 2643 clean fails on SQL Server 2014 and older

• Issue 2638 Add comment to select statement for schema history to disable load balancing on Pgpool-II

• Issue 2649 Ensure flyway cleans partition functions on azure sql server version 12

Thanks to KiruthikaSS, Kindrat, filiprichtarik, LukeLaz, romaindup, and codicuz for reporting these issues and/or submitting pull requests.

New features

• Issue 2186 New option to explicitly validate SQL migration/callback script names

• Issue 2590 Flyway output not colored in jenkins when using ansiColors plugin

• Issue 2621 Re-add the CLI option to disable colorization.

Changes

• Issue 1328 In multiple managed schema scenario, if one of the schemas already exists, no other schema is created

Bug fixes

• Issue 2620 Scripts with empty description causing issues in Oracle and Sybase

• Issue 2624 Error parsing CASE...END in SAP HANA

• Issue 2626 Support for MariaDB enterprise version numbering

• Issue 2634 Deadlock on some instances of Postgres

• Issue 2637 Add environment variable for defaultSchema

Java compatibility

• Issue 2619 JDK 13 support officially added

Thanks to allenatdecisiv, esauser, Roman Dubinin, Marko K, Nicholas Fechner, stesix, rickselby and morl-la for reporting these issues and/or submitting pull requests.

Bug fixes

• Issue 2608 Unrecognized configration parameters all reported on at the same time

• Issue 2609 Oracle: fix parsing of Q'! ... !' quoted string literals

• Issue 2611 Problems with Java comments in Oracle CREATE JAVA statement

• Issue 2613 Multiple procedures each terminated with '/' in placeholder string fails to create procedures

Thanks to codicuz and jaa2261 for reporting these issues and/or submitting pull requests.

Bug fixes

• Issue 2537 Unexpected error re. non-empty schemas

• Issue 2561 Improve parsing of Oracle SQL*Plus PROMPT statement Flyway Teams

• Issue 2604 Block depth issue with Oracle END CASE statement

• Issue 2607 Block depth issue with Oracle CREATE JAVA statement

Thanks to David Atkinson, codicuz and fszilinski for reporting these issues and/or submitting pull requests.

Bug fixes

• Issue 2519 Previous fix also needed for Azure MySQL Database v8

• Issue 2582 Combining -json and -logFile yields no logFile

• Issue 2591 Oracle: invalid delimiter (not alone on line) ignored

• Issue 2596 Snowflake stored procedure issues in migrate and clean

• Issue 2597 Parenthesis depth affects interpretation of LOOP in Oracle parser

• Issue 2602 Redact license key in -X (DEBUG) mode

Database compatibility

• Issue 2603 Aurora Postgres 11.4 support

Thanks to esauser, JFNGO, Joe Wu, SDepn, stevenenen and Tyson Gern for reporting these issues.

Bug fixes

• Issue 2560 Whitespace after / delimiter causes migration to fail

• Issue 2571 Changing delimiter to # in MySQL fails

• Issue 2577 Support JavaScript in Snowflake stored procedures

• Issue 2578 Clean fails for PROCEDURE in Postgres 12

• Issue 2580 Escaping issue with environment variable substitution

• Issue 2592 Cockroach doesn't support mixing DDL / DML in transactions

• Issue 2595 Only a single line of output produced when -logFile used

Thanks to BartBM, Christoph Dreis, Jeroen Roosen, Joe Wu and Tarcio Saraiva for reporting these issues.

New features

• Issue 1384 Special automatically-populated FLYWAY.CURRENT_SCHEMA placeholder

• Issue 1479 Environment variable substitution in config files

• Issue 1735 Snowflake support

• Issue 2180 Option to log a copy of the command-line output to a file

• Issue 2254 Machine-readable Flyway Info

• Issue 2445 Cockroach 19.2 support

• Issue 2532 H2 1.4.200 support

• Issue 2546 Option to force migration to (or not to) run in a transaction

Changes

• Issue 2576 New configuration parameter flyway.defaultSchema

Bug fixes

• Issue 1466 Classpath scanning results are cached between migrate runs

• Issue 2535 CREATE TABLE ... AS SELECT not allowed in MySQL when enforcing GTID consistency

• Issue 2550 Oracle SQL*Plus: SET ECHO ON should echo to Flyway's output

• Issue 2553 Error message improved when script is incorrectly named

• Issue 2562 Dry Run fails to recognize baseline version

• Issue 2566 Percona XtraDB 5.7 metadata issue

Thanks to Bob Tierney, David Campbell, esauser, Dennis Jansen, fanticat, fcaponi, Gavin Figueroa, John Yarham, jshayward (no relation!), Mike Breault, Milan Nankov, NEzer2 and rjungwirth for reporting these issues and/or submitting pull requests.

Bug fixes

• Issue 2537 Unexpected error re. non-empty schemas

• Issue 2539 HSQLDB: Unable to parse DROP INDEX IF EXISTS statement

• Issue 2542 MS-SQL stored proc calls cause non-transactional statement error.

• Issue 2493 Regression with forward-slash as division operator within PL/SQL

Thanks to David Atkinson, Niklas Lochschmidt, Seb Urbaniak and Tadayuki Onishi for reporting these issues and/or submitting pull requests.

Bug fixes

• Issue 2432 & in comments should not trigger SQL*Plus placeholder replacement Flyway Teams

• Issue 2519 Workround for Azure MySQL Database (Basic Edition) incorrectly reporting version

• Issue 2530 Empty line after / delimiter causes migration to fail

• Issue 2531 Workround for Azure MariaDB Database incorrectly reporting version

Thanks to bramant, Matonen and stevenenen for reporting these issues and/or submitting pull requests.

New features

• Issue 2445 Cockroach 19.1 support

Changes

• Minor-version updates to some third-party dependencies

Bug fixes

• Issue 2183 Fail-fast when errorOverrides are used with batch=true

• Issue 2511 Support backtick as an identifier quote for H2 database running in MySql mode

• Issue 2512 Null placeholder value no longer works for H2 database running in MySql mode

• Issue 2519 Workround for Azure MySQL Database incorrectly reporting version

• Issue 2522 Parser error when SQL*Plus SET statement is preceded by comments Flyway Teams

• Issue 2523 Error when SQL*Plus SERVEROUTPUT is set to WORD_WRAPPED Flyway Teams

Thanks to Axel Fontaine, elieabichar-wk, Richard Kettelerij and sladis for reporting these issues and/or submitting pull requests.

Bug fixes

• Issue 2504 Flyway gradle task cannot open file within custom location (windows)

• Issue 2503 Checksum mismatch with different relative path in 6.0

Thanks to esauser and gintsgints for reporting these issues and/or submitting pull requests.

New features

• Issue 2482 Warn about invalid Java migrations

• Issue 2462 Dry runs: handle more JDBC types Flyway Teams

Changes

• Issue 2116 validate() now warns on all checksum failures, rather than stopping at the first one found

• Issue 2498 Avoid creating unnecessary ResolvedMigrationComparator instances

• Issue 2499 Compare function(s) should return -1 || 0 || 1

Bug fixes

• Issue 2500 Cannot create AD account on MSSQL

Thanks to cdalexndr, Ezra Epstein, Martin Konôpka and gorille for reporting these issues and/or submitting pull requests.

Bug fixes

• Issue 2436 H2 Oracle mode: Unable to create schema history table

• Issue 1794 H2 Oracle mode: NULL not allowed for column 'installed_by'

• Issue 2493 Forward-slash as division operator within PL/SQL

• Issue 2496 NPE in AsciiTable.render

Thanks to Garret Wilson, Gerard de Leeuw, Jeroen Meys and GregorKo for reporting these issues and/or submitting pull requests.

New features

• Issue 2470 Derby 10.15 support (see Derby documentation for compatibility notes)

Bug fixes

• Issue 2467 Unable to create H2Database instance

• Issue 2481 Getting unsupported error with correct versions?

• Issue 2484 Parsing inline comments for SQL*Plus DEFINE statements fixed Flyway Teams

• Issue 2486 SQL Azure incorrectly detected as SQL Server 2014

• Issue 2487 Flyway 6.0 clean migrate command is throwing an 'eName' is not recognized as an internal or external command error on PostgreSQL 11

Thanks to 123Haynes, Kevin George, Morshed Daud, pcable, Piotrek Zygielo, Simon Stelling, Tauri28, and terje2001 for reporting these issues and submitting pull requests.

New features

• Issue 441 Firebird 3.0, 4.0 support Pull Request

• Issue 1871 Colorized output

• Issue 2069 Validate migration encoding

• Issue 2276 Toggle display of query results Flyway Teams

• Issue 2398 PostgreSQL 12 support

• Issue 2426 Command-line: Update MySQL driver to 8.0.16

• Issue 2435 DB2 11.5 support

• Issue 2449 HSQLDB 2.5 support

• Issue 2449 Command-line: Update HSQLDB to 2.5.0

Changes

• Issue 2450 Unify database support policy in Enterprise edition

Incompatible changes

• Issue 2276 Query results are now also displayed in Flyway Community Edition when using SELECT statements

Bug fixes

• Issue 2224 Allow to specify target migrate version to match the default behavior

• Issue 2260 Callback output doesn't match execution order

• Issue 2272 Gradle plugin does not resolve implementation-scoped artifacts, only compile

• Issue 2352 Typo in MigrationType Javadoc Pull Request

• Issue 2355 gradle flywayMigrate failing on missing postgresql CopyManager

• Issue 2384 JavaUtilLog doesn't need to be instantiated with ClassUtils Pull Request

• Issue 2392 Mixed scripts above target trigger error when mixed=false

• Issue 2409 Flyway fails as SQLDroid misreports SQLite version as 0.0

• Issue 2410 MariaDB: clean fails when event scheduler is disabled

• Issue 2413 UTF-8 BOM stripping no longer works in 6.0.0-beta2

• Issue 2414 Incorrect detection of GO keyword inside identifiers

• Issue 2417 SQLite clean fails due to violated foreign key constraints

• Issue 2424 slf4j loggerNameMismatch warning disabled

• Issue 2425 Dry run failing on JDBC defined data types (see also 2462)

• Issue 2438 Redshift ALTER TABLE ALTER COLUMN isn't executed in transaction

• Issue 2441 Output latest supported DB version with warning

• Issue 2442 HSQLDB parser: IF EXISTS causes incorrect block depth count

• Issue 2446 Migration files with hard spaces don't work anymore

• Issue 2447 Flyway clean doesn't remove partition schemes and functions

Thanks to AigleeK, anjo-swe, Árpád Egyed, beyondlov1, Christian Swan, dnk8n, esauser, François Guillot, JohnEgan91, Kirill Vergun, krite, mpe85, Richard Glidden, Ryan McElroy, sdwarwick and voronaam for reporting these issues.

New features

• Issue 2318 Wildcards in errorOverrides Flyway Teams

• Issue 2326 Command-line: Update H2 to 1.4.199

• Issue 2354 Java 12 support

• Issue 2357 Command-line: Upgrade built-in JRE to OpenJDK 11

• Issue 2371 SQL*Plus SET/SHOW ECHO/TERMOUT/TIME/TIMING support Flyway Teams

• Issue 2393 Oracle 19c support

Bug fixes

• Issue 2243 When running multiple instances of the app, baselineOnMigrate is not working properly

• Issue 2245 Dependent jars for Java migrations not on class path, same as in issue #783

• Issue 2267 Windows: CLI fails with CLASSPATH env var set to a value containing brackets

• Issue 2270 LogFactory not initialized with the right classloader if first log is from the Flyway class

• Issue 2307 SQL Server: Incorrect syntax error using GOTO and Labels

• Issue 2308 Empty placeholders no longer work in 6.0.0-Beta

• Issue 2310 SQL*Plus parsing fails when statement is immediately preceded by comment

• Issue 2317 H2: Concurrent migration of empty database fails

• Issue 2325 Update H2Schema to work with DATABASE_TO_UPPER=false Pull Request

• Issue 2329 Cannot execute PostgreSQL migration that contains ? operator for jsonb

• Issue 2334 Enable configFiles configuration for maven plugin Pull Request

• Issue 2335 H2: clean does not remove function alias

• Issue 2338 Create stored procedure for MySql and MariaDB fails

• Issue 2341 MySQL: Reset SQL_SAFE_UPDATES and FOREIGN_KEY_CHECKS after each migration

• Issue 2347 Feature 'Display query results' doesn't give output in 5.2.4 Pro for Oracle

• Issue 2363 Undoable migrations not shown as undoable in flyway info

• Issue 2368 SQLPlusDefineSqlStatement should not depend on SLF4J

• Issue 2370 Debug level does not work for enterprise option

• Issue 2374 Dry run doesn't intercept UPDATE run with executeQuery()

• Issue 2379 DB2Parser struggles with block depth count

• Issue 2383 SQL*Plus @ with file path fails to load correct file

• Issue 2395 DB2: Clean excludes user-defined functions based on new classifications

• Issue 2397 SQL Server: clean doesn't work for system-versioned temporal tables

Thanks to alexander-semenets-dev, armondoortega, Cristina Petri, Ernst-Udo Wallenborn, Jeremy Fleischman, Joe Barnett, Josh Wheeler, KiruthikaSS, kwood612, Lucas Persson, Mária Jurcovicová, Me1gireesh, pvhors, Richard Glidden, Sofoklis Papasofokli, swanym, tcat2 and Tomáš Poledný for reporting these issues and contributing fixes.

New features

• Issue 865 Custom tablespace for schema history table

• Issue 1062 API: Make it possible to use pre-instantiated Java-based migrations

• Issue 2120 Add new oracle.sqlplusWarn setting Flyway Teams

• Issue 2167 Allow versioned migration names like V12.sql (no separator, no description)

• Issue 2178 PostgreSQL 11 support Pull Request

• Issue 2189 Gradle 5.0 support

• Issue 2216 CockroachDB 2.1 support

• Issue 2300 MariaDB 10.4 support

• Issue 2301 Command-line: Upgrade MariaDB JDBC driver to 2.4.0

• Issue 2302 Oracle SQL*Plus: support WHENEVER SQLERROR EXIT SQL.SQLCODE Flyway Teams

• Issue 2303 SQL Server 2019 support

• Issue 2304 Command-line: Upgrade SQL Server JDBC driver to 7.2.0

Changes

• Issue 2223 Database support timeline guarantees

Incompatible changes

• Issue 2120 Unsupported Oracle SQL*Plus now throw an error by default Flyway Teams

• Issue 2188 Discontinue Java 6 support

• Issue 2218 Remove deprecated APIs and settings. See issue for full details

Bug fixes

• Issue 63 Support trailing single line comments

• Issue 558 MySQL statement not recognized due to multiple comment directives on a single line

• Issue 1706 Parser does not support multiple statements per line

• Issue 2198 Flyway fails to find resources in Felix 6.0.1 environment

• Issue 2228 NullPointerException with PostgreSQL multi-statement CREATE RULE

• Issue 2232 Clean tries to drop a table from an extension and fails

• Issue 2236 canExecuteInTransaction is not respected by JavaMigration

• Issue 2242 CREATE FULLTEXT CATALOG statement cannot be used inside a user transaction

• Issue 2252 Oracle: Parser fails on VIEW ... WITH not followed by PL/SQL

• Issue 2263 Oracle: cleaning type fails with object does not exist

• Issue 2266 Flyway does not clean sequences in MariaDB

• Issue 2275 Unable to override error S00011:15404

• Issue 2280 Dry-run file contains statements with invalid syntax

• Issue 2281 Sybase ASE: parsing error with double-quoted string literals

• Issue 2284 Documentation Typo Pull Request

• Issue 2287 DB2: Clean excludes views whose names end with _V

• Issue 2288 Unable to discard a migration after undoing it

• Issue 2289 MariaDB not recognized with MariaDB JDBC driver 2.4.0

• Issue 2298 The procedures 'sp_serveroption' and 'sp_droplinkedsrvlogin' cannot be executed within a transaction

Thanks to AlBa231, armondoortega, asamonov, CobraFlow, esauser, Evan J. Ercolano, Gerd Behrmann, Guy Brand, jankoh, Jason Turim, Jonas Kongslund, jutoft, Lochan08, Renat Sabitov, Sabine Heimsath, smrutikanta-cog, svpace, tinybarks and tomas-silhavy for reporting these issues and contributing fixes.

Bug fixes

• Issue 2215 MySQL: Migrate fails when the user does not have permission to SELECT on user_variables_by_thread table

• Issue 2219 Undo followed by repair leads to corrupted schema history

• Issue 2220 Command-line on Windows: Locations with spaces fails with was unexpected at this time error

• Issue 2221 Flyway 5.2.2 incorrectly complains about required SQLite upgrade

• Issue 2222 SAP HANA: CREATE OR REPLACE not working

• Issue 2229 flyway.errorOverrides broken within callbacks

Thanks to ArunNeo, Jason Hinch, Jean-Pierre Froud, Kevin George, laurre and seb-urbaniak for reporting these issues.

Bug fixes

• Issue 2213 Flyway warns about Postgres 10.5 being unsupported

Thanks to Antti Lampinen for reporting this issue.

New features

• Issue 2210 SQL*Plus: Add support for SHOW/SET FEEDBACK/VERIFY Flyway Teams

• Issue 2212 Additional D and I behaviors for errorOverrides to turn specific errors and warnings into debug or info messages Flyway Teams

Changes

• Issue 2209 Integrate Trial Edition into Pro and Enterprise Editions

Bug fixes

• Issue 2185 CONFIG statement cannot be used inside a user transaction

• Issue 2190 SQLite: Migrations containing PRAGMA foreign_keys= should be marked as non-transactional

• Issue 2197 MySQL: User-defined variables leak across migrations

• Issue 2198 Flyway fails to find resources in Felix 6.0.1 environment

• Issue 2202 NullPointerException with PostgreSQL CREATE RULE statements

• Issue 2206 MariaDB: Can't create database 'null' error if no database was specified in URL

• Issue 2210 SQL*Plus: SHOW and SET should allow multiple commands on same line

Thanks to Gerd Behrmann, htto, pjchester, Renat Sabitov, seb-urbaniak and SH.Xue for reporting these issues.

New features

• Issue 2170 Command-line: Add flags for running specific editions

Bug fixes

• Issue 2169 setCallbacks inconsistent deprecation warning

• Issue 2171 MySQL Driver 5.1.x support

• Issue 2175 'sp_addsubscription' cannot be executed within a transaction

• Issue 2176 MySQL: Exception restoring original database on a connection to a dropped database

Thanks to edquan, GregorKo, seb-urbaniak and Stéphane Nicoll for reporting these issues.

New features

• Issue 705 Oracle SQL*Plus: Add support for executing external scripts using @other_script.sql Flyway Teams

• Issue 1289 Statement-level callbacks: before, after and after error Flyway Teams

• Issue 1324 Add initSql for all clients

• Issue 1556 Percona XtraDB Cluster support

• Issue 2033 Automatically set application name to easily identify Flyway connections

• Issue 2043 Introduce license key Flyway Teams

• Issue 2044 Flyway Command-line downloads now include all Flyway editions

• Issue 2068 MariaDB 10.3 support

• Issue 2093 Oracle 18c support

• Issue 2100 Aurora MySQL support

• Issue 2101 Aurora PostgreSQL support

• Issue 2106 Introduce single statement configuration and deprecate old configuration methods on Flyway class

• Issue 2119 SQL*Plus: Support SET LINESIZE Flyway Teams

• Issue 2124 Introduce connectRetries setting

• Issue 2128 Add an 'ignorePendingMigrations' configuration option Pull Request

• Issue 2144 Command-line: Bundle MySQL JDBC driver

• Issue 2150 Java 11 support

• Issue 2151 Command-line: Update SQL Server JDBC driver to 7.0.0

• Issue 2155 Command-line: Update HsqlDB to 2.4.1

• Issue 2156 Command-line: Update MariaDB JDBC driver to 2.3.0

• Issue 2157 Command-line: Update PostgreSQL JDBC driver to 42.2.5

• Issue 2158 Command-line: Update SQLite to 3.23.1

• Issue 2163 DB2: Enable human-readable error messages

• Issue 2164 Non-transactional Java-based migrations support

Incompatible Changes

• Issue 1807 Disable recursive filesystem scanning down hidden directories

• Issue 2165 MigrationResolver.resolveMigrations() now takes a Context parameter

• Issue 2165 MigrationExecutor has been moved to the new org.flywaydb.core.api.executor package

• Issue 2165 MigrationExecutor.executeInTransaction() has been renamed to canExecuteInTransaction()

• Issue 2165 MigrationExecutor.execute() now takes a Context parameter

Changes

• Issue 2147 Oracle 12.1 support is now Flyway Enterprise Edition-only

• Issue 2164 JdbcMigration and SpringJdbcMigration have been deprecated in favor of JavaMigration

• Issue 2164 BaseJdbcMigration and BaseSpringJdbcMigration have been deprecated in favor of BaseJavaMigration

• Issue 2164 MigrationInfoProvider , MigrationChecksumProvider and ConfigurationAware have been deprecated in favor of JavaMigration

Bug fixes

• Issue 1909 Flyway breaks when JDBC driver returns null URL

• Issue 2035 PostgreSQL: Restore role to its original value between migrations instead of resetting it

• Issue 2048 Oracle: Parser fails on CREATE VIEW ... AS WITH

• Issue 2071 DROP FULLTEXT INDEX statement cannot be used inside a user transaction

• Issue 2082 Non-transactional RECONFIGURE statement not working in SQL Server

• Issue 2088 Derby Embedded DB stays open when using the Gradle wrapper

• Issue 2095 Flyway fails to drop aggregate functions from postgres on clean

• Issue 2096 Sql Server schema clean throws exception for indices on virtual columns for json attributes

• Issue 2097 CockroachDB 2.0: Clean broken for sequences

• Issue 2115 Oracle SQL/Plus DEFINE should not be case sensitive

• Issue 2118 SQL*Plus: SET SERVEROUTPUT ON SIZE not processed correctly

• Issue 2123 Performance issue for the MySQLSchema doEmpty() call

• Issue 2134 PostgreSQL current schema function throws NPE instead of permission denied exception

• Issue 2136 Issues connecting to mariadb linux socket

• Issue 2143 COPY ... FROM fails if run after a single-line comment

• Issue 2148 Flyway uses schema_version table even if I specify the table to be flyway_schema_history

Thanks to Daniel Scott, DanskerDave, Elvadas NONO, Fabian Bergmark, Gili Tzabari, Guy Brand, hdconradi, HiddenKnowledge, JeP42, JLopeDeB, Joe Lee-Moyet, Matt Sprague, Matthew Burghoffer, Mihir Mehta, raffig, Reinhard Handler, Sajith1988V, swanke00, Tim Hadwen and Valentin Gohard for reporting these issues.

New features

• Issue 2054 Additional SQL*Plus SET commands support (ESCAPE, FLAGGER, HEADING) Flyway Teams

• Issue 2059 Warn about MariaDB driver usage when connection to MySQL 5.5+

Bug fixes

• Issue 2051 PostgreSQL: clean fails when trying to drop aggregates added by extensions

• Issue 2052 Regression Issue: Checksums invalid for blank migrations applied in v5.0.7 and below

• Issue 2053 Repeatable migrations produce invalid SQL during dry-run

• Issue 2060 SQL Server: error parsing string literals starting with 'as'

Thanks to CatalinaMoisuc, Craig Davidson, Paul Chown and Uri Hendler for reporting these issues.

Bug fixes

• Issue 2028 Unable to clean schema that contains a user-defined function with schemabinding in SQL Server

• Issue 2031 Warning: Input stream has been finalized or forced closed without being explicitly closed

• Issue 2037 Upgrade Maven plugins to protect against Zip Slip Pull Request

• Issue 2041 Sybase 15.7: Incorrect syntax near 'GO'

• Issue 2042 Workaround a bug in windows cmd Pull Request

• Issue 2045 Info: Synthetic migrations (like SCHEMA) should not show up as repeatable

• Issue 2046 ErrorOverrides fail to override warning into error

• Issue 2047 Batching sometimes executes statements twice

Thanks to Dar Brett, Esteban Marin, Piotrek Zygielo, seneiran and sullis for reporting these issues and contributing fixes.

Bug fixes

• Issue 1803 Postgres "ERROR: must be superuser to create a base type" during clean of DOMAIN

• Issue 2026 ErrorOverrides should also work with negative error codes

• Issue 2027 Getting 'ERROR: Validate failed' after upgrading from 5.0.7 to 5.1.0

• Issue 2029 Regression in 5.1.0 regarding non-transactional migrations including comments

Thanks to Patrick Kohan, Peter Matseykanets and Simon Kissane for reporting these issues.

DO NOT USE: This release contains an important checksum validation regression which has been fixed in 5.1.1.

New features

• Issue 94 Batch updates for SQL statements Flyway Teams

• Issue 104 Informix support

• Issue 615 Stream parser for SQL migrations Flyway Teams

• Issue 1315 SQL Callbacks - more than one .sql file per event

• Issue 1392 Callbacks for errors

• Issue 1675 ErrorOverrides: override errors into warnings and warnings into errors Flyway Teams

• Issue 1738 Allow extending classpath in gradle task config Pull Request

• Issue 1865 New option to allow for 'Ignored' migrations in 'validate' command: ignoreIgnoredMigrations Pull Request

• Issue 1877 Maven: Add a workingDirectory parameter to support relative filesystem locations in conf files

• Issue 1883 SQL*Plus variable substitution support Flyway Teams

• Issue 1928 Fluent configuration using API

• Issue 1936 Environment variable configuration using API

• Issue 1970 CockroachDB 2.0 support

• Issue 1980 Provide a default implementation of Configuration as part of the API

• Issue 2003 MySQL 8.0 support

• Issue 2019 Java 10 support

Incompatible Changes

• Issue 1707 FlywayConfiguration.getCallbacks() now returns Callback[] instead of FlywayCallback[]

• Issue 1707 Flyway.getCallbacks() now returns Callback[] instead of FlywayCallback[]

• Issue 1865 'Ignored' migrations now trigger an error by default. The old more lenient behavior can be restored by setting ignoreIgnoredMigrations to true

• Issue 1883 SQL*Plus support is now disabled by default and must be explicitly activated using the new oracle.sqlplus flag

• Issue 1928 Flyway now implements Configuration instead of FlywayConfiguration

• Issue 1928 FlywayConfiguration.getLocations() now returns Location[] instead of String[]

• Issue 1928 Flyway.getLocations() now returns Location[] instead of String[]

• Issue 1928 Flyway.getSchemas() now returns an empty array (instead of the connection's default schema) if no schemas were set using setSchemas()

• Issue 1946 FlywayConfiguration.getEncoding() now returns Charset instead of String

• Issue 1946 Flyway.getEncoding() now returns Charset instead of String

Changes

• Issue 1707 FlywayCallback and BaseFlywayCallback have been deprecated in favor of Callback .

• Issue 1928 FlywayConfiguration has been deprecated in favor of Configuration .

• Issue 1989 Flyway Command-line now ships with H2 1.4.197

• Issue 2007 Flyway Command-line now ships with MariaDB JDBC driver 2.2.4

• Issue 2013 Flyway Command-line now ships with Derby 10.14

• Issue 2014 Flyway Command-line now ships with JRE 8u172

• Issue 2015 Flyway Command-line now ships with SQL Server JDBC driver 6.4.0

• Issue 2016 Flyway Command-line now ships with PostgreSQL JDBC driver 42.2.2

Bug fixes

• Issue 100 Clean tries to drop a function from an extension and fails

• Issue 1362 Header comment on stored procedure

• Issue 1420 Line break settings are not respected (Windows)

• Issue 1707 Non-transactional SQL callbacks failing after upgrade to 4.2.0

• Issue 1876 Postgres COPY FROM STDIN fails on data containing string delimiters

• Issue 1892 Allow executing info while a migration is running

• Issue 1917 CommandLine Help / Usage for Community Editions shows PRO commands and options

• Issue 1918 UNC path support for filesystem locations

• Issue 1922 LogFactory should use same classloader for feature detection and loading the correct logcreator

• Issue 1923 Flyway Maven Plugin can't find JDBC driver if the driver is a dependency with scope provided

• Issue 1924 Too much memory allocations

• Issue 1926 PostgreSQL: Flyway uses "public" schema instead of current_schema when search_path starts with $user

• Issue 1927 Flyway 5 regression when line in multi line string starts with single line comment

• Issue 1932 Do not delete types that extensions depend on when cleaning PostgreSql Pull Request

• Issue 1940 PostgreSQL: Ignore objects created by extensions when checking whether a schema is empty

• Issue 1943 Flyway schema creation issue on Oracle 12.2 DB with password policy enabled

• Issue 1945 COPY ... FROM stdin throws "missing data for column" error

• Issue 1948 On PostgreSql the alternate quote string literal is not detected if it is not followed by a space

• Issue 1950 Repair dry-run: java.lang.IndexOutOfBoundsException

• Issue 1955 Redshift: Unable to create uppercase schema history table

• Issue 1959 PostgreSQL search path not restored properly after migrations when auto-comit == false

• Issue 1968 JDBC Migration failures not entered into schema_version table

• Issue 1979 Support for tnsnames.ora if TNS_ADMIN is set (issue #1806) does not work correctly

• Issue 1983 Failure on creation of a schema history table on an empty database when autoCommit is false

• Issue 1989 Clean cannot drop schema with H2 1.4.197 and newer

• Issue 1992 CREATE SUBSCRIPTION PostgreSQL statement not detected as non-transactional

• Issue 2011 SQL Server parsing issue when string literal is followed by as keyword without a space in between

• Issue 2025 Baseline migration is always updated when repairing

Thanks to aebaugh, AndrasJanurik, andrey-poltavskiy, Bartosz Kaminski, Ben Manes, bigslack, Brett Randall, Brian O'Halloran, brodgers-oreilly, Chuck May, cmcmurtrie, Craig Davidson, Daniel Huss, Dmitrii Apanasevich, Jens Doose, jezovuk, jMediaConverter, Kevin Sheedy, Konrad Botor, Leo Breuss, luengnat, Manikanta G, nireno, nkbysani, Oleg Artenii, Peter Wippermann, Punnapulusu, Razvan, Sandra Parsick, Simon Gamma, TimoTHa, umapathy08, Wim Deblauwe and Yannik Hampe for reporting these issues.