Re: [PR] branch-3.0: [fix](nereids)canInferNotNullForMarkSlot method get wrong result if fold constant rule is disabled [doris]

2025-04-21 Thread via GitHub


dataroaring merged PR #49650:
URL: https://github.com/apache/doris/pull/49650


-- 
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] branch-3.0: [fix](nereids)canInferNotNullForMarkSlot method get wrong result if fold constant rule is disabled [doris]

2025-04-05 Thread via GitHub


starocean999 commented on PR #49650:
URL: https://github.com/apache/doris/pull/49650#issuecomment-2761474747

   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] branch-3.0: [fix](nereids)canInferNotNullForMarkSlot method get wrong result if fold constant rule is disabled [doris]

2025-04-01 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 31.53 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 294f67561912fd7d31802317541b99950cd272bc, 
data reload: false
   
   query1   0.030.020.03
   query2   0.060.030.03
   query3   0.230.060.06
   query4   1.620.100.11
   query5   0.520.500.51
   query6   1.130.730.72
   query7   0.020.020.03
   query8   0.040.030.04
   query9   0.560.510.50
   query10  0.560.540.53
   query11  0.150.110.10
   query12  0.140.110.11
   query13  0.610.590.60
   query14  2.752.822.74
   query15  0.900.830.82
   query16  0.370.390.39
   query17  0.981.021.05
   query18  0.240.230.22
   query19  1.811.902.05
   query20  0.010.010.01
   query21  15.36   0.570.54
   query22  2.593.141.24
   query23  17.07   0.790.68
   query24  3.071.051.59
   query25  0.260.150.05
   query26  0.500.140.13
   query27  0.050.030.05
   query28  10.28   0.500.46
   query29  12.91   3.283.28
   query30  0.250.060.06
   query31  2.850.380.38
   query32  3.270.460.46
   query33  2.983.043.02
   query34  17.11   4.484.49
   query35  4.544.484.49
   query36  0.670.500.48
   query37  0.100.060.06
   query38  0.050.040.04
   query39  0.040.020.02
   query40  0.160.120.13
   query41  0.070.020.02
   query42  0.030.020.03
   query43  0.040.020.02
   Total cold run time: 106.98 s
   Total hot run time: 31.53 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] branch-3.0: [fix](nereids)canInferNotNullForMarkSlot method get wrong result if fold constant rule is disabled [doris]

2025-04-01 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 40011 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 294f67561912fd7d31802317541b99950cd272bc, 
data reload: false
   
   -- Round 1 --
   q1   17660   670265756575
   q2   2066163 176 163
   q3   10640   106911771069
   q4   10560   771 715 715
   q5   7716285028342834
   q6   221 133 130 130
   q7   954 613 607 607
   q8   9346193619991936
   q9   6532641064626410
   q10  6994231622932293
   q11  458 258 256 256
   q12  394 216 209 209
   q13  17762   299129902990
   q14  241 205 211 205
   q15  505 466 467 466
   q16  652 598 576 576
   q17  960 561 649 561
   q18  7111671166526652
   q19  1385104910651049
   q20  468 206 205 205
   q21  3931314331463143
   q22  1091967 997 967
   Total cold run time: 107647 ms
   Total hot run time: 40011 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   6593664465816581
   q2   334 233 226 226
   q3   2908275528142755
   q4   2051181717591759
   q5   5818570957185709
   q6   214 130 133 130
   q7   2210181118011801
   q8   3334356735113511
   q9   8865889288208820
   q10  3574353135233523
   q11  583 488 472 472
   q12  794 638 643 638
   q13  9378324030933093
   q14  301 282 270 270
   q15  518 481 470 470
   q16  700 651 639 639
   q17  1818162215951595
   q18  8319772876827682
   q19  1662154615211521
   q20  2113184718761847
   q21  5475526753855267
   q22  1114105010511050
   Total cold run time: 68676 ms
   Total hot run time: 59359 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] branch-3.0: [fix](nereids)canInferNotNullForMarkSlot method get wrong result if fold constant rule is disabled [doris]

2025-04-01 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 197260 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 294f67561912fd7d31802317541b99950cd272bc, 
data reload: false
   
   query1   1291911 888 888
   query2   6227207120092009
   query3   10829   433643374336
   query4   65471   28783   23754   23754
   query5   4898459 447 447
   query6   407 175 174 174
   query7   5561306 312 306
   query8   316 220 222 220
   query9   8576261426102610
   query10  473 289 258 258
   query11  17256   15184   16018   15184
   query12  157 107 109 107
   query13  1560459 434 434
   query14  10209   770271327132
   query15  206 185 184 184
   query16  7247482 485 482
   query17  1092610 605 605
   query18  1843323 319 319
   query19  213 157 158 157
   query20  114 115 112 112
   query21  211 101 102 101
   query22  4915462244024402
   query23  34455   33792   33900   33792
   query24  6241296428652865
   query25  520 438 430 430
   query26  657 179 169 169
   query27  1819373 360 360
   query28  4258247624012401
   query29  670 441 433 433
   query30  242 157 159 157
   query31  981 861 831 831
   query32  68  56  54  54
   query33  479 299 309 299
   query34  914 512 520 512
   query35  859 735 719 719
   query36  1079960 1002960
   query37  115 66  68  66
   query38  4055412641194119
   query39  1539147014901470
   query40  221 98  100 98
   query41  51  47  44  44
   query42  116 101 102 101
   query43  518 484 501 484
   query44  1188826 810 810
   query45  183 167 170 167
   query46  1162732 748 732
   query47  2061195519511951
   query48  481 387 373 373
   query49  735 417 406 406
   query50  863 429 449 429
   query51  7490710970157015
   query52  98  87  87  87
   query53  246 177 177 177
   query54  558 454 438 438
   query55  78  71  73  71
   query56  262 243 243 243
   query57  1247113110951095
   query58  228 203 201 201
   query59  3216298829462946
   query60  282 253 257 253
   query61  114 111 139 111
   query62  803 665 680 665
   query63  223 190 188 188
   query64  1347652 642 642
   query65  3265320531973197
   query66  696 297 310 297
   query67  15861   15604   15718   15604
   query68  3986600 558 558
   query69  425 267 268 267
   query70  1210110811291108
   query71  358 257 253 253
   query72  6395414540174017
   query73  754 352 354 352
   query74  10164   918090199019
   query75  3365264326522643
   query76  1908100010811000
   query77  486 281 267 267
   query78  10578   961796279617
   query79  1512589 598 589
   query80  886 427 418 418
   query81  515 242 236 236
   query82  128790  85  85
   query83  237 143 137 137
   query84  284 75  77  75
   query85  880 299 291 291
   query86  335 297 299 297
   query87  4604425843634258
   query88  3691242323612361
   query89  415 292 298 292
   query90  2023184 186 184
   query91  182 149 146 146
   query92  71  48  50  48
   query93  1872549 555 549
   query94  855 306 298 298
   query95  363 264 263 263
   query96  623 287 286 286
   query97  3383318631513151
   query98  218 197 195 195
   query99  1537131713201317
   Total cold run time: 317018 ms
   Total hot run time: 197260 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

Re: [PR] branch-3.0: [fix](nereids)canInferNotNullForMarkSlot method get wrong result if fold constant rule is disabled [doris]

2025-04-01 Thread via GitHub


starocean999 commented on PR #49650:
URL: https://github.com/apache/doris/pull/49650#issuecomment-2768872406

   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] branch-3.0: [fix](nereids)canInferNotNullForMarkSlot method get wrong result if fold constant rule is disabled [doris]

2025-03-30 Thread via GitHub


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

   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] branch-3.0: [fix](nereids)canInferNotNullForMarkSlot method get wrong result if fold constant rule is disabled [doris]

2025-03-29 Thread via GitHub


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

   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] branch-3.0: [fix](nereids)canInferNotNullForMarkSlot method get wrong result if fold constant rule is disabled [doris]

2025-03-28 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 32.53 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 39c6c98e2b5c2ed1919efcaa38b3fa50cb15ea6c, 
data reload: false
   
   query1   0.040.030.03
   query2   0.060.030.03
   query3   0.230.070.07
   query4   1.630.110.10
   query5   0.520.510.51
   query6   1.140.730.73
   query7   0.020.020.01
   query8   0.040.030.03
   query9   0.550.490.49
   query10  0.540.540.55
   query11  0.140.100.11
   query12  0.140.110.11
   query13  0.610.590.59
   query14  2.862.762.87
   query15  0.890.830.82
   query16  0.380.390.41
   query17  1.031.041.07
   query18  0.240.210.21
   query19  1.971.861.91
   query20  0.020.010.01
   query21  15.36   0.580.57
   query22  2.512.451.99
   query23  16.98   0.990.83
   query24  2.971.461.06
   query25  0.150.090.09
   query26  0.560.140.14
   query27  0.050.050.05
   query28  10.00   0.490.51
   query29  12.62   3.273.25
   query30  0.240.060.06
   query31  2.850.390.38
   query32  3.260.450.45
   query33  2.973.013.00
   query34  16.86   4.524.45
   query35  4.544.534.49
   query36  0.670.500.50
   query37  0.090.060.06
   query38  0.050.030.03
   query39  0.040.030.02
   query40  0.150.120.12
   query41  0.080.020.02
   query42  0.040.020.03
   query43  0.040.030.03
   Total cold run time: 106.13 s
   Total hot run time: 32.53 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] branch-3.0: [fix](nereids)canInferNotNullForMarkSlot method get wrong result if fold constant rule is disabled [doris]

2025-03-28 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 196787 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 39c6c98e2b5c2ed1919efcaa38b3fa50cb15ea6c, 
data reload: false
   
   query1   1293927 901 901
   query2   6218200620132006
   query3   10817   447544584458
   query4   65614   28754   23159   23159
   query5   4998450 451 450
   query6   411 179 170 170
   query7   5591307 324 307
   query8   319 226 227 226
   query9   9139260125982598
   query10  465 292 257 257
   query11  17381   15053   15671   15053
   query12  160 112 102 102
   query13  1489454 438 438
   query14  10321   746173057305
   query15  209 194 181 181
   query16  7142502 470 470
   query17  1091608 599 599
   query18  1903329 317 317
   query19  215 159 166 159
   query20  121 114 116 114
   query21  210 102 110 102
   query22  4854460345044504
   query23  34381   33972   33807   33807
   query24  6208292730052927
   query25  528 435 421 421
   query26  657 175 171 171
   query27  1836361 376 361
   query28  3848250724272427
   query29  734 445 438 438
   query30  236 161 161 161
   query31  1028816 838 816
   query32  67  55  59  55
   query33  439 310 292 292
   query34  923 508 518 508
   query35  850 754 748 748
   query36  1062977 947 947
   query37  113 64  68  64
   query38  4107406040594059
   query39  1499148414701470
   query40  203 107 104 104
   query41  50  46  46  46
   query42  109 98  106 98
   query43  527 507 497 497
   query44  1194820 832 820
   query45  188 170 165 165
   query46  1150749 719 719
   query47  2026191419111911
   query48  485 379 382 379
   query49  733 398 384 384
   query50  853 435 444 435
   query51  7317703070177017
   query52  95  90  88  88
   query53  262 179 181 179
   query54  560 449 452 449
   query55  83  78  81  78
   query56  247 235 240 235
   query57  1256110511081105
   query58  232 207 217 207
   query59  3060293729902937
   query60  270 261 253 253
   query61  111 108 111 108
   query62  796 661 659 659
   query63  218 191 187 187
   query64  1375666 637 637
   query65  3251316432023164
   query66  707 299 318 299
   query67  15934   15631   15615   15615
   query68  4132597 562 562
   query69  428 263 265 263
   query70  1184106210621062
   query71  358 261 259 259
   query72  6375401039643964
   query73  756 349 345 345
   query74  10294   917190299029
   query75  3374265626812656
   query76  1974105411051054
   query77  516 279 273 273
   query78  10496   960195749574
   query79  1206599 607 599
   query80  834 429 429 429
   query81  503 243 238 238
   query82  128189  90  89
   query83  162 147 143 143
   query84  279 82  74  74
   query85  861 312 292 292
   query86  313 299 303 299
   query87  4416440042604260
   query88  3602246523512351
   query89  413 289 287 287
   query90  2020185 189 185
   query91  183 143 146 143
   query92  61  51  50  50
   query93  1282550 560 550
   query94  793 285 271 271
   query95  363 253 263 253
   query96  609 278 274 274
   query97  3331323831543154
   query98  215 201 197 197
   query99  1545128512921285
   Total cold run time: 315928 ms
   Total hot run time: 196787 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

Re: [PR] branch-3.0: [fix](nereids)canInferNotNullForMarkSlot method get wrong result if fold constant rule is disabled [doris]

