View Issue Details

IDProjectCategoryView StatusLast Update
0004212SymmetricDSBugpublic2020-01-02 09:42
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.8.12 
Target Version3.11.3Fixed in Version3.11.3 
Summary0004212: Resolve foreign key violation can pick up table from wrong catalog or schema
DescriptionWhen 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 Reproduce1. 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
TagsNo tags attached.

Relationships

related to 0002947 closedelong Auto resolve foreign key violation fails when table in different catalog or schema 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.11 e858fd9a

2019-12-18 13:45:46

admin

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

admin

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

admin

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

Issue History

Date Modified Username Field Change
2019-12-18 12:53 elong New Issue
2019-12-18 12:53 elong Status new => assigned
2019-12-18 12:53 elong Assigned To => elong
2019-12-18 13:36 elong Relationship added related to 0002947
2019-12-18 13:41 elong Status assigned => resolved
2019-12-18 13:41 elong Resolution open => fixed
2019-12-18 13:41 elong Fixed in Version => 3.11.3
2019-12-18 14:00 admin Changeset attached => SymmetricDS 3.11 8429d37f
2019-12-18 14:00 admin Changeset attached => SymmetricDS 3.11 ea9929dc
2019-12-18 14:00 admin Changeset attached => SymmetricDS 3.11 e858fd9a
2020-01-02 09:42 admin Status resolved => closed