jin xing created CALCITE-3214: --------------------------------- Summary: 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
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)