View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006727 | SymmetricDS Pro | Improvement | public | 2025-02-13 13:53 | 2025-04-23 19:14 |
| Reporter | pbelov | Assigned To | elong | ||
| Priority | high | ||||
| Status | resolved | Resolution | fixed | ||
| Target Version | 3.16.2 | Fixed in Version | 3.16.2 | ||
| Summary | 0006727: Include primary key transforms in the Compare and Repair process | ||||
| Description | Include primary key transforms in the Compare and Repair process. Use case is the source_node_id is added by a transform when syncing data from a store node to central node. | ||||
| Steps To Reproduce | Create table at the store node Create same table with addition of source_node_id to PK via transform at the central server node Run Compare and Repair for this table | ||||
| Tags | No tags attached. | ||||
|
|
Current way it's handled is it expects an "initial load select" to be configured on table routing to get the correct subset of rows from central. It excludes columns from comparison if there is a transform with no source column. It supports schema transform, like renaming columns, but not data transformation. In a later phase, we can add support for comparison involving sub-setting of data through routers and data transformation. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-02-13 13:53 | pbelov | New Issue | |
| 2025-03-31 19:52 | elong | Description Updated | View Revisions |
| 2025-03-31 19:52 | elong | Steps to Reproduce Updated | View Revisions |
| 2025-04-23 12:47 | elong | Assigned To | => elong |
| 2025-04-23 12:47 | elong | Status | new => resolved |
| 2025-04-23 12:47 | elong | Resolution | open => fixed |
| 2025-04-23 12:47 | elong | Fixed in Version | => 3.16.2 |
| 2025-04-23 12:51 | elong | Note Added: 0002836 |