[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-2731) VDB exported to Dynamic VDB XML, the foreign key relations have erroneous references in the resulting SQL.

VDB exported to Dynamic VDB XML, the foreign key relations have erroneous references in the resulting SQL. ------------------------------------------------------------------------------------------------------------- Key: TEIIDDES-2731 URL: https://issues.jboss.org/browse/TEIIDDES-2731 Project: Teiid Designer Issue Type: Bug Components: Dynamic VDBs, Import/Export, Patch Release Affects Versions: 9.2 Reporter: Debbie Steigner Assignee: Barry LaFond Fix For: 9.2.1 Attachments: TestcaseforExport.zip Model: • Catalog (ID, SecondID, ThirdID). Primary key: (ID). Unique constraint: (SecondID, ThirdID) • CatalogItem(ID,CatalogID, CatalogSecondID, CatalogThirdID) Foreign key relation on Unique constraints, spanning two columns: CatalogItem(CatalogSecondID, CatalogThirdID)  Catalog(SecondID, ThirdID) Expected in metadata DLL for CatalogItem: CONSTRAINT FKI_SECOND_THIRD_ID FOREIGN KEY(CatalogSecondID, CatalogThirdID) REFERENCES Catalog(SecondID, ThirdID) Actual: CONSTRAINT FKI_SECOND_THIRD_ID FOREIGN KEY(CatalogSecondID, CatalogThirdID) REFERENCES Catalog(ID)