This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch branch-2.0-alpha
in repository https://gitbox.apache.org/repos/asf/doris.git
commit 19887c7586244fb6adb4b0a39ae17fe1145e1756
Author: Mingyu Chen <morning...@163.com>
AuthorDate: Fri Apr 21 11:24:20 2023 +0800
Author: Mingyu Chen <morning...@163.com>
Date: Fri Apr 21 11:24:20 2023 +0800
[improvement](test) remove set global (#18807)
---
.../suites/correctness/test_set_session_default_val.groovy | 4 ++--
regression-test/suites/datev2/ssb_sf0.1_p1/load.groovy | 2 +-
regression-test/suites/datev2/ssb_sf1_p2/load.groovy | 2 +-
regression-test/suites/datev2/tpcds_sf1_p1/load.groovy | 4 ++--
regression-test/suites/ssb_sf0.1_p1/load.groovy | 2 +-
regression-test/suites/ssb_sf100_p2/load.groovy | 2 +-
regression-test/suites/ssb_sf1_p2/load.groovy | 2 +-
regression-test/suites/tpcds_sf100_p2/load.groovy | 2 +-
regression-test/suites/tpcds_sf1_p1/load.groovy | 4 ++--
regression-test/suites/tpcds_sf1_unique_p1/load.groovy | 2 +-
10 files changed, 13 insertions(+), 13 deletions(-)
diff --git
a/regression-test/suites/correctness/test_set_session_default_val.groovy
b/regression-test/suites/correctness/test_set_session_default_val.groovy
index b39cd7f1c4..26a2aec639 100644
--- a/regression-test/suites/correctness/test_set_session_default_val.groovy
+++ b/regression-test/suites/correctness/test_set_session_default_val.groovy
@@ -17,8 +17,8 @@
suite("test_set_session_default_val") {
def default_timeout = sql """show variables where variable_name =
'insert_timeout';"""
- sql """set global insert_timeout=3000;"""
+ sql """set insert_timeout=3000;"""
sql """set session insert_timeout=${default_timeout[0][1]};"""
def session_timeout = sql """show variables where variable_name =
'insert_timeout';"""
assertEquals(default_timeout, session_timeout)
-}
\ No newline at end of file
+}
diff --git a/regression-test/suites/datev2/ssb_sf0.1_p1/load.groovy
b/regression-test/suites/datev2/ssb_sf0.1_p1/load.groovy
index 6ed3a68b91..e047c25614 100644
--- a/regression-test/suites/datev2/ssb_sf0.1_p1/load.groovy
+++ b/regression-test/suites/datev2/ssb_sf0.1_p1/load.groovy
@@ -88,7 +88,7 @@ suite("load") {
def rowCount = sql "select count(*) from ${table}"
if (rowCount[0][0] != table_rows) {
sql new File("""${context.file.parent}/ddl/${table}_delete.sql""").text
- sql "set global insert_timeout=3600"
+ sql "set insert_timeout=3600"
def r = sql "select @@insert_timeout"
assertEquals(3600, r[0][0])
year_cons = [
diff --git a/regression-test/suites/datev2/ssb_sf1_p2/load.groovy
b/regression-test/suites/datev2/ssb_sf1_p2/load.groovy
index 5006e1a384..59d909b22d 100644
--- a/regression-test/suites/datev2/ssb_sf1_p2/load.groovy
+++ b/regression-test/suites/datev2/ssb_sf1_p2/load.groovy
@@ -88,7 +88,7 @@ suite("load") {
def rowCount = sql "select count(*) from ${table}"
if (rowCount[0][0] != table_rows) {
sql new File("""${context.file.parent}/ddl/${table}_delete.sql""").text
- sql "set global insert_timeout=3600"
+ sql "set insert_timeout=3600"
def r = sql "select @@insert_timeout"
assertEquals(3600, r[0][0])
year_cons = [
diff --git a/regression-test/suites/datev2/tpcds_sf1_p1/load.groovy
b/regression-test/suites/datev2/tpcds_sf1_p1/load.groovy
index 78927b93f1..d370954f73 100644
--- a/regression-test/suites/datev2/tpcds_sf1_p1/load.groovy
+++ b/regression-test/suites/datev2/tpcds_sf1_p1/load.groovy
@@ -55,7 +55,7 @@ suite("load") {
sql new File("""${context.file.parent}/ddl/${table}.sql""").text
}
- sql "set global exec_mem_limit=8G;"
+ sql "set exec_mem_limit=8G;"
for (String tableName in tables) {
streamLoad {
@@ -98,4 +98,4 @@ suite("load") {
}
}
}
-}
\ No newline at end of file
+}
diff --git a/regression-test/suites/ssb_sf0.1_p1/load.groovy
b/regression-test/suites/ssb_sf0.1_p1/load.groovy
index 9057b857f4..5151bff68e 100644
--- a/regression-test/suites/ssb_sf0.1_p1/load.groovy
+++ b/regression-test/suites/ssb_sf0.1_p1/load.groovy
@@ -87,7 +87,7 @@ suite("load") {
def rowCount = sql "select count(*) from ${table}"
if (rowCount[0][0] != table_rows) {
sql new File("""${context.file.parent}/ddl/${table}_delete.sql""").text
- sql "set global insert_timeout=3600"
+ sql "set insert_timeout=3600"
def r = sql "select @@insert_timeout"
year_cons = [
'lo_orderdate<19930101',
diff --git a/regression-test/suites/ssb_sf100_p2/load.groovy
b/regression-test/suites/ssb_sf100_p2/load.groovy
index bcf423f7d4..7d9461cbd5 100644
--- a/regression-test/suites/ssb_sf100_p2/load.groovy
+++ b/regression-test/suites/ssb_sf100_p2/load.groovy
@@ -77,7 +77,7 @@ suite('load') {
def rowCount = sql "select count(*) from ${table}"
if (rowCount[0][0] != table_rows) {
sql new File("""${context.file.parent}/ddl/${table}_delete.sql""").text
- sql "set global insert_timeout=3600"
+ sql "set insert_timeout=3600"
sql "sync"
def r = sql "select @@insert_timeout"
assertEquals(3600, r[0][0])
diff --git a/regression-test/suites/ssb_sf1_p2/load.groovy
b/regression-test/suites/ssb_sf1_p2/load.groovy
index ee0163b641..383844e120 100644
--- a/regression-test/suites/ssb_sf1_p2/load.groovy
+++ b/regression-test/suites/ssb_sf1_p2/load.groovy
@@ -89,7 +89,7 @@ suite("load") {
def rowCount = sql "select count(*) from ${table}"
if (rowCount[0][0] != table_rows) {
sql new File("""${context.file.parent}/ddl/${table}_delete.sql""").text
- sql "set global insert_timeout=3600"
+ sql "set insert_timeout=3600"
def r = sql "select @@insert_timeout"
assertEquals(3600, r[0][0])
year_cons = [
diff --git a/regression-test/suites/tpcds_sf100_p2/load.groovy
b/regression-test/suites/tpcds_sf100_p2/load.groovy
index 24460ecd74..ccc22a1273 100644
--- a/regression-test/suites/tpcds_sf100_p2/load.groovy
+++ b/regression-test/suites/tpcds_sf100_p2/load.groovy
@@ -40,7 +40,7 @@ suite('load') {
// set fe configuration
sql "ADMIN SET FRONTEND CONFIG ('max_bytes_per_broker_scanner' =
'161061273600')"
- sql "set global exec_mem_limit=16G;"
+ sql "set exec_mem_limit=16G;"
def uniqueID = Math.abs(UUID.randomUUID().hashCode()).toString()
tables.each { table, rows ->
diff --git a/regression-test/suites/tpcds_sf1_p1/load.groovy
b/regression-test/suites/tpcds_sf1_p1/load.groovy
index d1713217af..1b527dcc81 100644
--- a/regression-test/suites/tpcds_sf1_p1/load.groovy
+++ b/regression-test/suites/tpcds_sf1_p1/load.groovy
@@ -55,7 +55,7 @@ suite("load") {
sql new File("""${context.file.parent}/ddl/${table}.sql""").text
}
- sql "set global exec_mem_limit=8G;"
+ sql "set exec_mem_limit=8G;"
for (String tableName in tables) {
streamLoad {
@@ -99,4 +99,4 @@ suite("load") {
}
}
}
-}
\ No newline at end of file
+}
diff --git a/regression-test/suites/tpcds_sf1_unique_p1/load.groovy
b/regression-test/suites/tpcds_sf1_unique_p1/load.groovy
index c06e1ea61a..b48d538fa3 100644
--- a/regression-test/suites/tpcds_sf1_unique_p1/load.groovy
+++ b/regression-test/suites/tpcds_sf1_unique_p1/load.groovy
@@ -94,7 +94,7 @@ suite("load") {
sql new File("""${context.file.parent}/ddl/${table}.sql""").text
}
- sql "set global exec_mem_limit=8G;"
+ sql "set exec_mem_limit=8G;"
for (String tableName in tables) {
streamLoad {
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
