Jesus Camacho Rodriguez created CALCITE-2137: ------------------------------------------------
Summary: Materialized view rewriting not being triggered for some join queries Key: CALCITE-2137 URL: https://issues.apache.org/jira/browse/CALCITE-2137 Project: Calcite Issue Type: Bug Components: core Reporter: Jesus Camacho Rodriguez Assignee: Jesus Camacho Rodriguez Fix For: 1.16.0 The issue has to do with the column equivalences mapping for joins with equality predicates for columns that are output by the query or subquery (basically, there is a bug and we do not apply mapping). This results in missing rewriting opportunities as the top expression cannot be mapped from the query to the view. It can be reproduced with the following MV and query in {{MaterializationTest.java}}: MV: {code} select * from "emps" join "dependents" using ("empid"); {code} Query: {code} select "emps"."empid", "dependents"."empid", "emps"."deptno" from "emps" join "dependents" using ("empid") join "depts" "a" on ("emps"."deptno"="a"."deptno") where "emps"."name" = 'Bill'; {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)