xzj7019 commented on code in PR #28562:
URL: https://github.com/apache/doris/pull/28562#discussion_r1439302560
##########
regression-test/suites/nereids_p0/hint/test_leading.groovy:
##########
@@ -928,6 +928,159 @@ suite("test_leading") {
qt_select88_12 """select /*+ leading(t3 alias2 t1) */ count(*) from t1
left semi join (select c2 from t2) as alias2 on c1 = c2 left anti join t3 on c1
= c3 where exists (select 1 from t3 join t4 on c3 = c4);"""
qt_select88_13 """select /*+ leading(t3 {alias2 t1}) */ count(*) from t1
left semi join (select c2 from t2) as alias2 on c1 = c2 left anti join t3 on c1
= c3 where exists (select 1 from t3 join t4 on c3 = c4);"""
+ // distribute hint + leading hint
+// only distribute hint + single hint
+ // used
+ qt_select90_1 """explain shape plan select count(*) from t1 join
[broadcast] t2 on c1 = c2;"""
+ // unused
+ qt_select90_2 """explain shape plan select count(*) from t1 right outer
join [broadcast] t2 on c1 = c2;"""
+
+// only distribute hint + multi hints
+ qt_select90_3 """explain shape plan select count(*) from t1 join
[broadcast] t2 on c1 = c2 join[shuffle] t3 on c2 = c3;"""
+ qt_select90_4 """explain shape plan select count(*) from t1 right outer
join [broadcast] t2 on c1 = c2 join[shuffle] t3 on c2 = c3;"""
+ qt_select90_5 """explain shape plan select count(*) from t1 join
[broadcast] t2 on c1 = c2 right outer join[shuffle] t3 on c2 = c3;"""
+ qt_select90_6 """explain shape plan select count(*) from t1 join [shuffle]
t2 on c1 = c2 right outer join[broadcast] t3 on c2 = c3;"""
+
+// leading + distribute hint outside leading + single hint
(若leading生效则外面的distributeHint全部不生效，若leading不生效则外面的distributeHint照常)
Review Comment:
replace the chinese.
--
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: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
