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

Query containing set operations (UNION/MINUS/INTERSECT) would cause infinite loop in materialization substitution

Rank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersConvert to sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 1.11.0
    • 1.12.0
    • core
    • None

    Description

      Example: select a from t1 union all select a from t2 where materialized views are defined on t1 and/or t2.
      This is because MutableMultiRel, being super class of MutableSetOp, did not set "parent" and "ordinal" for its input rels.

      Attachments

        Activity

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

          People

            maryannxue Wei Xue
            maryannxue Wei Xue
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment