[CALCITE-3286] In LatticeSuggester, allow join conditions that use expressions

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.22.0
• Assignee: Unassigned
• Reporter: Julian Hyde
• Created: 23/Aug/19 04:00
• Updated: 06/Mar/20 04:33
• Resolved: 20/Sep/19 19:54

Description

In LatticeSuggester, allow join conditions that use expressions. For example, the query

select *
from emp
join dept on emp.deptno + 1 = dept.deptno

uses an expression "emp.deptno + 1" on the "emp" side of the join key.

Currently this query throws:

java.lang.ClassCastException: class org.apache.calcite.materialize.LatticeSuggester$DerivedColRef cannot be cast to class org.apache.calcite.materialize.LatticeSuggester$BaseColRef
	at org.apache.calcite.materialize.LatticeSuggester.frame(LatticeSuggester.java:478)
	at org.apache.calcite.materialize.LatticeSuggester.frame(LatticeSuggester.java:420)
	at org.apache.calcite.materialize.LatticeSuggester.frame(LatticeSuggester.java:399)
	at org.apache.calcite.materialize.LatticeSuggester.addQuery(LatticeSuggester.java:124)