View Issue Details

IDProjectCategoryView StatusLast Update
0005629SymmetricDSImprovementpublic2022-12-13 22:00
Reporteremiller Assigned Toemiller  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.13.0 
Target Version3.13.10Fixed in Version3.13.10 
Summary0005629: 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 0005628 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.13 f4fc815b

2022-12-13 21:28:30

evan-miller-jumpmind

Details Diff
0005629: Added query for parent row when deleting FK child rows during conflict resolution and old_data is null Affected Issues
0005629
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:31 emiller New Issue
2022-12-13 18:31 emiller Status new => assigned
2022-12-13 18:31 emiller Assigned To => emiller
2022-12-13 18:31 emiller Issue generated from: 0005628
2022-12-13 18:31 emiller Relationship added related to 0005628
2022-12-13 18:32 emiller Issue cloned: 0005630
2022-12-13 18:32 emiller Relationship added related to 0005630
2022-12-13 21:28 emiller Status assigned => resolved
2022-12-13 21:28 emiller Resolution open => fixed
2022-12-13 21:28 emiller Fixed in Version => 3.13.10
2022-12-13 22:00 Changeset attached => SymmetricDS 3.13 f4fc815b
2023-01-16 20:51 admin Status resolved => closed