[teiid-issues] [JBoss JIRA] (TEIID-3652) Teiid could push some outer joins to the source database, but does not

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3652?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins closed TEIID-3652.
---------------------------------


> Teiid could push some outer joins to the source database, but does not
> ----------------------------------------------------------------------
>
>                 Key: TEIID-3652
>                 URL: https://issues.jboss.org/browse/TEIID-3652
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.11.2
>            Reporter: Mike Higgins
>            Assignee: Steven Hawkins
>             Fix For: 8.12
>
>
> In the following SQL:
> select *
> from s1.t1 t1
> left outer join s2.t2 t2 on (t1.id = t2.id)
> left outer join s2.t3 t3 on (t2.id2 = t3.id2)
> where t1.name = 'x'
> option makedep s2.t2
>  
> where t1 is in one database and t2 and t3 are in a different database,
> Teiid could push the second left outer join to the source database.  Currently, it does not and performs the join itself.  Some outer joins cannot be pushed, of course, but this one and others like it could be.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)