[
https://issues.apache.org/jira/browse/CALCITE-5455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17651468#comment-17651468
]
Julian Hyde commented on CALCITE-5455:
--------------------------------------
A quick check reveals that NULLIF is already present:
{code:java}
$ cd calcite
$ git ls-files | xargs grep -i nullif{code}
> Add NULLIF() for BIG_QUERY
> --------------------------
>
> Key: CALCITE-5455
> URL: https://issues.apache.org/jira/browse/CALCITE-5455
> Project: Calcite
> Issue Type: Improvement
> Reporter: Oliver Lee
> Assignee: Oliver Lee
> Priority: Minor
>
> Adding NULLIF() for BIG_QUERY
> [https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#nullif]
>
>
> NULLIF(expr, expr_to_match)
> {quote}Returns {{NULL}} if {{expr = expr_to_match}} evaluates to
> {{{}TRUE{}}}, otherwise returns {{{}expr{}}}.
> {quote}
> NULLIF(0, 0) -> NULL
> NULLIF(10,0) -> 10
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
