francis0407 commented on issue #24344: [SPARK-27440][SQL] Optimize uncorrelated predicate subquery URL: https://github.com/apache/spark/pull/24344#issuecomment-486619453 I have made some tests in MySQL and SQLServer, and both have the same result with PostgreSQL. I think we'd better open a new JIRA for this issue. I can't solve the problem in this PR, since it requires a lot changes including codegen of Existence Join, and it is far beyond my ability. As for this PR, I just need to ensure that once we remove the case for `InSubquery` in `NullPropagation`, uncorrelated InSubquery could return the correct results.
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
