2010YOUY01 commented on issue #11408:
URL: https://github.com/apache/datafusion/issues/11408#issuecomment-2226912517
Note to myself: maybe duplicate
```
NoREC oracle violated:
Q1(result size 0):SELECT COUNT(*) FROM t2 table1 FULL JOIN t2 table1 ON
((table1.v1)<(((((table1.v2)|(-1680394990)))==(RADIANS(NULL))))) WHERE
table1.v3;
Q2(result size 3):SELECT COUNT(CASE WHEN TABLE1.V3 THEN 1 ELSE NULL END)
FROM t2 table1 FULL JOIN t2 AS table1 ON
((table1.v1)<(((((table1.v2)|(-1680394990)))==(RADIANS(NULL)))));
=======================================
Reproducer:
/*DML*/CREATE TABLE t0(v0 BIGINT, v1 BOOLEAN, v2 BOOLEAN, v3 DOUBLE);
/*DML*/CREATE TABLE t1(v0 DOUBLE);
/*DML*/CREATE TABLE t2(v0 DOUBLE, v1 BOOLEAN, v2 BIGINT, v3 BOOLEAN);
/*DML*/INSERT INTO t0(v3, v0, v2) VALUES ('NaN'::Double, 462373142, false);
/*DML*/INSERT INTO t0(v0, v2) VALUES (462373142, NULL);
/*DML*/INSERT INTO t1(v0) VALUES (0.23090038573154326);
/*DML*/INSERT INTO t1(v0) VALUES ('+Inf'::Double), ('+Inf'::Double);
/*DML*/INSERT INTO t1(v0) VALUES ('+Inf'::Double);
/*DML*/INSERT INTO t2(v2) VALUES (673041184);
/*DML*/INSERT INTO t2(v2, v3) VALUES (212832748, false);
/*DML*/INSERT INTO t2(v3, v0, v2) VALUES (true, 0.9397291016687526,
462373142);
/*DML*/INSERT INTO t2(v1, v2, v0, v3) VALUES (false, 462373142,
0.6388418793650567, true);
/*DML*/INSERT INTO t2(v3, v0) VALUES (true, 0.6388418793650567);
/*DML*/INSERT INTO t2(v0, v2, v3) VALUES (0.31756635573567127, 104424209,
false);
```
--
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: github-unsubscr...@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org
