[DRILL-709] FLOOR function should return an int instead of decimal

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 0.1.0-m1
• Fix Version/s: 0.4.0
• Component/s: Functions - Drill
• Assignee: Yash Sharma
• Reporter: Krystal
• Created: 13/May/14 16:18
• Updated: 31/Jul/14 06:32
• Resolved: 10/Jun/14 17:28

Description

Drill's FLOOR function returns a decimal instead of an int. For example:
select floor(100.75) from student where student_id=11;
Returns 100.0

Issue Links

• duplicates: DRILL-520 ceiling/ceil and floor functions return decimal value instead of an integer