[DRILL-708] TRUNC(n1) function returns a decimal instead of int

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Won't Fix
• Affects Version/s: 0.1.0-m1
• Fix Version/s: 1.0.0
• Component/s: Functions - Drill
• Assignee: Yash Sharma
• Reporter: Krystal
• Created: 13/May/14 15:36
• Updated: 06/Apr/15 20:40
• Resolved: 06/Apr/15 20:40

Description

The TRUNC(n1) function should return the integer part of n1 as an int. In drill, however, the value returned is a decimal. For example,

select trunc(15.79) from voter where voter_id=10;
returns 15.0
The other database platforms return an int value of 15.