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

      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: