Re: [PR] [bugfix](query) Fix for incorrect query results of variant type [doris]

2025-06-13 Thread via GitHub


eldenmoon merged PR #51651:
URL: https://github.com/apache/doris/pull/51651


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [bugfix](query) Fix for incorrect query results of variant type [doris]

2025-06-11 Thread via GitHub


github-actions[bot] commented on PR #51651:
URL: https://github.com/apache/doris/pull/51651#issuecomment-2964798546

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


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [bugfix](query) Fix for incorrect query results of variant type [doris]

2025-06-11 Thread via GitHub


felixwluo commented on PR #51651:
URL: https://github.com/apache/doris/pull/51651#issuecomment-2963711828

   run p0


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [bugfix](query) Fix for incorrect query results of variant type [doris]

2025-06-11 Thread via GitHub


doris-robot commented on PR #51651:
URL: https://github.com/apache/doris/pull/51651#issuecomment-2963469548

   
   
   ClickBench: Total hot run time: 29.49 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 801a6ec319d106eda5ee124d8f22f1eda0fab7cb, 
data reload: false
   
   query1   0.040.040.03
   query2   0.130.110.11
   query3   0.250.190.19
   query4   1.590.190.12
   query5   0.460.410.42
   query6   1.170.680.66
   query7   0.030.010.01
   query8   0.050.030.04
   query9   0.580.530.53
   query10  0.580.580.57
   query11  0.170.110.11
   query12  0.150.120.12
   query13  0.630.600.60
   query14  0.790.790.82
   query15  0.890.870.86
   query16  0.400.400.38
   query17  1.041.041.03
   query18  0.240.220.22
   query19  1.911.881.89
   query20  0.010.020.01
   query21  15.41   0.960.57
   query22  0.761.300.80
   query23  14.72   1.410.62
   query24  7.411.410.74
   query25  0.460.190.09
   query26  0.560.170.15
   query27  0.050.060.05
   query28  9.800.980.45
   query29  12.66   4.113.42
   query30  0.250.090.06
   query31  2.820.610.39
   query32  3.240.540.48
   query33  3.083.113.11
   query34  15.83   5.134.57
   query35  4.554.494.49
   query36  0.690.510.49
   query37  0.090.060.07
   query38  0.050.040.04
   query39  0.030.020.02
   query40  0.160.150.14
   query41  0.090.040.03
   query42  0.040.030.02
   query43  0.040.040.04
   Total cold run time: 103.9 s
   Total hot run time: 29.49 s
   ```
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [bugfix](query) Fix for incorrect query results of variant type [doris]

2025-06-11 Thread via GitHub


doris-robot commented on PR #51651:
URL: https://github.com/apache/doris/pull/51651#issuecomment-2963455945

   
   
   TPC-DS: Total hot run time: 195146 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 801a6ec319d106eda5ee124d8f22f1eda0fab7cb, 
data reload: false
   
   query1   1405110910901090
   query2   6452188618811881
   query3   11011   454543734373
   query4   25562   24106   23159   23159
   query5   4739654 483 483
   query6   311 229 228 228
   query7   4005533 311 311
   query8   277 250 230 230
   query9   8543286228772862
   query10  525 345 294 294
   query11  15526   15079   14837   14837
   query12  174 114 111 111
   query13  1579579 442 442
   query14  9624632662356235
   query15  201 190 167 167
   query16  7593621 521 521
   query17  1275766 621 621
   query18  2069421 332 332
   query19  215 200 166 166
   query20  130 129 128 128
   query21  209 128 113 113
   query22  4551471045054505
   query23  34823   34086   33489   33489
   query24  8457244024642440
   query25  523 489 431 431
   query26  1207284 160 160
   query27  2833537 367 367
   query28  4661234523122312
   query29  739 583 447 447
   query30  285 228 203 203
   query31  926 864 790 790
   query32  82  65  72  65
   query33  548 380 354 354
   query34  853 942 575 575
   query35  814 887 779 779
   query36  10371059954 954
   query37  123 106 79  79
   query38  4280435942024202
   query39  1566145214801452
   query40  215 125 122 122
   query41  65  62  61  61
   query42  142 121 123 121
   query43  541 567 521 521
   query44  1406890 885 885
   query45  183 184 176 176
   query46  901 1070673 673
   query47  1909191318311831
   query48  442 460 350 350
   query49  738 543 417 417
   query50  695 763 438 438
   query51  4352424542794245
   query52  125 115 114 114
   query53  250 283 197 197
   query54  634 614 555 555
   query55  90  84  89  84
   query56  333 333 340 333
   query57  1282127211691169
   query58  289 270 270 270
   query59  2800288028932880
   query60  384 341 333 333
   query61  147 144 127 127
   query62  779 725 659 659
   query63  237 202 192 192
   query64  39641122808 808
   query65  4234420342284203
   query66  971 425 329 329
   query67  16428   15900   15603   15603
   query68  8515980 562 562
   query69  480 327 281 281
   query70  1263114611901146
   query71  490 327 332 327
   query72  5702480949014809
   query73  731 687 387 387
   query74  9252917790039003
   query75  3881322827052705
   query76  37441210788 788
   query77  790 433 302 302
   query78  10201   10292   93319331
   query79  2411833 622 622
   query80  648 539 461 461
   query81  487 261 229 229
   query82  458 132 101 101
   query83  291 261 259 259
   query84  299 113 87  87
   query85  798 385 327 327
   query86  383 309 293 293
   query87  4449453344024402
   query88  3819241924022402
   query89  416 317 298 298
   query90  1833215 205 205
   query91  147 153 120 120
   query92  81  64  57  57
   query93  1919984 616 616
   query94  667 426 308 308
   query95  395 312 304 304
   query96  541 600 295 295
   query97  2738284427272727
   query98  256 211 200 200
   query99  1457140313081308
   Total cold run time: 283811 ms
   Total hot run time: 195146 ms
   ```
   
   


