[
https://issues.apache.org/jira/browse/DRILL-6471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pritesh Maker reassigned DRILL-6471:
------------------------------------
Assignee: Volodymyr Vysotskyi
> Different result for CAST String and Decimal literals as Decimal
> ----------------------------------------------------------------
>
> Key: DRILL-6471
> URL: https://issues.apache.org/jira/browse/DRILL-6471
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.14.0
> Reporter: Denys Ordynskiy
> Assignee: Volodymyr Vysotskyi
> Priority: Major
>
> 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));
> {code:java}
> +----------+
> | EXPR$0 |
> +----------+
> | 1200.00 |
> +----------+
> {code}
> SELECT cast(1234.5678 as DECIMAL(2, 2));
> {code:java}
> +---------+
> | EXPR$0 |
> +---------+
> | 0.12 |
> +---------+
> {code}
> CAST result for one number in String and Decimal formats should be the same.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
