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)