Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
Description
#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)