Oracle triggers agent changelog

GSSD-486: Fixed an issue with MERGE statements where applied in conjuction with target column data type length different from source column data type length;

Fixed an issue that was causing the Oracle Triggers Legacy agent not starting properly in certain scenarios;

GSSD-460: Added support for Long data types, and more generally LOB data types;

GSSD-460: Fixed NCHAR and NVARCHAR2 columns were generated with incorrect length definitions

GSSD-435: Improved performance of the triggers agent by adding support for range queries to mark the last processed transaction(s);

Added an additional index named _CONSUMED_INDEX to the auditing structure covering consumed transactions;

Updated the existing index named _INDEX to cover the remaining fields, especially the USER_NAME field that was not being indexed, potentially causing slow queries;

Added support for /*+ PARALLEL */ hint in the triggers SQL queries, customizable within the Oracle agent’s advanced settings (defaults to 4), only available on Enterprise Edition;

Fixed reserved keyword usage in queries when using Oracle as target agent;

Added Wallet authentication;

Fixed an issue that could prevent data to be synced when an entity was set to pause during an agent outage (restart or broken link issues);

Fixed a bug that was causing the replication to fail when the source table was having non contigue primary keys;

Fixed a bug that was leading the agent to allocate more CDC caching eviction jobs than actually required;

Fixed a bug when parsing a Date type;

Fixed a bug when handling source table partitions;

Relaxed check ahead of cast between date and datetime data types;

Fixed an issue that could cause a trigger with an outdated codebase to not being updated;

Fixed an issue with unhandled Char and Varchar data types when creating the underlining CDC table;

Support for same table names in different schemas;

Oracle Triggers agent now works even if COMPATIBLE flag is set to lower than 12.2, solving ORA00972 error by reducing the triggers auditing structure fields length to be less than 30 characters.

Added support for case sensitive objects names.

Fixed partitions queries;

Added CDC tables purge logic;

Fixed concurrent migration checkpoint update;

Added partitions support.

Fixed alias issue with reserved keywords;

GSSD-183: Added support for i18n in Oracle triggers agent;

GSSD-172: No table being shown while browsing Oracle target tables from a PDB direct connection under Oracle triggers agent;