0004553: Transforms break deletes when transforming primary key column and not capturing old data as specified in trigger - SymmetricDS

ID	Project	Category	View Status	Date Submitted	Last Update

0004553	SymmetricDS	Bug	public	2020-09-16 20:43	2020-09-23 20:34

Reporter	pmarzullo	Assigned To	pmarzullo
Priority	normal
Status	closed	Resolution	fixed
Product Version	3.12.3
Target Version	3.12.4	Fixed in Version	3.12.4

Summary	0004553: Transforms break deletes when transforming primary key column and not capturing old data as specified in trigger
Description	When a trigger is set up to not capture old data, and a transform is created that transforms a primary key column, the value of the primary key column ends up being null instead of the value that the transform set it to because the transforms set the value to the old value of a NewAndOldValue object. Then the TransformWriter takes that old value from the NewAndOldValue object ignores it because there are no oldSourceValues because the trigger did not capture old data.
Steps To Reproduce	1. Set up trigger to not capture old data. 2. Set up transform, with a primary key set to a "bsh" type of transform, with the expression set to "return currentValue;". 3. Cause a delete to be captured. 4. Target record will not be deleted. The staging file should have a null value for the primary key value.
Tags	transformation

Date Modified	Username	Field	Change
2020-09-16 20:43	pmarzullo	New Issue
2020-09-16 20:43	pmarzullo	Status	new => assigned
2020-09-16 20:43	pmarzullo	Assigned To	=> pmarzullo
2020-09-16 20:43	pmarzullo	Tag Attached: transformation
2020-09-16 20:43	pmarzullo	Relationship added	related to 0004552
2020-09-16 20:43	pmarzullo	Status	assigned => resolved
2020-09-16 20:43	pmarzullo	Resolution	open => fixed
2020-09-16 20:43	pmarzullo	Fixed in Version	=> 3.12.4
2020-09-23 20:34	admin	Status	resolved => closed