rubenada commented on pull request #2037: URL: https://github.com/apache/calcite/pull/2037#issuecomment-646651556
@hsyuan the behavior of our JoinType ANTI is not like a NOT IN, but a NOT EXISTS. Some time ago, I added a test case for this precise scenario in EnumerableCorrelateTest#antiJoinCorrelateWithNullValues (there is a comment in there explaining the situation). Bear in mind that, at that time, ANTI was a CorrelateJoinType, but not a JoinType. Later, with the big Join refactoring, ANTI (together with SEMI) was added as JoinType, and CorrelateJoinType was deprecated (and later removed). So, we must see ANTI as a NOT EXISTS, whose null management is not as drastic as NOT IN. ---------------------------------------------------------------- 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]
