0004293: Auto resolve fails for delete or update when existing child row references candidate key - SymmetricDS

ID	Project	Category	View Status	Date Submitted	Last Update

0004293	SymmetricDS	Bug	public	2020-02-27 18:25	2020-03-04 18:13

Reporter	elong	Assigned To	elong
Priority	normal
Status	closed	Resolution	fixed
Product Version	3.11.0
Target Version	3.11.6	Fixed in Version	3.11.6

Summary	0004293: Auto resolve fails for delete or update when existing child row references candidate key
Description	Auto 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 Reproduce	create 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));
Tags	No tags attached.

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		Affected Issues 0004293
	mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriterConflictResolver.java		Diff File

Date Modified	Username	Field	Change
2020-02-27 18:25	elong	New Issue
2020-02-27 18:25	elong	Status	new => assigned
2020-02-27 18:25	elong	Assigned To	=> elong
2020-02-27 18: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 18:29	elong	Description Updated	View Revisions
2020-02-27 18:29	elong	Status	assigned => resolved
2020-02-27 18:29	elong	Resolution	open => fixed
2020-02-27 18:29	elong	Fixed in Version	=> 3.11.6
2020-02-27 19:00	admin	Changeset attached	=> SymmetricDS 3.11 2e5be6b2
2020-03-04 18:13	chenson	Status	resolved => closed