[
https://issues.apache.org/jira/browse/IGNITE-18671?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Iurii Gerzhedovich reassigned IGNITE-18671:
-------------------------------------------
Assignee: Iurii Gerzhedovich
> 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
> Assignee: Iurii Gerzhedovich
> Priority: Major
> Labels: calcite2-required, calcite3-required, ignite-3
> 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)
