[
https://issues.apache.org/jira/browse/SPARK-22755?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16287994#comment-16287994
]
Sunitha Kambhampati commented on SPARK-22755:
---------------------------------------------
A) TRUNK:
- My trunk codeline is sync'd up to Dec 7, commit
2d4c2b0bdf89badf25f2d1d98903125e48e7cd5c
- That said, I tried these statements now in spark sql repl and the answer is
true.
- I have not set any configuration, it is just the defaults in my dev env.
B) Spark 2.2:
- I downloaded the spark 2.2 binaries and tried the queries in spark-sql repl
and I can repro the issue.
{code}
select ((946-885)*1.0/946 < 0.1) -> returns false
select ((946-885)*1.0/946 < 0.100) -> returns true
{code}
So it looks like some fix has gone in as I cannot repro it on trunk.
I am not sure which issue has fixed it but just wanted to add this info for
now.
> 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]
