XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Not A Problem
    • Affects Version/s: 2.1-incubating
    • Fix Version/s: None
    • Component/s: sql-cmp
    • Labels:
      None

      Description

      The subquery unnesting code relies on a certain structure of the query tree, with join and groupby nodes arranged in a certain way. If we have CommonSubExprRef nodes present in the tree, the unnesting logic doesn't recognize some of the patterns and subquery unnesting doesn't take place.

      Hopefully we can somehow ignore these extra nodes in subquery unnesting.

        Attachments

          Activity

            People

            • Assignee:
              hzeller Hans Zeller
              Reporter:
              hzeller Hans Zeller
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: