[jira] [Commented] (DRILL-710) SIGN function should return an int value

["Jacques Nadeau (JIRA)" <ji...@apache.org>]

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

Jacques Nadeau commented on DRILL-710:
--------------------------------------

Fixed at master 3db1d5a and beyond.

> SIGN function should return an int value
> ----------------------------------------
>
>                 Key: DRILL-710
>                 URL: https://issues.apache.org/jira/browse/DRILL-710
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Functions - Drill
>    Affects Versions: 1.0.0-milestone-1
>            Reporter: Krystal
>         Attachments: DRILL-710.patch
>
>
> The SIGN(n) function should return int values of 0, 1, or -1 regardless of number data type of n.  In drill, the return value is 1.0/-1.0/0.0 if n is a decimal value and 1/-1/0 if n is an int.  In oracle, postgres, and mysql, the return value is an int regardless of numeric data type passed to n.



--
This message was sent by Atlassian JIRA
(v6.2#6252)