[CALCITE-1640] SqlImplementor (RelToSql) doesn't handle join cond same as filter

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.22.0
• Component/s: core
• Assignee: Unassigned
• Reporter: Jess Balint
• Created: 16/Feb/17 22:06
• Updated: 28/May/21 10:09
• Resolved: 10/Dec/19 11:32

Description

If I have a join condition with an arbitrary expression, e.g.

  LogicalJoin(condition=[AND(=($0, $7), NOT(LIKE($2, ||('%', 'xyz', '%'))))], joinType=[inner])

I get an AssertionError in convertConditionToSqlNode(). This method should pass the rel node to toSql() so it can't be handled the same is it would be in a filter over the join.

Issue Links

• duplicates: CALCITE-3207 Fail to convert Join RelNode with like condition to sql statement