[teiid-issues] [JBoss JIRA] (TEIID-5541) Incorrect parsing of xml with XmlTable
[
https://issues.jboss.org/browse/TEIID-5541?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-5541:
---------------------------------------
//root creates the path map entry:
{code}
descendantelement(Q{}root)
{code}
root()/root creates the path map entries:
{code}
descendant-or-selfelement()
descendantelement()
childelement(Q{}root)
{code}
In the latter case the path map filter logic will accept all elements, and won't
descend to the point of seeing the text of the child node as needed. Still trying to
determine if this is a general issue with our path map logic, or if this is specific to
the root function.
Incorrect parsing of xml with XmlTable
--------------------------------------
Key: TEIID-5541
URL: https://issues.jboss.org/browse/TEIID-5541
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 11.1
Environment: teiid-11.1.0 (from 01.09.2018) on WildFly Full 11.0.0.Final (WildFly
Core 3.0.8.Final)
Reporter: dalex dalex
Assignee: Steven Hawkins
Priority: Blocker
Running the query:
{code:sql}
Begin
Declare xml xcontent = '<root
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<report>
<data>
<year xsi:type="decimal">2018</year>
</data>
</report>
<waitSeconds xsi:type="decimal">13</waitSeconds>
</root>' ;
Select *
From
XmlTable(
XmlNamespaces ('http://www.w3.org/2001/XMLSchema-instance' as xsi),
'/root/report/data'
PASSING xcontent
Columns
"year" integer,
waitSeconds xml Path 'root()/root/waitSeconds',
waitSecondsStr string Path 'root()/root/waitSeconds'
)a ;
End ;;
{code}
and having a look at the structure we can see that the value 13 should be returned, while
the value is not picked from xml for result.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)