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/07/09 19:45:05 UTC
[jira] [Created] (DRILL-1120) mod(bigint, decimal) places decimal
point at wrong location - regression
Chun Chang created DRILL-1120:
---------------------------------
Summary: 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
#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)