morrySnow commented on code in PR #32703:
URL: https://github.com/apache/doris/pull/32703#discussion_r1535495743
##########
regression-test/suites/nereids_rules_p0/pkfk/eliminate_inner.groovy:
##########
@@ -112,6 +113,11 @@ suite("eliminate_inner") {
check_shape_res("select fkt.*, pkt.pk from pkt inner join (select fk from
fkt order by fk limit 1 ) fkt on pkt.pk = fkt.fk;", "fk with limit")
check_shape_res("select fkt.*, pkt.pk from pkt inner join fkt on pkt.pk =
fkt.fk where pkt.pk = 1 and fkt.fk = 1;", "pk with filter that same as fk")
check_shape_res("select fkt.*, pkt.pk from pkt inner join fkt on pkt.pk =
fkt.fk where pkt.pk = 1 and fkt.fk = 1 and fkt.f = 1;", "pk with filter that
included same as fk")
- check_shape_res("select fkt.*, pkt.pk from pkt inner join fkt on pkt.pk =
fkt.fk where pkt.p = 1 and fkt.fk = 1 and fkt.f = 1;;", "pk with filter that
not same as fk")
+ check_shape_res("select fkt.*, pkt.pk from pkt inner join fkt on pkt.pk =
fkt.fk where pkt.p = 1 and fkt.fk = 1 and fkt.f = 1;", "pk with filter that not
same as fk")
+
+ // 测试多表join，其中fkt_not_null和pkt为主外键关系，fkt_not_null2为普通表
Review Comment:
use english
--
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]
