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

liuxian updated SPARK-20876:
----------------------------
    Description: 
spark-sql>SELECT ceil(cast(12345.1233 as float));
spark-sql>12345
For this case, we expected is 12346

spark-sql>SELECT floor(cast(-12345.1233 as float));
spark-sql>-12345
For this case, the result we expected is  -12346

  was:
spark-sql>SELECT ceil(cast(12345.1233 as float));
spark-sql>12345
For this case, we expected is 12346



> if the input parameter is float type for  ceil ,the result is not we expected
> -----------------------------------------------------------------------------
>
>                 Key: SPARK-20876
>                 URL: https://issues.apache.org/jira/browse/SPARK-20876
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 2.1.0
>            Reporter: liuxian
>
> spark-sql>SELECT ceil(cast(12345.1233 as float));
> spark-sql>12345
> For this case, we expected is 12346
> spark-sql>SELECT floor(cast(-12345.1233 as float));
> spark-sql>-12345
> For this case, the result we expected is  -12346



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to