DataFusion CLI v40.0.0
> /*DML*/CREATE TABLE t1(v0 BIGINT, v1 STRING, v2 STRING, v3 BIGINT);
/*DML*/INSERT INTO t1(v3, v2, v0) VALUES (-12297124, 'X}', 1), (2077280913, '', 0), (1, '', -844943143);
0 row(s) fetched.
Elapsed 0.066 seconds.
+-------+
| count |
+-------+
| 3 |
+-------+
1 row(s) fetched.
Elapsed 0.048 seconds.
> SELECT APPROX_PERCENTILE_CONT('NaN'::Double, 0.8)
FROM t1
WHERE ('+Inf'::Double) > t1.v3;
thread 'main' panicked at /rustc/051478957371ee0084a7c0913941d2a8c4757bb9/library/core/src/num/f64.rs:1509:9:
min > max, or either was NaN. min = NaN, max = -inf
note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace