[CALCITE-4907] JDBC adapter cannot push down join ON TRUE (cartesian product)

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.28.0
• Fix Version/s: 1.31.0
• Component/s: jdbc-adapter
• Labels: pull-request-available
• Assignee: Francesco Gini
• Reporter: Francesco Gini
• Created: 28/Nov/21 18:12
• Updated: 03/Aug/22 16:21
• Resolved: 07/Jun/22 15:22

Description

JDBC adapter (in JdbcJoinRule) cannot push down join ON TRUE (cartesian product). This results in implementing the join in memory via EnumerableNestedLoopJoin which is a less efficient implementation.

Issue Links

• links to: GitHub Pull Request #2620