View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0005128 | SymmetricDS Pro | Bug | public | 2021-11-19 20:59 | 2022-08-15 16:10 |
Reporter | harunkucuk5 | Assigned To | |||
Priority | high | ||||
Status | resolved | Resolution | open | ||
Product Version | 3.12.12 | ||||
Summary | 0005128: SymmetricDS ignores case sensitivity and merges different rows into a single row in target | ||||
Description | We 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 | ||||
Tags | No tags attached. | ||||
|
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. |
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 |