[
https://issues.apache.org/jira/browse/DRILL-1120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14068140#comment-14068140
]
Jacques Nadeau commented on DRILL-1120:
---------------------------------------
fixed by e5c2da0 or earlier
> 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: DrillCommitter
> 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)
