[Exec](agg) Fix agg limit result error

[HappenLee]

Proposed changes

Before merge #34853， should merge the pr firstly

[doris-robot]

Thank you for your contribution to Apache Doris. Don't know what should be done next? See How to process your PR

Since 2024-03-18, the Document has been moved to doris-website. See Doris Document.

[HappenLee]

run buildall

[github-actions[bot]]

clang-tidy review says "All clean, LGTM! :+1:"

[doris-robot]

TPC-H: Total hot run time: 40875 ms

``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 2447aef3fc6b9fa7f4029c5fc5fc67e025620883, data reload: false ------ Round 1 ---------------------------------- q1 17596 4442 4317 4317 q2 2020 189 191 189 q3 10492 1202 1177 1177 q4 10189 755 821 755 q5 7579 2716 2624 2624 q6 224 137 139 137 q7 973 601 618 601 q8 9236 2105 2108 2105 q9 9111 6517 6497 6497 q10 8981 3748 3752 3748 q11 455 239 244 239 q12 491 238 234 234 q13 17972 3029 3019 3019 q14 267 217 226 217 q15 512 479 477 477 q16 491 375 379 375 q17 970 681 655 655 q18 7978 7498 7435 7435 q19 4815 1555 1594 1555 q20 662 324 335 324 q21 5027 3852 3989 3852 q22 401 343 347 343 Total cold run time: 116442 ms Total hot run time: 40875 ms ----- Round 2, with runtime_filter_mode=off ----- q1 4407 4265 4243 4243 q2 378 276 278 276 q3 3001 2941 2922 2922 q4 2021 1718 1793 1718 q5 5593 5522 5458 5458 q6 228 131 133 131 q7 2210 1856 1831 1831 q8 3291 3414 3486 3414 q9 8701 8745 8749 8745 q10 4158 3750 3746 3746 q11 603 488 506 488 q12 834 647 640 640 q13 16133 3162 3167 3162 q14 294 296 278 278 q15 555 474 482 474 q16 519 457 429 429 q17 1792 1514 1485 1485 q18 8281 7826 7709 7709 q19 1858 1655 1624 1624 q20 3067 1883 1844 1844 q21 5103 4986 4837 4837 q22 616 529 563 529 Total cold run time: 73643 ms Total hot run time: 55983 ms ```

[doris-robot]

TPC-DS: Total hot run time: 174722 ms

``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS sf100 test result on commit 2447aef3fc6b9fa7f4029c5fc5fc67e025620883, data reload: false query1 913 382 384 382 query2 6469 2438 2346 2346 query3 6631 206 215 206 query4 21428 17512 17441 17441 query5 3606 494 478 478 query6 270 176 173 173 query7 4590 295 304 295 query8 308 297 285 285 query9 8464 2483 2462 2462 query10 574 316 295 295 query11 10475 10018 9987 9987 query12 111 90 81 81 query13 1643 383 371 371 query14 9528 7652 7036 7036 query15 229 191 201 191 query16 7920 278 267 267 query17 1886 563 553 553 query18 2074 280 306 280 query19 208 158 165 158 query20 94 83 86 83 query21 210 131 129 129 query22 4266 4099 4213 4099 query23 33968 33778 33645 33645 query24 10724 3049 2884 2884 query25 594 413 389 389 query26 719 161 166 161 query27 2235 327 333 327 query28 5930 2206 2207 2206 query29 925 670 645 645 query30 271 163 166 163 query31 991 771 795 771 query32 96 55 58 55 query33 671 308 312 308 query34 882 490 508 490 query35 751 672 647 647 query36 1119 1000 964 964 query37 161 82 83 82 query38 2957 2817 2826 2817 query39 933 839 918 839 query40 222 125 132 125 query41 56 51 57 51 query42 110 102 104 102 query43 582 584 568 568 query44 1152 741 739 739 query45 195 161 163 161 query46 1077 718 728 718 query47 1888 1753 1781 1753 query48 366 295 295 295 query49 850 412 409 409 query50 778 392 393 392 query51 6841 6792 6744 6744 query52 108 100 96 96 query53 364 312 302 302 query54 896 444 449 444 query55 74 75 75 75 query56 285 263 267 263 query57 1126 1075 1052 1052 query58 258 242 253 242 query59 3356 3216 3143 3143 query60 291 277 273 273 query61 91 89 93 89 query62 613 449 440 440 query63 330 297 302 297 query64 8555 2235 1818 1818 query65 3133 3135 3123 3123 query66 745 326 333 326 query67 15484 15091 14915 14915 query68 8582 589 571 571 query69 719 494 392 392 query70 1431 1120 1152 1120 query71 527 283 281 281 query72 8613 5788 5226 5226 query73 2324 329 328 328 query74 5941 5432 5561 5432 query75 5004 2640 2716 2640 query76 4714 961 982 961 query77 768 303 304 303 query78 10319 10012 9753 9753 query79 7783 527 537 527 query80 919 502 491 491 query81 548 222 230 222 query82 267 104 104 104 query83 345 178 167 167 query84 265 85 89 85 query85 883 286 271 271 query86 356 317 313 313 query87 3313 3099 3126 3099 query88 5027 2391 2397 2391 query89 535 391 385 385 query90 1963 197 196 196 query91 129 99 98 98 query92 65 52 51 51 query93 5992 534 522 522 query94 1340 195 193 193 query95 402 328 327 327 query96 613 274 266 266 query97 3214 3038 3062 3038 query98 215 215 197 197 query99 1131 839 826 826 Total cold run time: 289897 ms Total hot run time: 174722 ms ```

[doris-robot]

ClickBench: Total hot run time: 30.54 s

``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 2447aef3fc6b9fa7f4029c5fc5fc67e025620883, data reload: false query1 0.04 0.04 0.04 query2 0.08 0.03 0.04 query3 0.22 0.05 0.04 query4 1.68 0.08 0.08 query5 0.49 0.49 0.50 query6 1.13 0.73 0.74 query7 0.02 0.02 0.01 query8 0.05 0.05 0.05 query9 0.55 0.49 0.49 query10 0.52 0.56 0.55 query11 0.16 0.12 0.12 query12 0.15 0.12 0.13 query13 0.59 0.58 0.58 query14 0.77 0.79 0.79 query15 0.85 0.81 0.83 query16 0.35 0.36 0.35 query17 0.96 0.93 0.95 query18 0.22 0.25 0.25 query19 1.84 1.68 1.66 query20 0.01 0.01 0.01 query21 15.42 0.75 0.66 query22 4.31 7.20 1.97 query23 18.29 1.42 1.24 query24 2.09 0.23 0.23 query25 0.16 0.08 0.08 query26 0.26 0.17 0.17 query27 0.08 0.07 0.09 query28 13.19 1.04 1.00 query29 12.64 3.28 3.30 query30 0.25 0.06 0.05 query31 2.88 0.38 0.38 query32 3.28 0.48 0.47 query33 2.90 2.93 2.92 query34 16.86 4.40 4.38 query35 4.49 4.50 4.45 query36 0.65 0.48 0.48 query37 0.20 0.15 0.15 query38 0.15 0.14 0.14 query39 0.04 0.03 0.04 query40 0.17 0.15 0.14 query41 0.08 0.04 0.04 query42 0.06 0.04 0.05 query43 0.05 0.04 0.04 Total cold run time: 109.18 s Total hot run time: 30.54 s ```

[github-actions[bot]]

PR approved by at least one committer and no changes requested.

[github-actions[bot]]

PR approved by anyone and no changes requested.