This is an automated email from the ASF dual-hosted git repository.
englefly 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 f1b8e501d37 [fix](test)delete unstable case
qt_agg_distinct_satisfy_dst_key_with_other_func_low_ndv in agg_strategy (#64022)
f1b8e501d37 is described below
commit f1b8e501d375940c40a9598385c39713a1d26f92
Author: feiniaofeiafei <[email protected]>
AuthorDate: Wed Jun 3 10:54:20 2026 +0800
[fix](test)delete unstable case
qt_agg_distinct_satisfy_dst_key_with_other_func_low_ndv in agg_strategy (#64022)
### What problem does this PR solve?
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
### Release note
None
### Check List (For Author)
- Test <!-- At least one of them must be included. -->
- [ ] Regression test
- [ ] Unit Test
- [ ] Manual test (add detailed scripts or steps below)
- [ ] No need to test or manual test. Explain why:
- [ ] This is a refactor/code format and no logic has been changed.
- [ ] Previous test can cover this change.
- [ ] No code files have been changed.
- [ ] Other reason <!-- Add your reason? -->
- Behavior changed:
- [ ] No.
- [ ] Yes. <!-- Explain the behavior change -->
- Does this need documentation?
- [ ] No.
- [ ] Yes. <!-- Add document PR link here. eg:
https://github.com/apache/doris-website/pull/1214 -->
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label <!-- Add branch pick label that this PR
should merge into -->
---
.../nereids_rules_p0/agg_strategy/agg_strategy.out | 22 ----------------------
.../agg_strategy/agg_strategy.groovy | 1 -
2 files changed, 23 deletions(-)
diff --git
a/regression-test/data/nereids_rules_p0/agg_strategy/agg_strategy.out
b/regression-test/data/nereids_rules_p0/agg_strategy/agg_strategy.out
index 919d26620e9..8115545a6e7 100644
--- a/regression-test/data/nereids_rules_p0/agg_strategy/agg_strategy.out
+++ b/regression-test/data/nereids_rules_p0/agg_strategy/agg_strategy.out
@@ -562,17 +562,6 @@ PhysicalResultSink
--------hashAgg[GLOBAL]
----------PhysicalOlapScan[t_gbykey_2_dstkey_10_30_id]
--- !agg_distinct_satisfy_dst_key_with_other_func_low_ndv --
-PhysicalResultSink
---PhysicalQuickSort[MERGE_SORT]
-----PhysicalDistribute[DistributionSpecGather]
-------PhysicalQuickSort[LOCAL_SORT]
---------hashAgg[DISTINCT_GLOBAL]
-----------PhysicalDistribute[DistributionSpecHash]
-------------hashAgg[DISTINCT_LOCAL]
---------------hashAgg[GLOBAL]
-----------------PhysicalOlapScan[t_gbykey_2_dstkey_10_30_id]
-
-- !agg_distinct_without_gby_key_low_ndv --
PhysicalResultSink
--hashAgg[DISTINCT_GLOBAL]
@@ -727,17 +716,6 @@ PhysicalResultSink
----------hashAgg[GLOBAL]
------------PhysicalOlapScan[t_gbykey_2_dstkey_10_30_id]
--- !agg_distinct_satisfy_dst_key_with_other_func_low_ndv --
-PhysicalResultSink
---PhysicalQuickSort[MERGE_SORT]
-----PhysicalDistribute[DistributionSpecGather]
-------PhysicalQuickSort[LOCAL_SORT]
---------hashAgg[DISTINCT_GLOBAL]
-----------PhysicalDistribute[DistributionSpecHash]
-------------hashAgg[DISTINCT_LOCAL]
---------------hashAgg[GLOBAL]
-----------------PhysicalOlapScan[t_gbykey_2_dstkey_10_30_id]
-
-- !agg_distinct_without_gby_key_low_ndv --
PhysicalResultSink
--hashAgg[DISTINCT_GLOBAL]
diff --git
a/regression-test/suites/nereids_rules_p0/agg_strategy/agg_strategy.groovy
b/regression-test/suites/nereids_rules_p0/agg_strategy/agg_strategy.groovy
index 85809510784..996fcac11fd 100644
--- a/regression-test/suites/nereids_rules_p0/agg_strategy/agg_strategy.groovy
+++ b/regression-test/suites/nereids_rules_p0/agg_strategy/agg_strategy.groovy
@@ -126,7 +126,6 @@ suite("agg_strategy") {
qt_agg_distinct_satisfy_dst_key_low_ndv "explain shape plan select
count(distinct id) from t_gbykey_2_dstkey_10_30_id group by gby_key order by 1"
qt_agg_distinct_with_gby_key_with_other_func_low_ndv "explain shape
plan select count(distinct dst_key1), gby_key, sum(dst_key2), avg(dst_key2)
from t_gbykey_2_dstkey_10_30_id group by gby_key order by 1,2,3,4"
qt_agg_distinct_satisfy_gby_key_with_other_func_low_ndv "explain shape
plan select count(distinct dst_key1), id, sum(dst_key2), avg(dst_key2) from
t_gbykey_2_dstkey_10_30_id group by id order by 1,2,3,4"
- qt_agg_distinct_satisfy_dst_key_with_other_func_low_ndv"explain shape
plan select count(distinct id), sum(dst_key2), avg(dst_key2) from
t_gbykey_2_dstkey_10_30_id group by gby_key order by 1,2,3"
qt_agg_distinct_without_gby_key_low_ndv "explain shape plan select
count(distinct dst_key1) from t_gbykey_2_dstkey_10_30_id"
//use final multi_distinct + sum0
qt_agg_distinct_without_gby_key_satisfy_dst_key_low_ndv "explain shape
plan select count(distinct id) from t_gbykey_2_dstkey_10_30_id"
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
