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