This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new ab8cfbbfb6 [bugfix](regression-test) add some window function test
(#19460)
ab8cfbbfb6 is described below
commit ab8cfbbfb630b98f91fb629511ce6189085123b0
Author: yiguolei <[email protected]>
AuthorDate: Wed May 10 12:06:02 2023 +0800
[bugfix](regression-test) add some window function test (#19460)
Only 2000 union will cause BE use a lot of memory, so that I enable other
test in this PR only disable 2000 union case.
---------
Co-authored-by: yiguolei <[email protected]>
---
fe/fe-core/src/main/java/org/apache/doris/qe/SessionVariable.java | 3 ++-
regression-test/pipeline/p0/conf/regression-conf.groovy | 2 +-
.../sql_functions/window_functions/test_window_function.groovy | 8 ++++----
3 files changed, 7 insertions(+), 6 deletions(-)
diff --git a/fe/fe-core/src/main/java/org/apache/doris/qe/SessionVariable.java
b/fe/fe-core/src/main/java/org/apache/doris/qe/SessionVariable.java
index 731635b5c8..9e55696c85 100644
--- a/fe/fe-core/src/main/java/org/apache/doris/qe/SessionVariable.java
+++ b/fe/fe-core/src/main/java/org/apache/doris/qe/SessionVariable.java
@@ -636,7 +636,8 @@ public class SessionVariable implements Serializable,
Writable {
* the new optimizer is fully developed. I hope that day
* would be coming soon.
*/
- @VariableMgr.VarAttr(name = ENABLE_NEREIDS_PLANNER, needForward = true,
expType = ExperimentalType.EXPERIMENTAL)
+ @VariableMgr.VarAttr(name = ENABLE_NEREIDS_PLANNER, needForward = true,
+ fuzzy = true, expType = ExperimentalType.EXPERIMENTAL)
private boolean enableNereidsPlanner = false;
@VariableMgr.VarAttr(name = DISABLE_NEREIDS_RULES, needForward = true)
diff --git a/regression-test/pipeline/p0/conf/regression-conf.groovy
b/regression-test/pipeline/p0/conf/regression-conf.groovy
index 4fdf7d77bc..33e2bc8ff5 100644
--- a/regression-test/pipeline/p0/conf/regression-conf.groovy
+++ b/regression-test/pipeline/p0/conf/regression-conf.groovy
@@ -48,7 +48,7 @@ testDirectories = ""
// this groups will not be executed
excludeGroups = ""
// this suites will not be executed
-excludeSuites = "test_broker_load,test_window_function"
+excludeSuites = "test_broker_load"
// this directories will not be executed
excludeDirectories = ""
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 c6e503816c..0748ebb833 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
@@ -492,10 +492,10 @@ suite("test_window_function") {
sql """ admin set frontend
config("remote_fragment_exec_timeout_ms"="300000"); """
- qt_window_hang2"""select /*+SET_VAR(parallel_fragment_exec_instance_num=1)
*/ A.${k1}, A.wj - B.dyk + 1 as num from
- (select ${k1}, wj from ${line} as W1) as A join
- (select ${k1}, min(wj) as dyk from ${line} as W2 group by ${k1}) as B
- where A.${k1}=B.${k1} order by A.${k1}, num"""
+ //qt_window_hang2"""select
/*+SET_VAR(parallel_fragment_exec_instance_num=1) */ A.${k1}, A.wj - B.dyk + 1
as num from
+ // (select ${k1}, wj from ${line} as W1) as A join
+ // (select ${k1}, min(wj) as dyk from ${line} as W2 group by ${k1}) as B
+ // where A.${k1}=B.${k1} order by A.${k1}, num"""
//test_hujie
line = "("
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
