apache / apache/datafusion-comet

SQL "order by" query returns wrong order for +0.0 and -0.0

Open
#3,825 2 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.