This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.1 by this push:
new e63df94c9d9 [fix](cases) fix unstable leading cases (#46441) (#47896)
e63df94c9d9 is described below
commit e63df94c9d924cb7f12f1c3b2e9a750051ebe80d
Author: LiBinfeng <libinf...@selectdb.com>
AuthorDate: Tue Feb 25 20:38:34 2025 +0800
[fix](cases) fix unstable leading cases (#46441) (#47896)
---
.../data/nereids_p0/hint/test_leading.out | Bin 36438 -> 36239 bytes
.../suites/nereids_p0/hint/test_leading.groovy | 32 ++++++++++-----------
2 files changed, 15 insertions(+), 17 deletions(-)
diff --git a/regression-test/data/nereids_p0/hint/test_leading.out
b/regression-test/data/nereids_p0/hint/test_leading.out
index e7bca5b4023..4328db31dca 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 ad321424f29..57453ba7eb8 100644
--- a/regression-test/suites/nereids_p0/hint/test_leading.groovy
+++ b/regression-test/suites/nereids_p0/hint/test_leading.groovy
@@ -938,8 +938,6 @@ suite("test_leading") {
// 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
explain {
sql """shape plan select count(*) from t1 right outer join [broadcast]
t2 on c1 = c2;"""
@@ -983,19 +981,19 @@ 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 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 {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 {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 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 {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 {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 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 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 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 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 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 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;"""
@@ -1007,7 +1005,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 t3)
*/ count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
+ 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 })")
@@ -1020,8 +1018,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
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
t1}) */ count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
+ 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: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
