You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "zddr (via GitHub)" <gi...@apache.org> on 2024/06/17 07:16:32 UTC
[PR] [fix](auth)Auth support case insensitive [doris]
zddr opened a new pull request, #36381:
URL: https://github.com/apache/doris/pull/36381
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
--
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] [fix](auth)Auth support case insensitive [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36381:
URL: https://github.com/apache/doris/pull/36381#issuecomment-2172583686
<details>
<summary>TPC-DS: <b>Total hot run time: 173828 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 e982458fe614c643d654dbe55431a5d4edc10f3b, data reload: false
query1 925 381 374 374
query2 6560 2545 2256 2256
query3 6637 206 204 204
query4 21732 17225 17336 17225
query5 3607 490 481 481
query6 237 160 159 159
query7 4578 301 288 288
query8 326 280 280 280
query9 8647 2430 2342 2342
query10 575 294 271 271
query11 10512 10112 9993 9993
query12 117 89 82 82
query13 1638 369 372 369
query14 9840 7143 7741 7143
query15 231 193 188 188
query16 7726 265 267 265
query17 1674 536 516 516
query18 1946 292 269 269
query19 196 163 159 159
query20 93 81 81 81
query21 211 129 130 129
query22 4337 3984 3907 3907
query23 33769 33564 33820 33564
query24 11153 2893 2980 2893
query25 588 386 375 375
query26 719 161 161 161
query27 2355 333 326 326
query28 6219 2133 2103 2103
query29 912 632 645 632
query30 251 149 158 149
query31 947 757 775 757
query32 89 55 54 54
query33 764 295 284 284
query34 1021 498 498 498
query35 738 644 642 642
query36 1091 976 1001 976
query37 145 74 74 74
query38 2960 2888 2874 2874
query39 884 851 846 846
query40 216 139 130 130
query41 58 52 51 51
query42 137 98 100 98
query43 586 554 529 529
query44 1205 727 737 727
query45 196 161 169 161
query46 1080 715 739 715
query47 1882 1762 1771 1762
query48 368 295 298 295
query49 842 418 433 418
query50 757 400 399 399
query51 6787 6697 6692 6692
query52 109 93 94 93
query53 355 296 289 289
query54 901 448 458 448
query55 75 72 76 72
query56 293 281 281 281
query57 1136 1067 1065 1065
query58 264 245 249 245
query59 3426 3214 3138 3138
query60 306 296 300 296
query61 108 105 105 105
query62 618 441 438 438
query63 323 293 291 291
query64 8629 2320 1838 1838
query65 3318 3118 3097 3097
query66 764 324 327 324
query67 15430 14881 15189 14881
query68 4633 536 540 536
query69 699 461 399 399
query70 1178 1089 1068 1068
query71 457 284 277 277
query72 8400 5812 5413 5413
query73 759 329 327 327
query74 5811 5505 5494 5494
query75 4428 2675 2692 2675
query76 3089 1073 896 896
query77 747 300 297 297
query78 10513 9897 9768 9768
query79 2587 526 509 509
query80 2798 468 475 468
query81 629 212 228 212
query82 776 107 102 102
query83 323 170 167 167
query84 266 91 84 84
query85 1889 291 273 273
query86 477 321 318 318
query87 3232 3115 3067 3067
query88 4069 2355 2366 2355
query89 461 385 388 385
query90 1984 190 194 190
query91 131 102 100 100
query92 62 52 49 49
query93 2384 510 505 505
query94 1405 189 186 186
query95 410 313 307 307
query96 590 266 275 266
query97 3205 3072 3046 3046
query98 229 204 191 191
query99 1146 837 831 831
Total cold run time: 276886 ms
Total hot run time: 173828 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] [fix](auth)Auth support case insensitive [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #36381:
URL: https://github.com/apache/doris/pull/36381#issuecomment-2172477109
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] [fix](auth)Auth support case insensitive [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36381:
URL: https://github.com/apache/doris/pull/36381#issuecomment-2173055926
<details>
<summary>TPC-H: <b>Total hot run time: 39379 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 c8fdd8d7514969d5cdad3595decf071ccb64a63e, data reload: false
------ Round 1 ----------------------------------
q1 17624 4294 4252 4252
q2 2017 186 191 186
q3 10456 1156 991 991
q4 10183 734 787 734
q5 7453 2670 2598 2598
q6 222 135 135 135
q7 973 604 597 597
q8 9213 2061 2030 2030
q9 8645 6501 6431 6431
q10 8976 3732 3707 3707
q11 471 227 232 227
q12 473 234 224 224
q13 17760 2986 2962 2962
q14 270 218 217 217
q15 529 476 483 476
q16 511 391 376 376
q17 954 627 735 627
q18 7924 7463 7371 7371
q19 2456 1511 1473 1473
q20 655 322 337 322
q21 4986 3216 3118 3118
q22 386 328 325 325
Total cold run time: 113137 ms
Total hot run time: 39379 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4354 4246 4229 4229
q2 364 267 252 252
q3 3012 2746 2724 2724
q4 1967 1695 1694 1694
q5 5567 5609 5550 5550
q6 220 128 129 128
q7 2258 1858 1806 1806
q8 3256 3406 3409 3406
q9 8747 8644 8738 8644
q10 4142 3909 3970 3909
q11 590 483 481 481
q12 770 583 596 583
q13 15771 3207 3208 3207
q14 307 272 275 272
q15 539 471 489 471
q16 495 464 460 460
q17 1802 1540 1499 1499
q18 8305 8003 7998 7998
q19 4279 1509 1642 1509
q20 2098 1871 1881 1871
q21 5052 5003 4873 4873
q22 624 550 571 550
Total cold run time: 74519 ms
Total hot run time: 56116 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] [fix](auth)Auth support case insensitive [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36381:
URL: https://github.com/apache/doris/pull/36381#issuecomment-2172474461
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)
Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).
--
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] [fix](auth)Auth support case insensitive [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #36381:
URL: https://github.com/apache/doris/pull/36381#issuecomment-2172962811
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] [fix](auth)Auth support case insensitive [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36381:
URL: https://github.com/apache/doris/pull/36381#issuecomment-2173078653
<details>
<summary>TPC-DS: <b>Total hot run time: 174440 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 c8fdd8d7514969d5cdad3595decf071ccb64a63e, data reload: false
query1 936 381 369 369
query2 6441 2422 2314 2314
query3 6636 200 207 200
query4 19884 17454 17330 17330
query5 3581 487 476 476
query6 242 158 160 158
query7 4578 306 289 289
query8 308 285 284 284
query9 8494 2414 2410 2410
query10 578 308 290 290
query11 10676 10043 10087 10043
query12 120 99 88 88
query13 1662 370 362 362
query14 10123 7201 7221 7201
query15 258 193 183 183
query16 7788 268 260 260
query17 1878 568 514 514
query18 1945 283 274 274
query19 205 156 156 156
query20 103 86 87 86
query21 212 127 124 124
query22 4376 4096 4034 4034
query23 33792 33633 33625 33625
query24 11147 2908 2912 2908
query25 615 373 380 373
query26 1207 162 167 162
query27 2488 340 334 334
query28 6971 2126 2127 2126
query29 949 684 666 666
query30 283 156 159 156
query31 987 802 776 776
query32 99 54 56 54
query33 750 290 308 290
query34 1016 483 485 483
query35 719 673 620 620
query36 1067 951 970 951
query37 176 76 82 76
query38 2935 2808 2857 2808
query39 913 824 859 824
query40 212 129 130 129
query41 56 51 56 51
query42 119 116 103 103
query43 582 562 543 543
query44 1209 719 736 719
query45 193 158 172 158
query46 1080 727 725 725
query47 1860 1791 1760 1760
query48 387 294 297 294
query49 847 411 409 409
query50 767 397 398 397
query51 6894 6640 6638 6638
query52 104 93 90 90
query53 365 296 284 284
query54 896 441 444 441
query55 75 74 73 73
query56 279 258 267 258
query57 1106 1039 1044 1039
query58 259 251 243 243
query59 3399 3232 3253 3232
query60 300 281 305 281
query61 129 110 118 110
query62 604 448 449 448
query63 319 295 303 295
query64 8910 2260 1737 1737
query65 3213 3163 3128 3128
query66 817 326 321 321
query67 15490 15229 15189 15189
query68 4488 527 532 527
query69 493 337 314 314
query70 1180 1068 1080 1068
query71 383 280 273 273
query72 7074 5222 5660 5222
query73 748 327 330 327
query74 5947 5514 5519 5514
query75 3329 2654 2712 2654
query76 2126 1000 881 881
query77 446 304 304 304
query78 10380 10001 9923 9923
query79 2258 528 513 513
query80 1317 486 469 469
query81 590 221 227 221
query82 950 107 103 103
query83 272 169 167 167
query84 246 86 85 85
query85 1351 278 266 266
query86 479 339 310 310
query87 3296 3073 3133 3073
query88 3983 2372 2362 2362
query89 478 390 381 381
query90 1739 198 188 188
query91 139 100 100 100
query92 61 48 49 48
query93 2354 499 497 497
query94 1097 192 191 191
query95 410 319 321 319
query96 591 267 270 267
query97 3201 3063 3060 3060
query98 227 197 274 197
query99 1248 844 859 844
Total cold run time: 270490 ms
Total hot run time: 174440 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] [fix](auth)Auth support case insensitive [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36381:
URL: https://github.com/apache/doris/pull/36381#issuecomment-2172559925
<details>
<summary>TPC-H: <b>Total hot run time: 39578 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 e982458fe614c643d654dbe55431a5d4edc10f3b, data reload: false
------ Round 1 ----------------------------------
q1 17625 4357 4289 4289
q2 2025 192 201 192
q3 10446 1086 1127 1086
q4 10182 801 889 801
q5 7465 2650 2618 2618
q6 219 135 137 135
q7 967 606 601 601
q8 9221 2066 2049 2049
q9 8697 6499 6490 6490
q10 8997 3682 3675 3675
q11 455 239 236 236
q12 437 244 227 227
q13 18729 2943 2989 2943
q14 263 241 223 223
q15 506 466 465 465
q16 532 377 380 377
q17 958 684 654 654
q18 7960 7514 7340 7340
q19 4844 1370 1437 1370
q20 655 324 324 324
q21 4913 3136 3860 3136
q22 400 347 350 347
Total cold run time: 116496 ms
Total hot run time: 39578 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4466 4222 4213 4213
q2 374 265 275 265
q3 3006 2819 2869 2819
q4 1970 1702 1668 1668
q5 5616 5523 5531 5523
q6 218 127 131 127
q7 2170 1841 1848 1841
q8 3304 3485 3414 3414
q9 8710 8595 8790 8595
q10 4068 3874 3714 3714
q11 626 499 508 499
q12 840 636 626 626
q13 17108 3175 3142 3142
q14 307 286 273 273
q15 526 497 488 488
q16 498 467 442 442
q17 1806 1499 1488 1488
q18 8122 7872 7706 7706
q19 1806 1467 1606 1467
q20 3301 1872 1850 1850
q21 5204 4955 4764 4764
q22 640 538 578 538
Total cold run time: 74686 ms
Total hot run time: 55462 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] [fix](auth)Auth support case insensitive [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36381:
URL: https://github.com/apache/doris/pull/36381#issuecomment-2172594330
<details>
<summary>ClickBench: <b>Total hot run time: 30.34 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 e982458fe614c643d654dbe55431a5d4edc10f3b, data reload: false
query1 0.04 0.03 0.03
query2 0.08 0.04 0.04
query3 0.22 0.05 0.05
query4 1.68 0.07 0.08
query5 0.49 0.49 0.58
query6 1.13 0.72 0.71
query7 0.02 0.02 0.01
query8 0.05 0.04 0.05
query9 0.54 0.49 0.49
query10 0.54 0.55 0.54
query11 0.16 0.11 0.11
query12 0.14 0.11 0.12
query13 0.58 0.59 0.60
query14 0.76 0.79 0.77
query15 0.82 0.81 0.82
query16 0.37 0.37 0.37
query17 1.00 1.01 0.95
query18 0.22 0.25 0.25
query19 1.80 1.76 1.74
query20 0.01 0.01 0.01
query21 15.40 0.67 0.66
query22 4.59 6.85 1.75
query23 18.27 1.39 1.23
query24 2.16 0.21 0.23
query25 0.15 0.09 0.08
query26 0.26 0.17 0.18
query27 0.09 0.08 0.08
query28 13.21 1.01 0.99
query29 12.64 3.20 3.25
query30 0.26 0.07 0.05
query31 2.86 0.38 0.38
query32 3.31 0.47 0.46
query33 2.95 2.93 2.92
query34 17.19 4.44 4.43
query35 4.45 4.54 4.49
query36 0.64 0.46 0.48
query37 0.17 0.15 0.15
query38 0.15 0.14 0.14
query39 0.04 0.04 0.04
query40 0.17 0.14 0.15
query41 0.10 0.05 0.04
query42 0.05 0.05 0.05
query43 0.05 0.04 0.04
Total cold run time: 109.81 s
Total hot run time: 30.34 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] [fix](auth)Auth support case insensitive [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36381:
URL: https://github.com/apache/doris/pull/36381#issuecomment-2173088049
<details>
<summary>ClickBench: <b>Total hot run time: 30.79 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 c8fdd8d7514969d5cdad3595decf071ccb64a63e, data reload: false
query1 0.04 0.03 0.04
query2 0.08 0.04 0.04
query3 0.23 0.07 0.05
query4 1.67 0.10 0.09
query5 0.50 0.49 0.49
query6 1.12 0.72 0.73
query7 0.02 0.02 0.02
query8 0.05 0.05 0.04
query9 0.54 0.49 0.50
query10 0.55 0.55 0.56
query11 0.16 0.12 0.11
query12 0.15 0.12 0.12
query13 0.60 0.59 0.58
query14 0.80 0.78 0.78
query15 0.83 0.82 0.83
query16 0.37 0.37 0.37
query17 1.03 1.04 1.03
query18 0.21 0.21 0.26
query19 1.77 1.70 1.72
query20 0.01 0.00 0.00
query21 15.42 0.64 0.66
query22 4.18 7.05 2.01
query23 18.22 1.31 1.31
query24 2.14 0.24 0.22
query25 0.16 0.09 0.08
query26 0.26 0.17 0.18
query27 0.08 0.08 0.08
query28 13.30 1.02 1.00
query29 12.87 3.34 3.28
query30 0.25 0.07 0.06
query31 2.86 0.39 0.38
query32 3.31 0.47 0.48
query33 2.90 2.87 2.91
query34 17.07 4.53 4.44
query35 4.49 4.51 4.48
query36 0.66 0.46 0.51
query37 0.18 0.16 0.15
query38 0.15 0.14 0.15
query39 0.04 0.04 0.04
query40 0.17 0.14 0.15
query41 0.09 0.05 0.05
query42 0.05 0.05 0.04
query43 0.05 0.04 0.04
Total cold run time: 109.63 s
Total hot run time: 30.79 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] [fix](auth)Auth support case insensitive [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #36381:
URL: https://github.com/apache/doris/pull/36381#issuecomment-2173149342
run feut
--
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