This is an automated email from the ASF dual-hosted git repository.
morrysnow pushed a commit to branch branch-3.1
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-3.1 by this push:
new 1189dd3f470 [fix](test) fix regression
eliminate_group_by_key_by_uniform and eliminate_order_by_key (#53867)
1189dd3f470 is described below
commit 1189dd3f470c8aa76dc7cd39d18c7951bde78d34
Author: feiniaofeiafei <[email protected]>
AuthorDate: Fri Jul 25 14:10:48 2025 +0800
[fix](test) fix regression eliminate_group_by_key_by_uniform and
eliminate_order_by_key (#53867)
---
.../eliminate_group_by_key_by_uniform.out | Bin 4819 -> 4414 bytes
.../eliminate_order_by_key/eliminate_order_by_key.out | Bin 6764 -> 6771 bytes
.../eliminate_group_by_key_by_uniform.groovy | 3 ++-
.../eliminate_order_by_key.groovy | 1 +
4 files changed, 3 insertions(+), 1 deletion(-)
diff --git
a/regression-test/data/nereids_rules_p0/eliminate_gby_key/eliminate_group_by_key_by_uniform.out
b/regression-test/data/nereids_rules_p0/eliminate_gby_key/eliminate_group_by_key_by_uniform.out
index 14be541c3d5..a1b5b40c98f 100644
Binary files
a/regression-test/data/nereids_rules_p0/eliminate_gby_key/eliminate_group_by_key_by_uniform.out
and
b/regression-test/data/nereids_rules_p0/eliminate_gby_key/eliminate_group_by_key_by_uniform.out
differ
diff --git
a/regression-test/data/nereids_rules_p0/eliminate_order_by_key/eliminate_order_by_key.out
b/regression-test/data/nereids_rules_p0/eliminate_order_by_key/eliminate_order_by_key.out
index 5ba1fcce552..43959f7af10 100644
Binary files
a/regression-test/data/nereids_rules_p0/eliminate_order_by_key/eliminate_order_by_key.out
and
b/regression-test/data/nereids_rules_p0/eliminate_order_by_key/eliminate_order_by_key.out
differ
diff --git
a/regression-test/suites/nereids_rules_p0/eliminate_gby_key/eliminate_group_by_key_by_uniform.groovy
b/regression-test/suites/nereids_rules_p0/eliminate_gby_key/eliminate_group_by_key_by_uniform.groovy
index 1d4bedc0a5c..b7e2dccaa77 100644
---
a/regression-test/suites/nereids_rules_p0/eliminate_gby_key/eliminate_group_by_key_by_uniform.groovy
+++
b/regression-test/suites/nereids_rules_p0/eliminate_gby_key/eliminate_group_by_key_by_uniform.groovy
@@ -17,6 +17,7 @@
suite("eliminate_group_by_key_by_uniform") {
sql "set enable_nereids_rules = 'ELIMINATE_GROUP_BY_KEY_BY_UNIFORM'"
sql "set runtime_filter_mode=OFF"
+ sql "SET ignore_shape_nodes='PhysicalDistribute,PhysicalProject'"
sql "drop table if exists eli_gbk_by_uniform_t"
sql """create table eli_gbk_by_uniform_t(a int null, b int not null, c
varchar(10) null, d date, dt datetime)
distributed by hash(a) properties("replication_num"="1");
@@ -233,7 +234,7 @@ suite("eliminate_group_by_key_by_uniform") {
qt_to_limit_multi_group_by "select 1 as c1,a from eli_gbk_by_uniform_t
where a=1 group by c1,a"
qt_to_limit_multi_group_by_one_col_in_project "select 2 as c1 from
eli_gbk_by_uniform_t where a=1 group by c1,a"
- qt_to_limit_join_project_shape "explain shape plan select 1 as c1 from
test1 t1 inner join (select * from test2 where b=105) t2 on t1.a=t2.a group by
c1 order by 1;"
+ qt_to_limit_join_project_shape "explain shape plan select 1 as c1 from
test1 t1 inner join (select * from test2 where b=105) t2 on t1.a=t2.a group by
c1;"
qt_to_limit_project_uniform_shape "explain shape plan select 1 as c1 from
eli_gbk_by_uniform_t group by c1"
qt_to_limit_multi_group_by_shape "explain shape plan select 2 as c1 from
eli_gbk_by_uniform_t where a=1 group by c1,a"
}
\ No newline at end of file
diff --git
a/regression-test/suites/nereids_rules_p0/eliminate_order_by_key/eliminate_order_by_key.groovy
b/regression-test/suites/nereids_rules_p0/eliminate_order_by_key/eliminate_order_by_key.groovy
index 15a9ad86f8c..69a10b90524 100644
---
a/regression-test/suites/nereids_rules_p0/eliminate_order_by_key/eliminate_order_by_key.groovy
+++
b/regression-test/suites/nereids_rules_p0/eliminate_order_by_key/eliminate_order_by_key.groovy
@@ -186,6 +186,7 @@ suite("eliminate_order_by_key") {
"""
// test composite key
+ sql "drop table if exists test_unique_order_by2"
sql """create table test_unique_order_by2(a int not null, b int not null,
c int, d int) unique key(a,b) distributed by hash(a)
properties('replication_num'='1');"""
sql """INSERT INTO test_unique_order_by2 (a, b, c, d)
VALUES(1, 2, 3, 4),(2, 3, 3, 5),(3, 4, 5, 6),(4, 5, 6, 7),(5, 6, 7, 8),(6,
7, 8, 9),(7, 8, 9, 10),(8, 9, 10, 11),(9, 10, 11, 12),(10, 11, 12, 13);"""
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
