xzj7019 commented on code in PR #31854:
URL: https://github.com/apache/doris/pull/31854#discussion_r1515405651
##########
regression-test/suites/nereids_syntax_p0/transform_outer_join_to_anti.groovy:
##########
@@ -62,5 +62,25 @@ suite("transform_outer_join_to_anti") {
sql("select eliminate_outer_join_B.* from eliminate_outer_join_A right
outer join eliminate_outer_join_B on eliminate_outer_join_B.b =
eliminate_outer_join_A.a where eliminate_outer_join_A.null_a is null")
contains "OUTER JOIN"
}
+
+ explain {
Review Comment:
does this will do or-expansion and side b can be converted to anti?
--
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]
