This is an automated email from the ASF dual-hosted git repository.
dataroaring pushed a commit to branch branch-3.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-3.0 by this push:
new 4524a8c5ff0 branch-3.0: [fix](cases) fix unstable leading cases #46441
(#47898)
4524a8c5ff0 is described below
commit 4524a8c5ff0a8276b53059436305a0422d46bb6c
Author: LiBinfeng <[email protected]>
AuthorDate: Mon Feb 24 17:34:37 2025 +0800
branch-3.0: [fix](cases) fix unstable leading cases #46441 (#47898)
pick from master #46441
---
.../data/nereids_p0/hint/test_leading.out | Bin 27327 -> 33391 bytes
.../suites/nereids_p0/hint/test_leading.groovy | 17 +++++++++++++++++
2 files changed, 17 insertions(+)
diff --git a/regression-test/data/nereids_p0/hint/test_leading.out
b/regression-test/data/nereids_p0/hint/test_leading.out
index 3ab63f84213..ea625449636 100644
Binary files a/regression-test/data/nereids_p0/hint/test_leading.out and
b/regression-test/data/nereids_p0/hint/test_leading.out differ
diff --git a/regression-test/suites/nereids_p0/hint/test_leading.groovy
b/regression-test/suites/nereids_p0/hint/test_leading.groovy
index 48d3d38fc81..8a4e27ea7fb 100644
--- a/regression-test/suites/nereids_p0/hint/test_leading.groovy
+++ b/regression-test/suites/nereids_p0/hint/test_leading.groovy
@@ -982,6 +982,20 @@ suite("test_leading") {
qt_select92_5 """explain shape plan select /*+ leading(t2 shuffle {t1
broadcast t3}) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
qt_select92_6 """explain shape plan select /*+ leading(t2 shuffle {t3
broadcast t1}) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select93_1 """explain shape plan select /*+ leading(t1 broadcast t2
broadcast t3) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select93_2 """explain shape plan select /*+ leading(t1 broadcast {t2
broadcast t3}) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select93_3 """explain shape plan select /*+ leading(t1 broadcast {t3
broadcast t2}) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select93_4 """explain shape plan select /*+ leading(t2 broadcast t1
broadcast t3) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select93_5 """explain shape plan select /*+ leading(t2 broadcast {t1
broadcast t3}) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select93_6 """explain shape plan select /*+ leading(t2 broadcast {t3
broadcast t1}) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+
+ qt_select94_2 """explain shape plan select /*+ leading(t1 shuffle t2
shuffle t3) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select94_2 """explain shape plan select /*+ leading(t1 shuffle {t2
shuffle t3}) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select94_2 """explain shape plan select /*+ leading(t1 shuffle {t3
shuffle t2}) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select94_2 """explain shape plan select /*+ leading(t2 shuffle t1
shuffle t3) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select94_2 """explain shape plan select /*+ leading(t2 shuffle {t1
shuffle t3}) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select94_2 """explain shape plan select /*+ leading(t2 shuffle {t3
shuffle t1}) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+
// outer join
qt_select95_1 """explain shape plan select /*+ leading(t1 broadcast t2
broadcast t3) */ count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2 =
c3;"""
explain {
@@ -992,6 +1006,7 @@ suite("test_leading") {
sql """shape plan select /*+ leading(t1 broadcast {t3 t2}) */ count(*)
from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
contains("UnUsed: leading(t1 broadcast { t3 t2 })")
}
+ qt_select95_4 """explain shape plan select /*+ leading(t2 broadcast t1
broadcast t3) */ count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2 =
c3;"""
explain {
sql """shape plan select /*+ leading(t2 broadcast {t1 t3}) */ count(*)
from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
contains("UnUsed: leading(t2 broadcast { t1 t3 })")
@@ -1004,6 +1019,8 @@ suite("test_leading") {
sql """shape plan select /*+ leading(t3 broadcast t1 t2) */ count(*)
from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
contains("UnUsed: leading(t3 broadcast t1 t2)")
}
+ qt_select95_8 """explain shape plan select /*+ leading(t3 broadcast {t1
broadcast t2}) */ count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2
= c3;"""
+ qt_select95_9 """explain shape plan select /*+ leading(t3 broadcast {t2
broadcast t1}) */ count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2
= c3;"""
qt_select96_1 """explain shape plan select /*+ leading(t1 shuffle t2
broadcast t3) */ count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2 =
c3;"""
explain {
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
