View Issue Details

IDProjectCategoryView StatusLast Update
0005628SymmetricDSImprovementpublic2023-01-16 18:42
Reporteremiller Assigned Toemiller  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.12.0 
Target Version3.12.21Fixed in Version3.12.21 
Summary0005628: When deleting FK child rows during conflict resolution and old_data is null, query for the parent row on the target
DescriptionCurrently, when deleting FK child rows during conflict resolution, if old_data is null, SymmetricDS will attempt to use the pk_data to find the child rows. This does not work if the child rows reference a column that is not a part of the PK. In this case, it would be better to use the pk_data to query for the parent row on the target and then use the data from the target's parent row to find the child rows.
TagsNo tags attached.

Relationships

related to 0005629 closedemiller When deleting FK child rows during conflict resolution and old_data is null, query for the parent row on the target 
related to 0005630 closedemiller When deleting FK child rows during conflict resolution and old_data is null, query for the parent row on the target 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 195d744d

2022-12-13 19:42:59

evan-miller-jumpmind

Details Diff
0005628: Added query for parent row when deleting FK child rows during conflict resolution and old_data is null Affected Issues
0005628
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriterConflictResolver.java Diff File

Issue History

Date Modified Username Field Change
2022-12-13 18:30 emiller New Issue
2022-12-13 18:30 emiller Status new => assigned
2022-12-13 18:30 emiller Assigned To => emiller
2022-12-13 18:31 emiller Issue cloned: 0005629
2022-12-13 18:31 emiller Relationship added related to 0005629
2022-12-13 18:32 emiller Relationship added related to 0005630
2022-12-13 19:43 emiller Status assigned => resolved
2022-12-13 19:43 emiller Resolution open => fixed
2022-12-13 19:43 emiller Fixed in Version => 3.12.21
2022-12-13 20:00 Changeset attached => SymmetricDS 3.12 195d744d
2023-01-16 18:42 admin Status resolved => closed
2023-01-16 20:30 admin Status resolved => closed