[ https://issues.jboss.org/browse/TEIID-979?page=com.atlassian.jira.plugin.... ] 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} -- This message was sent by Atlassian JIRA (v6.4.11#64026)