MySQL agent changelog

Arena batches are handed over in the order they were written instead of being re-sorted by transaction id, which on Oracle LogMiner inverted two changes sharing an SCN and wrote the older value to the target;

Booleans and maps keep their type through the arena cache, instead of reaching the target as "true"/"false" and as a non-JSON string;

The change readers are stopped when their agent is unassigned or closed, and the MySql and MariaDB binlog reconnect loop is cancelled on stop;

Added the source lag probe, reporting the unread change backlog and how far behind the last read transaction is;

GSSD-1357: The two unchecked arena length fields are now bounded, so a damaged arena is reported as a corrupted record instead of surfacing as a NumberFormatException or advancing the recovery scan into garbage;

GSSD-1357: An arena is no longer mapped at a size the filesystem refused to give it, which on a full disk wrote into a sparse region with no blocks behind it;

Replaced the Chronicle Queue source cache with ArenaCache, the local cache first proven on Oracle LogMiner. See Source agent caching layer;

GSSD-1200: Added missing quote column names in bulk load SQL;

GSSD-1184: Added hex decode while writing byte arrays to table using bulk operations;

GSSD-1184: Fixed byte array conversion for csv file used during bulk operations;

GSSD-1174: Fix missing column error while parsing events from BinLog;

GSSD-1120: Fixed deduplication logic for primary keys columns with case insensitive collation;

Added precision fallback for null datetime precision;

Added logic to recreate staging table for bulk operations to keep it aligned with entity schema;

Improved support for enhaced columns discovery (precision, lenght, scale);

Fixed possible duplicate key error using bulk operations for target agent.

Fixed possible loss of rows when data received from BinLog.

Snapshot performance enhancements;

Fixed enum/set data type not matching in UI;

Correctly quoted default values for strings and dates while preserving functions and numeric types;

Improved ENUM and SET type handling by using the full column type definition;

Disabled strict SQL mode during staging table creation to allow zero-date defaults like '0000-00-00'.

Fixed an issue that was causing the agent to fail when attempting to use unquoted identifiers;

The agent can now run without requiring BinLog to be activated on the source database (an error will be thrown if the user attempts to use CDC mode without BinLog enabled);

Optimized metadata queries;

Replace drop of staging table with Truncate operation in case of Bulk loads usage;

Agent compatibility upgrade to Gluesync 2.2;