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)