-- 
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

Re: [PR] [bugfix](query) Fix for incorrect query results of variant type [doris]

2025-06-11 Thread via GitHub


doris-robot commented on PR #51651:
URL: https://github.com/apache/doris/pull/51651#issuecomment-2963414665

   
   
   TPC-H: Total hot run time: 33472 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 801a6ec319d106eda5ee124d8f22f1eda0fab7cb, 
data reload: false
   
   -- Round 1 --
   q1   25956   509449804980
   q2   1956286 190 190
   q3   10339   1265677 677
   q4   10277   1021518 518
   q5   8266234723332333
   q6   182 161 133 133
   q7   918 725 619 619
   q8   9316124110541054
   q9   6856506150745061
   q10  6817233418881888
   q11  490 296 274 274
   q12  346 352 214 214
   q13  17767   369330713071
   q14  247 229 211 211
   q15  559 484 478 478
   q16  425 427 380 380
   q17  607 861 357 357
   q18  7612719970167016
   q19  1414959 548 548
   q20  346 336 222 222
   q21  3742313222982298
   q22  10471019950 950
   Total cold run time: 115485 ms
   Total hot run time: 33472 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5088501550445015
   q2   235 323 221 221
   q3   2203264323112311
   q4   1371174113241324
   q5   4423436543964365
   q6   210 171 130 130
   q7   1981196517431743
   q8   2571254025012501
   q9   7304726970447044
   q10  3024320027872787
   q11  581 515 505 505
   q12  656 764 619 619
   q13  3447390832893289
   q14  281 297 276 276
   q15  524 491 482 482
   q16  456 495 431 431
   q17  1138155413691369
   q18  7763744574527445
   q19  804 831 884 831
   q20  2002205718611861
   q21  4803442345284423
   q22  1072107510461046
   Total cold run time: 51937 ms
   Total hot run time: 50018 ms
   ```
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [bugfix](query) Fix for incorrect query results of variant type [doris]

2025-06-11 Thread via GitHub


felixwluo commented on PR #51651:
URL: https://github.com/apache/doris/pull/51651#issuecomment-2963350397

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [bugfix](query) Fix for incorrect query results of variant type [doris]

2025-06-11 Thread via GitHub


doris-robot commented on PR #51651:
URL: https://github.com/apache/doris/pull/51651#issuecomment-2963187421

   
   
   ClickBench: Total hot run time: 29.3 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit e4a3597c7a9b61f5e3a5ee8d9dc387890d594bef, 
data reload: false
   
   query1   0.040.030.04
   query2   0.120.120.12
   query3   0.260.200.19
   query4   1.590.190.11
   query5   0.450.400.42
   query6   1.170.660.67
   query7   0.020.010.01
   query8   0.050.040.03
   query9   0.580.540.53
   query10  0.570.580.59
   query11  0.150.110.11
   query12  0.150.110.11
   query13  0.620.580.60
   query14  0.790.810.81
   query15  0.870.840.85
   query16  0.410.380.38
   query17  1.081.081.02
   query18  0.230.210.22
   query19  1.951.841.87
   query20  0.010.010.02
   query21  15.39   0.890.54
   query22  0.741.040.98
   query23  14.80   1.420.66
   query24  7.742.270.66
   query25  0.480.090.09
   query26  0.650.170.15
   query27  0.050.050.05
   query28  9.500.840.45
   query29  12.53   4.023.35
   query30  0.240.100.06
   query31  2.820.610.39
   query32  3.230.560.47
   query33  3.053.173.09
   query34  15.64   5.124.50
   query35  4.554.494.49
   query36  0.680.490.48
   query37  0.090.060.06
   query38  0.040.040.04
   query39  0.040.030.02
   query40  0.160.130.13
   query41  0.090.030.02
   query42  0.030.030.02
   query43  0.040.040.03
   Total cold run time: 103.69 s
   Total hot run time: 29.3 s
   ```
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [bugfix](query) Fix for incorrect query results of variant type [doris]

