yiyi99 commented on issue #25258: URL: https://github.com/apache/datafusion/issues/25258#issuecomment-5653323844
Thanks! I don't have bandwidth to work on a fix right now — please go ahead. FWIW, in case it helps: we observed the optimized plan ends up with the correlation predicate pushed inside the subquery scan as a self-comparison (emp.salary > emp.salary IS TRUE) when the outer query and subquery reference the same unaliased table — looks like the outer reference becomes indistinguishable from the inner column after the SubqueryAlias wrapper is stripped during pushdown. Verified on 54.1.0 and 55.1.0. Happy to review/test the fix. > [@yiyi99](https://github.com/yiyi99) if you don't plan on working on this, I can take it -- 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]
