Aleksey Plekhanov created IGNITE-16181:
------------------------------------------

             Summary: Calcite engine. Handle arithmetic overflows
                 Key: IGNITE-16181
                 URL: https://issues.apache.org/jira/browse/IGNITE-16181
             Project: Ignite
          Issue Type: Improvement
            Reporter: Aleksey Plekhanov


Currently, we silently ignore arithmetic overflows and return the wrong result, 
for example:
{noformat}
SELECT 2147483647 + 2147483647{noformat}
Returns -2. But SQL standard says that exception should be thrown:
{noformat}
5) If the most specific type of the result of an arithmetic operation is exact 
numeric, then Case:
a) If the operator is not division and the mathematical result of the operation 
is not exactly representable with the precision and scale of the result data 
type, then an exception condition is raised: data exception — numeric value out 
of range.{noformat}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

Reply via email to