[
https://issues.apache.org/jira/browse/CALCITE-2976?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated CALCITE-2976:
------------------------------------
Labels: pull-request-available (was: )
> 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
> Labels: pull-request-available
>
> 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)
