apache / apache/datafusion-comet
SQL "order by" query returns wrong order for +0.0 and -0.0
Open
bug
df compatibility
- Dominant language
- Scala
- Stars
- 1.3k
- Forks
- 373
- Avg merge
- 2d 4h
- Merged PRs (30d)
- 198
Description
### Describe the bug
Spark returns +0.0 first
Comet returns -0.0 first
### Steps to reproduce
```scala
test("negative zero order by") {
withTable("t1") {
Seq(0.0f, -0.0f).toDF("a").write.saveAsTable("t1")
val df = sql("SELECT * FROM t1 ORDER BY a")
checkSparkAnswerAndOperator(df)
}
}
```
### Expected behavior
_No response_
### Additional context
_No response_
Contributor guide
Assessment
This issue has not been assessed yet.