The following bug has been logged on the website:
Bug reference: 17172
Logged by: ma liangzhu
Email address: ma100(at)hotmail(dot)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)