[CALCITE-3656] EnumerableNestedLoopJoin cost should account for cost of inner restarts

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Abandoned
• Affects Version/s: 1.21.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Vladimir Sitnikov
• Created: 31/Dec/19 13:42
• Updated: 14/Nov/20 21:47
• Resolved: 14/Nov/20 21:47

Description

EnumerableNestedLoopJoin uses makeCost(rowCount, 0, 0) which does not account the efforts spent in restarting the nested loops.

For instance: select * from emp, dept where false produces 0 rows, however, it still has non-trivial execution efforts.

Issue Links

• is related to: CALCITE-3657 EnumerableHashJoin should not use NLogN for costing
• is required by: CALCITE-3671 Join cost computation should consider join condition (equi vs non-equi)
• links to: GitHub Pull Request #1712