[DRILL-706] DIV function does not return the integer portion of result as expected

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.1.0-m1
• Fix Version/s: 0.4.0
• Component/s: Functions - Drill
• Assignee: DrillCommitter
• Reporter: Krystal
• Created: 12/May/14 23:33
• Updated: 21/Jul/14 23:07
• Resolved: 21/Jul/14 02:48

Description

Based on the spec for DIV(x,y) function, the function suppose to return the integer part of x/y. However, drill returns the exact value of x/y. For example, in drill:
select div(120.524,7.6456) div from voter where voter_id=10;
returns 15.763838024484672.
The same query from postgres returns 15.