[CALCITE-2137] Materialized view rewriting not being triggered for some join queries

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.16.0
• Component/s: core
• Labels: materializedviews
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 17/Jan/18 03:22
• Updated: 27/Feb/24 22:23
• Resolved: 17/Jan/18 03:33

Description

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:

select *
from "emps"
join "dependents" using ("empid");

Query:

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';