You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Dan Zou (Jira)" <ji...@apache.org> on 2023/06/08 02:41:00 UTC
[jira] [Updated] (CALCITE-5591) Implement BigQuery functions SAFE_ADD, SAFE_SUBTRACT, SAFE_MULTIPLY, SAFE_DIVIDE and SAFE_NEGATE
[ https://issues.apache.org/jira/browse/CALCITE-5591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dan Zou updated CALCITE-5591:
-----------------------------
Description:
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]
was:
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: Returns the result of Y subtracted from X. 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]
> Implement BigQuery functions SAFE_ADD, SAFE_SUBTRACT, SAFE_MULTIPLY, SAFE_DIVIDE and SAFE_NEGATE
> ------------------------------------------------------------------------------------------------
>
> Key: CALCITE-5591
> URL: https://issues.apache.org/jira/browse/CALCITE-5591
> Project: Calcite
> Issue Type: New Feature
> Reporter: Dan Zou
> Assignee: Dan Zou
> Priority: Major
>
> 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)