View Issue Details

IDProjectCategoryView StatusLast Update
0005121SymmetricDSBugpublic2021-12-11 17:11
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.13.0 
Target Version3.12.13Fixed in Version3.12.13 
Summary0005121: Data mapping is incorrect on an insert fallback to update potentially when column count on target is not the same as row data
DescriptionOn scenarios where the source has more columns that the target and an insert needs to fall back to an update because the row already exist at the target.
The additional columns need to be at the beginning of the list of columns
Steps To ReproduceSource
create table (extra_value varchar(100), id int, val1 varchar(100));

Target
create table (id int primary key, val1 varchar(100));

Insert a row at the source that already exists at the target

TagsNo tags attached.

Relationships

related to 0005113 closedjosh-a-hicks Data mapping is incorrect on an insert fallback to update potentially when column count on target is not the same as row data 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 e46c1c42

2021-11-15 19:27:01

admin

Details Diff
0005121: fix pk in different sequence Affected Issues
0005121
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriterConflictResolver.java Diff File

Issue History

Date Modified Username Field Change
2021-11-15 19:25 elong New Issue
2021-11-15 19:25 elong Status new => assigned
2021-11-15 19:25 elong Assigned To => elong
2021-11-15 19:25 elong Issue generated from: 0005113
2021-11-15 19:25 elong Relationship added related to 0005113
2021-11-15 19:27 elong Status assigned => resolved
2021-11-15 19:27 elong Resolution open => fixed
2021-11-15 19:27 elong Fixed in Version => 3.12.13
2021-11-15 20:00 admin Changeset attached => SymmetricDS 3.12 e46c1c42
2021-12-11 17:11 admin Status resolved => closed