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

[Tom Arnold (JIRA)]

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

Tom Arnold commented on TEIID-979:
----------------------------------

To further explain my use-case, here's a query that does N-many queries (one per ITEM). I would instead want this whole thing to get pushed down.

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?

{code:sql}
select
"ITEMS"."ITEM_ID" "ITEM_ID",
(
    select xmlelement (
        name "attributes",
        xmlagg(
            xmlelement(
                name "attribute", 
                xmlattributes(
                    "ITEM_ATTRIBUTES"."ATTR_NAME" as "name", 
                    "ITEM_ATTRIBUTES"."ATTR_VALUE" as "value"
                )
            )
        )
    )
    from "ITEM_ATTRIBUTES" "ITEM_ATTRIBUTES"
    where (
        "ITEMS"."ITEM_ID" = "ITEM_ATTRIBUTES"."ITEM_ID"
    )
) "ITEM_ATTRIBUTES"
from "ITEMS" "ITEMS";
{code}

{code}
ITEM_ID    ITEM_ATTRIBUTES
3          <attributes><attribute name="foo" value="bar"></attribute><attribute name="baz" value="blah"></attribute></attributes>
4          <attributes><attribute name="foo" value="123"></attribute><attribute name="baz" value="456"></attribute></attributes>
{code}

> 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)