org.flywaydb:flyway-sqlserver

Changes

• RGCompare MySql support has gone GA

Database compatibility

• Flyway now supports the latest version on SQL Server 2022.

Bug fixes

• incorrect license shown above correct license

• Issue 3682 Fixed parsing of boolean values in configuration

Thanks to TheHenrick for reporting these issues.

Bug fixes

• Fix missing Jackson-Annotation dependency in CLI bundle

Bug fixes

• Improved parsing of CASE expressions inside function bodies.

• Fixed a bug encountered when cleaning Azure Synapse instances where Flyway referred to 'sys.xml_schema_collections` which only exists in SQL Server.

Bug fixes

• Fixed exit code when report is disabled and error occurs

Changes

• The SQLite driver shipped with the Flyway CLI has been updated to 3.41.2.2 to avoid CVE-2023-32697

• Flyway's SQLPlus 'FEEDBACK' output wording has been adjusted to match Oracle SQLPlus.

Database compatibility

• Fixed an issue where IF(..) function calls in MySQL functions could cause the statement parser to incorrectly split the function in two

Changes

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

• Change error code on migration failure to be more specific and include script path and line number of failure in JSON error output

• Disable GET_LOCK on MariaDB connections when WSRERP=ON is present. This is to allow for usage of MariaDB with Galera clusters

• An event connection will be created to handle callbacks, and this connection will be released instantly after the event handle work is done.

• Baseline scripts with the same version number as an applied '<< Flyway Baseline >>' are now put in the 'Ignored (Baseline)' state. Also, migrations in this state appear before the '<< Flyway Baseline >>' in the info output instead of being put at the end.

• Update RGCompare version to 1.11.2.9265

New features

• Added driver() method to FluentConfiguration

Bug fixes

• Avoid hanging indefinitely during 'check' comparisons when running on Windows.

• Running check -changes or check -drift now handles schema creation rows in the schema history table.

Changes

• All undo migrations will no longer have their own rows in the ASCII-table output. This seemed redundant given that there's a separate Undoable column to provide this information. Also, there was some inconsistency whereby undo migrations in the AVAILABLE state were already filtered out but others were not.

• Baseline migrations now have the 'baseline' category in info output

• Issue 3665 Only warn if reports are unable to write to the default location rather than print an error

New features

• Flyway now handles defining PostgreSQL functions using BEGIN ATOMIC.

Java compatibility

• Bump maven version to address CVE-2021-29425

• Update documentation to provide solution to Snowflake JDBC JRE16+ issues

Thanks to sseide for reporting these issues.

Bug fixes

• Fixed the issue causing empty dry run reports when running flyway using the Maven plugin.

• Issue 3621 The Snowflake SQL parser can now handle escaping single quotes inside strings using backslash.

Changes

• Undo migrations which have not been applied will no longer cause validation to fail.

• add direct support for Alpine linux

• Remove unused Edition flags documentation, E.G -community or -teams. These flags are no longer used by Flyway and have been marked for deprecation. These flags will be removed in V10.

• Issue 3648 Ensure Flyway uses ALL_CREDENTIALS when using versions of Oracle where ALL_SCHEDULER_CREDENTIALS is deprecated. This is to avoid continuting to rely on functionality only retained in Oracle for backwards compatibility.

• Issue 3652 Remove redundant html extension on automatically generated reports and prevent generation of reports for currently unsupported verbs

New features

• Add Info report. You can now get a report of an info call as a tab in a flyway HTML report.

• We have improved support for WHENEVER SQLERROR EXIT in Oracle SQL*Plus. This now works on its own and no longer needs to be followed by FAILURE or SQL.SQLCODE.

• Add migration report

• Adding Flyway Reports; Single file HTML reports that expose important details and stats about your Flyway pipeline in an easy to read and share format.

Java compatibility

• Update version of snowflake-jdbc to 3.13.29 to fix SNYK-JAVA-NETSNOWFLAKE-5425048

• Issue 3664 Bump Snowflake JDBC to 3.13.3

• Issue 3664 ]Bump SQLite JDBC to 3.41.2.1 to address CVE-2021-20227, CVE-2022-35737 and CVE-2022-46908

• Issue 3664 Bump MariaDB JDBC to 2.7.9 to address race condition, metadata catalog, ArrayIndexOutOfBounceExcetions and other issues in JDBC driver

Thanks to lm-net, ryangraffy, jdmendozaa and frichtarik for reporting these issues.

Bug fixes

• Remove placeholder text from report summary

• Fix Nullpointer exception on empty exception in reports

