[
https://issues.apache.org/jira/browse/SPARK-22755?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16288061#comment-16288061
]
Sunitha Kambhampati commented on SPARK-22755:
---------------------------------------------
SPARK-21332 fixed this issue.
The changes for it are also in Spark-2.2.1 that is released on Dec 1. I tried
it on Spark-2.2.1 and the queries return true.
> Expression (946-885)*1.0/946 < 0.1 and (946-885)*1.000/946 < 0.1 return
> different results
> -----------------------------------------------------------------------------------------
>
> Key: SPARK-22755
> URL: https://issues.apache.org/jira/browse/SPARK-22755
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.2.0
> Reporter: Kevin Zhang
>
> both of the following sql statements
> {code:sql}
> select ((946-885)*1.000/946 < 0.1)
> {code}
> and
> {code:sql}
> select ((946-885)*1.0/946 < 0.100)
> {code}
> return true, while the following statement
> {code:sql}
> select ((946-885)*1.0/946 < 0.1)
> {code}
> returns false
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
