Debbie Steigner created TEIIDDES-2731: ----------------------------------------- Summary: 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: Import/Export Affects Versions: 9.2 Reporter: Debbie Steigner 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) -- This message was sent by Atlassian JIRA (v6.4.11#64026)