[
https://issues.apache.org/jira/browse/IGNITE-29311?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kirill Tkalenko resolved IGNITE-29311.
--------------------------------------
Resolution: Invalid
> 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
> Priority: Major
> Labels: calcite, ignite-2, sql
>
> {{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)