[IGNITE-18662] Sql. Numeric to/from decimal cast with overflow does not produce an error

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0
• Component/s: sql
• Labels: calcite2-required ignite-3
• Assignee: Evgeny Stanilovsky
• Reporter: Maksim Zhuravkov
• Created: 30/Jan/23 11:32
• Updated: 10/Oct/24 17:50
• Resolved: 20/Nov/23 06:15

Description

Casts from numeric type to decimal with overflow must fail but they return a result:

SELECT 10000000::BIGINT::DECIMAL(3,1)

Returns

----
1000000

And the following query:

SELECT 2147483648::DECIMAL(18,0)::INTEGER
----
-2147483648
# Integer.MIN_VALUE

query I
SELECT 128::DECIMAL(3,0)::TINYINT
----
-128
# Byte.MIN_VALUE 

See skipif-ed examples in cast_to_decimal.test and cast_from_decimal.test

Issue Links

• incorporates: IGNITE-20849 Sql. Incorrect result returns from CAST as DECIMAL
• incorporates: IGNITE-16181 Calcite engine. Handle arithmetic overflows
• is cloned by: IGNITE-20784 Sql. Derive correct type for numbers manipulations operations.
• is related to: IGNITE-23407 Calcite. No overflow of numeric cast.
• links to: GitHub Pull Request #2786