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)