[CALCITE-4819] SemiJoin operator is not skipped in materialized view-based rewriting algorithm

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.28.0
• Labels: pull-request-available
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 02/Oct/21 03:50
• Updated: 27/Feb/24 22:23
• Resolved: 05/Oct/21 19:50

Description

This had been solved in CALCITE-2277 but apparently it was broken in CALCITE-2969 (MaterializedViewRelOptRulesTest.testJoinMaterialization11 result was modified assuming the change was correct). The rewriting algorithm does not support semijoin so this can lead to incorrect results.

Issue Links

• is caused by: CALCITE-2969 Improve design of join-like relational expressions
• links to: GitHub Pull Request #2557