[ https://issues.apache.org/jira/browse/CALCITE-5455?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Oliver Lee updated CALCITE-5455: -------------------------------- Description: 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 was: Adding NULLIF() for BIG_QUERY 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 > 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 > 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)