[ https://issues.apache.org/jira/browse/CALCITE-2976?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16808331#comment-16808331 ]
Jesus Camacho Rodriguez commented on CALCITE-2976: -------------------------------------------------- PR also enables materialization tests that were previously ignored. > Improve materialized view rewriting coverage with disjunctive predicates > ------------------------------------------------------------------------ > > Key: CALCITE-2976 > URL: https://issues.apache.org/jira/browse/CALCITE-2976 > Project: Calcite > Issue Type: Improvement > Components: core > Reporter: Jesus Camacho Rodriguez > Assignee: Jesus Camacho Rodriguez > Priority: Major > > For instance, in the following case: > {code} > @Test public void testJoinAggregateMaterializationAggregateFuncs14() { > checkMaterialize( > "select \"empid\", \"emps\".\"name\", \"emps\".\"deptno\", > \"depts\".\"name\", " > + "count(*) as c, sum(\"empid\") as s\n" > + "from \"emps\" join \"depts\" using (\"deptno\")\n" > + "where (\"depts\".\"name\" is not null and \"emps\".\"name\" = > 'a') or " > + "(\"depts\".\"name\" is not null and \"emps\".\"name\" = 'b')\n" > + "group by \"empid\", \"emps\".\"name\", \"depts\".\"name\", > \"emps\".\"deptno\"", > "select \"depts\".\"deptno\", sum(\"empid\") as s\n" > + "from \"emps\" join \"depts\" using (\"deptno\")\n" > + "where \"depts\".\"name\" is not null and \"emps\".\"name\" = > 'a'\n" > + "group by \"depts\".\"deptno\"", > HR_FKUK_MODEL, > CONTAINS_M0); > } > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)