[ https://issues.apache.org/jira/browse/CALCITE-5735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728131#comment-17728131 ]
Tanner Clary commented on CALCITE-5735: --------------------------------------- [~FrankZou] thanks for all of your comments, very helpful. I will get around to responding to them soon. > Implement SAFE_MULTIPLY function (enabled for BigQuery) > ------------------------------------------------------- > > Key: CALCITE-5735 > URL: https://issues.apache.org/jira/browse/CALCITE-5735 > Project: Calcite > Issue Type: Sub-task > Reporter: Tanner Clary > Assignee: Tanner Clary > Priority: Major > Labels: pull-request-available > > Add support for SAFE_MULTIPLY in BigQuery. > SAFE_MULTIPLY: Equivalent to the multiplication operator '*', but returns > NULL if overflow occurs. > Example #1: {{SELECT SAFE_MULTIPLY(3, 4)}} would return {{12}}. > Example #2: {{SELECT SAFE_MULTIPLY(2^63, 2)}} would return {{NULL}} because > of overflow. -- This message was sent by Atlassian Jira (v8.20.10#820010)