View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006367 | SymmetricDS | Bug | public | 2024-04-29 14:58 | 2024-04-29 15:11 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.14.0 | ||||
| Target Version | 3.14.15 | Fixed in Version | 3.14.15 | ||
| Summary | 0006367: Auto resolve delete of blocking rows when binary type in primary key | ||||
| Description | The auto resolver can detect and remove a blocking row with a unique key or child foreign key reference. When a binary type is used in the primary key, the auto resolver uses the wrong value for primary key when querying foreign key children. The routine expects a Row with Object values (a byte array for the binary type), but it is passed a Row with String values (a base64 or hex string for the binary type). | ||||
| Steps To Reproduce | 1. create a table with a binary/varbinary in the primary key, and a unique index on another column 2. create a table that references the first table 3. insert a row on target 4. insert a row on the source that matches the unique index of the target Expected: It should delete blocking rows for foreign key child and unique constraint Actual: It tries to query and look up foreign key child with wrong value for primary key, so no blocking rows are cleared, and the row won't load | ||||
| Tags | conflict manager | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-04-29 14:58 | elong | New Issue | |
| 2024-04-29 14:58 | elong | Status | new => assigned |
| 2024-04-29 14:58 | elong | Assigned To | => elong |
| 2024-04-29 14:58 | elong | Tag Attached: conflict manager | |
| 2024-04-29 14:58 | elong | Issue generated from: 0006363 | |
| 2024-04-29 14:58 | elong | Relationship added | related to 0006363 |
| 2024-04-29 15:11 | elong | Status | assigned => resolved |
| 2024-04-29 15:11 | elong | Resolution | open => fixed |
| 2024-04-29 15:11 | elong | Fixed in Version | => 3.14.15 |
| 2024-05-03 17:35 | admin | Status | resolved => closed |