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

Add UnionToUnionRule for materialization matching

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

      Description

      Below materialization matching fails now

        @Test public void testDEV() {
          String sql0 = "select * from \"emps\" where \"empid\" < 300";
          String sql1 = "select * from \"emps\" where \"empid\" > 200";
          checkMaterialize(sql0 + " union all " + sql1, sql1 + " union all " + sql0);
        }
      

      This issue proposes to add a rule for union matching

        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 - 3h 10m
                3h 10m

                  Issue deployment