You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@drill.apache.org by "Mehant Baid (JIRA)" <ji...@apache.org> on 2014/06/04 07:41:02 UTC

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

     [ https://issues.apache.org/jira/browse/DRILL-710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mehant Baid reassigned DRILL-710:
---------------------------------

    Assignee: Mehant Baid

> 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
>            Assignee: Mehant Baid
>         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)