[teiid-issues] [JBoss JIRA] (TEIID-4202) Support Lateral join and procedure pushdown

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-4202.
-----------------------------------
    Resolution: Done


Added the initial support targeting both procedure and lateral join pushdown to Teiid sources, and lateral join pushdown to newer postgresql.  There are still more targets that can added for pushdown, but that can be done with additional issues.

> Support Lateral join and procedure pushdown
> -------------------------------------------
>
>                 Key: TEIID-4202
>                 URL: https://issues.jboss.org/browse/TEIID-4202
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Misc. Connectors, Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 9.0
>
>
> Lateral joins of the form:
> select ... from x inner join lateral (... x.col ...) as y on ...
> Have been supported for some time, but not the ability to push them to source.
> A highly related scenario is to be able to push procedures used directly or in lateral joins with the rest of their plan:
> select ... from x inner join lateral (call proc(.. x.col ...)) as y on ...



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