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

Materialization matching succeeds when query and view are both of UNION but have different 'all' property

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

      Description

      Materialized-View:
      select * from emps where empid < 300
      union
      select * from emps where empid > 200
      
      Query:
      select * from emps where empid < 300
      union all
      select * from emps where empid > 200
      

      Above MV and Query have different 'all' property in UNION but they succeed matching now. 

        Attachments

        Issue Links

          Activity

            People

            • Assignee:
              jinxing6042@126.com Jin Xing
              Reporter:
              jinxing6042@126.com Jin Xing

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

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

                  Issue deployment