Krystal created DRILL-708:
-----------------------------
Summary: TRUNC(n1) function returns a decimal instead of int
Key: DRILL-708
URL: https://issues.apache.org/jira/browse/DRILL-708
Project: Apache Drill
Issue Type: Bug
Components: Functions - Drill
Affects Versions: 1.0.0-milestone-1
Reporter: Krystal
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.
--
This message was sent by Atlassian JIRA
(v6.2#6252)