[DRILL-6471] Different result for CAST String and Decimal literals as Decimal

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.14.0
• Fix Version/s: 1.14.0
• Assignee: Vova Vysotskyi
• Reporter: Denys Ordynskiy
• Created: 06/Jun/18 12:34
• Updated: 08/Jul/19 15:58
• Resolved: 13/Jul/18 12:56

Description

If I cast String and Decimal literals as Decimal and literal precision is more than I casting to,

I see different results for the same literal data in String and Decimal formats

SELECT cast('1234.5678' as DECIMAL(2, 2));

+----------+
| EXPR$0   |
+----------+
| 1200.00  |
+----------+

SELECT cast(1234.5678 as DECIMAL(2, 2));

+---------+
| EXPR$0  |
+---------+
| 0.12    |
+---------+

CAST result for one number in String and Decimal formats should be the same.

Issue Links

• relates to: DRILL-6472 Drill allows to use decimal zero precision in CAST function for CTAS