[CALCITE-6398] Spark's ifnull function has only one parameter and the return value is Boolean

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Bug
• Affects Version/s: 1.36.0
• Fix Version/s: 1.37.0
• Component/s: core
• Assignee: Unassigned
• Reporter: Caican Cai
• Created: 03/May/24 16:04
• Updated: 03/May/24 16:20
• Resolved: 03/May/24 16:15

Description

Spark's ifnull function has only one parameter and the return value is Boolean

https://spark.apache.org/docs/2.3.0/api/sql/index.html#isnull

 
But calcite's ifnull has two parameters and returns expr

| b s | IFNULL(value1, value2)                       | Equivalent to `NVL(value1, value2)`