lyne7-sc opened a new issue, #22901: URL: https://github.com/apache/datafusion/issues/22901
### Describe the bug A query whose subquery is planned as a mark join (`LeftMark`/`RightMark`) fails during physical planning with an internal error in `ProjectionPushdown`. ### To Reproduce ```sql CREATE TABLE t1(t1_id INT, t1_name TEXT, t1_int INT) AS VALUES (11, 'a', 1),(22, 'b', 2),(33, 'c', 3),(44, 'd', 4); CREATE TABLE t2(t2_id INT, t2_name TEXT, t2_int INT) AS VALUES (11, 'z', 3),(22, 'y', 1),(44, 'x', 3),(55, 'w', 3); SELECT t1_id FROM t1 WHERE t1_id > 40 OR NOT EXISTS (SELECT 1 FROM t2 WHERE t2.t2_int > t1.t1_int); ``` Result: ``` ProjectionPushdown caused by Internal error: Assertion failed: col.name() == matching_name: Input field name t2_int does not match with the projection expression t1_id. This issue was likely caused by a bug in DataFusion's code. Please help us to resolve this by filing a bug report in our issue tracker: https://github.com/apache/datafusion/issues ``` ### Expected behavior The query should plan and execute successfully. ### Additional context _No response_ -- 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]
