[CALCITE-995] Sort transpose rules might fall in an infinite loop

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.6.0
• Fix Version/s: 1.6.0
• Component/s: core
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 29/Nov/15 21:52
• Updated: 27/Feb/24 22:24
• Resolved: 29/Nov/15 22:08

Description

CALCITE-987 introduced the RelMdMaxRowCount metadata provider. By default, RelMdMaxRowCount returns Double.MAX, which is causing some infinite loops in the current test suite, as Sort will continue being pushed below Union/Join (if the estimate row count for Union/Join is Double.MAX).

I propose to return null by default if we cannot get the maximum number of rows, which makes more sense and allows catching this issue.

Issue Links

• is broken by: CALCITE-987 Push limit 0 will result in an infinite loop
• relates to: CALCITE-1018 SortJoinTransposeRule not firing due to getMaxRowCount(RelSubset) returning null