You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Mehant Baid (JIRA)" <ji...@apache.org> on 2014/07/12 09:41:04 UTC
[jira] [Updated] (DRILL-1120) mod(bigint, decimal) places decimal
point at wrong location - regression
[ https://issues.apache.org/jira/browse/DRILL-1120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mehant Baid updated DRILL-1120:
-------------------------------
Attachment: DRILL-1120.patch
> mod(bigint, decimal) places decimal point at wrong location - regression
> ------------------------------------------------------------------------
>
> Key: DRILL-1120
> URL: https://issues.apache.org/jira/browse/DRILL-1120
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Reporter: Chun Chang
> Assignee: Mehant Baid
> Attachments: DRILL-1120.patch
>
>
> #Wed Jul 09 10:28:32 PDT 2014
> git.commit.id.abbrev=810a204
> The following query used to work. The decimal point is placed wrong.
> Drill:
> 0: jdbc:drill:schema=dfs> select mod(c_bigint, cast(c_decimal38 as decimal(38,18))) from data where c_row < 15 and cast(c_decimal38 as decimal(38,18)) <> 0;
> +------------+
> | EXPR$0 |
> +------------+
> | 0E-18 |
> | -1000000000.000000000000000000 |
> | 12000000000.000000000000000000 |
> | 123000000000.000000000000000000 |
> | 12243822600000.000000000000000000 |
> | -36999908918111010.000000000000000000 |
> | 920320399049584000000000.000000000000000000 |
> | -922337203685477580000000000.000000000000000000 |
> | 2147483647000000000.000000000000000000 |
> +------------+
> 9 rows selected (0.222 seconds)
> postgres:
> foodmart=# select mod(c_bigint, cast(c_decimal38 as decimal(38,18))) from data where c_row < 15 and cast(c_decimal38 as decimal(38,18)) <> 0;
> mod
> ----------------------------------------
> 0.000000000000000000
> -1.000000000000000000
> 12.000000000000000000
> 123.000000000000000000
> 0.000000000000000000
> 0.000000000000000000
> 12243.822600000000000000
> -36999908.918111010000000000
> 920320399049584.000000000000000000
> -922337203685477580.000000000000000000
> 0.000000000000000000
> 0.000000000000000000
> 2147483647.000000000000000000
> (13 rows)
--
This message was sent by Atlassian JIRA
(v6.2#6252)