[CALCITE-3644] Calc on the Intersect in target is not being matched

• Type: Wish
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.22.0
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: xzh_dz
• Created: 30/Dec/19 02:13
• Updated: 06/Mar/20 04:36
• Resolved: 14/Jan/20 06:11

Description

@Test public void testIntersectToCalcOnIntersect() {
    final String mv = ""
        + "select \"deptno\",\"name\" from \"emps\"\n"
        + "intersect all\n"
        + "select \"deptno\",\"name\" from \"depts\"";
    String mv1 = "select \"name\", \"deptno\" from (" + mv + ")";

    final String query = ""
        + "select \"name\",\"deptno\" from \"depts\"\n"
        + "intersect all\n"
        + "select \"name\",\"deptno\" from \"emps\"";
    checkMaterialize(mv1, query, true);
  }

error:

java.lang.AssertionError: 
Expected: a string containing "EnumerableTableScan(table=[[hr, m0]])"
     but: was "PLAN=EnumerableIntersect(all=[true])\n  EnumerableCalc(expr#0..3=[{inputs}], name=[$t1], deptno=[$t0])\n    EnumerableTableScan(table=[[hr, depts]])\n  EnumerableCalc(expr#0..4=[{inputs}], name=[$t2], deptno=[$t1])\n    EnumerableTableScan(table=[[hr, emps]])\n\n"
<Click to see difference>


	at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18)
	at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
	at org.apache.calcite.test.CalciteAssert.lambda$checkResultContains$7(CalciteAssert.java:429)
	at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:544)
	at org.apache.calcite.test.CalciteAssert$AssertQuery.lambda$returns$1(CalciteAssert.java:1514)

Issue Links

• links to: GitHub Pull Request #1704