[
https://issues.apache.org/jira/browse/ASTERIXDB-2375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Xikui Wang reassigned ASTERIXDB-2375:
-------------------------------------
Assignee: Xikui Wang
> 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
> Assignee: Xikui Wang
> Priority: Major
>
> 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)