raghavyadav01 commented on issue #25347: URL: https://github.com/apache/datafusion/issues/25347#issuecomment-6506155904
Checked on current main (14aa185dd). All 8 shapes return the same rows as DuckDB 1.5.6 now, including the constant ones from https://github.com/apache/datafusion/issues/25347#issuecomment-5689471249: ```sql CREATE TABLE t_out(id INT, g INT) AS VALUES (1, 1), (2, 2); CREATE TABLE t_in(id INT, g INT) AS VALUES (1, 1), (NULL, 2); SELECT id FROM t_out WHERE 3 NOT IN (SELECT id FROM t_in WHERE t_in.g = t_out.g); -- 1 SELECT id FROM t_out WHERE 3 NOT IN (SELECT id FROM t_in WHERE t_in.g > t_out.g); -- 2 SELECT id FROM t_out WHERE 3 NOT IN (SELECT id FROM t_in WHERE t_in.g = t_out.g) OR g = 99; -- 1 SELECT id FROM t_out WHERE 3 NOT IN (SELECT id FROM t_in WHERE t_in.g > t_out.g) OR g = 99; -- 2 SELECT id FROM t_out WHERE (3 NOT IN (SELECT id FROM t_in WHERE t_in.g = t_out.g)) IS NULL; -- 2 SELECT id FROM t_out WHERE (3 NOT IN (SELECT id FROM t_in WHERE t_in.g > t_out.g)) IS NULL; -- 1 SELECT id FROM t_out WHERE id NOT IN (SELECT id FROM t_in WHERE t_in.g = t_out.g); -- no rows SELECT id FROM t_out WHERE id NOT IN (SELECT id FROM t_in WHERE t_in.g > t_out.g); -- 2 ``` I think this can be closed. -- 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]
