drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-708) TRUNC(n1) function returns a decimal instead of int
Date Tue, 13 May 2014 15:37:15 GMT
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)

Mime
View raw message