SymmetricDS - Change Log

0006757: [Bug] ExtractDataReader support from target platform (josh-a-hicks) 0004643: [Bug] Initial load fails with DB concurrent error (pmarzullo)

0006774: [Bug] Sybase ASE unitext error when exceeding 8192 characters (elong) 0006799: [Bug] Old heartbeat batches syncing old heartbeat time (elong)

0006678: [Improvement] Support INCLUDE non-key columns for indexes in Postgres (awebb) 0006777: [New Feature] Add free disk space to runtime properties (awebb) 0006797: [Bug] Dbfill uses values too large for money data type on sql-server (elong) 0006798: [Bug] Sybase ASE unitext error when exceeding 8192 characters (elong) 0006800: [Bug] Old heartbeat batches syncing old heartbeat time (elong)

0006616: [Improvement] Save column references as numeric values for faster look-up in AbstractDatabaseWriter.getRowData() (pbelov) 0006687: [New Feature] Ready queues for more efficient push/pulls (elong) 0006734: [Improvement] Multi-threaded routing by channel enabled by default (elong) 0006244: [Improvement] Upgrade H2 library to 2.2 (emiller) 0006351: [Bug] Text and icons disappear in SQL Explorer TreeGrid when switching nodes (emiller) 0006429: [Improvement] Upgrade dependencies to latest versions (emiller) 0006537: [Improvement] Data gap detector should refresh cluster lock (elong) 0006538: [New Feature] Use source staging for incoming batch when engines are hosted together (elong) 0006577: [Improvement] Enable acceptance of cookies by default for compatibility with load balancers (elong) 0006663: [Bug] Logging of exceptions on data load can show values used in the wrong order when conflict resolution is in play (pmarzullo) 0006691: [Improvement] Skip querying of self-referencing foreign key child levels if constraints are deferred (elong) 0006692: [Improvement] Prevent logging of secrets in symadmin and wrapper (elong) 0006695: [Improvement] Increase the default max batch size for the reload channel (emiller) 0006703: [New Feature] System channel and queue for responsive data sync (elong)

0006729: [Bug] Sync triggers with $(targetExternalId) usage fails to avoid duplicate trigger names (pmarzullo) 0006730: [Bug] Sync triggers with $(targetExternalId) usage fails to avoid duplicate trigger names (pmarzullo) 0006735: [Bug] When cluster.lock.enabled is set to false, the unrouted data count is incorrect before the route job runs for the first time (emiller) 0006737: [Improvement] SQL Explorer DB Fill should allow specification of how many rows to commit at one time (pmarzullo) 0006741: [Bug] Change log level to WARN in DefaultDatabaseWriter.logFailureDetails (pbelov) 0006744: [Improvement] Mock DB classes and re-tool MsSql2000 and MsSql2008DdlReaderTest (pbelov)

0006716: [Improvement] Deadlocks on Sybase due to default table locking scheme being overly restrictive (pbelov) 0006637: [Improvement] Add support for Derby boolean data types (pbelov) 0006677: [Improvement] Support include column for SQL Server indexes (covering index) (pmarzullo) 0006690: [New Feature] Send Trigger DDL when sending table schema (pmarzullo) 0006702: [Bug] Failed to update sym_table_reload_request (elong) 0006704: [Task] unable to deploy WAR file in Tomcat 10 (elong) 0006706: [Bug] Error in DataService, not closing transaction object (pmarzullo) 0006708: [Bug] DDL Builder always sees a size difference for columns that are types without size when platform column exists (pmarzullo) 0006709: [Improvement] Support UUID column types (including DDL) directly for MySQL and MariaDB (pmarzullo) 0006710: [Improvement] Create parameter to keep bulk load files (for testing and development) (pmarzullo) 0006717: [Improvement] Improve logging of batch without batch ID (elong) 0006718: [Bug] Only default queue can push registration (elong) 0006721: [Bug] Data loader incorrect SQL error when no columns on target table match (elong) 0006722: [Bug] Purge of batches before data causes appearance of stranded data (elong) 0006725: [Improvement] Allow IClientReloadListener to be used on H2 and SQLite (elong) 0006728: [Bug] NullPointerException in JdbcSqlTransaction attempting to remove markers from a bulk insert with an exception (pmarzullo)

0006626: [Bug] Security review of springframework (pmarzullo) 0006661: [Bug] Logging of exceptions on data load can show values used in the wrong order when conflict resolution is in play (pmarzullo) 0006665: [Bug] New "Initial Load" not cancelling previous initial loads (emiller) 0006666: [Improvement] Initial load request should cancel outstanding load requests (emiller)

0004317: [Bug] Mssql - On table with VARCHAR (MAX) column Insert trigget fails (pbelov) 0006671: [Improvement] When SymmetricDS has to add a new column to a sym_ table in a Sybase ASE database, it can recreate the table unnecessarily (emiller) 0006676: [Improvement] Preserve comments on stored procedures when loading DDL changes (new parameter dataloader.sql.event.strip.comments) (cquamme) 0006689: [Bug] Postgres negative default values always show as changed (pmarzullo) 0006684: [Improvement] Switch recapture transaction ID to ISO timestamp to help diagnose stranded data issues (pbelov) 0006685: [Bug] Purge Service recaptures an Insert for stranded data after record had been deleted (pbelov) 0006686: [Bug] AppUtils static initialization of symmetric-impl.properties needs to try a different way to find file when running in containers (pmarzullo)

0006620: [Improvement] Turn on UNLOGGED table mode during initial load into an empty PostgreSQL table (pbelov) 0002298: [Bug] DDL detection of a default value for real/float column type on the Interbase is wrong (elong) 0006647: [New Feature] Pause/Resume Nodes (josh-a-hicks) 0006654: [Improvement] Info URL handler to use channel cache (elong) 0006655: [Improvement] Add REST API to clear node host entries (elong) 0006657: [Bug] Data reload events with reload where clause should not be routed in common mode (pmarzullo) 0006659: [Bug] Custom data types causing sizing detection issues on table comparisons (josh-a-hicks) 0006662: [Bug] Logging of exceptions on data load can show values used in the wrong order when conflict resolution is in play (pmarzullo)

0006621: [Bug] NVARCHAR(MAX) and VARCHAR(MAX) columns get modified when another column is updated (SQLServer-specific) (pbelov) 0006608: [Improvement] Performance bottleneck in file change detection for >1M files (pbelov) 0006540: [Task] database.dtd could be updated to reflect support for NVARCHAR (and other n-types) (elong) 0006593: [Bug] DDL change cannot alter column to nullable on H2 (elong) 0006610: [Improvement] Move Tibero support to Pro (josh-a-hicks) 0006611: [New Feature] Auto resolve conflict of delete of missing rows by capturing delete (elong) 0006612: [Bug] MySQL 5.1 query error because generated columns not supported (elong) 0006617: [Bug] Update trigger to accommodate NULLs for unique index with NULLable columns (pbelov) 0006618: [New Feature] Group link flag to control syncing of SQL/DDL events (elong) 0006622: [Bug] Conflict detection for log miners need to use the correct database connection (pmarzullo) 0006623: [Bug] The isNull transform converts an empty string to NULL (pbelov) 0006624: [Improvement] Faster snapshot exports and more checkpoint progression (elong) 0006627: [Bug] DDL replication stuck from reader on another connection (elong) 0006630: [Bug] Initial load with delete first captures the deletes when source and target are log mining nodes (pmarzullo) 0006631: [Improvement] Deployment of WAR on Tomcat 10 (elong) 0006641: [Improvement] BasicDataSourceFactory should not set user and password if they are empty (pmarzullo) 0006645: [Improvement] Update jetty server dependency to 11.0.24 (elong) 0006646: [Bug] Setting node.offline parameter to true or false disables all communication (pmarzullo)

0006597: [Bug] Registration batch fails with foreign key error (elong) 0006592: [Improvement] Added currentRowCount to process info. Updated DataService (mdrouard) 0006600: [Bug] DDL replication of create table with insert in same transaction (elong) 0006603: [Bug] NULL-able trait is not preserved, when column referenced by a unique index (pbelov) 0006598: [New Feature] IPurgeListener needs to have the capability to run functionality before the purge outgoing/incoming is run (pmarzullo) 0006604: [Bug] Upgrade Spring libraries (elong) 0006594: [Improvement] Support DDL for automatic update of timestamp by database (elong) 0006602: [Bug] MySQL/MariaDB treat bit type with size greater than 1 as integer (elong) 0006590: [Bug] Empty LOB loads as null on Oracle (elong) 0006586: [Bug] StackOverflow on startup with DB2 LUW (elong) 0006578: [Improvement] SQL Server support for datetime and datetime2 column types when the paramter db.treat.date.time.as.varchar.enabled is true (josh-a-hicks) 0006575: [Improvement] Service wrapper should warn if incompatible Java version (elong) 0006576: [Improvement] Disallow HTTP methods not needed for data sync (elong) 0006572: [Bug] SQL Server updates create duplicate rows with datetime2 in primary key (elong) 0006571: [Bug] Database trigger is left on table after removing configuration for it (elong) 0006569: [Improvement] Symadmin option to drop SymmetricDS triggers (elong) 0006567: [Bug] Outgoing and incoming error tables sync to wrong targets (elong) 0006566: [Bug] Load cancellation not working from client node (mdrouard) 0006565: [Bug] Java Load Filter compilation error when some categories are blank. (mdrouard) 0006562: [Bug] Stream LOB when row is deleted can get exception ColumnNotFoundException (elong) 0006559: [Improvement] Purge and recapture can cause exception in routing (elong)

