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

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

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.17.0
    • 1.18.0
    • core
    • 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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment