[SPARK-22755] Expression (946-885)*1.0/946 < 0.1 and (946-885)*1.000/946 < 0.1 return different results - ASF JIRA

XML

Word

Printable

JSON

both of the following sql statements

select ((946-885)*1.000/946 < 0.1)

and

select ((946-885)*1.0/946 < 0.100)

return true, while the following statement

select ((946-885)*1.0/946 < 0.1)

returns false

is related to

SPARK-21332 Incorrect result type inferred for some decimal expressions