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

subquery unnesting missed

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Done
    • Major
    • 8.12
    • None
    • Query Engine
    • None

    Description

      A query such as:

      select b.SYMBOL from PRODUCT b where exists (select 1 from PRICES d where d.SYMBOL=b.SYMBOL)

      where there is no key between the symbol columns will not unnested when it should be eligible.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: