Krystal created DRILL-520:
-----------------------------
Summary: ceiling/ceil and floor functions return decimal value
instead of an integer
Key: DRILL-520
URL: https://issues.apache.org/jira/browse/DRILL-520
Project: Apache Drill
Issue Type: Bug
Affects Versions: 1.0.0
Reporter: Krystal
Ran the following queries in drill:
0: jdbc:drill:schema=dfs> select ceiling(55.8) from dfs.`student` where
rownum=11;
+------------+
| EXPR$0 |
+------------+
| 56.0 |
+------------+
0: jdbc:drill:schema=dfs> select floor(55.8) from dfs.`student` where rownum=11;
+------------+
| EXPR$0 |
+------------+
| 55.0 |
+------------+
The same queries executed from oracle, postgres and mysql returned integer
values of 56 and 55.
Found the following description of the two functions from
http://users.atw.hu/sqlnut/sqlnut2-chp-4-sect-4.html :
Ceil/Ceiling:
Rounds a noninteger value upwards to the next greatest integer. Returns an
integer value unchanged.
Floor:
Rounds a noninteger value downwards to the next least integer. Returns an
integer value unchanged.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
