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]

Reply via email to