https://issues.apache.org/jira/browse/IGNITE-26613

• The behavior of binary floating-point comparison has been reworked to use Float.compare / Double.compare (instead of primitive comparison operators) to align the behavior of handling special values NaN and -0.0 with the behavior of aggregate functions (for example, MAX/MIN).
• Fixed RelJson serialization to preserve negative zero (-0.0) value across (de)serialization.

Examples:

Table x

select val, count(val) from x group by val;

PostgreSql

-0.0 | 3

MariaDb

-0 | 2
0 | 1

Ignite

-0.0 | 2
0.0 | 1

select val from x where val < 0

PostgreSql

<empty>

MariaDb

<empty>

Ignite

-0.0
-0.0