You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Oliver Lee (Jira)" <ji...@apache.org> on 2022/12/22 22:30:00 UTC

[jira] (CALCITE-5455) Add NULLIF() for BIG_QUERY

    [ https://issues.apache.org/jira/browse/CALCITE-5455 ]


    Oliver Lee deleted comment on CALCITE-5455:
    -------------------------------------

was (Author: JIRAUSER297744):
Actually, it's already been implemented. I'll just add to quidem tests some test cases in my PR.

> 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)