Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-2503

XML Recursive and Nested Doc queries are producing "TEIID30328 Unable to evaluate "INPUT".nextKey: No value was available error"

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Minor Minor
    • None
    • 8.4
    • Query Engine
    • None
    • EAP6.1Alpha and Teiid8.4Alpha

      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

              rhn-engineering-shawkins Steven Hawkins
              wgibson_jira Warren Gibson (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: