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

common tables used in only 1 location which is a subquery still inlined

    XMLWordPrintable

Details

    • Quality Risk
    • Resolution: Done
    • Major
    • 12.0
    • None
    • Query Engine
    • None

    Description

      With a query such as:

      with x as (select ...)
      select (select ... from x where ...) from y

      The x common table is inlined even though it may be less efficient for processing.

      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: