[teiid-issues] [JBoss JIRA] (TEIID-979) Add pushdown support for sql/xml functions
[
https://issues.jboss.org/browse/TEIID-979?page=com.atlassian.jira.plugin....
]
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)