You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@datafusion.apache.org by "neilconway (via GitHub)" <gi...@apache.org> on 2026/03/27 16:47:07 UTC

[I] Support LATERAL subqueries with outer relation references outside WHERE clause [datafusion]

neilconway opened a new issue, #21201:
URL: https://github.com/apache/datafusion/issues/21201

   ### Describe the bug
   
   We only support LATERAL subqueries that reference the outer relation in their WHERE clause; we should expand this to support more queries.
   
   ### To Reproduce
   
   _No response_
   
   ### Expected behavior
   
   _No response_
   
   ### 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] Support LATERAL subqueries with outer relation references outside WHERE clause [datafusion]

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

   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] Support LATERAL subqueries with outer relation references outside WHERE clause [datafusion]

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

   I think we should implement support support for this feature as part of the more general subquery decorrelation project described here
   - https://github.com/apache/datafusion/issues/5492
   
   in my opinion WE SHOULD NOT try and extend the existing subquery rewrites to support this type of query as that risks introducing many more wrong results, see https://github.com/apache/datafusion/issues/5492#issuecomment-6479109212
   


-- 
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