[teiid-issues] [JBoss JIRA] (TEIID-2870) Expand "allow-join" extension property on Foreign Key

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2870?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12948680#comment-12948680 ] 

Steven Hawkins commented on TEIID-2870:
---------------------------------------

Can you elaborate on 2)?  From an engine perspective we'll see child left outer join parent (once the right outer join has been reversed).  We don't have the logic in there currently, but we could detect if there is a foreign key from parent to child and then further rewrite as child inner join parent.  From there since inner join is commutative, that's the same as parent inner join child.  So if inner join is ok, wouldn't that case still be covered?
                
> Expand "allow-join" extension property on Foreign Key
> -----------------------------------------------------
>
>                 Key: TEIID-2870
>                 URL: https://issues.jboss.org/browse/TEIID-2870
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Query Engine
>    Affects Versions: 8.7
>            Reporter: Ramesh Reddy
>            Assignee: Steven Hawkins
>
> Currently "allow-join" property on a Foreign Key, defines if the joins based on that Foreign Key that are valid to push to the source or not, when JOIN capability is turned on at translator level. This feature is used in the MongoDB translator to allow JOINS to pushed to source.
> What I have seen is "allow-join" is blanket capability that says it supports all LEFT, RIGHT, INNER and CROSS JOINS.  It is useful to define this capability in fine grained manner to allow each kind of JOIN explicitly to control the JOIN behavior.
> The need came from MongoDB translator, where INNER,LEFT are possible but CROSS and RIGHT are not.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira