2010YOUY01 opened a new issue, #11409: URL: https://github.com/apache/datafusion/issues/11409
### Describe the bug This query should be valid, but it returned a projection-pushdown related bug during the execution Reproducer: ``` /*DML*/CREATE TABLE t1(v0 BIGINT, v1 BIGINT, v2 BIGINT, v3 BOOLEAN); /*DML*/CREATE TABLE t2(v0 DOUBLE); -- Renamed t13 to t2 /*DML*/INSERT INTO t1(v0, v2, v1) VALUES (-1229445667, -342312412, -1507138076); /*DML*/INSERT INTO t1(v0, v1) VALUES (1541512604, -1229445667); /*DML*/INSERT INTO t1(v1, v3, v0, v2) VALUES (-1020641465, false, -1493773377, 1751276473); /*DML*/INSERT INTO t1(v3) VALUES (true), (true), (false); /*DML*/INSERT INTO t2(v0) VALUES (0.28014577292925047); SELECT t1.v2, t1.v0 FROM t2 NATURAL JOIN t1 UNION ALL SELECT t1.v2, t1.v0 FROM t2 NATURAL JOIN t1 WHERE (t1.v2 IS NULL); ``` Error message ``` ProjectionPushdown caused by Internal error: Not all InterleaveExec children have a consistent hash partitioning. This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker ``` ### To Reproduce _No response_ ### Expected behavior _No response_ ### 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: github-unsubscr...@datafusion.apache.org.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