Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1045

Decorrelate sub-queries in Project and Join

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      In CALCITE-816 we created a representation of sub-query in the relational algebra, RexSubQuery, so that we could defer expanding and de-correlating sub-queries until after SqlNode tree has been converted to RelNode tree. But the RelDecorrelator can only reliably handle sub-queries that occur in a Filter (such as WHERE EXISTS or WHERE IN).

      This task would except RelDecorrelator to handle sub-queries in Project (which occur with scalar sub-queries in the SELECT clause) and sub-queries in Join (which occur with scalar sub-queries in the ON clause of a JOIN).

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                julianhyde Julian Hyde
              • Votes:
                2 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated: