NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
Maven Central, #784 by repository stars
Flyway: Database Migrations Made Easy.
Latest stable
13.13.0
Last release 2 days ago
20 Nov 2026
Ships on a steady schedule
a new release about every 2 weeks
Nearly every release is documented
notes for 60 of the last 60 stable releases
Nothing withdrawn
no release was ever pulled
13 years old
329 releases · first in 2014
Drag across the ruler to compare, or tap a release to open it.
Issue 3110 Correctly parse GO in identifiers
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
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.
Issue 3100 Add flyway:workingDirectory placeholder.
Thanks to everyone who reported these issues.
Your coding agent can read these notes before it upgrades. Set up the MCP server →
Issue 3084 Allow loading Gradle configuration artifacts outside of a Java project
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
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.
Issue 3088 Fix comparator exception in migration comparator
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
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.
Issue 3063 Drop SQLServer types at the database level
Issue 3063 Drop SQLServer types at the database level
Issue 3071 Support multiline boolean expressions for shouldExecute
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
Thanks to Sam-Redgate, StaffanHorke, TonytheEditor, chakrit, and scottsauber for reporting these issues.
Check that PostgreSQL advisory unlock result returns true
Check that PostgreSQL advisory unlock result returns true
Allow 'pro' in FLYWAY_EDITION environment variable
Remove warning following tests against Snowflake 5.1
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.
Alpine Docker image rebuilt based on openjdk:16-alpine to fix CVE (as 12-alpine is no longer maintained)
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
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.
Issue 3037 Only use external authentication if it is required
Issue 3037 Only use external authentication if it is required
Issue 3041 Correctly parse nested multi-line comments
Issue 3043 Case-insensitive HSQLDB parsing
Thanks to JeanFrancoeur, calvarius7, esauser, and tanguanpeng1234 for reporting these issues.
Issue 3026 Fix parsing of wrapped Oracle SQL
Issue 3026 Fix parsing of wrapped Oracle SQL
Issue 3029 Include classpath variable in bash script
Issue 3034 HSQLDB - successfully parse drop procedure
Issue 2239 New callback for custom schema creation SQL
Issue 3028 Support p6spy in URLs
Support reading configurations from Vault and Conjur
Thanks to RB14, calvarius7, ericparton, luoy1991, mLarsenAlkaDk, and tobato for reporting these issues.
Issue 3021 Don't cascade when dropping SAP HANA views
Issue 3021 Don't cascade when dropping SAP HANA views
Issue 3025 Check that connected keywords are on the same line when parsin in Oracle
Issue 3029 Use classpath environment variable in bash script
Issue 3031 Calculate correct 'undoable' value when using info filters
Correct name for MSSQL integrated security DLL
Only validate cherry-picked migrations
Use correct execution time in migrate result
Thanks to BaburaoLad, cesargomezvela, iggycoder, luoy1991, and rglidden for reporting these issues.
Issue 3010 Fix MariaDB block parsing
Issue 3010 Fix MariaDB block parsing
Issue 3019 Fix NPE when repairing failed repeatables
Thanks to adipata, bjaglin, and tatumsu for reporting these issues.
Issue 2914 Script filename placeholder introduced
Issue 2914 Script filename placeholder introduced
Issue 2953 If Flyway cannot connect to the database, retries are now made in an exponential backoff pattern
Issue 2992 Dry Run output can now be directed to AWS S3 or Google Cloud Storage (if relevant SDK is present)
Issue 2997 Add migration preconditions using shouldExecute in script config
Issue 2932 CockroachDB: lock indicators time out if left behind by Flyway erroring on bad scripts
Issue 2999 PostgreSQL 12: support for ALTER TYPE ... ADD VALUE being run in a transaction added
Issue 3005 PostgreSQL: cleaning no longer tries to drop extensions installed by a superuser
Issue 3010 MariaDB: script parsing error fixed
Thanks to adipata, axelfontaine, gendolf3d, OliverDTM and scranen for reporting these issues.
Issue 2953 Exponential backoff scheme for connect intervals
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
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.
Issue 960 Read MySQL credentials from option files
Issue 960 Read MySQL credentials from option files
Issue 2914 Add filename as a default placeholder
Option to filter info by migration state
Issue 2987 Display all validate messages in exceptions
Issue 2987 Ignore superseded repeatables when validating
Thanks to AigleeK, OliverDTM, ToBeReplaced, kasgilpofi, and wilkinsona for reporting these issues.
Issue 2991 Fix Teams upgrade exception incorrectly appearing in Community edition
Thanks to kasgilpofi, wilkinsona, and willy0275 for reporting these issues.
Issue 960 Support pgpass for authentication
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
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.
Thanks to A248, AigleeK, ToBeReplaced, aherkarsatish11, cheppsn, and yarhamjohn for reporting these issues.
Fix cherryPick feature name in exception
Fix cherryPick feature name in exception
Fix issue with licensing
Thanks to everyone who reported these issues.
Issue 2921 Support for Log4J v2
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
Thanks to Dan Carley and sniperrifle2004 for reporting these issues.
Issue 2969 Drop support for setting s3 client via fluent configuration
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.
Issue 2952 Confirm PostgreSQL 13 support
Issue 2921 Add Log4J v2 support
Issue 2919 Allow custom S3Client to be supplied
Issue 2871 Double quote migration names in logs
Issue 2957 Make AWS S3 SDK optional
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
Thanks to AigleeK, TheSench, gendolf3d, mLarsenAlkaDk, peng-ran, and pyrocks for reporting these issues.
Make validate messages suggest actions
Introduce Flyway Teams edition
Make validate messages suggest actions
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
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.
Deprecated command-line argument -logFile removed (see -outputFile for replacement)
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
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
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
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
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)
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.
Issue 2936 Update postgres driver version because of XXE vulnerability
Thanks to amccarthy and sstrang for reporting these issues and/or submitting pull requests.
Issue 2924 Improve mysql block handling
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.
Issue 2903 Fix resource resolving logic to be more performant
Thanks to leoherbie for reporting these issues and/or submitting pull requests.
Issue 2900 Make scanner resource look up case insensitive
Thanks to ekennedy247 for reporting these issues and/or submitting pull requests.
Issue 2887 Oracle SQL*Plus: Support @-style import of script file with absolute path
Issue 2887 Oracle SQL*Plus: Support @-style import of script file with absolute path
Issue 2889 SnowflakeDB: Support //-style single-line comments in scripts
Issue 2865 Remove unhelpful warning re. MariaDB driver / MySQL server following driver update
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.
Issue 2866 MySQL parser: fixed error around CREATE TABLE IF NOT EXISTS
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
Thanks to Nathan Ginther and Yvette Cook for reporting these issues and/or submitting pull requests.
Issue 2350 Added a config option to disable automatic schema creation
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
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.
Issue 2832 Fix bug with cleaning modules in DB2
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
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.
Issue 2559 Improve SQL*PLUS SET FEEDBACK support
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.
Issue 2810 CockroachDB history table locking
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.
Issue 2588 Ship Snowflake drivers
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.
Issue 1192 allow wildcard in flyway.locations
Issue 1192 allow wildcard in flyway.locations
Issue 2695 Enable piping of config files to command line
Issue 2182 PostgreSQL: Parse search_path to determine name of first non-existing schema to create
Issue 2756 Fix performance issue with the MySQLSchema doEmpty() call
Issue 2769 Don't prompt for user+password for Azure passwordless auth
Issue 2754 Baseline doesn't work if flyway_schema_history table exists
Issue 2678 Parameters in JDBC URL
Issue 2773 Flyway parsing bug: unable to decrease block depth below 0
Issue 2772 unable to decrease block depth below 0
Issue 2768 unable to decrease block depth below 0
Issue 2762 Flyway parsing bug: unable to decrease block depth below 0
Issue 2758 Block Depth Below 0 - MySQL 5.7 CREATE PROCEDURE
Issue 2770 No schema history found in dry run
Issue 2759 Failure to obtain Postgres 11 advisory lock
Thanks to Ali Ustek, Jörg Hohwiller, Alexis Deschamps, Ben Manes, Ben Manes, Jonas Natten, Jacquers, Damjan Vujnovic, Matteo Quintiliani, Chris Borckholder, and ln0v for reporting these issues.
Issue 2701 Oracle parser: Improve support for oracle statements separated by a /
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.
Issue 2132 Command line should not prompt for values if user and/or password are in PostgreSQL JDBC URL
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.
Issue 2709 flyway.url must be set when running command but already set in flyway.conf
Issue 2709 flyway.url must be set when running command but already set in flyway.conf
Issue 2447 Cleaning dry-runs
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.
Issue 1780 Flyway api load configuration files from the default locations
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
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
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.
Issue 2674 Oracle SQL*Plus parsing extended to support SPOOL
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.
Issue 2642 Package Oracle drivers
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.
Issue 2663 CockroachDB retrying mechanism
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.
Issue 2645 Support for Snowflake 4.2 verified
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.
Issue 2186 New option to explicitly validate SQL migration/callback script names
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.
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
Thanks to allenatdecisiv, esauser, Roman Dubinin, Marko K, Nicholas Fechner, stesix, rickselby and morl-la for reporting these issues and/or submitting pull requests.
Issue 2608 Unrecognized configration parameters all reported on at the same time
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.
Issue 2537 Unexpected error re. non-empty schemas
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.
Issue 2519 Previous fix also needed for Azure MySQL Database v8
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
Thanks to esauser, JFNGO, Joe Wu, SDepn, stevenenen and Tyson Gern for reporting these issues.
Issue 2560 Whitespace after / delimiter causes migration to fail
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.
Issue 1384 Special automatically-populated FLYWAY.CURRENT_SCHEMA placeholder
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
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.
Issue 2537 Unexpected error re. non-empty schemas
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.
Issue 2432 & in comments should not trigger SQL*Plus placeholder replacement Flyway Teams
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.
Issue 2445 Cockroach 19.1 support
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.
Nothing published for this version
Issue 2504 Flyway gradle task cannot open file within custom location (windows)
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.
Issue 2482 Warn about invalid Java migrations
Issue 2482 Warn about invalid Java migrations
Issue 2462 Dry runs: handle more JDBC types Flyway Teams
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
Thanks to cdalexndr, Ezra Epstein, Martin Konôpka and gorille for reporting these issues and/or submitting pull requests.
Issue 2436 H2 Oracle mode: Unable to create schema history table
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.
Issue 2470 Derby 10.15 support (see Derby documentation for compatibility notes)
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.
Issue 441 Firebird 3.0, 4.0 support Pull Request
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
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.
Issue 2318 Wildcards in errorOverrides Flyway Teams
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
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.
Issue 2218 Remove deprecated APIs and settings. See issue for full details
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
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
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.
One column per quarter.