drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kristine Hahn (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-2355) TRUNC function returns incorrect result when second parameter is specified
Date Tue, 25 Aug 2015 21:44:46 GMT

    [ https://issues.apache.org/jira/browse/DRILL-2355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14712028#comment-14712028
] 

Kristine Hahn commented on DRILL-2355:
--------------------------------------

Added Unresolved Issues section to Drill 1.0 release notes: http://kristinehahn.github.io/drill/docs/apache-drill-1-0-0-release-notes/

The revision will appear on the Apache site next time we publish the docs.

> 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: Mehant Baid
>            Priority: Minor
>              Labels: document_if_not_fixed
>             Fix For: 1.4.0
>
>
> 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)

Mime
View raw message