Bug fixes

• Removed unwanted SLF4J messages on stderr

• Issue 3636 EnvironmentModel: swap back connectRetries and connectRetriesInterval default values

Changes

• Updated Postgres password change regex to use latest form

Java compatibility

• Update msal4j to fix SNYK-JAVA-NETMINIDEV-3369748

Performance improvements

• Reduce allocations from class loading through FeatureDetector

Thanks to mihalyr for reporting these issues.

Bug fixes

• Issue 3618 Fix reading in configuration from standard input in Teams and Enterprise edition.

• Issue 3621 Fixed a parsing error caused by begin transaction statements in Snowflake.

Changes

• Drift report titles have been renamed from 'Before' and 'After' to 'Expected' and 'Actual'.

Java compatibility

• Issue 3628 Update flyway-bom to use correct versioning system and deploy to Maven Central

Thanks to eddumelendez, frichtarik and Phil-Factor for reporting these issues.

Bug fixes

• SQL errors with configured overrides no longer cause the Oracle SQLPlus spool output to close prematurely and lead to a null pointer exception.

• Issue 3621 Further improvements to the Snowflake parser when detecting conditionally creatable objects.

Changes

• When running 'check' commands with involve database comparison (i.e. '-drift' and '-changes') and Flyway has debug enabled, debug output from the Redgate Compare engine will be logged as well.

Java compatibility

• Update Ant dependency version to address CVE-2020-11979, CVE-2021-36374, CVE-2021-36373 and CVE-2020-1945 vulnerabilities.

Thanks to frichtarik for reporting these issues.

Changes

• If Flyway encounters a SQL exception while Oracle Spool is set, the error information is now written to the Spool output.

Bug fixes

• Issue 3613 Allow the Snowflake parser to handle more conditionally creatable objects.

Thanks to niegowic for reporting these issues.

Breaking changes

• When Flyway is running in Oracle SQLPlus mode, character escaping is now disabled by default in order to be consistent with Oracle's SQLPlus command-line tool.

Bug fixes

• Issue 3616 Fixed a bug where migration patterns display names incorrectly changed case depending on default locale.

New features

• Introduced a flyway-bom pom for Maven. This BOM includes all modules of Flyway which are compatible with each other to be used in Maven dependency management.

Thanks to zihniogmen for reporting these issues.

Bug fixes

• Issue 3583 Fixed issues with the Snowflake SQL parser which failed to correctly parse scripting blocks containing 'if' and 'for' statements

• Fix issue with code analysis reports not generating when major or minor tolerance threshold has been passed and set build to fail.

Database compatibility

• Issue 3557 Update latest supported MariaDB version to 10.10

• Issue 3602 Flyway now officially supports snowflake versions up to 7.1

New features

• Added 'NON_EMPTY_SCHEMA_WITHOUT_SCHEMA_HISTORY_TABLE' as a new error code

Java compatibility

• As part of the ongoing work to improve Flyway we are looking at the current Java landscape and to the future. As a result, we are introducing Multi-Release builds for Flyway which will support Java 8 and Java 17. This allows us access to modern Java practices and technologies. This is with the aim to move fully to Java 17 in the next major release.

Thanks to pachu, hackyoMa and frichtarik for reporting these issues.

Bug fixes

• Explicitly drop Oracle package bodies so that package bodies not tied to an existing package are also cleaned

Changes

• 'check' reports now produce all successful reports and fail on the first non-successful report

• Update RGCompare engine to 1.6.0.7325

New features

• Regex Rule code analysis results now include the line and column number of where violations occurred

Bug fixes

• Issue 3581 Resolves migration resolvers not fully supporting instances for API users

Changes

• version operations (version or -v or --version) will now list the versions of all plugins (and if they are correctly licensed)

• Update AWS dependency to resolve CVE-2022-41915

Thanks to nafg for reporting these issues.

Bug fixes

• Flyway includes a custom SQL Fluff plugin, containing extra rules for enterprise users. Previously, if this custom plugin failed to install it would fail the whole process citing an absence of the correct SQL Fluff installation. It now only gives a warning so core SQL Fluff rules can still be run.

• Incorrectly errored when validating the configuration for the 'check -changes' command, when using a URL and a snapshot.

• Config parameter flyway.executeInTransaction should now correctly set when doing so via an environment variable.

• Issue 3582 Fix missing setBaselineVersion(MigrationVersion baselineVersion) on ClassicConfiguration

Changes

• Update RG Compare to 1.3.1.7159