0006521: [Improvement] Initial load request should cancel outstanding load requests (elong) 0006475: [Bug] New "Initial Load" not cancelling previous initial loads (elong) 0006545: [Improvement] MSSQL create table support for user defined types (josh-a-hicks) 0006529: [Improvement] Do not data load columns that are generated (computed) (josh-a-hicks) 0006557: [Improvement] Filter extension point during extraction (elong) 0006552: [Bug] SQL Anywhere fails to call DatabaseMetaData.getSchemas() (pmarzullo) 0006535: [Improvement] Support for MySQL 5.1 with latest 3.15.x versions (josh-a-hicks) 0004000: [Bug] java.lang.NoClassDefFoundError: org.jumpmind.symmetric.io.stage.StagingManager$1, even though the class exists in the jar file 0006526: [Bug] Triggers aren't synced after schema changes. (elong) 0006482: [Bug] Could not find trigger history causes error of wrong number of columns data validation in wrong column (elong) 0006485: [Bug] Do not issue foreign key correction for non-DML events (elong) 0006510: [Bug] SQLite with initial load in background can hang (elong) 0006547: [Bug] Prevent registration of registration server or empty node group (elong) 0006524: [Bug] Symadmin sync-triggers command does not update triggers (emiller) 0006539: [Bug] FileSyncDataRouter should handle initial load that uses an initialloadselect like other routers (pmarzullo) 0006528: [Improvement] Upgrade sybase JDBC driver to jconn4 version 16.0 build 27538 (pmarzullo) 0006533: [Bug] mssql-jdbc 12.6.1 SocketTimeoutException (elong) 0006531: [Bug] 0006530: Conflict resolution needs to set source node ID when executing conflict resolution for a SQL Server log mining node (pmarzullo) 0006520: [Bug] Trigger template replacement for SQL Server and Sybase not replacing channel id variables correctlly (pmarzullo) 0006513: [Bug] File Sync Tracker changes to improve performance and to collect completely the set of files (pmarzullo) 0006517: [Bug] Multi primary incorrectly detected when group link is routes only (elong) 0006516: [Improvement] Routing process status and lock improvements (elong) 0006515: [Bug] Incoming batch from reload missing table summary when 0 rows (elong) 0006219: [Improvement] Make Sybase ASE triggers use an "insert ... select" statement instead of a cursor (pmarzullo) 0006514: [Bug] H2 always reconfiguring sym_node table when schema XML changes most_recent_active_table column from varchar to varchar(255) (pmarzullo) 0006507: [Bug] Values can be matched with the wrong columns during extraction when using targetExternalId variable and table definitions differ (emiller) 0006508: [Bug] SQL-Server DDL table alterations when change not needed (elong) 0006503: [Bug] Sync on incoming batch setting does not get applied if a group link exists with the same source and target group ID (emiller) 0006505: [Bug] Service error and bad request are using same 601 http error code (elong) 0006488: [Bug] org.hsqldb.HsqlException: length must be specified in type definition: VARCHAR (pmarzullo) 0006487: [Bug] Wildcard trigger definitions do not remove existing triggers when adding a NOT table name to wild carded definition (pmarzullo)

0006555: [Bug] CPU monitor is inaccurate for systems with a Mac or Linux OS and more than 1 core (emiller) 0006477: [Bug] If auto resolve missing foreign key fails, try again (elong) 0006484: [Bug] Do not issue foreign key correction for non-DML events (elong) 0006530: [Bug] Conflict resolution needs to set source node ID when executing conflict resolution for a SQL Server log mining node (pmarzullo) 0006506: [Bug] Values can be matched with the wrong columns during extraction when using targetExternalId variable and table definitions differ (emiller) 0006502: [Bug] Sync on incoming batch setting does not get applied if a group link exists with the same source and target group ID (emiller) 0006489: [Bug] CPU monitor should use Java routine if native command not available (pmarzullo) 0006486: [Bug] Wildcard trigger definitions do not remove existing triggers when adding a NOT table name to wild carded definition (pmarzullo) 0006483: [Bug] Could not find trigger history causes error of wrong number of columns data validation in wrong column (elong) 0006467: [Bug] Symadmin export-sym-tables subcommand doubles the table prefix when called without the --alters option (emiller) 0006446: [Improvement] Provide the ability to specify a no lock hint when reading DDL (pmarzullo) 0006441: [Bug] NullPointerException when searching for a matching trigger history and row_data or pk_data is null (emiller) 0006400: [Bug] Issue with file sync when successful, retry is tried even when bean shell script is successful (pmarzullo) 0006393: [Bug] When building DDL for SQL Server, default values of 'true' or null for bit columns get changed to 0 (emiller)

0006460: [New Feature] Add symadmin export-sym-objects subcommand (emiller) 0006459: [Bug] Unitext Columns fail during initial load (jvanmeter) 0006424: [Bug] Statistics for synchronization should not be saved when batch is in error (pmarzullo) 0006478: [Improvement] Column match router expression for has, starts with, and ends with (elong) 0006476: [Bug] If auto resolve missing foreign key fails, try again (elong) 0006473: [New Feature] Add a --use-sym-db option to the DbImport and DbSql commands (emiller) 0006469: [Improvement] Add a section to the user guide that explains how to add a new node without having SymmetricDS run any DDL (emiller) 0006468: [Bug] Symadmin export-sym-tables subcommand doubles the table prefix when called without the --alters option (emiller) 0006465: [Improvement] Prevent sync triggers from running the trigger DDL when it's called to export a SQL script (emiller) 0006458: [Bug] DB Compare unable to process Unitypes in both directions. (jvanmeter) 0006453: [Bug] SQL Explorer tree displays schemas incorrectly when using Postgres JDBC driver version 42.7.0 or later (emiller) 0006452: [Bug] Newer wins conflict detection table case when cross platform (elong) 0006449: [Improvement] Add a "Show Triggers" option to SQL Explorer (emiller) 0006448: [Improvement] Provide the ability to specify a no lock hint when reading DDL (pmarzullo) 0006447: [Bug] Stack overflow when inserting last gap (elong) 0006442: [Bug] NullPointerException when searching for a matching trigger history and row_data or pk_data is null (emiller) 0006433: [Bug] Exception when auto resolver tries to lock row in conflict (elong) 0006434: [Improvement] Logging of mismatch primary key that causes auto resolver action (elong) 0006435: [Improvement] Avoid checking newer capture time if table isn't being captured (elong) 0006406: [Bug] Trigger Sync do not capture updates on included_column_names or excluded_column_names (elong) 0006420: [Bug] SQL Server money data type error with commas (elong) 0006419: [Bug] Stopping an engine from JMX sets the auto.start.engine false for ALL engines. (jvanmeter) 0006415: [Bug] Recapture data for stranded data and for expired data gaps should keep the old data values to allow subselect routing to work (pmarzullo) 0006414: [Bug] Stream Lobs setting does not work with Sybase ASE Unitypes (jvanmeter) 0006413: [Improvement] DBImport should have option to adjust create.index.convert.unique.to.nonunique.when.columns.not.required param (cquamme) 0006401: [Bug] Issue with file sync when successful, retry is tried even when bean shell script is successful (pmarzullo) 0006394: [Bug] When building DDL for SQL Server, default values of 'true' or null for bit columns get changed to 0 (emiller)

0006373: [Bug] SQLite purge fails with unrecognized token: "{" (elong) 0006362: [Bug] Upgrade Jetty libraries (elong) 0006383: [Bug] DB Compare fails to work bidirectionally when using Unitypes (jvanmeter) 0006385: [Bug] Error on registration batch or import of config from newer 3.14 or 3.15 (elong) 0006375: [Improvement] File Sync exceptions thrown by bsh script should be retried for transient errors (pmarzullo) 0006363: [Bug] Auto resolve delete of blocking rows when binary type in primary key (elong) 0006365: [Improvement] Add logging when instance ID changes (emiller) 0006370: [Bug] MySQL 5.5 and earlier don't allow timestamp precision (elong) 0006369: [Improvement] REV_INITIAL_LOAD_TIME should be set in the NODE_SECURITY table if a reverse initial load is made (cquamme) 0006361: [Bug] NullPointerException when sending a load with file sync enabled and without a valid sym_trigger_hist row for sym_file_snapshot (emiller) 0006359: [Bug] Purge of stranded data fails on Sybase ASE (elong) 0006357: [Bug] Initial load with overridden symmetric table trigger definition should skip symmetric tables when creating create table events (pmarzullo) 0006347: [Bug] Support SQLServer float positive negative infinity value (elong)

0006374: [Improvement] File Sync exceptions thrown by bsh script should be retried for transient errors (pmarzullo) 0006384: [Bug] Error on registration batch or import of config from newer 3.14 or 3.15 (elong) 0006364: [Improvement] Add logging when instance ID changes (emiller) 0006367: [Bug] Auto resolve delete of blocking rows when binary type in primary key (elong) 0006360: [Bug] NullPointerException when sending a load with file sync enabled and without a valid sym_trigger_hist row for sym_file_snapshot (emiller)

0006311: [Bug] Failed to decrypt password counter measure if node registration is already open (elong) 0006323: [Bug] Routing file deletes causes null pointer exception when capturing statistics (pmarzullo) 0006326: [Bug] Spring Framework URL Parsing with Host Validation (part 2) (elong) 0006327: [Bug] Specifying a reload channel ID for the channel_id in sym_table_reload_request results in the load getting stuck (emiller) 0006331: [Improvement] Allow specification of initial load select for initial load of filesync channel (pmarzullo) 0006334: [Bug] File sync batches get synchronized when there is an error during extraction (emiller) 0006341: [Bug] Index out of bounds routing change to sym_node_group_link (elong)

