2010YOUY01 opened a new issue, #11264:
URL: https://github.com/apache/datafusion/issues/11264
### Describe the bug
This aggregate query returns different result from run to run
Much appreciated if anyone could rerun & confirm, or minimize this bug!
### To Reproduce
Executing following statements in `datafusion-cli` to setup tables
```sql
/*1*/ /*DML*/ CREATE TABLE t0(v0 BIGINT, v1 DOUBLE, v2 BOOLEAN);
/*2*/ /*DML*/ CREATE TABLE t64(v0 DOUBLE);
/*3*/ /*DML*/ CREATE TABLE t1(v0 DOUBLE);
/*4*/ /*DML*/ CREATE TABLE t97(v0 BOOLEAN);
/*5*/ /*DML*/ CREATE TABLE t73(v0 DOUBLE, v1 BIGINT, v2 BIGINT);
/*6*/ /*DML*/ INSERT INTO t64(v0) VALUES (0.9381581402445061), (+0.0),
(-0.0);
/*7*/ /*DML*/ INSERT INTO t64(v0) VALUES (NULL), (1.5753477614031765E308),
(0.006050796796817082);
/*8*/ /*DML*/ INSERT INTO t64(v0) VALUES (0.2409806315244235),
(0.2210083496149292);
/*9*/ /*DML*/ INSERT INTO t64(v0) VALUES (0.7884859643116078);
/*10*/ /*DML*/ INSERT INTO t64(v0) VALUES (1.0520311921422949E308),
(7.328703000726609E307);
/*11*/ /*DML*/ INSERT INTO t64(v0) VALUES (1.1395407049358574E308),
(-1.3151865100063228E308);
/*12*/ /*DML*/ INSERT INTO t64(v0) VALUES (0.5051666339856035),
(0.4220858619783221), (-1.2830593404326414E308);
/*13*/ /*DML*/ INSERT INTO t64(v0) VALUES (0.2668989395491763);
/*14*/ /*DML*/ INSERT INTO t64(v0) VALUES (0.38341817667602074);
/*15*/ /*DML*/ INSERT INTO t73(v0) VALUES (0.04629472695473025);
/*16*/ /*DML*/ INSERT INTO t73(v2, v0, v1) VALUES (389871702,
'-Inf'::Double, 389871702);
/*17*/ /*DML*/ INSERT INTO t97(v0) VALUES (true);
/*18*/ /*DML*/ INSERT INTO t97(v0) VALUES (true);
/*19*/ /*DML*/ INSERT INTO t97(v0) VALUES (false);
/*20*/ /*DML*/ INSERT INTO t97(v0) VALUES (false), (false);
/*21*/ /*DML*/ INSERT INTO t97(v0) VALUES (false);
/*22*/ /*DML*/ INSERT INTO t97(v0) VALUES (false), (false);
/*23*/ /*DML*/ INSERT INTO t97(v0) VALUES (false);
/*24*/ /*DML*/ INSERT INTO t0(v0, v1) VALUES (611863454,
-1.7759381831381458E308), (389871702, -0.0);
/*25*/ /*DML*/ INSERT INTO t0(v0, v2) VALUES (389871702, false);
/*26*/ /*DML*/ INSERT INTO t0(v0, v1, v2) VALUES (NULL, 0.2824144132029637,
false);
/*27*/ /*DML*/ INSERT INTO t0(v1, v0, v2) VALUES (8.632837270764036E307,
389871702, true);
/*28*/ /*DML*/ INSERT INTO t0(v2) VALUES (true), (false);
/*29*/ /*DML*/ INSERT INTO t0(v2, v0) VALUES (true, -1448403337);
/*30*/ /*DML*/ INSERT INTO t1(v0) VALUES (0.2668989395491763);
/*31*/ /*DML*/ INSERT INTO t1(v0) VALUES (+0.0);
/*32*/ /*DML*/ INSERT INTO t1(v0) VALUES ('-Inf'::Double), ('NaN'::Double),
(+0.0);
/*33*/ /*DML*/ INSERT INTO t1(v0) VALUES (0.38341817667602074);
/*34*/ /*DML*/ INSERT INTO t1(v0) VALUES (+0.0), (6.11863454E8);
/*35*/ /*DML*/ INSERT INTO t1(v0) VALUES (-7.024071633675249E307);
/*36*/ /*DML*/ INSERT INTO t1(v0) VALUES (-0.0), (0.6980448162044035),
(-8.299172784637644E307);
/*37*/ /*DML*/ INSERT INTO t1(v0) VALUES (0.8169452791572056);
/*38*/ /*DML*/ INSERT INTO t1(v0) VALUES (+0.0), (0.3710336048023243);
```
Then execute the query. It seems around half of the result is `Inf` and
another half is `NaN` 🤔
```
> SELECT SUM(t64.v0) FROM t97, t73, t64 WHERE t97.v0;
+-------------+
| sum(t64.v0) |
+-------------+
| NaN |
+-------------+
1 row(s) fetched.
Elapsed 0.008 seconds.
> SELECT SUM(t64.v0) FROM t97, t73, t64 WHERE t97.v0;
+-------------+
| sum(t64.v0) |
+-------------+
| inf |
+-------------+
1 row(s) fetched.
Elapsed 0.008 seconds.
> SELECT SUM(t64.v0) FROM t97, t73, t64 WHERE t97.v0;
+-------------+
| sum(t64.v0) |
+-------------+
| NaN |
+-------------+
1 row(s) fetched.
Elapsed 0.008 seconds.
```
### Expected behavior
returns `Inf`
### Additional context
Found by SQLancer https://github.com/apache/datafusion/issues/11030
--
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]
