skyzh commented on PR #14595: URL: https://github.com/apache/datafusion/pull/14595#issuecomment-2661667504
The current one-pass subquery unnesting implementation in `PullUpCorrelatedExpr` does not handle cases such as when we have joins in subqueries: ```sql SELECT * FROM t0, LATERAL (SELECT 1), LATERAL (SELECT * FROM t1 WHERE t0.v0 = t1.v0); ``` Just note it down here and we can improve it in the future. We could implement a rule-based unnesting to push down the lateral join operator. -- 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
