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

FilterProjectTransposeRule should allow filter conditions with correlated variables to be pushed down

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.17.0
    • Fix Version/s: 1.18.0
    • Component/s: core
    • Labels:
      None

      Description

      The rule always forbids conditions with correlated variables to be pushed down (as of CALCITE-769 to avoid certain problems in the decorrelation of the query). However, in the general context of query optimization, it is beneficial to push-down filters and the fact that there is a correlated variable is not a reason to skip this optimization.

      In order to avoid regressions, and at the same time enable correlated conditions to be pushed down we should make the pushing of correlated variables configurable.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                julianhyde Julian Hyde
                Reporter:
                zabetak Stamatis Zampetakis
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: