You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2014/06/26 22:49:27 UTC
[jira] [Commented] (DRILL-605) should round a number up in a cast
if the rounded out number is >=5
[ https://issues.apache.org/jira/browse/DRILL-605?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14045154#comment-14045154 ]
Jacques Nadeau commented on DRILL-605:
--------------------------------------
Fixed in 3ea8eb5 or earlier
> 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: DrillCommitter
> 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)