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

XML

Word

Printable

JSON

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.

relates to

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