[CALCITE-6685] There is no support for checked arithmetic

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.38.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Mihai Budiu
• Reporter: Mihai Budiu
• Created: 12/Nov/24 07:38
• Updated: Yesterday 19:38

Description

Many SQL dialects perform arithmetic using checked operations.
I.e., they raise errors when the result of an arithmetic exception cannot be represented using the target type.

Some SQL dialects make this behavior configurable: e.g., SQL Server has an ARITHABORT flag:
https://learn.microsoft.com/en-us/sql/t-sql/statements/set-arithabort-transact-sql

Calcite's executor and many optimization passes use Java arithmetic, which is not checked.

Issue Links

• links to: GitHub Pull Request #4044