[ 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: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org