[
https://issues.apache.org/jira/browse/SPARK-22755?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16286256#comment-16286256
]
Sean Owen commented on SPARK-22755:
-----------------------------------
I assume the problem is precision, that the last expression is using only one
decimal place. Mathematically it should be true, but, I'm not expert enough on
SQL semantics to know whether the final expression is actually supposed to be
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]
