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)
