[CALCITE-6558] zero literal is appended as a paramer for FIRST/LAST but Spark requires boolean

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.32.0
• Component/s: core
• Assignee: Unassigned
• Reporter: peng wu
• Created: 02/Sep/24 10:35
• Updated: 04/Sep/24 18:21

Description

give the sql parser s simple input:

first(`my_column`)

After the SQL string is parsed as SqlNode, then an extra parameter is added to the first function, and the sql becomes:

first(`my_column`, 0) 

Error would be thrown when the above sql is executed by spark:
"The second argument in first should be a boolean literal"