View Issue Details

IDProjectCategoryView StatusLast Update
0004293SymmetricDSBugpublic2020-03-04 13:13
ReporterelongAssigned Toelong 
Prioritynormal 
Status closedResolutionfixed 
Product Version3.11.0 
Target Version3.11.6Fixed in Version3.11.6 
Summary0004293: Auto resolve fails for delete or update when existing child row references candidate key
DescriptionAuto resolve fails to delete or update gets a foreign key error when one of:

1) existing child row that references a candidate key on the table
OR
2) old data capture is turned off
Steps To Reproducecreate table t1 (id integer primary key, name varchar(100));
create unique index i_t1_name on t1(name);
create table t2 (id integer primary key, name varchar(100) references t1(name));

TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.11 2e5be6b2

2020-02-27 13:28:52

admin

Details Diff
0004293: Auto resolve fails for delete/update when existing child row
references candidate key

0004293
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriterConflictResolver.java Diff File

Issue History

Date Modified Username Field Change
2020-02-27 13:25 elong New Issue
2020-02-27 13:25 elong Status new => assigned
2020-02-27 13:25 elong Assigned To => elong
2020-02-27 13:29 elong Summary Auto resolve fails for delete when existing child row references candidate key => Auto resolve fails for delete or update when existing child row references candidate key
2020-02-27 13:29 elong Description Updated View Revisions
2020-02-27 13:29 elong Status assigned => resolved
2020-02-27 13:29 elong Resolution open => fixed
2020-02-27 13:29 elong Fixed in Version => 3.11.6
2020-02-27 14:00 admin Changeset attached => SymmetricDS 3.11 2e5be6b2
2020-03-04 13:13 chenson Status resolved => closed