[CALCITE-5766] Add SAFE_NEGATE function (enabled for BigQuery)

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.36.0
• Labels: pull-request-available
• Assignee: Tanner Clary
• Reporter: Tanner Clary
• Created: 07/Jun/23 21:46
• Updated: 10/Nov/23 11:34
• Resolved: 30/Aug/23 19:47

Description

Add support for SAFE_NEGATE in BigQuery.
SAFE_NEGATE: Equivalent to the unary minus operator , but returns NULL if overflow occurs.

Example #1: SELECT SAFE_NEGATE(3) would return -3.
Example #2: SELECT SAFE_NEGATE(-9223372036854775808) would return NULL because of overflow.

Issue Links

• links to: GitHub Pull Request #3252