0006350: [Bug] H2 version 2 LONGVARCHAR implementation uses VARCHAR(1000000000) (pmarzullo) 0006321: [Bug] Issues using DB Compare with Unitypes (jvanmeter) 0006356: [Bug] Creating a table in a load was not checking if platform column existed (jvanmeter) 0006355: [Bug] Support autosave=always mode on PostgreSQL (elong) 0006310: [Bug] Sybase ASE 12 can only quote column names 28 characters or less (elong) 0006313: [Bug] Sync triggers for table should treat null or blank catalog/schema as default catalog/schema (elong) 0006315: [Bug] MySQL and MariaDB create table support for UNSIGNED columns (josh-a-hicks) 0006318: [Bug] NullPointerException while extracting data on SQLite as the typeName is not being set by driver (jvanmeter) 0006320: [Improvement] Parameter for file sync compression of ZIP archive (elong) 0006325: [Bug] Spring Framework URL Parsing with Host Validation (part 2) (elong) 0006328: [Bug] Specifying a reload channel ID for the channel_id in sym_table_reload_request results in the load getting stuck (emiller) 0006333: [Improvement] File sync BeanShell script should place files in a separate error directory if any error occurs when they are copied (emiller) 0006335: [Bug] File sync batches get synchronized when there is an error during extraction (emiller) 0006343: [Bug] DbCompare on Postgres not using cursor with fetch size (elong) 0006346: [Improvement] Use read uncommitted for checking heartbeats and offline nodes (elong) 0006352: [Improvement] Improve logging when a problem occurs during repair of unrouted data (elong) 0006353: [Bug] Recapture data in purge service should not handle pre-routed data records (pmarzullo) 0006342: [Bug] Index out of bounds routing change to sym_node_group_link (elong) 0006332: [Improvement] Allow specification of initial load select for initial load of filesync channel (pmarzullo) 0006324: [Bug] Routing file deletes causes null pointer exception when capturing statistics (pmarzullo) 0006312: [Bug] Failed to decrypt password counter measure if node registration is already open (elong)

0006170: [Bug] DB Compare incorrectly comparing values (jvanmeter) 0006252: [Bug] ASE large column types for primary keys need to limit max size based on page size (pmarzullo) 0006253: [Bug] Issue with Initial loads when using Sybase ASE Unitypes while using JTDS driver (jvanmeter) 0006256: [Improvement] Add virtual column to sym_file_snapshot for easier routing by column match and bean shell routers (pmarzullo) 0006259: [Bug] Sync triggers is mis-detecting last update time on sym triggers (elong) 0006264: [Bug] Include source_node_id in the where clause when updating or deleting from sym_table_reload_status (emiller) 0006267: [Bug] Prevent columns from being created with a size of 0 (emiller) 0006270: [Bug] Prevent OracleSymmetricDialect from underestimating the current value of a sequence (emiller) 0006271: [Bug] Finding trigger histories should treat null or blank as default catalog/schema (elong) 0006272: [Improvement] Startup logging for specific node securities that can't decrypt (elong) 0006275: [Bug] FileSyncDataRouter gets FileTriggerRouters from database instead of cache (pmarzullo) 0006278: [Improvement] Change file sync processing to make immediate request when batches are received or sent (pmarzullo) 0006279: [Improvement] Make File Sync Tracker transactions smaller to minimize locking collision problems (pmarzullo) 0006283: [Bug] Spring Framework URL Parsing with Host Validation (elong) 0006285: [Bug] Memory leak in MSSQL JDBC driver 10.2.0 (elong) 0006292: [Improvement] File sync BeanShell script should place files in a separate error directory if they are not writable (emiller) 0006296: [Bug] DefaultDatabaseWriter sql(...) method parsing sql statement during exception needs changed (pmarzullo) 0006297: [Bug] Upgrade mysql, postgres, vaadin, jetty libraries (elong) 0006301: [Improvement] Update Rest Keys docs to reflect correct error code (cquamme) 0006302: [Bug] Unable to set web context path with symmetric.server.web.home (elong) 0006300: [Bug] Hot spot removing old node sessions in mixed environment with versions < 3.11 (elong) 0006201: [Improvement] Add support for NTypes in XML (cquamme) 0006288: [Bug] Writing table definitions from xml for indexes that do not have a corresponding platform index (josh-a-hicks) 0006217: [Bug] Schema information missing from drop index query generated by DDL on PostgreSQL 0006229: [Bug] Old stage files used after node is rebuilt (elong) 0006240: [Improvement] Failed to update a table_reload_request as processed for loadId (elong) 0006243: [New Feature] Support H2 version 2.2 (emiller) 0006251: [Bug] BSH column transform column names can conflict with built-in variable names (elong) 0006246: [Bug] Cancel Load needs to make sure processes threads shut down before updating outstanding load request records (pmarzullo) 0006226: [Bug] H2 DDL Builder incorrectly adds size information to "UUID" data type (cquamme)

0006263: [Bug] Include source_node_id in the where clause when updating or deleting from sym_table_reload_status (emiller) 0006266: [Bug] Prevent columns from being created with a size of 0 (emiller) 0006269: [Bug] Prevent OracleSymmetricDialect from underestimating the current value of a sequence (emiller) 0006274: [Bug] FileSyncDataRouter gets FileTriggerRouters from database instead of cache (pmarzullo) 0006282: [Bug] Spring Framework URL Parsing with Host Validation (elong) 0006298: [Bug] Upgrade mysql, postgres libraries (elong) 0006299: [Bug] Hot spot removing old node sessions in mixed environment with versions < 3.11 (elong) 0006273: [Improvement] Startup logging for specific node securities that can't decrypt (elong) 0006245: [Bug] Cancel Load needs to make sure processes threads shut down before updating outstanding load request records (pmarzullo)

0006198: [Improvement] Record failed sync trigger attempts to database in trigger history and stats (elong) 0004617: [Bug] Corrupted row data during extract 0006174: [Improvement] Could not find trigger history, causes error of had X columns but expected Y (elong) 0006188: [New Feature] Add boolean data type support for Oracle 23c (cquamme) 0006189: [Improvement] Issue with syncing BIGINT, INT, TINYINT, SMALLINT, and BIT data types to Oracle and Tibero databases (cquamme) 0006194: [Bug] Postgres XML incorrectly identifies "BOOLEAN" as "BIT" (cquamme) 0006195: [Bug] symadmin module error when file exists without a dot (elong) 0006205: [Bug] Syncing a NCLOB from Oracle to Postgres results in an error (cquamme) 0006206: [Improvement] Add LOB Mapping for SQL Server 2005 and later (cquamme) 0006207: [Bug] Reverse initial load sometimes doesn't start when also using forward initial load (elong) 0006210: [Improvement] "Node failed to authenticate" in server logs after server restarts or client session expires (elong) 0006214: [Bug] SQLite sync error on sym_table_reload_request when db.treat.date.time.as.varchar.enabled (elong) 0006224: [Bug] Imported configuration sometimes gets deleted from sym_data (emiller) 0006212: [Bug] Registration error: sym_parameter changes causing sync triggers need to be limited to DML changes (pmarzullo) 0006193: [Bug] Adjusting unique indexes to non-unique when columns can be null should be able to be turned off by parameter (pmarzullo) 0006165: [Improvement] During an upgrade, log DDL before executing it instead of afterwards (emiller) 0006168: [Bug] File sync push is rejected because of a lack of a reservation (pmarzullo) 0006171: [Bug] Cookies required error when both http and https enabled (elong) 0006176: [Bug] Upgrade Jetty (elong) 0006184: [Improvement] Multi-threaded routing and gap detection (elong) 0006185: [Improvement] Unnecessary unrouted batch appears along with routed batch (elong) 0006178: [Improvement] Snapshot util timeout for taking too long on table definitions (elong) 0006163: [Bug] Snapshot error from database time on Sybase ASE/ASA (elong)

0006192: [Bug] Adjusting unique indexes to non-unique when columns can be null should be able to be turned off by parameter (pmarzullo) 0006199: [Improvement] Remove securityToken parameter from /outgoingBatchSummary REST API call (emiller) 0006209: [Improvement] "Node failed to authenticate" in server logs after server restarts or client session expires (elong) 0006211: [Bug] Registration error: sym_parameter changes causing sync triggers need to be limited to DML changes (pmarzullo) 0006223: [Bug] Imported configuration sometimes gets deleted from sym_data (emiller) 0006162: [Bug] Snapshot error from database time on Sybase ASE/ASA (elong) 0006164: [Improvement] During an upgrade, log DDL before executing it instead of afterwards (emiller) 0006173: [Improvement] Could not find trigger history, causes error of had X columns but expected Y (elong) 0006175: [Bug] Upgrade Jetty (elong) 0006177: [Improvement] Snapshot util timeout for taking too long on table definitions (elong)

0006152: [Bug] DDL replication errors on SQL-Server with renaming columns and deadlocks (elong) 0006156: [Bug] Repair of unrouted data should go through routing (elong) 0006159: [Bug] Firebird sym_hex UDF can cause an access violation (emiller) 0006146: [Improvement] Additional trigger template variable to suppor primary key joins without an alias (josh-a-hicks) 0006154: [New Feature] Add parameters that can disable specific types of conflict resolution (emiller) 0006155: [Bug] Conflict resolver does not handle unique index violations correctly when a unique index ignores null values (emiller) 0006148: [Improvement] Remove individual jobs stats for push and pull and uri handlers (elong) 0006145: [Bug] Purge fails with incorrect syntax near 'd' on SQL Server (elong) 0006139: [Bug] Jtds driver does not work with Sybase ASE (jvanmeter) 0006144: [Bug] Postgres timestamp with time zone columns get their values formatted incorrectly when extracted for a load (emiller) 0006140: [Bug] DB compare was incorrectly hex-encoding Unitype columns (jvanmeter) 0006132: [Improvement] Too many "Expected but did not receive an ack for batch" (elong) 0006128: [Bug] Dbfill of nchar/nvarchar and avoid timestamp/rowversion (elong) 0006106: [Improvement] Some Bulk loaders don't process before filters (cquamme) 0006115: [Bug] Cancel of load at target does not clean up everything at the source and still shows active at target (pmarzullo)

0006076: [Bug] Protect against exceptions in CPU monitor (emiller) 0006080: [Improvement] Improve name and documentation for DBExport's --symmetric option (emiller) 0006150: [Bug] Firebird sym_hex UDF can cause an access violation (emiller) 0006153: [New Feature] Add parameters that can disable specific types of conflict resolution (emiller) 0006143: [Bug] Postgres timestamp with time zone columns get their values formatted incorrectly when extracted for a load (emiller) 0006133: [Bug] DB compare was incorrectly hex-encoding Unitype columns (jvanmeter) 0006131: [Improvement] Too many "Expected but did not receive an ack for batch" (elong) 0006127: [Bug] Dbfill of nchar/nvarchar and avoid timestamp/rowversion (elong) 0006124: [Improvement] Add documentation for PostGIS data types for Postgres (cquamme) 0006112: [Bug] Cancel of load at target does not clean up everything at the source and still shows active at target (pmarzullo) 0006098: [Bug] Many router types attempt to handle non-DML data event types when they do not support them (emiller) 0006032: [Bug] Multiple queues can cause contention when trying to register a node. (jvanmeter) 0006095: [Improvement] Contains big LOB check can be fooled by commas in data (elong) 0006082: [Improvement] SQLite nodes do not insert into sym_context correctly when disabling sync triggers (emiller) 0006073: [Bug] Sync triggers fails when checking for multiple active trigger histories if Sybase ASE page size is 2K (emiller) 0006064: [Improvement] Slow extract and load when using $(targetExternalId) variable (elong) 0006071: [Bug] sym_node gets updated unnecessarily when heartbeat.update.node.with.batch.status parameter is disabled (emiller)

0006130: [Improvement] Too many "Expected but did not receive an ack for batch" (elong) 0006050: [Bug] Sybase ASE result set has already been closed during trigger exists check (elong) 0005930: [Bug] log.slow.sql.threshold.millis and log.sql.parameters.inline parameters do not work and are not documented (emiller) 0005914: [Bug] Cannot Install swaggerui module by using symadmin ModuleManager (pmarzullo) 0005896: [Bug] ValidatorException while validating self-signed X509 certificate (emiller) 0005870: [Improvement] Improve documentation of sym_node_group_link.sync_config_enabled (emiller) 0005852: [Improvement] sym_monitor_event trigger should capture changes when monitor.events.capture.enabled=true even if auto.sync.configuration=false (emiller) 0005846: [Improvement] Try again when foreign key correction fails (emiller)

0006057: [Improvement] Multi-threaded routing by channel (elong) 0006016: [Bug] Missing Kafka dependencies when installing Kafka module (emiller) 0006081: [Improvement] Improve name and documentation for DBExport's --symmetric option (emiller) 0006017: [Improvement] DDL Create Table Oracle with varchar columns that have a size > 4000 (josh-a-hicks) 0006104: [Improvement] Add indexes to sym_outgoing_batch (emiller) 0006087: [Bug] Upgrade from pre-3.15 to 3.15 loses H2 databases (emiller) 0006099: [Bug] Many router types attempt to handle non-DML data event types when they do not support them (emiller) 0006100: [Bug] Engine "filesync" not found (elong) 0006097: [Improvement] Cache trigger template hashcode (elong) 0006096: [Improvement] Contains big LOB check can be fooled by commas in data (elong) 0006094: [New Feature] Add symadmin take-snapshot subcommand (emiller) 0006086: [Improvement] Improve watchdog job and enable it by default (emiller) 0006083: [Improvement] SQLite nodes do not insert into sym_context correctly when disabling sync triggers (emiller) 0006079: [New Feature] Make it possible to use DBCompare's --config option to specify a suffix for each column in the order by clause (emiller) 0006074: [Bug] Sync triggers fails when checking for multiple active trigger histories if Sybase ASE page size is 2K (emiller) 0006072: [Bug] sym_node gets updated unnecessarily when heartbeat.update.node.with.batch.status parameter is disabled (emiller) 0006069: [Improvement] Slow extract and load when using $(targetExternalId) variable (elong) 0006040: [Bug] maxFormContentSize and maxFormKeys are no longer used (elong) 0006052: [Bug] Sybase ASE result set has already been closed during trigger exists check (elong) 0006046: [Bug] The watchdog job should not allow a node to detect itself as offline (emiller) 0006044: [Bug] ConcurrentConnectionManager expects nodeId-channel in the white list, but only the nodeId is put in the white list (pmarzullo) 0006041: [Improvement] Reject node registration request (elong) 0006035: [Improvement] Use the value of javax.net.ssl.trustStoreType as the truststore type if specified (emiller) 0006023: [Bug] SQLException when updating a non-OK outgoing batch on some database platforms (emiller) 0006015: [New Feature] Add :SOURCE_NODE_ID, :SOURCE_EXTERNAL_ID, and :SOURCE_NODE_GROUP_ID variables to column match routers (emiller) 0006012: [Bug] Do not attempt to "create or alter" triggers on SQL Server 2016 RTM (emiller) 0006007: [Improvement] Prevent node from starting up if the sync.url is invalid (emiller) 0006003: [Improvement] Upgrade Gradle Docker Plugin to latest version and get it working (emiller) 0006004: [Bug] SQL Explorer grid editor causes error in browser and "Edit" button is initially invisible (emiller)

0006055: [Improvement] Multi-threaded routing by channel (elong) 0005992: [Bug] Conflict resolver does not handle unique index violations correctly when a unique index ignores null values (emiller) 0005965: [Bug] Conflict Detection Fixes for Unique Keys (cquamme) 0006051: [Bug] Sybase ASE result set has already been closed during trigger exists check (elong) 0006043: [Bug] ConcurrentConnectionManager expects nodeId-channel in the white list, but only the nodeId is put in the white list (pmarzullo) 0006034: [Improvement] Use the value of javax.net.ssl.trustStoreType as the truststore type if specified (emiller) 0006021: [Bug] SQLException when updating a non-OK outgoing batch on some database platforms (emiller) 0006013: [New Feature] Add :SOURCE_NODE_ID, :SOURCE_EXTERNAL_ID, and :SOURCE_NODE_GROUP_ID variables to column match routers (emiller) 0005788: [Bug] The source_table_name wildcard behavior does not match the documentation on the website (emiller) 0006011: [Bug] Do not attempt to "create or alter" triggers on SQL Server 2016 RTM (emiller) 0006010: [Improvement] Add exception message to logging when bulk loader fails and falls back to default loading (pmarzullo) 0006006: [Improvement] Prevent node from starting up if the sync.url is invalid (emiller) 0005976: [Bug] User is incorrectly warned that table is missing primary key (elong) 0005986: [Bug] Method that selects from sym_node_security is not synchronized (emiller) 0005984: [Bug] Fixed compatibility for other databases to insert/update into Sybase ASE Unitypes (jvanmeter) 0005983: [Improvement] Improve accuracy of CPU monitor (emiller) 0005980: [Improvement] MonitorService should use the dirty SQL template when selecting from sym_monitor_event (emiller) 0005971: [Bug] Loads fail when they include a table with a SQL Server uniqueidentifier column (emiller) 0005966: [Improvement] SQLAnywhere support for stream row (pmarzullo)

0001132: [Improvement] Support Postgres Special Floating Point Values Infinity, -Infinity, NaN 0005770: [Improvement] Use 600 series HTTP codes to distinguish from network devices (elong) 0006039: [Bug] CVE-2016-1000027 - /opt/symmetric-server/web/WEB-INF/lib/spring-web-5.3.27.jar 0005740: [Improvement] Have file sync make better use of staging (emiller) 0005857: [Bug] Security Vulnerability in Spring Framework and h2 database (elong) 0005840: [Improvement] Purge should use "exists" clause instead of "in" clause for performance (elong) 0002530: [Bug] postgresql infinity timestamp (JishLong) 0004034: [New Feature] Create tables based on target table name and column names set by routers and transforms (emiller) 0005545: [New Feature] Add support for H2 2.x and upgrade the H2 driver to the latest version (emiller) 0005641: [Improvement] Increase default db.pool.max.active connections to match what is needed for http.concurrent.workers.max (pmarzullo) 0005827: [Improvement] Track expired data gaps and repair any data missed by routing (elong) 0005778: [Improvement] Change timestamp size on sym tables with a timestamp as a primary key (cquamme) 0005784: [Improvement] Cache list of enabled nodes used by routing (elong) 0005792: [Improvement] Better logging when ack fail (elong) 0005835: [Bug] column name containing a "/" causes error (JishLong) 0005842: [Improvement] Purge retention for monitor events and console events (elong) 0005843: [Improvement] Change default push/pull to 10 seconds (elong) 0005860: [Improvement] Increase the statement query timeout (elong) 0005925: [Bug] Ignore Row Count not getting updated in outgoing batch table when a row is ignored (cquamme) 0005926: [New Feature] Adding a corresponding sym_outgoing_error table connected to sym_incoming_error (cquamme) 0005927: [Improvement] Use sym_outgoing_error table to ignore a row in outgoing batch (cquamme) 0002826: [Bug] Monitor event duplicate key when syncing (cquamme) 0003505: [Bug] SYM_TABLE_RELOAD_REQUEST is updated via DateTime which sometimes fails due to precision mismatch (elong)

0005960: [Improvement] Add support for NTEXT to SQLAnywhere dialect (pmarzullo) 0005961: [Bug] SQL Anywhere long varbit values are inconsistent between change data capture and initial load (pmarzullo) 0005955: [Bug] Sybase Anywhere - channel_id size Problem on auto-create triggers (emiller) 0005921: [Improvement] Adding Uni* type support to Sybase ASE (jvanmeter) 0005944: [Improvement] Adding log info for subselect routers (cquamme) 0005948: [Bug] KafkaDataWriter by ROW method has a trailing comma (jvanmeter) 0005937: [Improvement] SymmetricDS User Guide Incorrectly Referencing Table Column Name Which Dropped From 3.14 Release Already (elong) 0005932: [Improvement] Update docs on using environment variables in engines properties (modified summary) (cquamme) 0005942: [Bug] SQLAnywhere DDL problems with dropping indexes and triggers, and trigger syntax issue for version 11 and earlier (pmarzullo) 0005935: [Bug] Failed to execute IHeartbeatListener PushHeartbeatListener java.lang.NullPointerException When Starting up SymmetricDS (elong) 0005934: [Bug] Getting null pointer from Column.java in new method anyPlatformColumnTypeContains on platformColumns (chenson) 0001180: [New Feature] Add option to symadmin --send-sql to specify a file containing the sql to send. (JishLong) 0005931: [Bug] log.slow.sql.threshold.millis and log.sql.parameters.inline parameters do not work and are not documented (emiller) 0001063: [Improvement] Add export-config and import-config command line options to symadmin (JishLong)

0005916: [New Feature] New parameter to allow automatic loads to be sent based on configuration rather than just to and from registration server (josh-a-hicks) 0005651: [Bug] Row in sym_table_reload_status can have incorrect values for completed, data_batch_loaded and finalize_batch_loaded (pmarzullo) 0005906: [Bug] Non transactional initial load setup can cause load events to be missed ini table_reload_status (pmarzullo) 0005834: [Bug] Unnamed constraint causes alter table error (JishLong) 0005848: [Bug] Security Vulnerbility in Spring Framework (elong) 0005886: [Improvement] Monitor enhancements for centralized support (josh-a-hicks) 0004952: [Bug] Cannot resolve monitors of type log (emiller) 0005893: [Improvement] DbCompare should write to standard error and not continue with an invalid date-time format (cquamme) 0005922: [Improvement] Added debug logging to File Sync Trigger Tracker (jvanmeter) 0005901: [Bug] DBCompare produces output SQL with invalid syntax (cquamme) 0005903: [Bug] Failing to create trigger on table (pmarzullo) 0005913: [Bug] Update postgres documentation on how to give access to schemas for a SymmetricDS user (pmarzullo) 0005915: [Bug] Cannot Install swaggerui module by using symadmin ModuleManager (pmarzullo) 0005865: [Bug] Estimated count from initial load does not work with SqlServer when using different schema than dbo (JishLong) 0005909: [Improvement] Some methods are synchronized unnecessarily in AbstractParameterService (cquamme) 0005907: [Improvement] Postgres support for ddl table creations with a default function on a GUID from MSSQL (josh-a-hicks) 0005885: [New Feature] MSSQL support for hierarchyid data types (josh-a-hicks) 0005904: [Bug] LOB data does not sync when sending a load with use_stream_lobs=1 (emiller) 0005894: [Bug] NotificationTypeEmail's deserializeOfflineNodes method always returns empty collection (cquamme) 0005897: [Bug] ValidatorException while validating self-signed X509 certificate (emiller) 0005892: [Bug] DbCompare fails to write comparison SQL for timestamp with timezone values (cquamme) 0005884: [New Feature] Add job monitor (emiller) 0005880: [Bug] Transform documentation missing Java Column Transform Type (pmarzullo) 0005873: [Improvement] Open Registration in Rest API doesn't allow user to specify node if 2 nodes have the same external ID (cquamme) 0003476: [Improvement] When a node is unregistered cancel all jobs / threads that are actively doing work for that node (JishLong) 0000706: [Improvement] Make sleep time between registration retries configurable (JishLong) 0005869: [Improvement] Improve documentation of sym_node_group_link.sync_config_enabled (emiller) 0005314: [Bug] Infinite synchronization loop when 3 nodes are connected to each other and sync_on_incoming_batch = 1 (emiller) 0005867: [Bug] Prevent file sync from syncing all files when first scanning a directory when initial load is enabled (emiller) 0005863: [New Feature] Add option to send additional batch error notifications when the number of batches in error increases (emiller) 0002260: [Improvement] Also sync the stored procedures with the schema (emiller) 0004151: [Bug] MSSQL DDL ERROR: View / function / stored procedure (emiller) 0005853: [Improvement] sym_monitor_event trigger should capture changes when monitor.events.capture.enabled=true even if auto.sync.configuration=false (emiller) 0005847: [Improvement] Try again when foreign key correction fails (emiller) 0005836: [Improvement] Specify jaxb api and implementation so that libraries will be available when running in Java 8 through 17 (pmarzullo) 0005565: [Improvement] Adding Character Set to Snapshot (cquamme) 0005812: [Improvement] MathColumnTransform uses Evaluator that is not thread-safe (cquamme)

0005805: [Improvement] Allow specification of database platform of symmetric when DbDxport execution with load only/extract only/log miner (pmarzullo) 0005782: [Improvement] Unique Index with Multiple Nulls not Properly Handled for Certain Databases (jvanmeter) 0005815: [Improvement] DDL Capture Changes - Three enhancements to DDL trigger capture (josh-a-hicks) 0005780: [Improvement] Slow routing when using $(targetExternalId) variable (elong) 0005790: [Improvement] Failed to decrypt node password from lost secret key in keystore (elong) 0005791: [Bug] Allow registration of other nodes after registration and initial load is complete (elong) 0005817: [Improvement] Snapshot util not returning (elong) 0004310: [Bug] Replicating to postgres to postgres timestamp with default 0005803: [Bug] Interbase fixes: failing to have prepared statement indicators in set and select portion of SQL statements (pmarzullo) 0005831: [Improvement] Sync triggers by $(targetExternalId) and call after registration (elong) 0005781: [Bug] DBCompare --use-sym-config true (cquamme) 0005779: [Improvement] Improve docs on db.init.sql property (emiller) 0005828: [Bug] Class Not Found Exception when connecting to Redshift (cquamme) 0005823: [Improvement] Capture timings when running Sync Triggers (pmarzullo) 0005826: [Bug] Data can become misaligned with column names during extraction after a column gets renamed (emiller) 0005822: [Bug] SQL Server create or alter trigger fails when table is not in default schema (dbo) (pmarzullo) 0005810: [Improvement] Redshift Bulk Loader increased versioning and dependencies (josh-a-hicks) 0005809: [Bug] NullPointerException when writing a delete to Kafka when old data has not been captured (emiller) 0005811: [Bug] When Capture of Old Data is disabled, Deletes get an Index Out Of Bounds Error with Kafka (jvanmeter) 0005766: [Bug] NPE when inserting into sym_incoming_batch on some platforms (emiller) 0005807: [Bug] Sybase ASE gets Misinterpreted as Sybase SQL Anywhere (jvanmeter) 0005799: [Bug] 3 tier deployment, 3rd tier does not get top level tier sym_node* tables (pmarzullo) 0005802: [Bug] SQL Server and Sybase stream row on updates trigger syntax issue (pmarzullo) 0005800: [New Feature] Add a gradle task that generates javadoc and publishes it to the website (emiller) 0005783: [Improvement] SymmetricDS seems to require Postgres 11, but the docs don't reflect that (emiller) 0005774: [New Feature] Support for capturing the row identifier on various platforms if available (default is false) (josh-a-hicks) 0005775: [New Feature] File sync batches to provide file name as the summary in outgoing and incoming batch. (josh-a-hicks) 0005765: [Improvement] Add quotation marks around values in threads-stats.csv file in support snapshot (emiller) 0005757: [New Feature] Add server parameter for setting a server's cookie name (cquamme) 0005753: [Improvement] Reopening registration should reset the failed login count (emiller) 0005752: [Improvement] Add support for H2 2.x (emiller)

0005825: [Bug] Data can become misaligned with column names during extraction after a column gets renamed (emiller) 0005613: [Bug] When upgrading from a varchar(xxx) to longvarchar the change isn't detected on H2 (emiller) 0005754: [Improvement] Reopening registration should reset the failed login count (emiller) 0005745: [Improvement] Read max-size VARCHAR columns as LONGVARCHAR columns on H2 (emiller) 0005717: [Bug] SQL Server DDL Builder needs to handle objects in different databases (pmarzullo) 0005710: [Bug] When connecting to Azure, set platform version to SQL Server 2016 (pmarzullo)

0005737: [Bug] Server Time Offsets Causing an Error in Determining if a Node is Offline (jvanmeter) 0005746: [Bug] When upgrading from a varchar(xxx) to longvarchar the change isn't detected on H2 (emiller) 0005747: [Improvement] Read max-size VARCHAR columns as LONGVARCHAR columns on H2 (emiller) 0005742: [Improvement] Table sorting does not need to include sym tables (josh-a-hicks) 0005657: [Bug] SQLAnywhere CHAR is really a VARCHAR and should be mapped to VARCHAR for other dialects (emiller) 0003952: [Bug] Order table creation by foreign key dependency (pmarzullo) 0005722: [Bug] Tries to create foreign key before creating the referenced table (pmarzullo) 0005723: [Bug] The schema of the table that is being created is used instead of correct one when creating a foreign key (emiller) 0005721: [Bug] Query tries to address mixed-case column without quotes (Postgres) (pmarzullo) 0005731: [Bug] Functional indexes are only supported by Oracle (pmarzullo) 0005728: [Improvement] AbstractSymmetricEngine.isConfigured() should use the cache when querying for sym_node table (pmarzullo) 0005729: [Bug] DBImport- Allow the UI specification of the catalog and schema to override the catalog and schema specs in XML imported file (pmarzullo) 0005724: [Bug] SQL Server timestamp (rowversion) data type can not specify column size (pmarzullo) 0005720: [Improvement] sym_node trigger should capture changes even if auto.sync.configuration is set to false (pmarzullo) 0005718: [Bug] SQL Server DDL Builder needs to handle objects in different databases (pmarzullo) 0005711: [Bug] When connecting to Azure, set platform version to SQL Server 2016 (pmarzullo) 0005698: [Bug] Data truncation error when inserting/updating log event in sym_monitor_event on Interbase (emiller) 0005702: [Bug] Missing image in Manage Incoming Loads (pmarzullo) 0005699: [Bug] Missing image in Manage Nodes Load Data Where Clauses (pmarzullo) 0005700: [Bug] Grammar error (double word) in Manage Logging documentation (pmarzullo)

0005692: [Bug] Pulling corrupted batch gets null pointer in loop (elong) 0005693: [Bug] Fix multiple active trigger histories before sync triggers is run (pmarzullo) 0005675: [Improvement] Bidirectional sync causes need for trigger to be re-built on target side if table does not exist (cquamme) 0005686: [Bug] MariaDB JDBC Driver version 3 does not support a negative fetch size to indicate the use of streaming (pmarzullo) 0005679: [Bug] Extract fails with durationMillis must not be negative (elong) 0005671: [Improvement] Bring back java routers (emiller) 0005673: [Improvement] Sync triggers fails with deadlock on SQL-Server (elong) 0005593: [Bug] Incorrect Logic in various DDLBuilders for Processing Changes (cquamme) 0005664: [Bug] Tables are altered incorrectly on some platforms when their columns need to be made required or non-required (emiller) 0005663: [Improvement] Add table reload request to REST service (elong) 0005662: [Improvement] Snapshot util too slow for large multi-tenant deployment (elong) 0005636: [Improvement] Only cancel a full load in progress if the reload select is empty (josh-a-hicks) 0005598: [Bug] Sql Anywhere Drop Trigger (josh-a-hicks)

0005691: [Bug] Pulling corrupted batch gets null pointer in loop (elong) 0005685: [Bug] MariaDB JDBC Driver version 3 does not support a negative fetch size to indicate the use of streaming (pmarzullo) 0005676: [Bug] Initial load sends too many tables when using $(targetExternalId) variable (elong) 0005678: [Bug] Extract fails with durationMillis must not be negative (elong) 0005672: [Improvement] Sync triggers fails with deadlock on SQL-Server (elong) 0005659: [Improvement] Snapshot util too slow for large multi-tenant deployment (elong) 0005654: [Bug] sym_node_host trigger should capture changes even if auto.sync.configuration is set to false (pmarzullo)

0005652: [New Feature] Improve SQL Server DDL triggers and add DDL triggers for Oracle and Postgres (emiller) 0005655: [Bug] sym_node_host trigger should capture changes even if auto.sync.configuration is set to false (pmarzullo) 0005650: [Improvement] Problems replicating DDL to another node with the same database type but different database version (emiller) 0005648: [Improvement] Add "open registration" call to REST service (elong) 0005645: [Bug] Registration redirect URL does not have query parameters for older versions of SymmetricDS clients (pmarzullo) 0005646: [Bug] DBExport incorrectly formats time data (emiller) 0005640: [Bug] Filtering transactions for snapshot gets stack overflow error and never finishes creating snapshot (pmarzullo) 0005638: [Bug] Flush cache of routers when a router is changed (elong) 0005625: [Bug] Stack overflow while extracting batch containing a table removed from replication (elong) 0005610: [Improvement] SqlAnywhere support for v. 12 and higher (josh-a-hicks) 0005631: [Improvement] Full load request does not support a reload select statement (josh-a-hicks) 0005635: [Bug] Single Store extends MySQL dialect but does not need to check for an "innodb" engine (josh-a-hicks) 0005630: [Improvement] When deleting FK child rows during conflict resolution and old_data is null, query for the parent row on the target (emiller) 0005624: [Bug] Deletes get ignored when foreign key children exist but cannot be found (emiller) 0004424: [Improvement] Log monitor fails to insert because of duplicate key when logs are shared across instances of a node (pmarzullo) 0005597: [Bug] SymDS is not syncing specific record during initial load (pmarzullo) 0005619: [Bug] Insert statements generated by DBExport contain question marks when there are null values (emiller) 0005611: [Bug] Check sync URL ends with engine name or "sync" (elong)

0005644: [Bug] Registration redirect URL does not have query parameters for older versions of SymmetricDS clients (pmarzullo) 0005623: [Bug] Deletes get ignored when foreign key children exist but cannot be found (emiller) 0005629: [Improvement] When deleting FK child rows during conflict resolution and old_data is null, query for the parent row on the target (emiller)

0004168: [Improvement] SQL-Server capture rows that exceed 4000 characters (pmarzullo) 0005508: [Bug] Multiple active trigger history for same table (elong) 0005517: [Bug] Empty string default values not syncing to target (pmarzullo) 0005521: [Bug] Create trigger hist if routing can't find it (elong) 0005527: [Bug] Cannot set up SQL Server log-based replication without "ALTER ANY DATABASE" permission (emiller) 0005540: [Bug] Apache commons-text version 1.9 security vulnerability (pmarzullo) 0005573: [Bug] Unique index on function causes error when resolving a conflict (elong) 0005578: [Bug] Script error from newer wins conflict resolution with old nodes (elong) 0005584: [Bug] Trigger creation fails when 2 new triggers have trigger IDs that are identical when shortened (pmarzullo) 0005594: [Bug] Failure to Flush when using ConvertToReload router. (jvanmeter)

0005509: [Bug] Multiple active trigger history for same table (elong) 0005522: [Bug] Create trigger hist if routing can't find it (elong) 0005525: [Bug] Unsupported Postgresql data types 0005528: [Bug] Cannot set up SQL Server log-based replication without "ALTER ANY DATABASE" permission (emiller) 0005530: [Bug] Multi-homed clustered nodes stuck in loop of retry and resend of batches (elong) 0005518: [Improvement] Updating KafkaDataWriter to work with Filters (jvanmeter) 0005539: [Improvement] Support for a default value to generate a GUID using built in function on table creation (josh-a-hicks) 0005541: [Bug] Apache commons-text version 1.9 security vulnerability (pmarzullo) 0005543: [Bug] Initial load error on MySQL with parameter db.treat.date.time.as.varchar.enabled=true (elong) 0005556: [Bug] SQL-Server capture rows that exceed 4000 characters (pmarzullo) 0005574: [Bug] Unique index on function causes error when resolving a conflict (elong) 0005579: [Bug] Script error from newer wins conflict resolution with old nodes (elong) 0005585: [Bug] Trigger creation fails when 2 new triggers have trigger IDs that are identical when shortened (pmarzullo) 0005595: [Bug] Failure to Flush when using ConvertToReload router. (jvanmeter) 0005602: [Bug] Parse exception of batch should remove it from staging (elong)

0005519: [Improvement] Updating KafkaDataWriter to work with Filters (jvanmeter) 0005463: [Bug] Initial load of a table with a self referencing FK will not load if out of order (josh-a-hicks) 0005604: [Improvement] Check sync URL ends with engine name (elong) 0003313: [New Feature] Propagate default GUID from MSSQL to SQLITE (emiller) 0003545: [Bug] Mapped default values lead to always detecting a model change (emiller) 0005507: [Bug] Postgres LOCALTIMESTAMP function gets surrounded by quotes when imported as a default value (emiller) 0005510: [Bug] Multiple active trigger history for same table (elong) 0005511: [Bug] Error request path not supported for /server/config (elong) 0005512: [Bug] Default values for Oracle RAW columns get surrounded by quotes when exported (emiller) 0005513: [Bug] SQL Server GETDATE() and GETUTCDATE() functions get surrounded by quotes when imported as default values (emiller) 0005514: [Bug] SQL Server sysname type should not have its size specified (emiller) 0005515: [Improvement] When installing service for systemd, make sure to specify absolute path to java executable when creating systemd control file (pmarzullo) 0005520: [Improvement] Acknowledgement gets null SQL message (elong) 0005523: [Bug] Create trigger hist if routing can't find it (elong) 0005524: [New Feature] Adding New Monitor Types For OS Load Average and OS Open File Handles (cquamme) 0005526: [Improvement] Default max batch to send as 10 (elong) 0005529: [Bug] Cannot set up SQL Server log-based replication without "ALTER ANY DATABASE" permission (emiller) 0005531: [Bug] Multi-homed clustered nodes stuck in loop of retry and resend of batches (elong) 0005535: [Improvement] Improve how default values are handled when syncing DDL cross-platform (emiller) 0005536: [Improvement] Add support for Postgres' inet, cidr, macaddr and macaddr8 data types (emiller) 0005544: [Bug] Initial load error on MySQL with parameter db.treat.date.time.as.varchar.enabled=true (elong) 0005547: [Improvement] Treat any default value that contains "()" as a function (emiller) 0005551: [New Feature] Add parameters that specify how to sync default values (emiller) 0005553: [Improvement] Allow spaces in values within value map column transform expression (emiller) 0005554: [Bug] Example 25 in User Guide is missing permissions (emiller) 0005557: [Bug] SQL-Server capture rows that exceed 4000 characters (pmarzullo) 0005558: [Improvement] Create table without defaults if in error (elong) 0005563: [Improvement] Add functionality to symadmin export-sym-tables to export alters when upgrading (pmarzullo) 0005570: [New Feature] Add engine name and server name variables to notification templates (emiller) 0005571: [Bug] Unique index on function causes error when resolving a conflict (elong) 0005580: [Bug] Script error from newer wins conflict resolution with old nodes (elong) 0001960: [Improvement] Service start script always waits for 5s (elong) 0003109: [Bug] File replication routing job fails with error message when channel is not a file sync channel - needs better error message (emiller) 0005542: [Bug] Apache commons-text version 1.9 security vulnerability (pmarzullo) 0005560: [Bug] ORA-06502: PL/SQL: numeric or value error: character string buffer too small (elong) 0005582: [Bug] Database Platforms That Don't Support SQL Queries Throw Error with SQL Explorer (cquamme) 0005583: [Improvement] Service wrapper wait for "started" message instead of 5 second timeout (elong) 0005586: [Bug] Trigger creation fails when 2 new triggers have trigger IDs that are identical when shortened (pmarzullo) 0005596: [Bug] Failure to Flush when using ConvertToReload router. (jvanmeter) 0005603: [Bug] Parse exception of batch should remove it from staging (elong) 0005605: [Improvement] Parameter that alters table case should be for cross platform only (elong) 0005606: [Improvement] CPU monitor top threads should ignore threads waiting on I/O (elong) 0005456: [Bug] ORA-24816 when sync varchar2(4000) and long in same table (elong)

0005452: [Improvement] Backup keystore before saving it (elong) 0005438: [Bug] Conflict resolver fails if there are no primary keys on the target and it is set to not use primary keys from source (jvanmeter) 0005457: [Bug] Cannot write to more than one Kafka instance in a single instance of SymmetricDS (jvanmeter) 0005485: [Improvement] Ignore missing tables on config channel (elong) 0005488: [Improvement] Support snapshot fixes (elong) 0005491: [Improvement] Table reload request with "where" keyword gets error (elong) 0005494: [Bug] Batch error missing method sendMissingForeignKeyRowsForLoad (elong) 0005500: [Bug] Registration left pending when client is 3.12 or newer and server is 3.11 or older (elong)

0000765: [Improvement] Create table DDL and dbexport / dbimport should support generated / calculated / computed / virtual columns (emiller) 0005433: [Improvement] Sync triggers when parameters change that affect triggers (elong) 0005502: [Bug] Fix json deserialization issue with log summary object (josh-a-hicks) 0000697: [Task] Document the --client option in the User Guide. I've been told it is useful ;-) (elong) 0000922: [Bug] Float used on table without primary causes update to not capture (emiller) 0001753: [Bug] Default values that are functions do not work while creating tables in MySQL (emiller) 0003251: [Bug] Mysql BIGINT UNSIGNED processed as signed and gives error on larger than 63 bits numbers. (emiller) 0004116: [Bug] Syncing from Time to Timestamp (or vice versa) in Postgres produced inaccurate values (emiller) 0005392: [Bug] Unable to write to sym_outgoing_batch when using Postgres (elong) 0004295: [Bug] Detect when the order of a primary key changes in order to regenerate it (elong) 0004335: [Bug] Multiple transform_table rows per source table cause multiplication of rows in outgoing batch (elong) 0004514: [Bug] DbCompare: The output script to fix issues on the target does not support null values. (emiller) 0005427: [New Feature] Creating a Parameter That, Upon Registration, Will Automatically Create A Group Link Between Nodes if None Exist (cquamme) 0005430: [Bug] Android not implemented exception when sym_monitor syncs (elong) 0005431: [Improvement] Install triggers on registration server before configuration is complete (elong) 0005435: [Bug] NumberFormatException when querying for an integer greater than Long.MAX_VALUE in SQL Explorer (emiller) 0005436: [Bug] Sybase ASE issues when upgrading SymmetricDS from an older version to 3.14.* (pmarzullo) 0005439: [Bug] Conflict resolver fails if there are no primary keys on the target and it is set to not use primary keys from source (jvanmeter) 0005440: [Improvement] Change parameter treat.binary.as.lob.enabled to default to false (elong) 0005441: [Bug] Windows service won't start if tmp dir has trailing slash (elong) 0005449: [Improvement] Add SOURCE_NODE_ID_FROM_DATA to VariableColumnTransform to allow using the source_node_id from the data (pmarzullo) 0005450: [Improvement] Routing default batch algorithm protection against large transactions (elong) 0005453: [Improvement] Backup keystore before saving it (elong) 0005459: [Improvement] Adding Log Info For Queries for Lookup Table Routers (cquamme) 0005460: [Bug] Cannot write to more than one Kafka instance in a single instance of SymmetricDS (jvanmeter) 0005464: [Improvement] Parameter to use old conflict pk detect and fallback (elong) 0005476: [Improvement] Ability to disable sync triggers when sync on incoming is enabled (elong) 0005477: [Bug] Some default values do not sync correctly from Oracle to Oracle (emiller) 0005481: [Improvement] Cast TEXT types in MS SQL to VARCHAR for SymmetricDS tables (elong) 0005483: [Improvement] Cast TEXT to VARCHAR for all tables (elong) 0005486: [Improvement] Ignore missing tables on config channel (elong) 0005487: [Improvement] Support snapshot fixes (elong) 0005492: [Improvement] Table reload request with "where" keyword gets error (elong) 0005495: [Bug] Batch error missing method sendMissingForeignKeyRowsForLoad (elong) 0005472: [Bug] When a load filter changes catalog or schema the DML statement is not recreated with the updated values (josh-a-hicks) 0005496: [Improvement] Cast varchar to nvarchar (elong) 0005497: [Bug] NPE when running DbFill on a table with a foreign key that references a table in another catalog or schema (emiller) 0005501: [Bug] Registration left pending when client is 3.12 or newer and server is 3.11 or older (elong) 0005503: [Bug] New config tables are being routed to old nodes (elong) 0005504: [Bug] Oracle DATE type should not have its size specified (emiller) 0005505: [Bug] Oracle TO_TIMESTAMP() function gets surrounded by quotes when imported as a default value (emiller) 0003845: [Bug] Primary key constraint violation while replicating single table from MSSQL 2017 into PostgreSQL 9.6 (pmarzullo)

0001421: [Bug] DbFill error arithmetic overflow error with money data type (emiller) 0004191: [Bug] dbexport: MSSQL geometry -> PGSQL varchar(2147483647); better would be TEXT (emiller) 0005389: [New Feature] Implement conflict_win_count and conflict_lose_count columns in sym_outgoing_batch and sym_incoming_batch (emiller) 0004001: [Bug] Default value being passed as string for MS Sql Server (emiller) 0004090: [Bug] Firebird ddl/schema problem when creating tables and deferring constraints (emiller) 0001282: [Bug] MySQL outputs schema with DEFAULT '0000-00-00' that is not compatible (emiller) 0005385: [Bug] Snapshots do not contain log files when the files are in a non-default location specified in log4j2.xml (emiller) 0000140: [Improvement] Check to see that the SymmetricDS tables are created to use the Innodb storage engine on MySQL. (emiller) 0005393: [Bug] MySqlDdlReader.getTriggers() throws SQLException when MySQL database name contains special character (emiller) 0005421: [Bug] Initial load won't start if registration_enabled is 1 (elong) 0005395: [Bug] H2 database (or load only database) gets alter timestamp(0) every time starting (elong) 0003961: [Bug] Oracle XMLTYPE incorrectly mapped to invalid SQL Type SQLXML in MariaDB (emiller) 0002821: [Bug] dbcompare attempts to insert null into "not null default ..." field (emiller) 0003960: [Bug] NVARCHAR2() maps incorrectly to VARCHAR() when mapping from Oracle to MariaDB (emiller) 0003419: [Bug] MS SQL -> SQLite, don't translate "NEXT VALUE FOR" default value (emiller) 0003964: [Bug] Oracle's REAL datatype should map to DOUBLE in MariaDB, not FLOAT (emiller) 0003965: [Bug] Oracle's LONG type is incorrectly mapped to MariaDB's MEDIUMTEXT. Should be LONGTEXT (emiller) 0003966: [Bug] Oracle's CLOB (and NCLOB) type incorrectly maps to MariaDB's MEDIUMTEXT (emiller) 0003999: [Bug] Unable to translate default column for (new sequentialid()) (very easy fix) (emiller) 0004134: [Bug] DB Compare does not handle Oracle Timestamp with LOCAL time zone columns properly (emiller) 0004217: [Bug] Does not replicate index with upper function on PostgreSQL (emiller) 0005388: [Bug] Initial load delete or truncate with table transform (elong) 0004567: [Bug] sync.table.prefix parameter ignores for sequence in PostgreSQL (emiller) 0004667: [Bug] dbcompare prints each table multiple times (emiller) 0005106: [Bug] The PostgreSQL database cannot be synchronized under the USE_CHANGED_DATA and manual resolution strategy (emiller) 0005406: [Bug] Deleting a trigger doesn't inactivate its sym_trigger_hist entry when auto.sync.triggers.after.config.change=true (emiller) 0005413: [Bug] Bulk loaded flag is not being read from database for incoming and outgoing services (josh-a-hicks) 0005414: [Bug] JDBC Bulk Transactions Fallback While Using PostgreSQL (cquamme) 0005415: [Improvement] Detection of MSSQL Azure Managed Instance (josh-a-hicks) 0005416: [Improvement] Allow users to disable spatial data type support functions (josh-a-hicks) 0005417: [Bug] Fix NPE for conflict detection when table does not have a PK and all columns used including those with null values (josh-a-hicks) 0005422: [Task] Update IReloadListener example in user guide (emiller) 0005425: [Bug] Tables not created on reverse initial load (elong)

0005381: [Bug] [Postgres Data replication fails] ERROR: column "address" is of type inet but expression is of type character varying 0005386: [Improvement] Change index.html to redirect / to /app/ to minimize redirects through load balancers (pmarzullo) 0005387: [Bug] Initial load delete or truncate with table transform (elong) 0005347: [Bug] Incorrect implement in geometry type (emiller) 0005368: [Bug] DDL detects change in column data type for DATE on Oracle (elong) 0005370: [Bug] Send schema DDL detects widened varchar but does not alter (elong) 0005375: [Bug] Entire batch is ignored in PostgreSQL in case of error (emiller) 0005384: [Bug] Snapshots do not contain log files when the files are in a non-default location specified in log4j2.xml (emiller) 0005405: [Bug] Deleting a trigger doesn't inactivate its sym_trigger_hist entry when auto.sync.triggers.after.config.change=true (emiller) 0005401: [Bug] Since SymmetricDS version 3.13.5 MsSQL sync create tables in uppercase (emiller) 0005418: [Bug] Virtual Trigger Routers created for SymmetricDS tables do not make sure that the router ID is unique (pmarzullo) 0005423: [Bug] JDBC Bulk Transactions Fallback While Using PostgreSQL (elong) 0005424: [Bug] Tables not created on reverse initial load (elong) 0004201: [Bug] Failed to create update trigger for triggers that use and external_select with $(curTriggerValue) (pmarzullo)