2025-06-11 Thread via GitHub


doris-robot commented on PR #51651:
URL: https://github.com/apache/doris/pull/51651#issuecomment-2963169517

   
   
   TPC-DS: Total hot run time: 193292 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 e4a3597c7a9b61f5e3a5ee8d9dc387890d594bef, 
data reload: false
   
   query1   1388109710671067
   query2   6125183018181818
   query3   11000   452744514451
   query4   53425   25326   23371   23371
   query5   5258489 457 457
   query6   401 215 199 199
   query7   5204509 293 293
   query8   305 238 211 211
   query9   6993262626412626
   query10  396 317 272 272
   query11  15185   14955   14837   14837
   query12  153 109 107 107
   query13  1202513 407 407
   query14  10046   627463456274
   query15  214 195 192 192
   query16  7002687 483 483
   query17  1093761 624 624
   query18  1534411 320 320
   query19  207 196 171 171
   query20  123 124 125 124
   query21  214 131 117 117
   query22  4448457845104510
   query23  34311   33668   33639   33639
   query24  6650242324042404
   query25  473 476 404 404
   query26  705 283 159 159
   query27  2406515 352 352
   query28  2970217721892177
   query29  595 580 431 431
   query30  274 218 192 192
   query31  897 860 772 772
   query32  75  66  60  60
   query33  460 361 321 321
   query34  779 902 525 525
   query35  785 840 769 769
   query36  964 993 899 899
   query37  108 100 80  80
   query38  4238440841464146
   query39  1509150714561456
   query40  209 128 112 112
   query41  63  61  57  57
   query42  129 124 112 112
   query43  502 493 484 484
   query44  1360828 849 828
   query45  180 176 176 176
   query46  850 1028653 653
   query47  1853187818171817
   query48  396 425 311 311
   query49  659 482 402 402
   query50  650 736 413 413
   query51  4189428342644264
   query52  108 112 96  96
   query53  223 259 182 182
   query54  578 583 537 537
   query55  82  88  80  80
   query56  301 314 316 314
   query57  1237123312181218
   query58  279 275 266 266
   query59  2532270626962696
   query60  343 330 335 330
   query61  130 124 132 124
   query62  786 719 663 663
   query63  236 202 200 200
   query64  17841035693 693
   query65  4290416941554155
   query66  734 399 349 349
   query67  15997   15771   15259   15259
   query68  7643890 524 524
   query69  569 308 268 268
   query70  1172113610971097
   query71  499 314 303 303
   query72  5982487249844872
   query73  1208716 363 363
   query74  9325911090799079
   query75  3822319727132713
   query76  42771190768 768
   query77  642 379 292 292
   query78  10089   10308   93809380
   query79  2022806 585 585
   query80  589 509 507 507
   query81  481 261 222 222
   query82  431 126 102 102
   query83  259 248 230 230
   query84  295 103 88  88
   query85  806 358 311 311
   query86  406 319 296 296
   query87  4447444143104310
   query88  3254228422712271
   query89  395 367 284 284
   query90  1836207 203 203
   query91  145 140 112 112
   query92  74  59  59  59
   query93  1768916 565 565
   query94  660 408 299 299
   query95  366 297 279 279
   query96  505 576 280 280
   query97  2726275826802680
   query98  228 205 199 199
   query99  1433136812431243
   Total cold run time: 299149 ms
   Total hot run time: 193292 ms
   ```
   
   


-- 
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 

Re: [PR] [bugfix](query) Fix for incorrect query results of variant type [doris]

2025-06-11 Thread via GitHub


doris-robot commented on PR #51651:
URL: https://github.com/apache/doris/pull/51651#issuecomment-2963126067

   
   
   TPC-H: Total hot run time: 34228 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit e4a3597c7a9b61f5e3a5ee8d9dc387890d594bef, 
data reload: false
   
   -- Round 1 --
   q1   26731   517051365136
   q2   1984298 188 188
   q3   10279   1283695 695
   q4   10210   1015531 531
   q5   7527238223562356
   q6   193 165 132 132
   q7   933 735 611 611
   q8   9313146212231223
   q9   6964525951745174
   q10  6886232819061906
   q11  499 286 274 274
   q12  337 348 212 212
   q13  17779   372030533053
   q14  234 230 214 214
   q15  556 488 486 486
   q16  428 427 369 369
   q17  599 888 379 379
   q18  7549722272347222
   q19  1901977 558 558
   q20  325 332 210 210
   q21  3782315823292329
   q22  10211014970 970
   Total cold run time: 116030 ms
   Total hot run time: 34228 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5321503752125037
   q2   246 321 220 220
   q3   2173266622502250
   q4   1309178514731473
   q5   4475440643594359
   q6   226 163 131 131
   q7   1979192317831783
   q8   2748262525632563
   q9   7243722970427042
   q10  3006321227422742
   q11  588 511 490 490
   q12  687 764 618 618
   q13  3506397232743274
   q14  294 306 284 284
   q15  525 468 477 468
   q16  432 475 446 446
   q17  1180154613991399
   q18  7846750373697369
   q19  845 824 931 824
   q20  2028197518301830
   q21  4883455443884388
   q22  1137104110071007
   Total cold run time: 52677 ms
   Total hot run time: 49997 ms
   ```
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [bugfix](query) Fix for incorrect query results of variant type [doris]

2025-06-11 Thread via GitHub


github-actions[bot] commented on PR #51651:
URL: https://github.com/apache/doris/pull/51651#issuecomment-2963048901

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


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [bugfix](query) Fix for incorrect query results of variant type [doris]

2025-06-11 Thread via GitHub


github-actions[bot] commented on PR #51651:
URL: https://github.com/apache/doris/pull/51651#issuecomment-2963049034

   PR approved by anyone and no changes requested.


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [bugfix](query) Fix for incorrect query results of variant type [doris]

2025-06-11 Thread via GitHub


felixwluo commented on PR #51651:
URL: https://github.com/apache/doris/pull/51651#issuecomment-2963012670

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [bugfix](query) Fix for incorrect query results of variant type [doris]

2025-06-11 Thread via GitHub


hello-stephen commented on PR #51651:
URL: https://github.com/apache/doris/pull/51651#issuecomment-2963011045

   
   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]