[
https://issues.apache.org/jira/browse/DRILL-605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mehant Baid updated DRILL-605:
------------------------------
Attachment: DRILL-605.patch
> should round a number up in a cast if the rounded out number is >=5
> -------------------------------------------------------------------
>
> Key: DRILL-605
> URL: https://issues.apache.org/jira/browse/DRILL-605
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Reporter: Chun Chang
> Assignee: Mehant Baid
> Fix For: 1.0.0-BETA1
>
> Attachments: DRILL-605.patch, DRILL-605.patch.txt
>
>
> postgres:
> foodmart=# select c_row, c_decimal38, cast(c_decimal38 as decimal(38,15))
> from data where c_row = 19;
> c_row | c_decimal38 | c_decimal38
> -------+-----------------------------------------+-------------------------------------
> 19 | 1234567890123456789.1234567890123456789 |
> 1234567890123456789.123456789012346
> (1 row)
> drill:
> 0: jdbc:drill:schema=dfs> select c_row, c_decimal38, cast(c_decimal38 as
> decimal(38,15)) from data where c_row = 19;
> +------------+-------------+------------+
> | c_row | c_decimal38 | EXPR$2 |
> +------------+-------------+------------+
> | 19 | [B@632099ee | 1234567890123456789.123456789012345 |
> +------------+-------------+------------+
> 1 row selected (0.194 seconds)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
