This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-4.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-4.0 by this push:
new 7b5aa9e1f8a branch-4.0 [fix](regression) use qt_order in
tpch_sf0.1_p1/sql/cse.groovy to make case stable #56512 (#56670)
7b5aa9e1f8a is described below
commit 7b5aa9e1f8a8a5b84fcc8e1ca0de0d20afc77b92
Author: minghong <[email protected]>
AuthorDate: Tue Sep 30 16:23:55 2025 +0800
branch-4.0 [fix](regression) use qt_order in tpch_sf0.1_p1/sql/cse.groovy
to make case stable #56512 (#56670)
### What problem does this PR solve?
pick 56227 and 56512
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
### Release note
None
### Check List (For Author)
- Test <!-- At least one of them must be included. -->
- [ ] Regression test
- [ ] Unit Test
- [ ] Manual test (add detailed scripts or steps below)
- [ ] No need to test or manual test. Explain why:
- [ ] This is a refactor/code format and no logic has been changed.
- [ ] Previous test can cover this change.
- [ ] No code files have been changed.
- [ ] Other reason <!-- Add your reason? -->
- Behavior changed:
- [ ] No.
- [ ] Yes. <!-- Explain the behavior change -->
- Does this need documentation?
- [ ] No.
- [ ] Yes. <!-- Add document PR link here. eg:
https://github.com/apache/doris-website/pull/1214 -->
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label <!-- Add branch pick label that this PR
should merge into -->
---
regression-test/data/tpch_sf0.1_p1/sql/cse.out | 18 +++++++++---------
regression-test/suites/tpch_sf0.1_p1/sql/cse.groovy | 2 +-
2 files changed, 10 insertions(+), 10 deletions(-)
diff --git a/regression-test/data/tpch_sf0.1_p1/sql/cse.out
b/regression-test/data/tpch_sf0.1_p1/sql/cse.out
index a0d5f98f2b0..90ab26287db 100644
--- a/regression-test/data/tpch_sf0.1_p1/sql/cse.out
+++ b/regression-test/data/tpch_sf0.1_p1/sql/cse.out
@@ -36,30 +36,30 @@
5 6
6 7
--- !multiDataSink --
-9 INDONESIA 2 slyly express asymptotes. regular deposits
haggle slyly. carefully ironic hockey players sleep blithely. carefull 4
MIDDLE EAST uickly special accounts cajole carefully blithely close
requests. carefully final asymptotes haggle furiousl
-8 INDIA 2 ss excuses cajole slyly across the packages. deposits
print aroun 3 EUROPE ly final courts cajole furiously final excuse
+-- !order_multiDataSink --
5 ETHIOPIA 0 ven packages wake quickly. regu 0 AFRICA
lar deposits. blithely final packages cajole. regular waters are final
requests. regular accounts are according to
6 FRANCE 3 refully final requests. regular, ironi 1 AMERICA
hs use ironic, even requests. s
7 GERMANY 3 l platelets. regular accounts x-ray: unusual, regular
acco 2 ASIA ges. thinly even pinto beans ca
+8 INDIA 2 ss excuses cajole slyly across the packages. deposits
print aroun 3 EUROPE ly final courts cajole furiously final excuse
+9 INDONESIA 2 slyly express asymptotes. regular deposits
haggle slyly. carefully ironic hockey players sleep blithely. carefull 4
MIDDLE EAST uickly special accounts cajole carefully blithely close
requests. carefully final asymptotes haggle furiousl
20 SAUDI ARABIA 4 ts. silent requests haggle. closely express
packages sleep across the blithely 0 AFRICA lar deposits. blithely
final packages cajole. regular waters are final requests. regular accounts are
according to
23 UNITED KINGDOM 3 eans boost carefully special requests. accounts
are. carefull 3 EUROPE ly final courts cajole furiously final excuse
22 RUSSIA 3 requests against the platelets use never according to
the quickly regular pint 2 ASIA ges. thinly even pinto beans ca
-4 EGYPT 4 y above the carefully unusual theodolites. final
dugouts are quickly across the furiously regular d \N \N \N
-14 KENYA 0 pending excuses haggle furiously deposits. pending,
express pinto beans wake fluffily past t \N \N \N
-16 MOZAMBIQUE 0 s. ironic, unusual asymptotes wake blithely r
\N \N \N
-19 ROMANIA 3 ular asymptotes are about the furious multipliers.
express dependencies nag above the ironically ironic account \N \N \N
+21 VIETNAM 2 hely enticingly express accounts. even, final 1
AMERICA hs use ironic, even requests. s
+24 UNITED STATES 1 y final packages. slow foxes cajole quickly.
quickly silent platelets breach ironic accounts. unusual pinto be 4
MIDDLE EAST uickly special accounts cajole carefully blithely close
requests. carefully final asymptotes haggle furiousl
2 BRAZIL 1 y alongside of the pending deposits. carefully special
packages are about the ironic forges. slyly special \N \N \N
10 IRAN 4 efully alongside of the slyly final dependencies.
\N \N \N
11 IRAQ 4 nic deposits boost atop the quickly final requests?
quickly regula \N \N \N
12 JAPAN 2 ously. final, express gifts cajole a \N \N
\N
15 MOROCCO 0 rns. blithely bold courts among the closely regular
packages use furiously bold platelets? \N \N \N
18 CHINA 2 c dependencies. furiously express notornis sleep slyly
regular accounts. ideas sleep. depos \N \N \N
+4 EGYPT 4 y above the carefully unusual theodolites. final
dugouts are quickly across the furiously regular d \N \N \N
+14 KENYA 0 pending excuses haggle furiously deposits. pending,
express pinto beans wake fluffily past t \N \N \N
+16 MOZAMBIQUE 0 s. ironic, unusual asymptotes wake blithely r
\N \N \N
+19 ROMANIA 3 ular asymptotes are about the furious multipliers.
express dependencies nag above the ironically ironic account \N \N \N
0 ALGERIA 0 haggle. carefully final deposits detect slyly agai
\N \N \N
1 ARGENTINA 1 al foxes promise slyly according to the regular
accounts. bold requests alon \N \N \N
3 CANADA 1 eas hang ironic, silent packages. slyly regular
packages are furiously over the tithes. fluffily bold \N \N \N
13 JORDAN 4 ic deposits are blithely about the carefully regular pa
\N \N \N
17 PERU 1 platelets. blithely pending dependencies use fluffily
across the even pinto beans. carefully silent accoun \N \N \N
-21 VIETNAM 2 hely enticingly express accounts. even, final 1
AMERICA hs use ironic, even requests. s
-24 UNITED STATES 1 y final packages. slow foxes cajole quickly.
quickly silent platelets breach ironic accounts. unusual pinto be 4
MIDDLE EAST uickly special accounts cajole carefully blithely close
requests. carefully final asymptotes haggle furiousl
diff --git a/regression-test/suites/tpch_sf0.1_p1/sql/cse.groovy
b/regression-test/suites/tpch_sf0.1_p1/sql/cse.groovy
index 29451c8ff83..96747c290c6 100644
--- a/regression-test/suites/tpch_sf0.1_p1/sql/cse.groovy
+++ b/regression-test/suites/tpch_sf0.1_p1/sql/cse.groovy
@@ -56,6 +56,6 @@ suite('cse') {
from region order by x, y;"""
// do not apply cse upon multiDataSink. it is hard to check plan detail on
multiDataSink, so just check result.
- qt_multiDataSink "select * FROM nation left outer join region on
n_nationkey-5 = r_regionkey or n_nationkey-10=r_regionkey + 10;"
+ qt_order_multiDataSink "select * FROM nation left outer join region on
n_nationkey-5 = r_regionkey or n_nationkey-10=r_regionkey + 10;"
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
