View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006452 | SymmetricDS | Bug | public | 2024-05-28 18:42 | 2024-05-28 19:00 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.15.7 | Fixed in Version | 3.15.7 | ||
| Summary | 0006452: Newer wins conflict detection table case when cross platform | ||||
| Description | The newer wins conflict detector queries sym_data to find a newer change for the row in conflict. If the case of the table name it is looking for doesn't match, then the newer row isn't found. The detector uses the case of the table name from the database metadata. But sync triggers uses the case from the configuration in sym_trigger, which is then used in sym_trigger_hist and sym_data. | ||||
| Steps To Reproduce | - Replicate between Oracle and Postgres - Configure sym_trigger with lower case table name (or use wizard on Postgres) - Enable debug logging for conflicts - Put an update into conflict | ||||
| Tags | conflict manager | ||||
|
SymmetricDS: 3.15 dc7d34df 2024-05-28 18:45:28 Details Diff |
0006452: Newer wins conflict detection table case when cross platform |
Affected Issues 0006452 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/load/DefaultDataLoaderFactory.java | Diff File | ||
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/AbstractDatabaseWriterConflictResolver.java | Diff File | ||
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriterConflictResolver.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-05-28 18:42 | elong | New Issue | |
| 2024-05-28 18:42 | elong | Status | new => assigned |
| 2024-05-28 18:42 | elong | Assigned To | => elong |
| 2024-05-28 18:42 | elong | Tag Attached: conflict manager | |
| 2024-05-28 18:46 | elong | Status | assigned => resolved |
| 2024-05-28 18:46 | elong | Resolution | open => fixed |
| 2024-05-28 18:46 | elong | Fixed in Version | => 3.15.7 |
| 2024-05-28 19:00 | admin | Changeset attached | => SymmetricDS 3.15 dc7d34df |
| 2024-06-07 16:46 | admin | Status | resolved => closed |