[CALCITE-3214] Add UnionToUnionRule for materialization matching

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.21.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Jin Xing
• Reporter: Jin Xing
• Created: 26/Jul/19 03:59
• Updated: 10/Oct/19 09:28
• Resolved: 16/Aug/19 21:23

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

Issue Links

• is related to: CALCITE-3396 Materialization matching succeeds when query and view are both of UNION but have different 'all' property
• links to: GitHub Pull Request #1333
• links to: GitHub Pull Request #1391