[
https://issues.apache.org/jira/browse/DRILL-710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Krystal closed DRILL-710.
-------------------------
bug was verified.
> 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: 0.1.0-m1
> Reporter: Krystal
> Fix For: 0.4.0
>
> 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.3.15#6346)
