You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Victoria Markman (JIRA)" <ji...@apache.org> on 2015/03/02 19:07:05 UTC
[jira] [Created] (DRILL-2355) TRUNC function returns incorrect
result when second parameter is specified
Victoria Markman created DRILL-2355:
---------------------------------------
Summary: TRUNC function returns incorrect result when second parameter is specified
Key: DRILL-2355
URL: https://issues.apache.org/jira/browse/DRILL-2355
Project: Apache Drill
Issue Type: Bug
Components: Functions - Drill
Affects Versions: 0.8.0
Reporter: Victoria Markman
Assignee: Daniel Barclay (Drill)
I believe our TRUNC function is modeled on Postgres TRUNC function.
Semandics of Postgres TRUNC function:
{code}
postgres=# select trunc(1234.1234);
trunc
-------
1234
(1 row)
postgres=# select trunc(1234.1234, 0);
trunc
-------
1234
(1 row)
postgres=# select trunc(1234.1234, 2);
trunc
---------
1234.12
(1 row)
postgres=# select trunc(1234.1234, -1);
trunc
-------
1230
(1 row)
postgres=# select trunc(1234.1234, -3);
trunc
-------
1000
(1 row)
{code}
This is incorrect, I can't truncate to zero decimal places:
{code}
0: jdbc:drill:schema=dfs> select trunc(1234.1234) from sys.options limit 1;
+------------+
| EXPR$0 |
+------------+
| 1234.0 |
+------------+
1 row selected (0.133 seconds)
0: jdbc:drill:schema=dfs> select trunc(1234.1234,0) from sys.options limit 1;
+------------+
| EXPR$0 |
+------------+
| 1234.0 |
+------------+
1 row selected (0.065 seconds)
{code}
Second negative parameter, does not do what it is supposed to do as well:
{code}
0: jdbc:drill:schema=dfs> select trunc(1234.1234, -1) from sys.options limit 1;
+------------+
| EXPR$0 |
+------------+
| 1230.0 |
+------------+
1 row selected (0.068 seconds)
0: jdbc:drill:schema=dfs> select trunc(1234.1234, -3) from sys.options limit 1;
+------------+
| EXPR$0 |
+------------+
| 1000.0 |
+------------+
1 row selected (0.072 seconds)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)