[
https://issues.apache.org/jira/browse/CALCITE-3214?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Haisheng Yuan resolved CALCITE-3214.
------------------------------------
Resolution: Fixed
Fix Version/s: 1.21.0
Fixed in
https://github.com/apache/calcite/commit/a68bfc96bacc95b4b8ab5d185bb5cc1991113769,
thanks for the PR, [[email protected]]!
> Add UnionToUnionRule for materialization matching
> -------------------------------------------------
>
> Key: CALCITE-3214
> URL: https://issues.apache.org/jira/browse/CALCITE-3214
> Project: Calcite
> Issue Type: Bug
> Components: core
> Reporter: jin xing
> Assignee: jin xing
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.21.0
>
> Time Spent: 2h 20m
> Remaining Estimate: 0h
>
> Below materialization matching fails now
> {code:java}
> @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);
> }
> {code}
> This issue proposes to add a rule for union matching
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)