BUG #17172: NaN compare error in hash agg - Mailing list pgsql-bugs

The following bug has been logged on the website:

Bug reference:      17172
Logged by:          ma liangzhu
Email address:      ma100@hotmail.com
PostgreSQL version: 14beta1
Operating system:   centos7
Description:

postgres=# select '-NaN'::float union select ('Infinity'::float +
'-Infinity') union select 'NaN';
 float8 
--------
    NaN
    NaN
(2 rows)

postgres=# set enable_hashagg =0;
SET
postgres=# select '-NaN'::float union select ('Infinity'::float +
'-Infinity') union select 'NaN';
 float8 
--------
    NaN
(1 row)