You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Chun Chang (JIRA)" <ji...@apache.org> on 2014/05/13 18:55:17 UTC
[jira] [Assigned] (DRILL-637) numerical data format mismatch
[ https://issues.apache.org/jira/browse/DRILL-637?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chun Chang reassigned DRILL-637:
--------------------------------
Assignee: Chun Chang
> numerical data format mismatch
> ------------------------------
>
> Key: DRILL-637
> URL: https://issues.apache.org/jira/browse/DRILL-637
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Chun Chang
> Assignee: Chun Chang
> Priority: Minor
>
> There are some mismatch on the returns for numerical values between postgres and drill. Here is an example:
> postgres:
> foodmart=# select cast(c_decimal38 as double precision) from data;
> c_decimal38
> ----------------------
> 0
> 1
> 123456789
> 999999999
> -999999999
> 1e-08
> -1e-08
> 12345.6789
> 123456789.123457
> 1e+18
> -1e+18
> 1e-17
> -1e-17
> 12345678901234.1
> 1e+28
> -1e+28
> 1e-27
> -1e-27
> 1.23456789012346e+18
> 1e+38
> -1e+38
> 1e-37
> -1e-37
> (23 rows)
> drill:
> 0: jdbc:drill:schema=dfs> select cast(c_decimal38 as double precision) from data;
> +------------+
> | EXPR$0 |
> +------------+
> | 0.0 |
> | 1.0 |
> | 1.23456789E8 |
> | 9.99999999E8 |
> | -9.99999999E8 |
> | 1.0E-8 |
> | -1.0E-8 |
> | 12345.6789 |
> | 1.2345678912345679E8 |
> | 1.0E18 |
> | -1.0E18 |
> | 1.0E-17 |
> | -1.0E-17 |
> | 1.2345678901234123E13 |
> | 1.0E28 |
> | -1.0E28 |
> | 1.0E-27 |
> | -1.0E-27 |
> | 1.23456789012345677E18 |
> | 1.0E38 |
> | -1.0E38 |
> | 1.0E-37 |
> | -1.0E-37 |
> +------------+
> I don't think this is a bug but my boss asked me to file a tracking bug so we can discuss this.
--
This message was sent by Atlassian JIRA
(v6.2#6252)