[jira] [Created] (CALCITE-2976) Improve materialized view rewriting coverage with disjunctive predicates

["Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org>]

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)