[DRILL-1120] mod(bigint, decimal) places decimal point at wrong location - regression

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Functions - Drill
• Assignee: DrillCommitter
• Reporter: Chun Chang
• Created: 09/Jul/14 17:43
• Updated: 31/Jul/14 06:32
• Resolved: 21/Jul/14 02:48

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)