[teiid-issues] [JBoss JIRA] (TEIID-2503) XML Recursive and Nested Doc queries are producing "TEIID30328 Unable to evaluate "INPUT".nextKey: No value was available error"

[Steven Hawkins (JIRA)]

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

Steven Hawkins updated TEIID-2503:
----------------------------------

    Attachment: QT_PostgreSQL91_Push.vdb

    
> XML Recursive and Nested Doc queries are producing "TEIID30328 Unable to evaluate "INPUT".nextKey: No value was available error"
> --------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-2503
>                 URL: https://issues.jboss.org/browse/TEIID-2503
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.4
>         Environment: EAP6.1Alpha and Teiid8.4Alpha
>            Reporter: Warren Gibson
>            Assignee: Steven Hawkins
>            Priority: Minor
>         Attachments: QT_PostgreSQL91_Push.vdb, SERVER.log
>
>
> The following queries are producing TEIID30328 Unable to evaluate "INPUT".nextKey: No value was available error.
> The queries were returning expected query results in SOA-P5.3.1 release.  However, when testing them with EAP 6.1Alpha and
> Teiid 8.4Alpha they are returning the "Unable to evaluate "INPUT".nextKey" message.  This is occuring on Postgres91, Oracle10,11,11RAC, Mysql55, Teradata, and Greenplum data sources.
> I isolated "SELECT * FROM XQTNestedDoc.testSimpleNested ORDER BY recursiveroot.key" and ran a test to produce a log entry which 
> is attached.  If you need other testing artifacts such as VDB please let me know.
> SELECT * FROM XQTNestedDoc.testBoundTempTable
> SELECT * FROM XQTNestedDoc.testExcludeFromDoc ORDER BY recursiveroot.key
> SELECT * FROM XQTNestedDoc.testOptimizableTempTable ORDER BY recursiveroot.key
> SELECT * FROM XQTNestedDoc.testRootTempTable ORDER BY recursiveroot.key
> SELECT * FROM XQTNestedDoc.testSimpleNested ORDER BY recursiveroot.key
> SELECT * FROM XQTRecursiveDoc.testNested2Document ORDER BY recursiveroot.key
> SELECT * FROM XQTRecursiveDoc.testNestedDocument ORDER BY recursiveroot.key
> SELECT * FROM XQTRecursiveDoc.testSimpleDocument ORDER BY recursiveroot.key
> SELECT * FROM XQTRecursiveDoc.testSimpleTempTable ORDER BY recursiveroot.key

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira