Julian Hyde created CALCITE-3286: ------------------------------------ Summary: In LatticeSuggester, allow join conditions that use expressions Key: CALCITE-3286 URL: https://issues.apache.org/jira/browse/CALCITE-3286 Project: Calcite Issue Type: Bug Reporter: Julian Hyde
In {{LatticeSuggester}}, allow join conditions that use expressions. For example, the query {code} select * from emp join dept on emp.deptno + 1 = dept.deptno {code} uses an expression "emp.deptno + 1" on the "emp" side of the join key. Currently this query throws: {noformat} 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) {noformat} -- This message was sent by Atlassian Jira (v8.3.2#803003)