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

XMLTable passing scalar subquery fails to evaluate

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Done
    • 7.1
    • 7.6
    • Query Engine
    • None

    Description

      Using a scalar subquery as a passing argument (for example - "select * from xmltable('/a/b' passing (SELECT xmlelement(name a, xmlAgg(xmlelement(name b, e1))) from pm1.g1) columns val string path '/.') as x" fails because the planner is not looking for suqueries in source nodes.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: