[teiid-issues] [JBoss JIRA] (TEIID-5551) Inconsistency with document projection

[Steven Hawkins (Jira)]

     [ https://issues.jboss.org/browse/TEIID-5551?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins updated TEIID-5551:
----------------------------------

The logic here no opts to providing the full string value - which could be a breaking change for some scenarios - so it may need a flag for 11.2.x.

> Inconsistency with document projection
> --------------------------------------
>
>                 Key: TEIID-5551
>                 URL: https://issues.jboss.org/browse/TEIID-5551
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>            Priority: Major
>             Fix For: 12.0, 11.2.1
>
>
> When using the xml type for a given column the entire subtree is returned - which is universally the expected behavior.  If projection is used and another type is used, then only local node text will be considered.  If projection is disabled, all of the descendant text is considered.
> Based upon our initial consistency with oracle, we should consider all of the descendant text.
> for example:
> Select * From XmlTable('/root' Passing xmlparse(document '<root><def><test1>10</test1><test1>20</test1></def><abc>22</abc></root>') 
> Columns b varchar(40) Path 'def') xx
> should return 1020.



--
This message was sent by Atlassian Jira
(v7.12.1#712002)