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 d542248e1b5 [regression-test]( fix case ) fix case that using same
table in one db with another case (#32380)
d542248e1b5 is described below
commit d542248e1b5b04a9ff32f586acbb4c1ff9e3fdd7
Author: shuke <[email protected]>
AuthorDate: Mon Mar 18 16:40:27 2024 +0800
[regression-test]( fix case ) fix case that using same table in one db
with another case (#32380)
---
.../grouping_sets/remove_duplicate_expr_in_grouping_set.groovy | 10 +++++-----
1 file changed, 5 insertions(+), 5 deletions(-)
diff --git
a/regression-test/suites/nereids_rules_p0/grouping_sets/remove_duplicate_expr_in_grouping_set.groovy
b/regression-test/suites/nereids_rules_p0/grouping_sets/remove_duplicate_expr_in_grouping_set.groovy
index b9a10fe21d2..eebdc678eb6 100644
---
a/regression-test/suites/nereids_rules_p0/grouping_sets/remove_duplicate_expr_in_grouping_set.groovy
+++
b/regression-test/suites/nereids_rules_p0/grouping_sets/remove_duplicate_expr_in_grouping_set.groovy
@@ -18,20 +18,20 @@ suite("remove_duplicate_expr_in_grouping_set") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql """
- DROP TABLE IF EXISTS mal_test1
+ DROP TABLE IF EXISTS mal_test33
"""
sql """
- create table mal_test1(pk int, a int, b int) distributed by hash(pk)
buckets 10
+ create table mal_test33(pk int, a int, b int) distributed by hash(pk)
buckets 10
properties('replication_num' = '1');
"""
sql """
- insert into mal_test1
values(2,1,3),(1,1,2),(3,5,6),(6,null,6),(4,5,6),(2,1,4),(2,3,5),(1,1,4)
+ insert into mal_test33
values(2,1,3),(1,1,2),(3,5,6),(6,null,6),(4,5,6),(2,1,4),(2,3,5),(1,1,4)
,(3,5,6),(3,5,null),(6,7,1),(2,1,7),(2,4,2),(2,3,9),(1,3,6),(3,5,8),(3,2,8);
"""
sql "sync"
- qt_test_col "select a, sum(b) from mal_test1 group by grouping sets((a,a))
order by 1,2"
- qt_test_expr "select a+1,sum(b) from mal_test1 group by grouping
sets((a+1,a+1)) order by 1,2"
+ qt_test_col "select a, sum(b) from mal_test33 group by grouping
sets((a,a)) order by 1,2"
+ qt_test_expr "select a+1,sum(b) from mal_test33 group by grouping
sets((a+1,a+1)) order by 1,2"
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
