[HIVE-21976] Offset should be null instead of zero in Calcite HiveSortLimit

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0-alpha-1
• Component/s: CBO
• Labels: pull-request-available
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 10/Jul/19 00:27
• Updated: 27/Feb/24 22:24
• Resolved: 11/Jul/19 15:47

Description

Calcite expects a value equal or greater than 1. Otherwise, it may generate SQL from a plan incorrectly (offset 0).

Issue Links

• links to: GitHub Pull Request #716