Issues with Dynamic VDB to Models - FOREIGN KEY REFERENCING MULTIPLE COLUMNS ----------------------------------------------------------------------------- Key: TEIIDDES-2732 URL: https://issues.jboss.org/browse/TEIIDDES-2732 Project: Teiid Designer Issue Type: Bug Components: Dynamic VDBs, Import/Export, Patch Release Affects Versions: 9.2 Reporter: Debbie Steigner Assignee: Barry LaFond Labels: release_notes, verified_jbdsis-8.0.5 Fix For: 9.0.5, 9.2.1 Attachments: TestcaseforImport-vdb.xml, TestcaseforImport.zip AFTER IMPORTING FROM XML INTO TEIID: FOREIGN KEY REFERENCING MULTIPLE COLUMNS POINTS TO WRONG COLUMNS IN SOURCE MODEL Test case : Foreign key relation on Unique constraints, spanning two columns: CatalogItem(CatalogSecondID, CatalogThirdID)  Catalog(SecondID, ThirdID) XML INPUT fragment for Source model, table CatalogItem: CONSTRAINT FKI_CATALOG_ID FOREIGN KEY(CatalogID) REFERENCES Catalog(ID), CONSTRAINT FKI_SECOND_THIRD_ID FOREIGN KEY(CatalogSecondID, CatalogThirdID) REFERENCES Catalog(SecondID, ThirdID) Expected in Teiid: CatalogItem(CatalogSecondID, CatalogThirdID)  Catalog(SecondID, ThirdID) Actual: CatalogItem(CatalogSecondID, CatalogThirdID)  Catalog(ID) 3. AFTER IMPORTING FROM XML INTO TEIID: FOREIGN KEY REFERENCING MULTIPLE COLUMNS IS MISSING IN VIEW MODEL. Test case : Foreign key relation on Unique constraints, spanning two columns: CatalogItem(CatalogSecondID, CatalogThirdID)  Catalog(SecondID, ThirdID) XML INPUT fragment for View model, table CatalogItem: CONSTRAINT FKI_CATALOG_ID FOREIGN KEY(CatalogID) REFERENCES Catalog(ID), CONSTRAINT FKI_SECOND_THIRD_ID FOREIGN KEY(CatalogSecondID, CatalogThirdID) REFERENCES Catalog(SecondID, ThirdID) Expected in Teiid: CatalogItem(CatalogSecondID, CatalogThirdID)  Catalog(SecondID, ThirdID) Actual: Not Foreign key reference at all.