Mihai Budiu created CALCITE-6685:
------------------------------------

             Summary: There is no support for checked arithmetic
                 Key: CALCITE-6685
                 URL: https://issues.apache.org/jira/browse/CALCITE-6685
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.38.0
            Reporter: Mihai Budiu


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.




--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to