[CALCITE-6111] Explicit cast from expression to numeric type doesn't check overflow

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.36.0
• Fix Version/s: 1.37.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Mihai Budiu
• Reporter: Evgeny Stanilovsky
• Created: 13/Nov/23 06:17
• Updated: 06/May/24 22:19
• Resolved: 19/Jan/24 23:56

Description

After [1] was implemented it is still possible to obtain erroneous result, check:

SELECT cast(100+30 as tinyint);

result:

-126

[1] https://issues.apache.org/jira/browse/CALCITE-5990

Issue Links

• links to: GitHub Pull Request #3522