View Issue Details

Related ChangesetsJump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0003624SymmetricDSBugpublic2018-07-11 14:122019-04-26 16:50
Reporterabrougher Assigned Tochenson  
Priorityhigh 
Status closedResolutionfixed 
Product Version3.9.9 
Target Version3.9.10Fixed in Version3.9.10 
Summary0003624: Some situations can cause a transformed value to be written to the old column value instead of the new column value.
DescriptionWhen transforms run they check if the Source DML Type is DELETE. If the source DML type is delete, the transformed value is saved in the old column.

This can be an issue if the Target DML Type was converted to UPDATE.

We should check the target DML type instead of the source DML type, and only stash the converted value in the old column if the target dml type is DELETE.
TagsNo tags attached.

Relationships

related to 0003605 closedelong Transforms should return an old value for delete and new value for insert and updates 
related to 0002694 closedelong (lookup)Transform and LoadFilter on DELETE 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.9 d8638a5f

2018-07-11 12:15:54

chenson42

Details Diff 		0003624: Some situations can cause a transformed value to be written to
the old column value instead of the new column value.		 Affected Issues
0003624
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/io/data/transform/BshColumnTransform.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/io/data/transform/LookupColumnTransform.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/io/data/transform/ParameterColumnTransform.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/transform/BinaryLeftColumnTransform.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/transform/ClarionDateTimeColumnTransform.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/transform/ConstantColumnTransform.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/transform/IsNullTransform.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/transform/LeftColumnTransform.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/transform/MathColumnTransform.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/transform/SubstrColumnTransform.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/transform/ValueMapColumnTransform.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/TransformWriter.java Diff File

SymmetricDS: 3.9 2557e3a6

2018-07-13 08:03:34

chenson42

Details Diff 		0003624: Some situations can cause a transformed value to be written to
the old column value instead of the new column value.		 Affected Issues
0003624
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/TransformWriter.java Diff File

SymmetricDS: 3.9 6f3b8e41

2018-07-13 08:03:48

chenson42

Details Diff 		0003624: Some situations can cause a transformed value to be written to
the old column value instead of the new column value.		 Affected Issues
0003624
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/transform/TargetDmlAction.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/transform/TransformedData.java Diff File

Issue History

Date Modified Username Field Change
2018-07-11 14:12 abrougher New Issue
2018-07-11 14:12 abrougher Status new => assigned
2018-07-11 14:12 abrougher Assigned To => chenson
2018-07-11 14:24 mmichalek Relationship added related to 0003605
2018-07-11 14:24 mmichalek Project SymmetricDS Pro => SymmetricDS
2018-07-11 16:15 chenson Fixed in Version => 3.9.10
2018-07-11 16:15 chenson Target Version => 3.9.10
2018-07-11 16:16 chenson Status assigned => resolved
2018-07-11 16:16 chenson Resolution open => fixed
2018-07-11 17:00 chenson42 Changeset attached => SymmetricDS 3.9 d8638a5f
2018-07-13 13:00 chenson42 Changeset attached => SymmetricDS 3.9 6f3b8e41
2018-07-13 13:00 chenson42 Changeset attached => SymmetricDS 3.9 2557e3a6
2018-08-03 14:12 chenson Status resolved => closed
2019-04-26 16:50 elong Relationship added related to 0002694