0005269: [Improvement] Variables of source catalog/schema names for use in target catalog/schema fields in routing (elong) 0002254: [Bug] sym_outgoing_batch and sym_incoming_batch should both use the same time for last_update_time and create_time (emiller) 0005157: [Improvement] Sybase and SQL Server update trigger should be made more efficient generating sym_data records when primary keys are changed (pmarzullo) 0005198: [Improvement] Clean up the consistent use of table constants for registration, trigger installation, extract, and export (elong) 0003724: [Bug] Conflict detection with Timestamps between DB2 and Derby (elong) 0005239: [Bug] Conflict resolution doesn't work if timestamp is in PK and different fractional second precision between databases (elong) 0004525: [Bug] Database name with special character like minus sign, fails to create trigger (emiller) 0002180: [Bug] H2 timestamp format creates conflict against ORACLE timestamp format (elong) 0003941: [Improvement] Data gap route reader could use multiple queries when exceeding max gaps (elong) 0005210: [Improvement] Routing reader may use multiple queries for a large number of gaps (elong) 0002972: [Improvement] Registration order of nodes should not matter (elong) 0005138: [Improvement] Build a cache manager to centralize the handling of data caches (pmarzullo) 0002261: [Bug] Schema from Postgres outputs TIMESTAMPTZ that is not compatible with other databases (elong) 0003778: [Bug] Send table fails when sending H2 Timestamp to MySQL (elong) 0003962: [Bug] Oracle's TIMESTAMP with Time Zone doesn't map to MariaDB (elong) 0003963: [Bug] char(n) and nchar(n) where n>255 is valid in oracle but maps to invalid types in MariaDB (elong) 0004298: [Bug] Sycing schemas from MSSQL with column type CHAR(400) to MySQL fails (elong) 0004723: [Improvement] Send column with Oracle DATE type to PostgreSQL (elong) 0004724: [Improvement] Send column with timestamp datatype from PostgreSQL to PostgreSQL (elong) 0005122: [Bug] Wrong conversion from mssql datetime(7) to mysql/mariadb (elong) 0005140: [Task] Upgrade to gradle version 7.4.2 (pmarzullo) 0005178: [New Feature] Push registration to nodes when group links indicate push (elong) 0005180: [New Feature] Schedule registration of a node for a window of time (elong) 0005203: [Improvement] Sync incoming load details to target node (table_reload_status, extract_request) (elong) 0005238: [Improvement] Bulk loaders should report missing table (elong) 0005243: [Bug] Change documentation on outgoing batch errors to set the status to 'IG' instead of 'OK' so target will get notified (pmarzullo) 0005265: [Improvement] Update drivers, modules, and libraries (emiller) 0005278: [Improvement] Alphabetize list of tables in user guide (emiller) 0005280: [Improvement] Table DDL with timestamp and fractional second precision (elong) 0005304: [Bug] Snapshot Fails to Find SingleStore Enum (cquamme) 0005305: [Bug] SingleStore Snapshot: Failed to execute SQL Error (cquamme) 0005306: [Bug] SingleStore Snapshot: 'Table 'sym_outgoing_batch' doesn't exist' (cquamme) 0005308: [Bug] Unable to Retrieve Database Time for Load-Only and Log-Based (cquamme) 0005309: [Improvement] Prepare for Gradle upgrade to version 8 (pmarzullo) 0005351: [Improvement] Use PKCS12 for keystore by default (elong) 0005353: [Improvement] Add gpg code signing to jar files (emiller) 0005364: [Improvement] Always execute shutdown hooks, even for embedded and war deployments (pmarzullo) 0005376: [Improvement] Parameter to disable logging of application data from a batch error (elong)

0005341: [New Feature] Add system property to control use of "on conflict" on Postgres (elong) 0005045: [Task] Errors in "ON CONFLICT " - need a new parameter (elong) 0004975: [Bug] insert with on conflict clause cannot be used with table that has insert or update rules (elong) 0005340: [Bug] Wrong character in document (emiller) 0003295: [Bug] Sync from MySql to MSSql initial load - table create fails on Decimal Precision when MySQL precision is more than 38 (elong) 0005329: [Bug] Sync triggers on selected tables without primary key gets trigger hist without primary key columns (elong) 0005333: [Bug] Oracle log mining throwing exception when finding mismatched LOB record in log mining result set (pmarzullo) 0005334: [Bug] Server not trusted when sending email (elong) 0005343: [Bug] Mathematical transform turns an integer into a decimal when the result has 8 or more digits (emiller) 0005349: [Improvement] Substring Transform support for all spaces (josh-a-hicks) 0005350: [Bug] Conflict resolution based on newer wins with transforms (josh-a-hicks)

0005162: [Bug] Keystore becomes invalid after Generating and adding a new Keypair (elong) 0002423: [Bug] Create table with max varchar supported by target (emiller) 0005272: [Bug] Conflict Resolution of deletes of parent records fail to delete child records when child tables have no primary keys (pmarzullo) 0005273: [Bug] Rebuild trigger does not take into account the target platform (pmarzullo) 0005274: [Bug] Prevent "Failed to get hash code for field delimiter" warning message for SQL Server (emiller) 0005279: [Bug] FK correction for self referencing table. (josh-a-hicks) 0005285: [Bug] Create tables xml needs to escape double quotes on the database type (josh-a-hicks) 0005289: [Bug] Method in AbstractSqlTemplate Causes Recursive Looping with Android (elong) 0005313: [Bug] Null default values become string values when replicating tables from Oracle to MariaDB (elong) 0005318: [Bug] Conflict resolution batch with token parsing error when newlines in data (elong) 0005320: [Improvement] Use unique index for PK column names in trigger hist when table is missing primary key (elong) 0005321: [Bug] SymmetricDS Not Properly Handling Unable to Write Batch to Kafka Error (jvanmeter) 0005327: [Bug] Upgrade spring and okhttp (elong)

0005200: [Improvement] Allow specification of local user/password for running Windows service (pmarzullo) 0005213: [New Feature] Allow to save startup parameters in local keystore or in Azure Key Vault (pmarzullo) 0005260: [Bug] Sybase ASE with 2k page file fails to create SYM tables (600 is the maximum allowable size of an index.) (elong) 0005194: [Bug] DBCompare support for load only target nodes and log based source nodes. (josh-a-hicks) 0005204: [Improvement] MSSQL support for engine edition (josh-a-hicks) 0005214: [Bug] Column count error when load transform falls back to an insert with a column that is included on insert only (emiller) 0005216: [Bug] Metadata error can skip data when using dataloader.ignore.missing.tables parameter (elong) 0005255: [Bug] Monitor doesn't run when its type requires a cluster lock and it's supposed to run less often than the monitor job (emiller) 0005263: [Bug] CVE-2022-22965: Spring Version needs to use 5.2.20.RELEASE or 5.3.18 in order to not be vulnerable to this security issue (pmarzullo) 0005264: [Bug] Update any driver, module, or library that has a security vulnerability or serious defect (emiller)

0005160: [Bug] Db2DdlReader - Failed to read table (elong) 0005179: [Improvement] Provide wrapper.run.as.user property in sym_service.conf for open source users (pmarzullo) 0005191: [Bug] Upgrade log4j2 again again (elong) 0005171: [Bug] DB2 zOS support for clobs (josh-a-hicks)

0005166: [Bug] Initial load stuck in loop with "there is no content to read" error (elong) 0005158: [Bug] Upgrade log4j2 again (elong)

0005118: [Bug] During a full load do not ok existing batches for the same load id. (josh-a-hicks) 0005145: [Bug] Multiple active trigger histories result when more than one trigger assigned to a table (pmarzullo) 0005150: [Bug] Upgrade log4j2 (elong)

0004978: [Bug] Binary primary keys will not delete as part of conflict resolution (josh-a-hicks) 0005102: [Bug] Interbase Table SYM_TEMP_CONTEXT (elong) 0005113: [Bug] Data mapping is incorrect on an insert fallback to update potentially when column count on target is not the same as row data (josh-a-hicks) 0002970: [Bug] db connection leaks after engine stop (pmarzullo) 0003119: [Bug] Stopping service breaks connections with error in Interbase logs (pmarzullo) 0003382: [Bug] MV-Store DB corrupt after stopping SymmetricDS replication software (pmarzullo) 0003563: [Improvement] Purging large number of extract requests, query time out (elong) 0003897: [Improvement] Cleanly exit all job threads when engine is stopped (pmarzullo) 0004800: [Improvement] Subselect router expression improvement (elong) 0004955: [Improvement] Ignore batch status is sometimes overwritten (elong) 0004958: [Improvement] Initial load select boolean directly without template (elong) 0004993: [Improvement] Remove "databases" sub-directory (elong) 0004995: [Improvement] Upgrade Gradle to latest possible version (emiller) 0005013: [Bug] Registration server config_version not updating (elong) 0005015: [New Feature] Speed up start up by only checking tables when version changes (elong) 0005059: [Bug] var_row_data is defined as mediumtext (rudiejd) 0005098: [Improvement] Auto sync triggers at startup parameter default off and option to force rebuild (elong) 0005099: [New Feature] Purge trigger history (elong) 0005101: [Improvement] Changing parameters should not restart all jobs (elong) 0005107: [Improvement] Parameter staging.dir should be appended with the engine name (elong) 0005117: [Improvement] Increase size of file_name column in sym_file_snapshot (elong)