You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@datafusion.apache.org by "lyne7-sc (via GitHub)" <gi...@apache.org> on 2026/06/11 07:28:19 UTC

[I] ProjectionPushdown panics with assertion error on mark join (NOT EXISTS with non-equi correlation) [datafusion]

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: github-unsubscribe@datafusion.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org

Re: [I] `ProjectionPushdown` internal error on NestedLoopJoin mark joins [datafusion]

Posted by "lyne7-sc (via GitHub)" <gi...@apache.org>.
lyne7-sc commented on issue #22901:
URL: https://github.com/apache/datafusion/issues/22901#issuecomment-4678253889

   take


-- 
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-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org

Re: [I] `ProjectionPushdown` internal error on NestedLoopJoin mark joins [datafusion]

Posted by "kosiew (via GitHub)" <gi...@apache.org>.
kosiew closed issue #22901: `ProjectionPushdown` internal error on NestedLoopJoin mark joins
URL: https://github.com/apache/datafusion/issues/22901


-- 
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-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org