2025-03-28 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 40316 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 39c6c98e2b5c2ed1919efcaa38b3fa50cb15ea6c, 
data reload: false
   
   -- Round 1 --
   q1   17607   672066126612
   q2   2064175 167 167
   q3   10626   107412441074
   q4   10538   780 833 780
   q5   7739284328382838
   q6   218 136 136 136
   q7   971 625 623 623
   q8   9360195320331953
   q9   6539636863766368
   q10  6976228222992282
   q11  454 256 263 256
   q12  405 214 212 212
   q13  17810   298330772983
   q14  241 201 210 201
   q15  512 458 459 458
   q16  643 587 584 584
   q17  981 596 592 592
   q18  7270656065946560
   q19  1393103711001037
   q20  480 225 210 210
   q21  4062342033993399
   q22  1074997 991 991
   Total cold run time: 107963 ms
   Total hot run time: 40316 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   6555653365316531
   q2   329 233 227 227
   q3   2930278830182788
   q4   2037178017731773
   q5   5771573157345731
   q6   219 131 135 131
   q7   2309184818411841
   q8   3420353635793536
   q9   8789891488238823
   q10  3583351035043504
   q11  590 501 495 495
   q12  847 596 635 596
   q13  8927324231973197
   q14  300 282 278 278
   q15  515 470 464 464
   q16  693 676 670 670
   q17  1836159916071599
   q18  8197765576237623
   q19  1666153915041504
   q20  2133184318841843
   q21  5564532453705324
   q22  11351076972 972
   Total cold run time: 68345 ms
   Total hot run time: 59450 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] branch-3.0: [fix](nereids)canInferNotNullForMarkSlot method get wrong result if fold constant rule is disabled [doris]

2025-03-28 Thread via GitHub


starocean999 commented on PR #49650:
URL: https://github.com/apache/doris/pull/49650#issuecomment-2763108572

   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] branch-3.0: [fix](nereids)canInferNotNullForMarkSlot method get wrong result if fold constant rule is disabled [doris]

2025-03-28 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 32.6 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 483a2a9009285c70136c2ab6a77064770657e15e, 
data reload: false
   
   query1   0.030.030.03
   query2   0.070.040.03
   query3   0.230.060.06
   query4   1.620.110.10
   query5   0.520.510.51
   query6   1.140.730.73
   query7   0.020.010.01
   query8   0.040.030.03
   query9   0.560.520.49
   query10  0.560.560.56
   query11  0.150.110.09
   query12  0.130.120.12
   query13  0.600.610.60
   query14  2.732.722.82
   query15  0.900.830.84
   query16  0.380.410.41
   query17  1.021.020.99
   query18  0.230.230.21
   query19  1.881.852.04
   query20  0.010.010.01
   query21  15.37   0.600.57
   query22  2.392.082.06
   query23  16.92   0.990.94
   query24  3.350.980.95
   query25  0.270.050.12
   query26  0.530.140.15
   query27  0.050.040.05
   query28  10.34   0.490.49
   query29  12.61   3.223.22
   query30  0.240.060.06
   query31  2.850.380.39
   query32  3.250.460.45
   query33  2.982.993.01
   query34  17.23   4.544.57
   query35  4.524.554.57
   query36  0.680.500.48
   query37  0.090.060.07
   query38  0.040.030.04
   query39  0.030.020.03
   query40  0.160.130.13
   query41  0.090.030.02
   query42  0.030.020.02
   query43  0.030.030.03
   Total cold run time: 106.87 s
   Total hot run time: 32.6 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] branch-3.0: [fix](nereids)canInferNotNullForMarkSlot method get wrong result if fold constant rule is disabled [doris]

