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

SemiJoin operator is not skipped in materialized view-based rewriting algorithm

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.28.0
    • None

    Description

      This had been solved in CALCITE-2277 but apparently it was broken in CALCITE-2969 (MaterializedViewRelOptRulesTest.testJoinMaterialization11 result was modified assuming the change was correct). The rewriting algorithm does not support semijoin so this can lead to incorrect results.

      Attachments

        Issue Links

        is caused by

        Improvement - An improvement or enhancement to an existing feature or task. CALCITE-2969 Improve design of join-like relational expressions

        • Major - Major loss of function.
        • Closed
        links to

        Web Link GitHub Pull Request #2557

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

          People

            jcamacho Jesús Camacho Rodríguez
            jcamacho Jesús Camacho Rodríguez
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 10m
                10m

                Slack

                  Issue deployment