MySQL component release notes

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

Changelog

Version 2024.1.6

Bug fixes

  • DI-9291: Fixed an issue which caused an error when consulting data in a MariaDB table.

Version 2024.1.0

Features

  • DI-7621: Implement serializer functionality in Designer. Use the serializer in mappings to parse structured data from a source and flatten it to string data.

  • DI-8585: Update MySQL backend to the latest version.

Version 2023.4.0

Features

  • DI-6932: New template: DESERIALIZER MySQL String as JSON.

  • DI-8194: Third-party library upgrade.

Version 2023.3.0 (MySQL component)

Features

  • DI-4592: LOAD XML to MySQL: New parameter Create Load Indexes.

Bug fixes

  • DI-7969: LOAD XML to MySQL (with LOAD) template: java.sql.SQLFeatureNotSupportedException is thrown when using the template.

Version 2023.1.14

Bug Fixes

  • DI-9291: Fixed an issue which caused an error when consulting data in a MariaDB table.

Version 2023.1.1 (MySQL Component)

Bug fixes

  • DI-7142: When using the MariaDB third-party pack, MySQL’s JDBC URL is proposed instead of the MariaDB’s JDBC URL.

Version 2023.1.0 (MySQL component)

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)

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)

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)

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)

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)

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.