Thanks to bmarcaur for reporting these issues.

Bug fixes

• Fix NPE that results when configuring either 'workingDirectory' or 'jarDirs'

New features

• Adds a new configuration parameter ('flyway.executeInTransaction') which determines whether SQL execution in a transaction is enabled.

Bug fixes

• Removed the parsing of nested multiline comments from Oracle. This is in line with their documentation that states nested multiline comments are not supported.

• Drift results now appear in the JSON and HTML reports when 'failOnDrift' is set and drift is present.

Changes

• The bundled Regex Rules are now case insensitive

• Update error message for invalid CLI argument to reflect possible fixes

• The version of the Postgres driver included in the CLI has been increased to 42.4.3 to avoid CVE-2022-41946

• Issue 3578 Fix documentation to use correct method to configure url, user and password in API

Database compatibility

• Support for BigQuery is now out of beta and in GA

Thanks to gastaldi for reporting these issues.

Changes

• The version of RG compare included with Flyway has been increased to 1.2.2.6628. This avoids a bug in which 'check' produced empty change/drift reports for certain SQL Server URLs.

• Upgrade the version of the Apache Ignite core dependency to avoid a new vulnerability.

Changes

• Check reports are written when an exception occurs

Bug fixes

• Fix issue with Regex Rules looking in the wrong directory by default

• Issue 3563 Fixed parsing error with batch statements in GCP Spanner.

Thanks to Glavis for reporting these issues.

Breaking changes

• Logic for the undo command has been moved into the separate 'flyway-proprietary' module, which will need to be present on the classpath in order to use the undo command. This also means that undo migrations will now be resolved in Community edition, and migrations may be marked as undone in the info output, though running the undo migrations still requires a Teams or Enterprise license. Lastly, when implementing undo migrations as java migrations, they should extend 'UndoJavaMigration' instead of 'BaseJavaMigration'.

Bug fixes

• Fix an issue where 'clean.mode' would not be detected in Enterprise

Changes

• We now use 'jackson-dataformat-toml' to read TOML config files, instead of 'night-config'.

• All 'check' results include the operation in the JSON result

• Include the code analysis engine's name in the summary logs

• Bump the version of Redgate Compare to 1.0.0.6319

• Move documentation to main repo

• Create a Dialect configuration to allow configuration of rules engine dialect via Flyway

• Add descriptions to shipped Regex Rules in the check report

• Bundled Regex Rules are now enabled by default

• Issue 3562 The version of 'jackson-dataformat' bundled in the CLI package has been bumped to 2.14.0 to avoid CVE-2022-42003

Database compatibility

• Issue 1317 Add SingleStoreDB support at the Teams level

• Issue 3570 Cockroach DB is now supported up to the latest version of 22.1

New features

• The JSON result for the 'check' command now includes the paths to any generated report

• SingleStoreDB JDBC driver is now shipped in the CLI

• Allows a configuration ('flyway.check.failOnDrift') to trigger an error if drift is detected with check -drift allowing the build to be halted should drift exist.

Thanks to nycjay, engvalla and basweitjens for reporting these issues.

Bug fixes

• Help output for 'check' no longer returns 'null' when 'outputType=json'

• Issue 3552 Fix Snowflake parser to handle nested 'BEGIN...END' statements

Changes

• Rule codes are now visible in Code Analysis HTML Reports

• Update version of MSAL4J to fix CVE-2022-42004

• Update AWS SecretsManager to fix CVE-2022-42004

New features

• Add bundled Code Analasys RegEx rules for Enterprise tiers

• A new rule has been added to the Flyway SQL Fluff plugin, which is applied when running code analysis. This rule checks that all tables created in TSQL have an 'MS_Description' extended property set in the same file.

• Add REGEX rules engine to -code for Enterprise tier

Thanks to pachu for reporting these issues.

Changes

• Move SQLFluff specific components into own module

• Increase hsqldb version from 2.6.1 to 2.7.1 to resolve CVE-2022-41853

• Issue 3489 PostgreSQL history table indexes and constraints now use the configured tablespace

• Issue 3516 Drop PostgreSQL DOMAINs with 'CASCADE'

New features

• Provide a Mac CLI for arm64 CPUs

• Issue 3535 Added error override behavior which excludes the full error/warning message and only shows the SQL state and error code.

Thanks to dev257, Peter-Laws and oaowren for reporting these issues.

Database compatibility

• Remove in-product warnings when using PostgreSQL 15

Changes

• Ensure correct version of SQL Fluff is installed

• Update version of 'commons-text' to fix vulnerability CVE-2022-42889

