You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ignite.apache.org by "Andrey Mashenkov (Jira)" <ji...@apache.org> on 2025/10/06 11:22:00 UTC

[jira] [Created] (IGNITE-26613) Sql. Fix SQL queries results inconsistency for NaN values.

Andrey Mashenkov created IGNITE-26613:
-----------------------------------------

             Summary: Sql. Fix SQL queries results inconsistency for NaN values.
                 Key: IGNITE-26613
                 URL: https://issues.apache.org/jira/browse/IGNITE-26613
             Project: Ignite
          Issue Type: Bug
          Components: sql ai3
            Reporter: Andrey Mashenkov


For now, in come cases queries, which uses `{{{}FLOAT`{}}} or `DOUBLE`, may return inconsistent results for {{`NaN`}} values. 

* `{{{}SELECT MAX(f)`{}}} returns {{`NaN`}} 
* `{{{}SELECT f ... WHERE f > 0`{}}} omit {{NaN}} values.
* `SELECT f .. GROUP BY f`  returns a single group for `NaN` values.

Let's validate this behavior and fix if needed, or explain why all results are valid.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)