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

[Caican Cai (Jira)]

Caican Cai created CALCITE-6398:
-----------------------------------

             Summary: Spark's ifnull function has only one parameter and the 
return value is Boolean
                 Key: CALCITE-6398
                 URL: https://issues.apache.org/jira/browse/CALCITE-6398
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.36.0
            Reporter: Caican Cai
             Fix For: 1.37.0


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 
{code:java}
| b s | IFNULL(value1, value2)                       | Equivalent to 
`NVL(value1, value2)`{code}
 
 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)