Informix agent changelog

NOT NULL columns are reported as such by the MCP describe-table tool, instead of every column being reported as nullable;

The MCP describe-table tool returns the name of the type instead of the raw Informix type code, and no longer fails on an untyped NULL that Informix rejects;

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;

GSSD-1346: A bulk flush removes the rows it rewrites with a MERGE driven by the staging table, instead of a DELETE that scanned the whole target on every flush;

GSSD-1346: Staged updates are filled from one target row per key, so a key that is not unique on the target no longer fails the whole flush with error 26095;

GSSD-1366: The CDC engine is stopped when its agent is unassigned or closed, so a deleted pipeline no longer keeps a loop raising a CRITICAL error every 60 seconds until Core Hub is restarted;

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;

Target character columns: a value longer than its target column is now refused instead of being stored truncated with the transaction reported as written. Affects the IBM i series, Informix, MS SQL Server and Oracle targets, on the direct and the bulk write path alike (GSSD-1292, GSSD-1267);

Informix target: an overflow made only of blanks is still trimmed and written, since the server drops it anyway and a fixed-length source relies on it;

GSSD-1281: replaced UPDATE STATISTICS on the staging table with a proper index, removing the catalog lock held for the whole batch;

Fixed the connection pool silently overriding Informix Last Committed isolation;

Discovery failures now report SQLState, vendor error code and the full exception chain;

Fixed the database manager not being released on a failed column fetch;

GSSD-1281: replaced UPDATE STATISTICS on the staging table with a proper index, removing the catalog lock held for the whole batch;

Fixed the connection pool silently overriding Informix Last Committed isolation;

Discovery failures now report SQLState, vendor error code and the full exception chain;

Fixed the database manager not being released on a failed column fetch;

GSSD-1254: Added force for statistics update during bulk operation to improve performances;

GSSD-1253: Fixed match nullable key columns on the non-bulk write path;

GSSD-1142: Fixed queries not using prepared statement causing bad performances;

GSSD-1202: Added lock timeout configuration params (default to 15 seconds);

Fixed malformed create table statement;

Fixed an issue with the retrieval of composite keys from the information schema;

Added precision fallback for null datetime precision;

GSSD-1023: Refactored informix transaction engine events management to support multi table transaction events;

GSSD-990: Added support for trimming trailing spaces for text columns;

GSSD-999: Fixed missing support for new line inside queries

GSSD-1007: Fixed date and time parsing.

GSSD-999: Added missing backslash escaping that could cause quote without matching quote error;

Added transaction isolation level configuration;

Bulk loads support;

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

GSSD-893: Fixed an issue that could cause an incorrent checkpoint matching;

GSSD-845: Added missing datetime variants management;

Snapshot performance enhancements;

GSSD-762: Fixed Informix events management;

GSSD-813: Fixed Informix invalid session env var;

Database pooling technology;

GSSD-762: Fixed an issue that was causing the agent to fail when attempting to use the Ifmx CDC Engine;

Added support to database locale param;

Removed custom connection string support;

Agent compatibility upgrade to Gluesync 2.2;

Agent reconnection on connection loss;