This is an automated email from the ASF dual-hosted git repository.
starocean999 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 6fa788735c6 [bug](regression-test)fix regression test fail (#39935)
6fa788735c6 is described below
commit 6fa788735c6e239a9afbd20256c3aae0fb30d5f8
Author: Xujian Duan <[email protected]>
AuthorDate: Tue Aug 27 09:42:30 2024 +0800
[bug](regression-test)fix regression test fail (#39935)
## Proposed changes
After pr #37985, explain will not be rewritten for querying random
distributed table, so remove explain action in regression test case.
<!--Describe your changes.-->
---
.../aggregate/select_random_distributed_tbl.groovy | 24 ----------------------
1 file changed, 24 deletions(-)
diff --git
a/regression-test/suites/query_p0/aggregate/select_random_distributed_tbl.groovy
b/regression-test/suites/query_p0/aggregate/select_random_distributed_tbl.groovy
index e1edd7dad99..c818454c261 100644
---
a/regression-test/suites/query_p0/aggregate/select_random_distributed_tbl.groovy
+++
b/regression-test/suites/query_p0/aggregate/select_random_distributed_tbl.groovy
@@ -67,31 +67,15 @@ suite("select_random_distributed_tbl") {
}
def sql1 = "select * except (v_generic) from ${tableName}
${whereStr} order by k1, k2"
qt_sql_1 "${sql1}"
- explain {
- sql("${sql1}")
- contains "VAGGREGATE"
- }
def sql2 = "select k1 ,k2 ,v_sum ,v_max ,v_min ,v_hll ,v_bitmap
,v_quantile_union from ${tableName} ${whereStr} order by k1, k2"
qt_sql_2 "${sql2}"
- explain {
- sql("${sql2}")
- contains "VAGGREGATE"
- }
def sql3 = "select k1+1, k2, v_sum from ${tableName} ${whereStr}
order by k1, k2"
qt_sql_3 "${sql3}"
- explain {
- sql("${sql3}")
- contains "VAGGREGATE"
- }
def sql4 = "select k1, k2, v_sum+1 from ${tableName} ${whereStr}
order by k1, k2"
qt_sql_4 "${sql4}"
- explain {
- sql("${sql4}")
- contains "VAGGREGATE"
- }
def sql5 = """ select k1, sum(v_sum), max(v_max), min(v_min),
avg_merge(v_generic),
hll_union_agg(v_hll), bitmap_union_count(v_bitmap),
quantile_percent(quantile_union(v_quantile_union),0.5)
@@ -106,17 +90,9 @@ suite("select_random_distributed_tbl") {
def sql8 = "select max(k1) from ${tableName} ${whereStr}"
qt_sql_8 "${sql8}"
- explain {
- sql("${sql8}")
- contains "VAGGREGATE"
- }
def sql9 = "select max(v_sum) from ${tableName} ${whereStr}"
qt_sql_9 "${sql9}"
- explain {
- sql("${sql9}")
- contains "VAGGREGATE"
- }
def sql10 = "select sum(v_max) from ${tableName} ${whereStr}"
qt_sql_10 "${sql10}"
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]