[IGNITE-16181] Calcite engine. Handle arithmetic overflows

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.17
• Labels: calcite2-required calcite3-required ise
• Release Note: SQL Calcite: Added arithmetic overflow handling
• Assignee: Aleksey Plekhanov
• Reporter: Aleksey Plekhanov
• Created: 21/Dec/21 09:31
• Updated: 02/Jul/24 16:59
• Resolved: 28/Jun/24 07:11

Description

Currently, we silently ignore arithmetic overflows and return the wrong result, for example:

SELECT 2147483647 + 2147483647

Returns -2. But SQL standard says that exception should be thrown:

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.

Issue Links

• is duplicated by: IGNITE-18175 SQL: value out of type bounds is converted into 0 during implicit casting
• is part of: IGNITE-18662 Sql. Numeric to/from decimal cast with overflow does not produce an error
• is part of: IGNITE-12248 Apache Calcite based query execution engine
• links to: GitHub Pull Request #10541
• links to: GitHub Pull Request #10802
• links to: GitHub Pull Request #11404
• links to: Reworked pull request