This is an automated email from the ASF dual-hosted git repository. 924060929 pushed a commit to branch fe_local_shuffle_rebase in repository https://gitbox.apache.org/repos/asf/doris.git
commit ed711b3b36f3760a78470fd7453015856d5f304a Author: 924060929 <[email protected]> AuthorDate: Tue May 19 22:53:46 2026 +0800 [test](local shuffle) Switch order-sensitive checks to order_qt_* Two regression checks were comparing actual rows against .out in a specific order even though the SQL was order-insensitive at that point. The FE local-shuffle planner can legitimately change row delivery order within a fragment, exposing the latent assumption and failing the test. - unnest_order_by_list_test.groovy: qt_window_function_order_by_unnested_value has a window RANK() over UNNEST without an outer ORDER BY. Switch to order_qt_* (framework sorts the actual rows before comparing) and re-sort the corresponding .out block so the expected side is also in sorted order. - test_python_udaf_complex.groovy: qt_json_array_agg → order_qt_json_array_agg. The query GROUP BY category already returns rows in alphabetical category order, so no .out change is needed. Note: this only stabilises row order; the python UDAF's per-group array contents still depend on row arrival order inside each group, so a stricter pin (ORDER BY id in a subquery or array_sort around the agg) would still be needed if that variability resurfaces. --- .../gen_function/unnest_order_by_list_test.out | 8 ++++---- .../gen_function/unnest_order_by_list_test.groovy | 10 +++++----- .../pythonudf_complex_p0/test_python_udaf_complex.groovy | 2 +- 3 files changed, 10 insertions(+), 10 deletions(-) diff --git a/regression-test/data/nereids_function_p0/gen_function/unnest_order_by_list_test.out b/regression-test/data/nereids_function_p0/gen_function/unnest_order_by_list_test.out index 31141b95eae..f2f86a8bc5c 100644 --- a/regression-test/data/nereids_function_p0/gen_function/unnest_order_by_list_test.out +++ b/regression-test/data/nereids_function_p0/gen_function/unnest_order_by_list_test.out @@ -63,13 +63,13 @@ Alice Charlie -- !window_function_order_by_unnested_value -- -1 English 90 1 1 English 85 2 -1 Math 95 1 -1 Math 80 2 +1 English 90 1 1 Math 70 3 -2 Math 75 1 +1 Math 80 2 +1 Math 95 1 2 Math 60 2 +2 Math 75 1 -- !order_by_after_where_and_unnest -- 1 0 80 diff --git a/regression-test/suites/nereids_function_p0/gen_function/unnest_order_by_list_test.groovy b/regression-test/suites/nereids_function_p0/gen_function/unnest_order_by_list_test.groovy index af502abe1fe..8f441532fee 100644 --- a/regression-test/suites/nereids_function_p0/gen_function/unnest_order_by_list_test.groovy +++ b/regression-test/suites/nereids_function_p0/gen_function/unnest_order_by_list_test.groovy @@ -87,11 +87,11 @@ suite("unnest_order_by_list_test", "unnest") { (2, 'Math', [60, 75]);""" // Test using the unnested value within the ORDER BY clause of a window function. - qt_window_function_order_by_unnested_value """ - SELECT - user_id, - subject, - s.val, + order_qt_window_function_order_by_unnested_value """ + SELECT + user_id, + subject, + s.val, RANK() OVER (PARTITION BY user_id, subject ORDER BY s.val DESC) as score_rank FROM ${tb_name2}, UNNEST(history_scores) AS s(val);""" diff --git a/regression-test/suites/pythonudf_complex_p0/test_python_udaf_complex.groovy b/regression-test/suites/pythonudf_complex_p0/test_python_udaf_complex.groovy index 96ca48f13de..344ec21e77d 100644 --- a/regression-test/suites/pythonudf_complex_p0/test_python_udaf_complex.groovy +++ b/regression-test/suites/pythonudf_complex_p0/test_python_udaf_complex.groovy @@ -476,7 +476,7 @@ suite("test_python_udaf_complex") { ); """ - qt_json_array_agg """ + order_qt_json_array_agg """ SELECT category, py_json_array_agg(CAST(id AS STRING)) AS id_array FROM udaf_test_data GROUP BY category --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
