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