[CALCITE-3588] JDBC adapter should handle join conditions containing IS TRUE, SIMILAR TO etc. when generating SQL

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.27.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Jin Xing
• Reporter: Jin Xing
• Created: 11/Dec/19 09:58
• Updated: 31/Oct/22 15:43
• Resolved: 31/Oct/22 13:13

Description

Currently Calcite fail to convert RelNode to SqlNode when Join condition contains operators like 'SIMILAR_TO', 'IS_TRUE', 'IS_NOT_TRUE'. AssertionError will be thrown from [1]

 

[1] https://github.com/apache/calcite/blob/master/core/src/main/java/org/apache/calcite/rel/rel2sql/SqlImplementor.java#L290

Issue Links

• relates to: CALCITE-4620 Join on CASE causes AssertionError in RelToSqlConverter
• links to: GitHub Pull Request #1647