View Issue Details

IDProjectCategoryView StatusLast Update
0006367SymmetricDSBugpublic2024-04-29 15:11
Reporterelong Assigned Toelong  
Status closedResolutionfixed 
Product Version3.14.0 
Target Version3.14.15Fixed in Version3.14.15 
Summary0006367: Auto resolve delete of blocking rows when binary type in primary key
DescriptionThe 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 Reproduce1. 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

It should delete blocking rows for foreign key child and unique constraint

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
Tagsconflict manager


related to 0006363 closedelong Auto resolve delete of blocking rows when binary type in primary key 


There are no notes attached to this issue.

Issue History

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