2010YOUY01 commented on PR #16996: URL: https://github.com/apache/datafusion/pull/16996#issuecomment-3186586752
> Here is an example of a query that passes in main and fails on this branch: > > ```sql > CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER); > CREATE TABLE tab1(col0 INTEGER, col1 INTEGER, col2 INTEGER); > CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER); > INSERT INTO tab0 VALUES(97,1,99); > INSERT INTO tab0 VALUES(15,81,47); > INSERT INTO tab0 VALUES(87,21,10); > INSERT INTO tab1 VALUES(51,14,96); > INSERT INTO tab1 VALUES(85,5,59); > INSERT INTO tab1 VALUES(91,47,68); > INSERT INTO tab2 VALUES(64,77,40); > INSERT INTO tab2 VALUES(75,67,58); > INSERT INTO tab2 VALUES(46,51,23); > > SELECT DISTINCT 32 AS col2 FROM tab0 AS cor0 LEFT OUTER JOIN tab2 AS cor1 ON ( NULL ) IS NULL; > > Arrow error: Invalid argument error: must either specify a row count or at least one column > ``` > > There are a bunch of other failures where the result count between main and this branch do not match. I verified a bunch of the queries do have NestedLoopJoinExec in the explain result. Thanks for the reporting, I'll work on that today. I have ran the extended test on a early version, those failures must be introduced by my recent changes 🤔 -- 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
