Maksim Zhuravkov created IGNITE-18671:
-----------------------------------------

             Summary: Sql. Cast to BigInt with overflow does not produce an 
error.
                 Key: IGNITE-18671
                 URL: https://issues.apache.org/jira/browse/IGNITE-18671
             Project: Ignite
          Issue Type: Bug
          Components: sql
         Environment: See test_sum.test
Query 
            Reporter: Maksim Zhuravkov
             Fix For: 3.0.0-beta2



{code:java}
CREATE TABLE bigints(b BIGINT);

# a bunch of huge values
statement ok
INSERT INTO bigints SELECT * FROM table(system_range(4611686018427387904, 
4611686018427388903, 1));

# this is too big for a bigint.
# should fail but returns the result below
query I
SELECT SUM(b)::BIGINT FROM bigints
----
499500

{code}




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

Reply via email to