• Add edition to the version model

• When urls are unsupported by check, ascertain which ones are unsupported, and include them as part of the exception.

Database compatibility

• Issue 3539 Add support for PostgreSQL 15

New features

• Add custom code analysis rule that requires tables to have a primary key

• Add syntax highlighting to dry run reports

• Issue 3519 Replace SQLPlus placeholders that begin with a double '&'

Thanks to cowwoc and ben-peacock-uk for reporting these issues.

Changes

• Code analysis is now available in Community Edition

Database compatibility

• Add support for SQL Server 2022

New features

• Add configuration to allow flyway to fail when sqlfluff finds issues when running check code

Bug fixes

• Fix cases of 'cherryPick' causing issues with change and drift reports

• Fix bug where 'installedBy' wasn't always populated during a baseline

• Fixed bug when checking for changes or drift when multiple schemas are configured

Bug fixes

• Fix issues with Community Fallback

• Fix Windows paths with spaces causing classpath issues

New features

• Closed the Teams preview access to Change and Drift report. Please contact sales at sales@flywaydb.org for license information.

Skipped due to a regression.

Changes

• Add Community fallback warning to JSON output object

• Show correct validation message when checking for license keys that have expired.

Bug fixes

• Fix issue with Flyway not running correctly on Macs with a path that has a space

• Added null-check to avoid NPE when scanning inaccessible locations

• Fix bug in 'check' when comparing non-Oracle databases with configured schemas

• Issue 3515 Drop MariaDB JDBC driver back to major version 2 to enable MySQL compatibility

Changes

• Issue 3296 Schemas are now created if the user has edited flyway.schemas after an initial migration

Thanks to juliahayward and hemberger for reporting these issues.

Changes

• Check report UI improvements

• change and drift reports now fail for incompatible database types

Database compatibility

• Issue 3386 Updated to support Snowflake 6 and Snowflake Scripting

Java compatibility

• Remove JNA dependency as no longer needed by MariaDB

• Increase MariaDB driver version to 3.0.7

• Move flyway-commandline runtime dependency to correct scope

Thanks to filiprichtarik for reporting these issues.

Bug fixes

• Fix problems when appending to code analysis reports

• Fix bug in 'check -code' where multiple SQL files were not being correctly linted

• Configured suffixes are now case insensitive

Changes

• Improvements to the 'check' report

• Remove the error information from 'CompareResult' so that the existing JSON error handling is used

Java compatibility

• Remove unnecessary dependencies

• Moved Undo command into flyway-proprietary

• Remove unnecessary maven-model dependency

• Make 'CompositeResult' generic

• Issue 3505 Include transitive GAX dependency in CLI

Thanks to jward-premise for reporting these issues.

Bug fixes

• Issue 3499 connectRetriesInterval now defaults to 120 instead of 0 on the Maven plugin.

Changes

• code analysis now auto detects the dialect if a URL is provided, otherwise a '.sqlfluff' configuration file is needed

Thanks to mihalyr for reporting these issues.

New features

• Add SQLFluff to redgate/flyway Docker image for use with new integrations

Changes

• Issue 3498 Updated dependencies to fix vulnerabilities

New features

• Add 'dryrun' to check as a report that can be generated

Thanks to ggolawski for reporting these issues.

Changes

• Add access to Community features for Teams and Enterprise artifacts when no license key is given

• Issue 3491 PostgreSQL session locks now use one connection

Database compatibility

• Issue 3467 Added support for H2 2.1.214

Thanks to henricook and hackyoMa for reporting these issues.

Bug fixes

• check includes all transitive dependencies so it runs out of the box

• Issue 3479 BigQuery procedures containing END AS are not cut off early.

• Issue 3487 Update ensured supported to latest documented versions for Oracle and Snowflake

New features

• Issue 2895 Use transactional locks in PostgreSQL by default, which enables support for PgBouncer (session locks can be enabled again by setting 'flyway.postgresql.transactional.lock=false')

Java compatibility

• Update bundled JRE to latest version of Java 11 to include security updates

Thanks to arshaknorsoyan, matmannion and odin568 for reporting these issues.

Due to issues in the release process, this version is to be skipped as the artifacts are incomplete.

Due to issues in the release process, this version is to be skipped as the artifacts are incomplete.

Bug fixes

• Change reports now html encode SQL.

Bug fixes

• JSON output for 'drift' now always shows the 'driftDetected' field

Changes

• Improved tab styling of check reports

Changes

• Multiple 'check' reports now appear as tabs

