[IGNITE-18671] Sql. Cast to BigInt with overflow does not produce an error.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 3.0.0-beta2
• Component/s: sql
• Labels: calcite2-required calcite3-required ignite-3

Environment

See test_sum.test
Query

• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Maksim Zhuravkov
• Created: 30/Jan/23 12:54
• Updated: 29/Mar/24 10:16

Description

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