[teiid-issues] [JBoss JIRA] Issue Comment Edited: (TEIID-1448) XMLTABLE processing should support streaming when possible

[ https://issues.jboss.org/browse/TEIID-1448?page=com.atlassian.jira.plugin... ] Steven Hawkins edited comment on TEIID-1448 at 6/10/11 2:00 PM: ---------------------------------------------------------------- Integrated XOM/NUX for situations where simple context item xquery expressions and path expressions allow for subtrees to be processed independently. The reference guide was updated with the current limitations (in short, context expressions must be a simple path to a non-root element). We can look at expanding the logic later to handle predicates or other more complicated expressions. Example workaround to simplify the context expression: If a user wishes to perform streaming but wants a predicate applied, they would omit the predicate from the context path and instead use criteria to filter results. So instead of: SELECT * FROM XMLTABLE('/a/b[@x=1]/c' PASSING doc COLUMNS z string) t they would use: SELECT * FROM XMLTABLE('/a/b/c' PASSING doc COLUMNS z string, x integer PATH '../@x') t WHERE x = 1 was (Author: shawkins): Integrated XOM/NUX for situations where simple context item xquery expressions and path expressions allow for subtrees to be processed independently. The reference guide was updated with the current limitations (in short, context expressions must be a simple path to a non-root element). We can look at expanding the logic later to handle predicates or other more complicated expressions. Example workaround to simplify the context expression: If a user wishes to perform streaming but wants a predicate applied, they would omit the predicate from the context path and instead use criteria to filter results. So instead of: SELECT * FROM XMLTABLE('/a/b[\@x=1]/c' PASSING doc COLUMNS z string) t they would use: SELECT * FROM XMLTABLE('/a/b/c' PASSING doc COLUMNS z string, x integer PATH '../@x') t WHERE x = 1 -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira