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)