You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "github-actions[bot] (via GitHub)" <gi...@apache.org> on 2025/05/23 03:24:52 UTC
[PR] branch-3.0: [Bug](intersect) fix wrong result of intersect with null literal #50951 [doris]
github-actions[bot] opened a new pull request, #51178:
URL: https://github.com/apache/doris/pull/51178
Cherry-picked from #50951
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] branch-3.0: [Bug](intersect) fix wrong result of intersect with null literal #50951 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51178:
URL: https://github.com/apache/doris/pull/51178#issuecomment-2903184165
<details>
<summary>TPC-DS: <b>Total hot run time: 195818 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 29cf54ec7cc9284ad2574513256b7ee488bef107, data reload: false
query1 1302 907 922 907
query2 6362 1969 1899 1899
query3 10825 4282 4244 4244
query4 61326 29172 23304 23304
query5 5312 454 445 445
query6 408 190 181 181
query7 5488 314 310 310
query8 313 215 220 215
query9 8541 2582 2578 2578
query10 474 268 266 266
query11 17736 15166 16166 15166
query12 171 102 104 102
query13 1462 450 438 438
query14 9988 7425 7151 7151
query15 197 186 185 185
query16 7230 484 489 484
query17 1210 569 601 569
query18 1835 317 306 306
query19 213 166 164 164
query20 118 112 110 110
query21 206 101 102 101
query22 4811 4526 4550 4526
query23 34393 33880 33756 33756
query24 6229 2947 2909 2909
query25 537 399 391 391
query26 651 162 164 162
query27 1713 359 362 359
query28 4013 2145 2122 2122
query29 699 455 447 447
query30 236 154 154 154
query31 993 827 810 810
query32 64 52 58 52
query33 444 276 286 276
query34 914 500 514 500
query35 834 742 732 732
query36 1066 951 951 951
query37 115 68 65 65
query38 4028 3909 3997 3909
query39 1537 1473 1621 1473
query40 207 104 101 101
query41 48 51 50 50
query42 116 100 102 100
query43 540 484 485 484
query44 1160 805 818 805
query45 190 166 169 166
query46 1128 713 718 713
query47 2016 1901 1921 1901
query48 475 387 409 387
query49 716 395 385 385
query50 842 433 434 433
query51 7436 7239 7123 7123
query52 97 87 91 87
query53 275 178 179 178
query54 574 482 467 467
query55 77 79 79 79
query56 269 234 234 234
query57 1270 1127 1144 1127
query58 229 215 214 214
query59 3221 3083 2998 2998
query60 296 263 253 253
query61 110 133 114 114
query62 802 720 692 692
query63 226 196 186 186
query64 1425 659 629 629
query65 3287 3201 3172 3172
query66 703 298 288 288
query67 15820 15418 15528 15418
query68 4349 576 569 569
query69 441 290 264 264
query70 1130 1119 1110 1110
query71 353 264 259 259
query72 6369 4045 4096 4045
query73 749 340 359 340
query74 10501 8914 9243 8914
query75 3350 2660 2662 2660
query76 2043 1072 1067 1067
query77 464 278 267 267
query78 10630 9669 9509 9509
query79 2107 587 580 580
query80 1404 414 428 414
query81 529 229 219 219
query82 1253 82 87 82
query83 172 148 136 136
query84 279 82 71 71
query85 1031 302 295 295
query86 363 303 303 303
query87 4348 4285 4218 4218
query88 3907 2417 2389 2389
query89 413 285 290 285
query90 2011 184 183 183
query91 182 148 150 148
query92 58 49 47 47
query93 3029 548 530 530
query94 784 287 249 249
query95 357 255 250 250
query96 619 285 278 278
query97 3333 3150 3137 3137
query98 208 203 207 203
query99 1575 1301 1294 1294
Total cold run time: 315890 ms
Total hot run time: 195818 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] branch-3.0: [Bug](intersect) fix wrong result of intersect with null literal #50951 [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #51178:
URL: https://github.com/apache/doris/pull/51178#issuecomment-2903137808
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] branch-3.0: [Bug](intersect) fix wrong result of intersect with null literal #50951 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51178:
URL: https://github.com/apache/doris/pull/51178#issuecomment-2903170219
<details>
<summary>TPC-H: <b>Total hot run time: 39428 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 29cf54ec7cc9284ad2574513256b7ee488bef107, data reload: false
------ Round 1 ----------------------------------
q1 17573 6694 6559 6559
q2 2044 169 184 169
q3 10779 1070 1110 1070
q4 10559 699 704 699
q5 7768 2848 2747 2747
q6 212 133 130 130
q7 958 604 589 589
q8 9346 1950 2029 1950
q9 6557 6376 6348 6348
q10 7048 2285 2255 2255
q11 471 267 261 261
q12 407 219 210 210
q13 17779 3009 2966 2966
q14 246 210 202 202
q15 503 465 457 457
q16 508 395 378 378
q17 965 565 559 559
q18 7296 6680 6516 6516
q19 1411 1031 1030 1030
q20 469 199 195 195
q21 3995 3161 3209 3161
q22 1106 979 977 977
Total cold run time: 108000 ms
Total hot run time: 39428 ms
----- Round 2, with runtime_filter_mode=off -----
q1 6528 6536 6564 6536
q2 331 229 226 226
q3 2866 2697 2767 2697
q4 2050 1795 1785 1785
q5 5743 5745 5682 5682
q6 207 135 131 131
q7 2217 1797 1773 1773
q8 3366 3492 3511 3492
q9 8900 8688 8852 8688
q10 3561 3485 3493 3485
q11 586 498 485 485
q12 782 611 594 594
q13 9741 3131 3108 3108
q14 298 279 260 260
q15 520 465 456 456
q16 489 467 417 417
q17 1840 1597 1588 1588
q18 8313 7844 7629 7629
q19 1706 1582 1580 1580
q20 2135 1860 1922 1860
q21 5288 5222 5255 5222
q22 1082 1012 1005 1005
Total cold run time: 68549 ms
Total hot run time: 58699 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] branch-3.0: [Bug](intersect) fix wrong result of intersect with null literal #50951 [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #51178:
URL: https://github.com/apache/doris/pull/51178#issuecomment-2903137756
Thank you for your contribution to Apache Doris.
Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR).
Please clearly describe your PR:
1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
3. What features were added. Why was this function added?
4. Which code was refactored and why was this part of the code refactored?
5. Which functions were optimized and what is the difference before and after the optimization?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] branch-3.0: [Bug](intersect) fix wrong result of intersect with null literal #50951 [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring closed pull request #51178: branch-3.0: [Bug](intersect) fix wrong result of intersect with null literal #50951
URL: https://github.com/apache/doris/pull/51178
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] branch-3.0: [Bug](intersect) fix wrong result of intersect with null literal #50951 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51178:
URL: https://github.com/apache/doris/pull/51178#issuecomment-2903195761
<details>
<summary>ClickBench: <b>Total hot run time: 30 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 29cf54ec7cc9284ad2574513256b7ee488bef107, data reload: false
query1 0.03 0.03 0.02
query2 0.07 0.03 0.03
query3 0.24 0.07 0.06
query4 1.63 0.10 0.10
query5 0.50 0.51 0.53
query6 1.13 0.73 0.73
query7 0.02 0.02 0.02
query8 0.05 0.04 0.04
query9 0.56 0.49 0.49
query10 0.55 0.54 0.54
query11 0.14 0.10 0.10
query12 0.14 0.11 0.14
query13 0.60 0.61 0.59
query14 0.77 0.77 0.79
query15 0.84 0.81 0.82
query16 0.38 0.38 0.39
query17 1.06 1.04 1.01
query18 0.24 0.22 0.22
query19 1.96 1.84 1.83
query20 0.01 0.01 0.01
query21 15.40 0.58 0.61
query22 2.32 1.88 1.89
query23 16.82 1.06 0.87
query24 3.64 1.01 0.91
query25 0.28 0.13 0.05
query26 0.46 0.13 0.15
query27 0.03 0.04 0.04
query28 10.17 0.44 0.49
query29 12.57 3.27 3.21
query30 0.24 0.06 0.05
query31 2.87 0.38 0.36
query32 3.26 0.46 0.46
query33 2.92 3.00 3.04
query34 17.06 4.52 4.42
query35 4.53 4.47 4.48
query36 0.67 0.46 0.48
query37 0.09 0.06 0.06
query38 0.05 0.03 0.03
query39 0.04 0.02 0.02
query40 0.15 0.12 0.13
query41 0.08 0.02 0.02
query42 0.03 0.02 0.02
query43 0.03 0.03 0.03
Total cold run time: 104.63 s
Total hot run time: 30 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] branch-3.0: [Bug](intersect) fix wrong result of intersect with null literal #50951 [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #51178:
URL: https://github.com/apache/doris/pull/51178
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org