This is an automated email from the ASF dual-hosted git repository.

englefly pushed a commit to branch branch-3.0
in repository https://gitbox.apache.org/repos/asf/doris.git


The following commit(s) were added to refs/heads/branch-3.0 by this push:
     new 5690eed0a4e [fix](regression) unstable case 
push_down_aggr_distinct_through_join_one_side_cust (#46693)
5690eed0a4e is described below

commit 5690eed0a4ed27857b8090e89371064fe7bfc3fa
Author: minghong <zhoumingh...@selectdb.com>
AuthorDate: Thu Jan 9 18:42:58 2025 +0800

    [fix](regression) unstable case 
push_down_aggr_distinct_through_join_one_side_cust (#46693)
    
    ### What problem does this PR solve?
    
    LIMIT_AGG_TO_TOPN_AGG rule adjusts the topn orderkeys, and makes plan
    different from expected.
---
 .../push_down_aggr_distinct_through_join_one_side_cust.groovy       | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

diff --git 
a/regression-test/suites/nereids_rules_p0/eager_aggregate/push_down_aggr_distinct_through_join_one_side_cust.groovy
 
b/regression-test/suites/nereids_rules_p0/eager_aggregate/push_down_aggr_distinct_through_join_one_side_cust.groovy
index 9134d66b76d..5fb78a281d2 100644
--- 
a/regression-test/suites/nereids_rules_p0/eager_aggregate/push_down_aggr_distinct_through_join_one_side_cust.groovy
+++ 
b/regression-test/suites/nereids_rules_p0/eager_aggregate/push_down_aggr_distinct_through_join_one_side_cust.groovy
@@ -23,7 +23,11 @@ suite("push_down_aggr_distinct_through_join_one_side_cust") {
 
     sql """
         DROP TABLE IF EXISTS dwd_com_abtest_result_inc_ymds;
-       DROP TABLE IF EXISTS dwd_tracking_sensor_init_tmp_ymds;
+             DROP TABLE IF EXISTS dwd_tracking_sensor_init_tmp_ymds;
+    """
+
+    sql """
+      set topn_opt_limit_threshold=1024;
     """
 
     sql """


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to