[CALCITE-4621] SemiJoinRule throws AssertionError on ANTI join

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.26.0
• Fix Version/s: 1.27.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Ruben Q L
• Reporter: Ruben Q L
• Created: 25/May/21 12:44
• Updated: 18/Jun/21 16:00
• Resolved: 27/May/21 07:24

Description

Credits to thomas.rebele for discovering the issue.

When SemiJoinRule (both CoreRules.JOIN_TO_SEMI_JOIN and CoreRules.PROJECT_TO_SEMI_JOIN) matches an ANTI join, it fails with the following error:

java.lang.AssertionError: ANTI
  at org.apache.calcite.rel.rules.SemiJoinRule.perform(SemiJoinRule.java:122)
  ...

The problem is that the rule config only forbids RIGHT and FULL joins, and lets ANTI go through. Later when the rule is actually executed, joins with type ANTI cannot be handled, hence the AssertionError.
The rule config must be adapted to forbid also ANTI joins.

Issue Links

• is related to: CALCITE-4623 SemiJoinRule should not match SEMI join
• links to: GitHub Pull Request #2418