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

Posted to dev@drill.apache.org by "Krystal (JIRA)" <ji...@apache.org> on 2014/05/13 19:36:14 UTC

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

Krystal created DRILL-710:
-----------------------------

             Summary: 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


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)