View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005437 | SymmetricDS | Bug | public | 2022-09-06 11:14 | 2022-09-21 21:07 |
| Reporter | jvanmeter | Assigned To | jvanmeter | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.0 | ||||
| Target Version | 3.12.18 | Fixed in Version | 3.12.18 | ||
| Summary | 0005437: Conflict resolver fails if there are no primary keys on the target and it is set to not use primary keys from source | ||||
| Description | If the dataloader.use.primary.keys.from.source is set to false, and the target has no primary keys, the Conflict Resolution fails. This happens because when it gets into the Conflict Resolver, it attempts to create a where clause using the target table primary keys, however in this case there are none, resulting in an empty where clause that throws a sql error. | ||||
| Steps To Reproduce | Setup Two nodes, Source and a Load-Only Target Source table with no primary keys Target table with no primary keys Set dataloader.use.primary.keys.from.source to false Create a conflict. Can achieve this by stopping the pull job on the target, update a row on the target and then updating the same row with different data on the source and then starting the pull job on the target again. | ||||
| Tags | conflict manager | ||||
|
SymmetricDS: 3.12 dfc952d7 2022-09-06 17:26:44 jakobvanmeter Details Diff |
0005437: Conflict resolver fails if there are no primary keys on the target and it is set to not use primary keys from source |
Affected Issues 0005437 |
|
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriter.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2022-09-06 11:14 | jvanmeter | New Issue | |
| 2022-09-06 11:14 | jvanmeter | Status | new => assigned |
| 2022-09-06 11:14 | jvanmeter | Assigned To | => jvanmeter |
| 2022-09-06 17:21 | jvanmeter | Status | assigned => resolved |
| 2022-09-06 17:21 | jvanmeter | Resolution | open => fixed |
| 2022-09-06 17:21 | jvanmeter | Fixed in Version | => 3.12.18 |
| 2022-09-06 17:21 | jvanmeter | Tag Attached: conflict manager | |
| 2022-09-06 18:00 | Changeset attached | => SymmetricDS 3.12 dfc952d7 | |
| 2022-09-21 21:07 | elong | Status | resolved => closed |