[CALCITE-5591] Add SAFE_ADD, SAFE_DIVIDE, SAFE_MULTIPLY, SAFE_NEGATE, SAFE_SUBTRACT functions (enabled in BigQuery library)

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.36.0
• Assignee: Tanner Clary
• Reporter: Dan Zou
• Created: 18/Mar/23 02:53
• Updated: 10/Nov/23 11:34
• Resolved: 06/Sep/23 00:58

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

Sub-Tasks

• Add SAFE_ADD function (enabled in BigQuery library): Closed
• Add SAFE_SUBTRACT function (enabled in BigQuery library): Closed
• Add SAFE_MULTIPLY function (enabled for BigQuery): Closed
• Add SAFE_NEGATE function (enabled for BigQuery): Closed
• Add SAFE_SUBTRACT function (enabled in BigQuery library): Closed
• Add SAFE_DIVIDE function (enabled in BigQuery library): Closed