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

Must pushdown correlated subquery without from fails

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 12.2, 11.2.3, 12.1.1
    • None
    • Query Engine
    • None

      A query such as:

      select (select func(e1)) from g1

      where func is a must pushdown function will fail due to not finding the correlated value e1. This happens regardless of whether func is from the same source as g1 - because currently the plan will be the same either way (we don't yet see a way to associate the subplan with the g1 source).

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

                Created:
                Updated:
                Resolved: