-
Bug
-
Resolution: Done
-
Major
-
9.2
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.
- is incorporated by
-
TEIIDDES-2699 Issues with Dynamic VDB import/export
- Closed