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

• Type: Improvement
• Status: Closed
• Priority: Trivial
• Resolution: Fixed
• Fix Version/s: 1.33.0
• Assignee: Oliver Lee
• Reporter: Oliver Lee
• Created: 13/Dec/22 01:23
• Updated: 07/Feb/23 22:33
• Resolved: 14/Jan/23 01:20

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