Skip to content

Crash bug in APPROX_MEDIAN aggregate function (SQLancer) #11871

New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Closed
2010YOUY01 opened this issue Aug 7, 2024 · 0 comments · Fixed by #11934
Closed

Crash bug in APPROX_MEDIAN aggregate function (SQLancer) #11871

2010YOUY01 opened this issue Aug 7, 2024 · 0 comments · Fixed by #11934
Labels
bug Something isn't working

Comments

@2010YOUY01
Copy link
Contributor

Describe the bug

See full reproducer in datafusion-cli

DataFusion CLI v40.0.0
> /*DML*/CREATE TABLE t1(v0 BOOLEAN, v1 BIGINT, v2 BOOLEAN, v3 STRING);
/*DML*/INSERT INTO t1(v3, v0, v2, v1) VALUES ('', false, false, 1962353436);
0 row(s) fetched.
Elapsed 0.068 seconds.

+-------+
| count |
+-------+
| 1     |
+-------+
1 row(s) fetched.
Elapsed 0.046 seconds.

> select APPROX_MEDIAN('NaN'::Double)
FROM
    t1
WHERE
    (t1.v0) IS DISTINCT FROM true;
thread 'main' panicked at /rustc/051478957371ee0084a7c0913941d2a8c4757bb9/library/core/src/num/f64.rs:1509:9:
min > max, or either was NaN. min = inf, max = -inf
note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace

To Reproduce

No response

Expected behavior

No response

Additional context

Found by SQLancer #11030

@2010YOUY01 2010YOUY01 added the bug Something isn't working label Aug 7, 2024
@2010YOUY01 2010YOUY01 changed the title Crash bug in APPROX_MEDIAN aggregate function Crash bug in APPROX_MEDIAN aggregate function (SQLancer) Aug 7, 2024
# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant