[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-2660) Add support in Designer for foreign keys cross models
[
https://issues.jboss.org/browse/TEIIDDES-2660?page=com.atlassian.jira.plu...
]
Matus Makovy commented on TEIIDDES-2660:
----------------------------------------
I have a project with 1 source model and 2 view models. Each of the models contains one
table. One of them uses foreign key from the second one. Designer complains about the
circular dependency, but I don't think there is one.
Project attached.
Add support in Designer for foreign keys cross models
-----------------------------------------------------
Key: TEIIDDES-2660
URL: https://issues.jboss.org/browse/TEIIDDES-2660
Project: Teiid Designer
Issue Type: Feature Request
Components: Modeling
Reporter: Van Halbert
Assignee: Barry LaFond
Fix For: 11.0.1
Add support in Designer for foreign keys cross models.
In Designer you cannot have a FK cross models. That is not a limitation with DDL metadata
in Teiid. It's a misstatement to relate that to optimization. If the PK/FK is present
we'll use that information just as we would in a single source - we do not however
enforce the FK. That can be done through the use of an update procedure though.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)