You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Haisheng Yuan (Jira)" <ji...@apache.org> on 2020/01/14 06:12:00 UTC
[jira] [Resolved] (CALCITE-3644) Calc on the Intersect in target is
not being matched
[ https://issues.apache.org/jira/browse/CALCITE-3644?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Haisheng Yuan resolved CALCITE-3644.
------------------------------------
Fix Version/s: 1.22.0
Resolution: Fixed
Fixed in https://github.com/apache/calcite/commit/81669c555a96b5dc74e363165b5b882b72d45949, thanks for the PR, [~xzh_dz]!
> Calc on the Intersect 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
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.22.0
>
> Attachments: screenshot-1.png, screenshot-2.png, screenshot-3.png
>
> Time Spent: 2.5h
> Remaining Estimate: 0h
>
> {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)