[
https://issues.apache.org/jira/browse/CALCITE-5591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tanner Clary resolved CALCITE-5591.
-----------------------------------
Fix Version/s: 1.36.0
Resolution: Fixed
This umbrella issue is being resolved because all of the subtasks have been
completed. You may find the commit hashes for the subtasks on their respective
JIRA cases. Thanks to all of those who helped with reviews.
> Add SAFE_ADD, SAFE_DIVIDE, SAFE_MULTIPLY, SAFE_NEGATE, SAFE_SUBTRACT
> functions (enabled in BigQuery library)
> ------------------------------------------------------------------------------------------------------------
>
> Key: CALCITE-5591
> URL: https://issues.apache.org/jira/browse/CALCITE-5591
> Project: Calcite
> Issue Type: New Feature
> Reporter: Dan Zou
> Assignee: Tanner Clary
> Priority: Major
> Fix For: 1.36.0
>
>
> Add support for SAFE_ADD, SAFE_SUBTRACT, SAFE_MULTIPLY, SAFE_DIVIDE and
> SAFE_NEGATE in BigQuery.
> Function description:
> * SAFE_ADD: Equivalent to the addition operator '+', but returns NULL if
> overflow occurs.
> * SAFE_SUBTRACT: Equivalent to the subtraction operator '-', but returns NULL
> if overflow occurs.
> * SAFE_MULTIPLY: Equivalent to the multiplication operator '*', but returns
> NULL if overflow occurs.
> * SAFE_DIVIDE: Equivalent to the division operator '/ ', but returns NULL if
> an error occurs, such as a division by zero error.
> * SAFE_NEGATE: Equivalent to the unary minus operator '-', but returns NULL
> if overflow occurs.
> See more details in [BigQuery
> Doc|https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#safe_divide]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
