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 af1dcbe17ce [cherry-pick](branch-21) fix unstable test case (#48141)
(#48274)
af1dcbe17ce is described below
commit af1dcbe17ce715bf66b6b9953f844d884cf62ebd
Author: zhangstar333 <[email protected]>
AuthorDate: Tue Feb 25 19:06:55 2025 +0800
[cherry-pick](branch-21) fix unstable test case (#48141) (#48274)
---
.../window_functions/test_window_function.out | Bin 11741 -> 11741 bytes
.../window_functions/test_window_function.out | Bin 11741 -> 11741 bytes
.../window_functions/test_window_function.groovy | 8 ++++----
.../window_functions/test_window_function.groovy | 8 ++++----
4 files changed, 8 insertions(+), 8 deletions(-)
diff --git
a/regression-test/data/nereids_p0/sql_functions/window_functions/test_window_function.out
b/regression-test/data/nereids_p0/sql_functions/window_functions/test_window_function.out
index c68c93691d3..18a210f579b 100644
Binary files
a/regression-test/data/nereids_p0/sql_functions/window_functions/test_window_function.out
and
b/regression-test/data/nereids_p0/sql_functions/window_functions/test_window_function.out
differ
diff --git
a/regression-test/data/query_p0/sql_functions/window_functions/test_window_function.out
b/regression-test/data/query_p0/sql_functions/window_functions/test_window_function.out
index c68c93691d3..18a210f579b 100644
Binary files
a/regression-test/data/query_p0/sql_functions/window_functions/test_window_function.out
and
b/regression-test/data/query_p0/sql_functions/window_functions/test_window_function.out
differ
diff --git
a/regression-test/suites/nereids_p0/sql_functions/window_functions/test_window_function.groovy
b/regression-test/suites/nereids_p0/sql_functions/window_functions/test_window_function.groovy
index 946f671bb06..9ab4614b4da 100644
---
a/regression-test/suites/nereids_p0/sql_functions/window_functions/test_window_function.groovy
+++
b/regression-test/suites/nereids_p0/sql_functions/window_functions/test_window_function.groovy
@@ -366,23 +366,23 @@ suite("test_window_function") {
rows between unbounded preceding and current row)
as wj from baseall order by ${k1}, wj"""
- qt_lag_1 "select /*+SET_VAR(parallel_pipeline_task_num=1) */ ${k1},${k2},
lag(${k2}) over (partition by ${k1} order by ${k3},${k2}) from baseall order by
1,2;"
+ qt_lag_1 "select /*+SET_VAR(parallel_pipeline_task_num=1) */ ${k1},${k2},
lag(${k2}) over (partition by ${k1} order by ${k3},${k2}) from baseall order by
1,2,3;"
test {
sql"select /*+SET_VAR(parallel_fragment_exec_instance_num=1) */ ${k1},
lag(${k2}, -1, 1) over (partition by ${k1} order by ${k3}) from baseall"
exception ""
}
- qt_lag_2 "select /*+SET_VAR(parallel_pipeline_task_num=1) */ ${k1}, ${k2},
lag(${k2}, 1) over (partition by ${k1} order by ${k3},${k2}) from baseall order
by 1,2;"
+ qt_lag_2 "select /*+SET_VAR(parallel_pipeline_task_num=1) */ ${k1}, ${k2},
lag(${k2}, 1) over (partition by ${k1} order by ${k3},${k2}) from baseall order
by 1,2,3;"
- qt_lead_1 "select /*+SET_VAR(parallel_pipeline_task_num=1) */ ${k1},
${k2}, lead(${k2}) over (partition by ${k1} order by ${k3},${k2}) from baseall
order by 1,2;"
+ qt_lead_1 "select /*+SET_VAR(parallel_pipeline_task_num=1) */ ${k1},
${k2}, lead(${k2}) over (partition by ${k1} order by ${k3},${k2}) from baseall
order by 1,2,3;"
test {
sql"select /*+SET_VAR(parallel_fragment_exec_instance_num=1) */ ${k1},
lead(${k2}, -1, 1) over (partition by ${k1} order by ${k3}) from baseall"
exception ""
}
- qt_lead_2 "select /*+SET_VAR(parallel_pipeline_task_num=1) */ ${k1},
${k2}, lead(${k2}, 1) over (partition by ${k1} order by ${k3},${k2}) from
baseall order by 1,2;"
+ qt_lead_2 "select /*+SET_VAR(parallel_pipeline_task_num=1) */ ${k1},
${k2}, lead(${k2}, 1) over (partition by ${k1} order by ${k3},${k2}) from
baseall order by 1,2,3;"
qt_window_error1"""select /*+SET_VAR(parallel_pipeline_task_num=1) */
${k1}, first_value(${k2}) over (partition by ${k1}) from baseall order by
${k1}"""
qt_window_error2"""select /*+SET_VAR(parallel_pipeline_task_num=1) */
${k1}, first_value(${k2}) over (order by ${k3}) from baseall"""
diff --git
a/regression-test/suites/query_p0/sql_functions/window_functions/test_window_function.groovy
b/regression-test/suites/query_p0/sql_functions/window_functions/test_window_function.groovy
index b20776ad6c5..045c457ea5a 100644
---
a/regression-test/suites/query_p0/sql_functions/window_functions/test_window_function.groovy
+++
b/regression-test/suites/query_p0/sql_functions/window_functions/test_window_function.groovy
@@ -364,24 +364,24 @@ suite("test_window_function") {
rows between unbounded preceding and current row)
as wj from baseall order by ${k1}, wj"""
- qt_lag_1 "select /*+SET_VAR(parallel_pipeline_task_num=1) */ ${k1}, ${k2},
lag(${k2}) over (partition by ${k1} order by ${k3},${k2}) from baseall order by
1,2;"
+ qt_lag_1 "select /*+SET_VAR(parallel_pipeline_task_num=1) */ ${k1}, ${k2},
lag(${k2}) over (partition by ${k1} order by ${k3},${k2}) from baseall order by
1,2,3;"
test {
sql"select /*+SET_VAR(parallel_fragment_exec_instance_num=1) */ ${k1},
lag(${k2}, -1, 1) over (partition by ${k1} order by ${k3}) from baseall"
exception ""
}
- qt_lag_2 "select /*+SET_VAR(parallel_pipeline_task_num=1) */ ${k1},
${k2},lag(${k2}, 1) over (partition by ${k1} order by ${k3}, ${k2}) from
baseall order by 1,2;"
+ qt_lag_2 "select /*+SET_VAR(parallel_pipeline_task_num=1) */ ${k1},
${k2},lag(${k2}, 1) over (partition by ${k1} order by ${k3}, ${k2}) from
baseall order by 1,2,3;"
- qt_lead_1 "select /*+SET_VAR(parallel_pipeline_task_num=1) */ ${k1},
${k2}, lead(${k2}) over (partition by ${k1} order by ${k3}, ${k2}) from baseall
order by 1,2;"
+ qt_lead_1 "select /*+SET_VAR(parallel_pipeline_task_num=1) */ ${k1},
${k2}, lead(${k2}) over (partition by ${k1} order by ${k3}, ${k2}) from baseall
order by 1,2,3;"
test {
sql"select /*+SET_VAR(parallel_fragment_exec_instance_num=1) */ ${k1},
lead(${k2}, -1, 1) over (partition by ${k1} order by ${k3}) from baseall"
exception ""
}
- qt_lead_2 "select /*+SET_VAR(parallel_pipeline_task_num=1) */ ${k1},
${k2}, lead(${k2}, 1) over (partition by ${k1} order by ${k3},${k2}) from
baseall order by 1,2;"
+ qt_lead_2 "select /*+SET_VAR(parallel_pipeline_task_num=1) */ ${k1},
${k2}, lead(${k2}, 1) over (partition by ${k1} order by ${k3},${k2}) from
baseall order by 1,2,3;"
qt_window_error1"""select /*+SET_VAR(parallel_pipeline_task_num=1) */
${k1}, first_value(${k2}) over (partition by ${k1}) from baseall order by
${k1}"""
qt_window_error2"""select /*+SET_VAR(parallel_pipeline_task_num=1) */
${k1}, first_value(${k2}) over (order by ${k3}) from baseall"""
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
