You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Sudheesh Katkam (JIRA)" <ji...@apache.org> on 2014/06/11 23:47:02 UTC
[jira] [Commented] (DRILL-955) Casting 0.0000001 to varchar
[ 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)