View Issue Details

IDProjectCategoryView StatusLast Update
0005128SymmetricDS ProBugpublic2022-08-15 16:10
Reporterharunkucuk5 Assigned To 
Status resolvedResolutionopen 
Product Version3.12.12 
Summary0005128: SymmetricDS ignores case sensitivity and merges different rows into a single row in target
DescriptionWe have realized the tables on the target node have fewer row numbers than the source and we looked into the details and it turned out like the following

we have Oracle source and MariaDB destination

for instance, we have 2 rows on the source like this

1 123abc 5 7
1 123ABC 5 7

these are different rows on the source but SymmetricDS migrates these two rows into a single row like below

1 123abc 5 7
TagsNo tags attached.



2021-12-01 18:30

developer   ~0002022

That sounds like case insensitive (CI) collation on MariaDB. The database rejects the second row because it violates the primary key, then SymmetricDS turns the insert into an update and overwrites the row. Change the collation of the database on MariaDB to be cases sensitive and you will get both rows.

Issue History

Date Modified Username Field Change
2021-11-19 20:59 harunkucuk5 New Issue
2021-12-01 18:30 elong Status new => feedback
2021-12-01 18:30 elong Note Added: 0002022
2022-08-15 15:28 cquamme Assigned To => cquamme
2022-08-15 15:28 cquamme Status feedback => assigned
2022-08-15 16:10 cquamme Assigned To cquamme =>
2022-08-15 16:10 cquamme Status assigned => resolved