• Serialize the LocalDateTime field in the check JSON result as a string

• No longer include .html when generating the JSON result for a check report

• bash entrypoint now adds 'native' folder to library path for use on Windows

• Only print the version information in Flyway once per execution

• No longer display the underlying 'DELETE' rows during 'info'

• License check now occurs when a Flyway object is constructed

Bug fixes

• Issue 3481 Fix cases where validation fails saying checksums of '0' are now 'null'

Thanks to henricook for reporting these issues.

Skipped due to a regression.

Breaking changes

• Migration patterns that are version numbers are treated as numbers rather than strings when matching to migrations

• Script & Java migrations are no longer executed during a dry run.

• 'getResolvedMigration' method on Java Migrations interface now takes a StatementInterceptor

• Don't clear the Url/Pass/Username when setting a data source

• Change default of cleanDisabled to true.

• Removed deprecated parameters for configuring secrets managers

• Removed parameter 'oracleKerberosConfigFile' as it is replaced by 'kerberosConfigFile'

• Removed parameters 'ignorePendingMigrations', 'ignoreMissingMigrations', 'ignoreIgnoredMigrations' and 'ignoreFutureMigrations' as they are replaced by 'ignoreMigrationPatterns'

• 'MigrationType' moved into 'extensibility' package as an enum and replaced with 'CoreMigrationType'

• 'SQL__BASELINE' and 'JDBC__BASELINE' migration types removed from 'flyway-core'

• 'CoreMigrationType' enum field 'baselineMigration' now called 'baseline', for which the type 'BASELINE' now returns true

• 'baselineMigrationPrefix' removed from Configuration - see the docs for this parameter for how to configure it via the API

• use 'BaselineJavaMigration' from the 'flyway-proprietary' package to make Java-based Baseline Migrations now

• Removed 'isUndo' and 'isBaselineMigration' from 'ResolvedMigration'

• 'Context' in 'resolveMigrations' on a 'MigrationResolver' is now a class which also has 'ResourceProvider', 'SqlScriptFactory' and 'SqlScriptExecutorFactory'

Changes

• Info filter 'infoOfState' now allows multiple states as a comma-separated list

• Handle errors (with warning) when cleaning procs on snowflake

• 'flyway/flyway-azure' Docker images are deprecated and replaced with 'flyway/flyway:*-azure'

Database compatibility

• H2 1.4 is now in Teams

• Oracle 12.2 is now in Teams

• MariaDB 10.2 is now in Teams

• HSQLDB 2.4 is now in Teams

• Issue 3469 Flyway CLI now bundles version 2.6.1 of the HSQLDB driver.

New features

• Add '-migrationIds' flag to 'info' to get a comma-separated list of versions or descriptions for repeatables

• Added the 'check' command to the Flyway CLI which lets you generate deployment reports. You can find more information here

Thanks to pzygielo for reporting these issues.

Bug fixes

• Issue 3388 The Ascii table will not be logged if there are no columns

• Issue 3428 Fix potential parsing bug during 'create package' statement in DB2

• Issue 3440 Always close the underlying Java connection inside a Database object

Thanks to CharmanderJieniJieni, AlexandruKetroy and medwards8 for reporting these issues.

Bug fixes

• Fix relative locations not being relative to the working directory

• Issue 3444 When using the delimiter keyword the value can be placed on the next line without entering an infinite loop

• Issue 3449 Update checker times out if it doesn't receive a response

• Issue 3454 The filename placeholder no longer causes errors in repeatable SQL migrations

Changes

• 'version' command now has JSON output

Thanks to sleepkever, csudhirr and alexandrugrigor for reporting these issues.

Changes

• Optimize param tokenization

• Update GCS dependency due to vulnerability

Java compatibility

• Update AWS ASK , AWS_SECRETSMANAGER-JDBC, Maven Core and MSAL4J dependencies to fix vulnerabilities

Bug fixes

• Fix NPE in Oracle when 'echo' is set to 'on' during spool

Changes

• Manually register the Oracle driver so Flyway CLI works with AWS Secrets Manager

Java compatibility

• Update recommended Spring JDBC version due to Spring vulnerability

Bug fixes

• Issue 3427 PLSQL division on new line in package body is no longer classified as a delimiter

• Issue 3433 Fix bug where connection details set in placeholders were overriding the main details

Changes

• Handle errors (with warning) when cleaning procs on snowflake

Thanks to olavquorum and bennyr1003 for reporting these issues.

Bug fixes

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

Thanks to cies for reporting these issues.