[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-2672) Wrong Foreign Key reference when exporting Dynamic VDB

Andrej Šmigala created TEIIDDES-2672: ---------------------------------------- Summary: Wrong Foreign Key reference when exporting Dynamic VDB Key: TEIIDDES-2672 URL: https://issues.jboss.org/browse/TEIIDDES-2672 Project: Teiid Designer Issue Type: Bug Components: Import/Export, Modeling, VDB & Execution Affects Versions: 9.0.4 Reporter: Andrej Šmigala Attachments: DynamicVdbFk.zip When creating a dynamic VDB from an existing VDB, Foreign Key definitions use the wrong table in the REFERENCES clause. The reference table is the same as the one that contains this FK. For example, in the table SUPPLIER_PARTS, the following constraint is generated: {code:sql}CONSTRAINT FK_SPLIER_PRTS_SPLY FOREIGN KEY(SUPPLIER_ID) REFERENCES SUPPLIER_PARTS(SUPPLIER_ID){code} which is obviously wrong. The correct constrant definition should be: {code:sql}CONSTRAINT FK_SPLIER_PRTS_SPLY FOREIGN KEY(SUPPLIER_ID) REFERENCES SUPPLIER(SUPPLIER_ID){code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)