Steven Hawkins created TEIID-5551:
-------------------------------------
Summary: 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
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)