[ https://issues.apache.org/jira/browse/CALCITE-5430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jess Balint closed CALCITE-5430. -------------------------------- Resolved in release 1.33.0 (2023-02-06) > 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: Trivial > Fix For: 1.33.0 > > > 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)