This is an automated email from the ASF dual-hosted git repository.
gabriellee 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 c1cce29b20 [chore](regression) modify duplicate table name for
regression cases (#13527)
c1cce29b20 is described below
commit c1cce29b204485cc99f463c73d15d8a974d416f5
Author: Gabriel <gabrielleeb...@gmail.com>
AuthorDate: Fri Oct 21 21:37:13 2022 +0800
[chore](regression) modify duplicate table name for regression cases
(#13527)
---
.../suites/nereids_syntax_p0/agg_with_const.groovy | 12 +++++-----
.../suites/nereids_syntax_p0/having.groovy | 28 +++++++++++-----------
2 files changed, 20 insertions(+), 20 deletions(-)
diff --git a/regression-test/suites/nereids_syntax_p0/agg_with_const.groovy
b/regression-test/suites/nereids_syntax_p0/agg_with_const.groovy
index 91199569f2..c77e1e6542 100644
--- a/regression-test/suites/nereids_syntax_p0/agg_with_const.groovy
+++ b/regression-test/suites/nereids_syntax_p0/agg_with_const.groovy
@@ -21,10 +21,10 @@ suite("agg_with_const") {
sql "SET enable_nereids_planner=true"
sql """
- DROP TABLE IF EXISTS t1
+ DROP TABLE IF EXISTS agg_with_const_tbl
"""
- sql """CREATE TABLE t1 (col1 int not null, col2 int not null, col3 int not
null)
+ sql """CREATE TABLE agg_with_const_tbl (col1 int not null, col2 int not
null, col3 int not null)
DISTRIBUTED BY HASH(col3)
BUCKETS 1
PROPERTIES(
@@ -33,21 +33,21 @@ suite("agg_with_const") {
"""
sql """
- insert into t1 values(1994, 1994, 1995)
+ insert into agg_with_const_tbl values(1994, 1994, 1995)
"""
sql "SET enable_fallback_to_original_planner=false"
qt_select """
- select count(2) + 1, sum(2) + sum(col1) from t1
+ select count(2) + 1, sum(2) + sum(col1) from agg_with_const_tbl
"""
qt_select """
- select count(*) from t1
+ select count(*) from agg_with_const_tbl
"""
qt_select """
- select count(2) + 1, sum(2) + sum(2) from t1
+ select count(2) + 1, sum(2) + sum(2) from agg_with_const_tbl
"""
}
diff --git a/regression-test/suites/nereids_syntax_p0/having.groovy
b/regression-test/suites/nereids_syntax_p0/having.groovy
index 6b0c00a759..1749cb3431 100644
--- a/regression-test/suites/nereids_syntax_p0/having.groovy
+++ b/regression-test/suites/nereids_syntax_p0/having.groovy
@@ -20,10 +20,10 @@ suite("test_nereids_having") {
sql "SET enable_nereids_planner=true"
sql "SET enable_vectorized_engine=true"
- sql "DROP TABLE IF EXISTS t1"
+ sql "DROP TABLE IF EXISTS test_nereids_having_tbl"
sql """
- CREATE TABLE t1 (
+ CREATE TABLE test_nereids_having_tbl (
pk INT,
a1 INT,
a2 INT
@@ -32,7 +32,7 @@ suite("test_nereids_having") {
"""
sql """
- INSERT INTO t1 VALUES
+ INSERT INTO test_nereids_having_tbl VALUES
(1, 1, 1),
(1, 1, 2),
(1, 1, 3),
@@ -46,15 +46,15 @@ suite("test_nereids_having") {
sql "SET enable_fallback_to_original_planner=false"
- order_qt_select "SELECT a1 as value FROM t1 GROUP BY a1 HAVING a1 > 0";
- order_qt_select "SELECT a1 as value FROM t1 GROUP BY a1 HAVING value > 0";
- order_qt_select "SELECT SUM(a2) FROM t1 GROUP BY a1 HAVING a1 > 0";
- order_qt_select "SELECT a1 FROM t1 GROUP BY a1 HAVING SUM(a2) > 0";
- order_qt_select "SELECT a1, SUM(a2) FROM t1 GROUP BY a1 HAVING SUM(a2) >
0";
- order_qt_select "SELECT a1, SUM(a2) as value FROM t1 GROUP BY a1 HAVING
SUM(a2) > 0";
- order_qt_select "SELECT a1, SUM(a2) as value FROM t1 GROUP BY a1 HAVING
value > 0";
- order_qt_select "SELECT a1, SUM(a2) FROM t1 GROUP BY a1 HAVING MIN(pk) >
0";
- order_qt_select "SELECT a1, SUM(a1 + a2) FROM t1 GROUP BY a1 HAVING SUM(a1
+ a2) > 0";
- order_qt_select "SELECT a1, SUM(a1 + a2) FROM t1 GROUP BY a1 HAVING SUM(a1
+ a2 + 3) > 0";
- order_qt_select "SELECT a1 FROM t1 GROUP BY a1 HAVING COUNT(*) > 0";
+ order_qt_select "SELECT a1 as value FROM test_nereids_having_tbl GROUP BY
a1 HAVING a1 > 0";
+ order_qt_select "SELECT a1 as value FROM test_nereids_having_tbl GROUP BY
a1 HAVING value > 0";
+ order_qt_select "SELECT SUM(a2) FROM test_nereids_having_tbl GROUP BY a1
HAVING a1 > 0";
+ order_qt_select "SELECT a1 FROM test_nereids_having_tbl GROUP BY a1 HAVING
SUM(a2) > 0";
+ order_qt_select "SELECT a1, SUM(a2) FROM test_nereids_having_tbl GROUP BY
a1 HAVING SUM(a2) > 0";
+ order_qt_select "SELECT a1, SUM(a2) as value FROM test_nereids_having_tbl
GROUP BY a1 HAVING SUM(a2) > 0";
+ order_qt_select "SELECT a1, SUM(a2) as value FROM test_nereids_having_tbl
GROUP BY a1 HAVING value > 0";
+ order_qt_select "SELECT a1, SUM(a2) FROM test_nereids_having_tbl GROUP BY
a1 HAVING MIN(pk) > 0";
+ order_qt_select "SELECT a1, SUM(a1 + a2) FROM test_nereids_having_tbl
GROUP BY a1 HAVING SUM(a1 + a2) > 0";
+ order_qt_select "SELECT a1, SUM(a1 + a2) FROM test_nereids_having_tbl
GROUP BY a1 HAVING SUM(a1 + a2 + 3) > 0";
+ order_qt_select "SELECT a1 FROM test_nereids_having_tbl GROUP BY a1 HAVING
COUNT(*) > 0";
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
