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)

Reply via email to