Jesus Camacho Rodriguez created CALCITE-2976:
------------------------------------------------
Summary: 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
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)
