[JBoss JIRA] (TEIID-5541) Incorrect parsing of xml with XmlTable
by dalex dalex (Jira)
[ https://issues.jboss.org/browse/TEIID-5541?page=com.atlassian.jira.plugin... ]
dalex dalex commented on TEIID-5541:
------------------------------------
Hi [~shawkins], I've checked new changes and now everything works as expected. Thx for the quick fix.
> 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
> Fix For: 11.0.3, 11.1.2, 12.0, 11.2.1
>
>
> 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)
6 years, 1 month
[JBoss JIRA] (TEIID-5536) Create separate repository for Thorntail modules
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5536?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5536:
---------------------------------------
After the pull request with various changes:
- 1.0.1 release (in progress). For some reason I need credentials for server ossrh even though that is not called that in our distributionManagement. Perhaps that's coming in from the parent somehow.
- deployment of the examples is dia
- a snapshot ci build has been added https://travis-ci.org/teiid/teiid-thorntail the logs needed trimming as the output exceed the default limits. There are a lot of "error" messages similar to Could not find artifact org.apache.cxf:cxf-rt-databinding-aegis:jar:3.1.12 that needed suppressed - THORN-791. The initial run took 15 minutes though...
TODO:
- expand the readme, add a build badge, etc.
- tests either in the main project or based upon the examples
- a full release triggered off of the creation of a label
> Create separate repository for Thorntail modules
> ------------------------------------------------
>
> Key: TEIID-5536
> URL: https://issues.jboss.org/browse/TEIID-5536
> Project: Teiid
> Issue Type: Task
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Major
>
> THORN-2232 Removes the Teiid modules from the core Thorntail repo for better release management. However, Teiid Thorntail would need a new home.
> Most notable breaking change will be, the package names will change from that of Thorntail.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
6 years, 1 month
[JBoss JIRA] (TEIID-5541) Incorrect parsing of xml with XmlTable
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5541?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5541:
---------------------------------------
> At least it breaks previous behavior.
Yes, that is another related case that needs addressed - we can use projection without streaming, but we can't do streaming processing without projection. This case wouldn't have been triggered before except in the case of a column path having multiple context items, which unfortunately there wasn't a test for.
There's a new commit to correct this.
> 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
> Fix For: 11.0.3, 11.1.2, 12.0, 11.2.1
>
>
> 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)
6 years, 1 month
[JBoss JIRA] (TEIID-5541) Incorrect parsing of xml with XmlTable
by dalex dalex (Jira)
[ https://issues.jboss.org/browse/TEIID-5541?page=com.atlassian.jira.plugin... ]
dalex dalex commented on TEIID-5541:
------------------------------------
[~shawkins] do you mean by the phrase "So for now document projection will not be allowed when root() is used." that now such query:
{code:sql}
Begin
Declare xml x = '<root><def><test1>10</test1><test1>20</test1></def><abc>22</abc></root>';
Select * From XmlTable (
'/root/abc'
Passing x
Columns
a string Path '.'
,b string Path 'root()'
)xx;
End;;
{code}
will return empty values for a and b though before your changes it returned 22 for a and 102022 for b.
I'm afraid that it's incorrect solution. At least it breaks previous behavior.
> 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
> Fix For: 11.0.3, 11.1.2, 12.0, 11.2.1
>
>
> 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)
6 years, 1 month