View Issue Details

IDProjectCategoryView StatusLast Update
0005113SymmetricDSBugpublic2021-11-24 18:31
Reporterjosh-a-hicks Assigned Tojosh-a-hicks  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.13.0 
Target Version3.13.0Fixed in Version3.13.0 
Summary0005113: 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 0005121 closedelong 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.13 abc7f759

2021-11-03 16:34:15

joshahicks

Details Diff
0005113: Data mapping is incorrect on an insert fallback to update
potentially when column count on target is not the same as row data
Affected Issues
0005113
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/CsvData.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriterConflictResolver.java Diff File

SymmetricDS: 3.13 eb07b2f2

2021-11-15 19:15:07

admin

Details Diff
0005113: fix pk columns in different sequence Affected Issues
0005113
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/CsvData.java Diff File
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-01 13:35 josh-a-hicks New Issue
2021-11-01 18:54 elong Steps to Reproduce Updated View Revisions
2021-11-03 17:00 Changeset attached => SymmetricDS 3.13 abc7f759
2021-11-15 19:25 elong Issue cloned: 0005121
2021-11-15 19:25 elong Relationship added related to 0005121
2021-11-15 20:00 admin Changeset attached => SymmetricDS 3.13 eb07b2f2
2021-11-24 18:31 elong Assigned To => josh-a-hicks
2021-11-24 18:31 elong Status new => closed
2021-11-24 18:31 elong Resolution open => fixed
2021-11-24 18:31 elong Fixed in Version => 3.13.0
2021-11-24 18:31 elong Target Version => 3.13.0