[HIVE-25263] CAST operation with decimal resulting to NULL

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Labels: pull-request-available
• Assignee: László Pintér Assign to me
• Reporter: László Pintér
• Created: 17/Jun/21 12:26
• Updated: 09/Jul/21 08:48
• Resolved: 09/Jul/21 08:48

Description

Some queries using cast to decimal and addition operation result in null values. Ex:

SELECT CAST('123456789123' AS DECIMAL(22,2)) + 1;

SELECT CAST('99' AS DECIMAL(5,2)) + 8;
 

Issue Links

• links to: GitHub Pull Request #2406