foxtail463 opened a new pull request, #70694: URL: https://github.com/apache/doris/pull/70694
Problem Summary: For p.k = 7 AND p.k NOT IN (SELECT b.k FROM b), declaration-only checks retain NULL_AWARE_LEFT_ANTI_JOIN even when nullable p.k is constant non-null and b.k is NOT NULL, preventing inference of b.k = 7 into the build side. Solution: Use immediate-child output nullability and Uniform proofs to eliminate null-aware anti joins when both equality keys are non-null, while retaining the original join for mark joins and unproven or null-extended keys. -- 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]