2025-03-28 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 196986 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 483a2a9009285c70136c2ab6a77064770657e15e, 
data reload: false
   
   query1   1278922 909 909
   query2   6241198820411988
   query3   10940   439544424395
   query4   65733   28743   23272   23272
   query5   4962447 449 447
   query6   406 174 176 174
   query7   5540320 312 312
   query8   322 230 221 221
   query9   9014260525792579
   query10  467 268 261 261
   query11  17184   15495   15843   15495
   query12  156 105 105 105
   query13  1478458 426 426
   query14  10863   720468426842
   query15  205 191 184 184
   query16  7029495 498 495
   query17  1089593 605 593
   query18  1868335 321 321
   query19  219 162 163 162
   query20  120 109 112 109
   query21  213 104 101 101
   query22  470043504350
   query23  34555   34069   34588   34069
   query24  6221294929192919
   query25  545 421 424 421
   query26  655 175 174 174
   query27  2130351 362 351
   query28  4316248024402440
   query29  711 466 458 458
   query30  239 169 167 167
   query31  1006836 866 836
   query32  69  57  57  57
   query33  398 289 295 289
   query34  904 504 523 504
   query35  879 746 712 712
   query36  1066980 989 980
   query37  115 68  75  68
   query38  4093400540514005
   query39  1699147214771472
   query40  207 99  102 99
   query41  52  47  48  47
   query42  114 109 102 102
   query43  536 500 482 482
   query44  1202837 837 837
   query45  188 167 172 167
   query46  1122746 738 738
   query47  1977192119391921
   query48  479 392 381 381
   query49  730 385 384 384
   query50  833 433 432 432
   query51  7429720969726972
   query52  103 90  92  90
   query53  269 191 183 183
   query54  560 457 452 452
   query55  78  79  80  79
   query56  260 237 250 237
   query57  1215117811351135
   query58  208 202 212 202
   query59  3058287227792779
   query60  279 267 251 251
   query61  106 105 107 105
   query62  760 680 679 679
   query63  222 196 203 196
   query64  1377685 622 622
   query65  3285317931993179
   query66  658 303 294 294
   query67  16081   15760   15645   15645
   query68  4046574 576 574
   query69  418 268 268 268
   query70  1185112711001100
   query71  344 260 267 260
   query72  6415436639783978
   query73  756 353 350 350
   query74  10456   891889358918
   query75  3327264226332633
   query76  1938103810581038
   query77  510 281 307 281
   query78  10604   970297569702
   query79  1204609 611 609
   query80  866 434 440 434
   query81  506 241 244 241
   query82  128396  88  88
   query83  257 143 146 143
   query84  284 88  79  79
   query85  893 307 297 297
   query86  348 304 292 292
   query87  4429424943394249
   query88  3740240023712371
   query89  423 295 293 293
   query90  1956191 189 189
   query91  178 150 153 150
   query92  69  53  53  53
   query93  1273558 558 558
   query94  772 296 303 296
   query95  365 257 261 257
   query96  612 273 281 273
   query97  3329318432353184
   query98  226 208 204 204
   query99  1538131712711271
   Total cold run time: 317566 ms
   Total hot run time: 196986 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

Re: [PR] branch-3.0: [fix](nereids)canInferNotNullForMarkSlot method get wrong result if fold constant rule is disabled [doris]

2025-03-28 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 40104 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 483a2a9009285c70136c2ab6a77064770657e15e, 
data reload: false
   
   -- Round 1 --
   q1   17583   701366306630
   q2   2070175 172 172
   q3   10645   112112021121
   q4   10557   735 769 735
   q5   7772285828312831
   q6   221 137 134 134
   q7   971 616 607 607
   q8   9358191320641913
   q9   6532639164306391
   q10  7028219123022191
   q11  461 258 260 258
   q12  414 210 208 208
   q13  17800   301930093009
   q14  239 209 208 208
   q15  502 450 475 450
   q16  661 572 597 572
   q17  974 563 578 563
   q18  7209673466146614
   q19  1395108711131087
   q20  472 206 203 203
   q21  3993327132093209
   q22  1092998 1008998
   Total cold run time: 107949 ms
   Total hot run time: 40104 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   6645657465736573
   q2   327 234 238 234
   q3   2914272829012728
   q4   2018176817651765
   q5   5778582757695769
   q6   211 135 131 131
   q7   2271185218141814
   q8   3415356735853567
   q9   8869895788818881
   q10  3568356335283528
   q11  601 499 498 498
   q12  798 611 617 611
   q13  8515332531943194
   q14  311 286 291 286
   q15  499 484 454 454
   q16  701 642 655 642
   q17  1843163116261626
   q18  8211772076727672
   q19  1645156015241524
   q20  2142187619031876
   q21  5645546353825382
   q22  1135107810401040
   Total cold run time: 68062 ms
   Total hot run time: 59795 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] branch-3.0: [fix](nereids)canInferNotNullForMarkSlot method get wrong result if fold constant rule is disabled [doris]

2025-03-28 Thread via GitHub


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

   
   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]