View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004212 | SymmetricDS | Bug | public | 2019-12-18 17:53 | 2020-01-02 14:42 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.8.12 | ||||
| Target Version | 3.11.3 | Fixed in Version | 3.11.3 | ||
| Summary | 0004212: Resolve foreign key violation can pick up table from wrong catalog or schema | ||||
| Description | When encountering a foreign key violation, the source will try to look up the missing rows using foreign key references. It incorrectly uses NULL for the catalog and schema, which can access the wrong catalog and schema. | ||||
| Steps To Reproduce | 1. Setup databases elong and elong2 on SQL-Server 2. Install SymmetricDS to elong 3. Create the same tables in elong and elong2 4. Configure replication for the elong2 tables. 5. Make a foreign key violation during sync | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.11 e858fd9a 2019-12-18 13:45:46 Details Diff |
0004212: Resolve foreign key violation can pick up table from wrong catalog or schema |
Affected Issues 0004212 |
|
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/AbstractJdbcDdlReader.java | Diff File | ||
|
SymmetricDS: 3.11 ea9929dc 2019-12-18 13:46:17 Details Diff |
0004212: Resolve foreign key violation can pick up table from wrong catalog or schema |
Affected Issues 0004212 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java | Diff File | ||
|
SymmetricDS: 3.11 8429d37f 2019-12-18 13:50:47 Details Diff |
0004212: Resolve foreign key violation can pick up table from wrong catalog or schema |
Affected Issues 0004212 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-12-18 17:53 | elong | New Issue | |
| 2019-12-18 17:53 | elong | Status | new => assigned |
| 2019-12-18 17:53 | elong | Assigned To | => elong |
| 2019-12-18 18:36 | elong | Relationship added | related to 0002947 |
| 2019-12-18 18:41 | elong | Status | assigned => resolved |
| 2019-12-18 18:41 | elong | Resolution | open => fixed |
| 2019-12-18 18:41 | elong | Fixed in Version | => 3.11.3 |
| 2019-12-18 19:00 | admin | Changeset attached | => SymmetricDS 3.11 8429d37f |
| 2019-12-18 19:00 | admin | Changeset attached | => SymmetricDS 3.11 ea9929dc |
| 2019-12-18 19:00 | admin | Changeset attached | => SymmetricDS 3.11 e858fd9a |
| 2020-01-02 14:42 | admin | Status | resolved => closed |