Evgeny Stanilovsky created IGNITE-20784:
-------------------------------------------

             Summary: Sql. Derive correct type for numbers manipulations 
operations.
                 Key: IGNITE-20784
                 URL: https://issues.apache.org/jira/browse/IGNITE-20784
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 3.0.0-beta1
            Reporter: Evgeny Stanilovsky


Both:
 
{code:java}
SELECT 2147483647 + 1 
SELECT (2147483647 + 1)::DECIMAL(18,0){code}
 
returns:
-2147483648

due to incorrect derive type for type overflow operations.

note: processing of mentioned cases differs between DB implementations.



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

Reply via email to