alamb commented on issue #11108:
URL: https://github.com/apache/datafusion/issues/11108#issuecomment-4558953225
I tested duckdb and postgres and they seem to have the -0 == 0 behavior
```sql
andrewlamb@Andrews-MacBook-Pro-3:~/Downloads/burnin/aws_tester$ duckdb
DuckDB v1.5.2 (Variegata)
Enter ".help" for usage hints.
memory D select 0.0 == -0.0;
┌─────────────┐
│ (0.0 = 0.0) │
│ boolean │
├─────────────┤
│ true │
└─────────────┘
```
```sql
postgres=# select 0.0::float = -0.0::float;
?column?
----------
t
(1 row)
postgres=# select 0.0 = -0.0;
?column?
----------
t
```
As long as we can fix this without causing performance regressions sounds
good to me
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]