Kirill Tkalenko created IGNITE-29311:
----------------------------------------

             Summary: SQL Calcite: Inconsistent equality and hashing for REAL 
and DOUBLE
                 Key: IGNITE-29311
                 URL: https://issues.apache.org/jira/browse/IGNITE-29311
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 2.18
            Reporter: Kirill Tkalenko
            Assignee: Kirill Tkalenko


{{SqlValueUtils#deepEquals}} and {{{}SqlValueUtils#{}}}{{{}deepHashCode{}}} are 
inconsistent with SQL equality for REAL and DOUBLE values:
 * {{-0.0}} and {{+0.0}} are treated as different values.
 * {{NaN}} and {{NaN}} are treated as equal.

This can produce incorrect results in operations such as hash joins and ROW 
comparisons. Add regression tests and align the methods with SQL comparison 
semantics.



--
This message was sent by Atlassian Jira
(v10.3.26#10030026)

Reply via email to