MySQL Component Release Notes

This page lists the main features added to the MySQL Component.

Feature Highlights

Version 2.0.5

New Template

Creation of a new template : Load Xml to MySQL (with LOAD)

This template improves processing times by extracting the data from the xml file into the delimited files which are subsequently loaded to the target database, with a specific command.

Version 2.0.4

Minor improvements and fixed issues

This version contains some minor improvements and fixed issues, which can be found in the complete changelog.

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.

Datatypes and creation mask

Some datatypes such as BINARY, JSON, TINYTEXT and VARBINARY have been added in MySQL Component, they were missing.

Moreover, YEAR and BIT datatypes creation masks have also been fixed.

Version 2.0.2

Missing MEDIUMTEXT datatype

MEDIUMTEXT datatype has been added in MySQL Component, it was missing.

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 2.0.2 (MySQL Component)

New Features

  • DI-2115: MySQL Component - update module definition to propose more accurate driver and urls

Bug Fixes

  • DI-111: MySQL Component - addition of missing datatype "MEDIUMTEXT"

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

Version 2.0.5 (MySQL Component)

New Features

  • DI-4258: Template - New template "Load Xml to MySQL (with LOAD)"

  • DI-4425: MySQL Product - add a dedicated drop index mask to generate indexes using the MySQL specific syntax

Version 20.1.0

Bug Fixes

  • DI-387: MySQL requires 'auto-increment' columns to be defined as primary key, which was not the case in some situations when creating automatically such columns using creation mask (through Templates such as Replicator or Automation for instance)

Version 3.0.0 (Component Pack)

New Features

  • DI-4508: Update Components and Designer to take into account dedicated license permissions

  • DI-4962: Improved component dependencies and requirements management

Version 3.0.1 (Component Pack)

Bug Fixes

  • DI-5237: MySQL - the creation of a BIT column was unexpectedly failing when no size was defined, because an incorrect syntax was used