xzh_dz created CALCITE-3644: ------------------------------- Summary: Calc on the Intersecrt in target is not being matched Key: CALCITE-3644 URL: https://issues.apache.org/jira/browse/CALCITE-3644 Project: Calcite Issue Type: Wish Reporter: xzh_dz
{code:java} @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); } {code} error: {code:java} 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) {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)