[teiid-issues] [JBoss JIRA] (TEIID-979) Add pushdown support for sql/xml functions

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-979:
--------------------------------------

> Is there any reason this never got finished?

It's a large amount of work, but not often requested.

> To further explain my use-case, here's a query that does N-many queries (one per ITEM).

Yes, unfortunately we only currently convert to traditional join / semi-join processing for subqueries in the the where clause.

> I'm not sure if the reason it's not getting pushed down is because XML functions are not, or if it's something to do with the aggregate/subquery?

The xml* functions are currently not pushed, so that is the primary reason.  If Teiid simply generated a plan that pushed a join rather than individually processing the subqueries, would that be acceptable?  Otherwise can you create a sub-task with the specific sql/xml constructs you need to be pushed?

> Add pushdown support for sql/xml functions
> ------------------------------------------
>
>                 Key: TEIID-979
>                 URL: https://issues.jboss.org/browse/TEIID-979
>             Project: Teiid
>          Issue Type: Sub-task
>          Components: JDBC Connector
>    Affects Versions: 7.1
>            Reporter: Marc Shirley
>            Assignee: Steven Hawkins
>
> We should have pushdown support for SQL/XML functionality.  In particular Oracle and DB2 have support.
> see also case 5715



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