[jira] [Updated] (CALCITE-5430) Implement IFNULL() for BigQuery dialect

["Oliver Lee (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CALCITE-5430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Oliver Lee updated CALCITE-5430:
--------------------------------
    Description: 
Implementing IFNULL() for BIG_QUERY dialect

 

IFNULL(expr, null_result) 

If {{expr}} evaluates to {{{}NULL{}}}, returns {{{}null_result{}}}. Otherwise, returns expr. If {{expr}} doesn't evaluate to {{{}NULL{}}}, {{null_result}} isn't evaluated.

[https://cloud.google.com/bigquery/docs/reference/standard-sql/conditional_expressions#ifnull] 

 

example:

{{ifnull(null, 5)}} -> returns 5

{{ifnull(1,2)}} -> returns 1 

  was:Implementing IFNULL() for BIG_QUERY dialect


> Implement IFNULL() for BigQuery dialect
> ---------------------------------------
>
>                 Key: CALCITE-5430
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5430
>             Project: Calcite
>          Issue Type: Improvement
>            Reporter: Oliver Lee
>            Assignee: Oliver Lee
>            Priority: Major
>
> Implementing IFNULL() for BIG_QUERY dialect
>  
> IFNULL(expr, null_result) 
> If {{expr}} evaluates to {{{}NULL{}}}, returns {{{}null_result{}}}. Otherwise, returns expr. If {{expr}} doesn't evaluate to {{{}NULL{}}}, {{null_result}} isn't evaluated.
> [https://cloud.google.com/bigquery/docs/reference/standard-sql/conditional_expressions#ifnull] 
>  
> example:
> {{ifnull(null, 5)}} -> returns 5
> {{ifnull(1,2)}} -> returns 1 



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