[ https://issues.apache.org/jira/browse/CALCITE-5430?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17675728#comment-17675728 ]
Oliver Lee commented on CALCITE-5430: ------------------------------------- Hi [~julianhyde] I updated the PR to follow {{NVL's}} pattern. The {{VARCHAR(3)}} NOT NULL tests did fix after that. > 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 > > 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)