MySQL Component Release Notes
This page lists the main features added to the MySQL Component.
Feature Highlights
Version 2.0.3
Change Data Capture (CDC)
Multiple improvements have been performed to homogenize the usage of Change Data Capture (CDC) in the various Components.
Parameters have been homogenized, so that all Templates should now have the same CDC Parameters, with the same support of features.
Multiple fixes have also been performed to correct CDC issues. Refer to the changelog for the exact list of changes.
Version 2.0.2
JDBC Drivers classes and URLs
| Prerequisites + \ * xDI Designer S20.2.0 or higher (Legacy Version) |
xDI Designer 20.2.0 introduces an improvement which allows Components and Modules definition to provide themselves the proper JDBC drivers classes and URLs, for the connection wizard to automatically adapt depending on the Module selected.
This Component has therefore been updated to take into account this improvement and provide the necessary JDBC drivers classes and URLs information.
Version 2.0.1
Creation of columns with auto increment fixed
MySQL requires that a column defined as "auto increment" is also set as primary key.
If both conditions are not met the create table statement will fail.
From now, when creating such columns in MySQL, such as when using Replicator or Automation Templates, autoincrement columns will be properly created and defined as primary key to avoid issues with table creation.
Change Log
Version 2023.1.0 (MySQL Component)
New Features
-
DI-4673: The Create indexes on Target Table parameter has been added to the INTEGRATION MySql template.
-
DI-5437: Target filters have been added to the INTEGRATION MySQL template.
-
DI-6241: A mask is provided for the default constraint on columns, to match the MySQL syntax.
-
DI-7061: MariaDB - Third-party libraries upgrade.
Version 2.0.2 (MySQL Component)
Version 2.0.3 (MySQL Component)
New Features
-
DI-1910: Templates updated - New parameter 'Cdc Subscriber' on Templates on which it was not handled yet
-
DI-1909: Templates updated - New Parameters 'Unlock Cdc Table' and 'Lock Cdc Table' to configure the behaviour of CDC tables locking
Bug Fixes
-
DI-2174: Add missing BINARY, JSON, TINYTEXT, VARBINARY datatypes and fix creation mask for YEAR and BIT datatypes
-
DI-2891: MySQL requires 'auto-increment' columns to be defined as primary key, which was not the case in some situations when creating such columns using creation mask (fix performed in 2.0.1 version was unexpectedly not present in 2.0.2, putting it back)
-
DI-1908: Templates updated - The 'Cdc Subscriber' parameter was ignored in some Templates on Lock / Unlock CDC steps
-
DI-1907: Templates updated - The 'Cdc Subscriber' parameter was ignored in some Templates when querying the source data
Version 2.0.4 (MySQL Component)
New Features
-
DI-2545: Template - Load File to MySql - new parameter "Create Load Indexes"
-
DI-2546: Template - Load Rdbms to MySQL (with LOAD) - new parameter "Create Load Indexes"
-
DI-2664: MySQL Metadata - add json datatype
Bug Fixes
-
DI-2653: Template - Reject MySQL - when "delete from checked table" parameter is used, deleted rows should be conditioned to the current session id
-
DI-2655: Template - Reject MySQL - delimiter incorrectly generated on index names
-
DI-2662: Template - Reject MySQL - when the "delete rejects from checked table" parameter is used, the generated query should use joins instead of subqueries for performance purposes
-
DI-2745: Template - LOAD Rdbms to MySQL (with LOAD) - generated file names may unexpectedly contain object delimiters