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