drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chun Chang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-605) should round a number up in a cast if the rounded out number is >=5
Date Thu, 26 Jun 2014 21:19:25 GMT

    [ https://issues.apache.org/jira/browse/DRILL-605?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14045194#comment-14045194
] 

Chun Chang commented on DRILL-605:
----------------------------------

rounding issue has been fixed for most data types. still fail for some data type and will
file separate JIRA.

#Thu Jun 26 13:57:45 PDT 2014
git.commit.id.abbrev=3ea8eb5

> 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)

Mime
View raw message