drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sudheesh Katkam (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-955) Casting 0.0000001 to varchar
Date Wed, 11 Jun 2014 21:47:02 GMT

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

Sudheesh Katkam commented on DRILL-955:
---------------------------------------

Another case:
(Basically places where varchar length is not mentioned.)

On postgres,
=# select cast(cast('1234567890123456789.1234567890123456789' as decimal(38,15)) as varchar);
               varchar               
-------------------------------------
 1234567890123456789.123456789012346
(1 row)

On drill,
0: jdbc:drill:zk=local> select cast(cast('1234567890123456789.1234567890123456789' as decimal(38,15))
as varchar) from cp.`employee.json` limit 1;
+------------+
|   EXPR$0   |
+------------+
| 1          |
+------------+
1 row selected (0.297 seconds)

> Casting 0.0000001 to varchar
> ----------------------------
>
>                 Key: DRILL-955
>                 URL: https://issues.apache.org/jira/browse/DRILL-955
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Sudheesh Katkam
>            Assignee: Sudheesh Katkam
>
> On postgres,
> =# select cast(0.00000001 as varchar);
>   varchar   
> ------------
>  0.00000001
> (1 row)
> On drill,
> 0: jdbc:drill:zk=local> select cast(0.00000001 as varchar) from cp.`employee.json`
limit 1;
> +------------+
> |   EXPR$0   |
> +------------+
> | 1          |
> +------------+
> 1 row selected (0.254 seconds)



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message