Xikui Wang created ASTERIXDB-2375:
-------------------------------------
Summary: Float to Double promotion causes comparison fail in
ComparisonHelper
Key: ASTERIXDB-2375
URL: https://issues.apache.org/jira/browse/ASTERIXDB-2375
Project: Apache AsterixDB
Issue Type: Bug
Reporter: Xikui Wang
In the ComparisonHelper, when the two compared values have different types, we
promote the lower precision one to higher and compare. This causes an issue
when checking equality of float and double, the float is cast to double but
failed at comparison as the prevision is widened. One example is
select * from Supplier s where s.salary = 83.44;
The 83.44 in the database is casted to 83.4397***** which is not equal to 83.44.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)