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)

Reply via email to