You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "linrrzqqq (via GitHub)" <gi...@apache.org> on 2025/11/05 04:00:12 UTC
[PR] [Fix](funtion) Fix utc_time result when input null [doris]
linrrzqqq opened a new pull request, #57716:
URL: https://github.com/apache/doris/pull/57716
### What problem does this PR solve?
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
Before:
```text
mysql> select utc_time(NULL);
+----------------+
| utc_time(NULL) |
+----------------+
| 00:00:00 |
+----------------+
```
After(throw error same with MySQL):
```text
mysql> select utc_time(NULL);
ERROR 1105 (HY000): errCode = 2, detailMessage = UTC_TIME argument cannot be NULL.
```
### Release note
None
### Check List (For Author)
- Test <!-- At least one of them must be included. -->
- [ ] Regression test
- [ ] Unit Test
- [ ] Manual test (add detailed scripts or steps below)
- [ ] No need to test or manual test. Explain why:
- [ ] This is a refactor/code format and no logic has been changed.
- [ ] Previous test can cover this change.
- [ ] No code files have been changed.
- [ ] Other reason <!-- Add your reason? -->
- Behavior changed:
- [ ] No.
- [ ] Yes. <!-- Explain the behavior change -->
- Does this need documentation?
- [ ] No.
- [x] Yes. https://github.com/apache/doris-website/pull/3009
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into -->
--
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](funtion) Fix utc_time result when input null [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #57716:
URL: https://github.com/apache/doris/pull/57716#issuecomment-3489185318
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] [Fix](funtion) Fix utc_time result when input null [doris]
Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb merged PR #57716:
URL: https://github.com/apache/doris/pull/57716
--
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](funtion) Fix utc_time result when input null [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #57716:
URL: https://github.com/apache/doris/pull/57716#issuecomment-3489266026
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: 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](funtion) Fix utc_time result when input null [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57716:
URL: https://github.com/apache/doris/pull/57716#issuecomment-3489955640
# FE UT Coverage Report
Increment line coverage ` 0.00% (0/10)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/57716_0ce8fb867802bbaac003948b3ebabd7407a0c2dc/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/57716_0ce8fb867802bbaac003948b3ebabd7407a0c2dc/fe_report/index.html)
--
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](funtion) Fix utc_time result when input null [doris]
Posted by "linrrzqqq (via GitHub)" <gi...@apache.org>.
linrrzqqq commented on PR #57716:
URL: https://github.com/apache/doris/pull/57716#issuecomment-3489724346
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](funtion) Fix utc_time result when input null [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #57716:
URL: https://github.com/apache/doris/pull/57716#issuecomment-3490497935
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: 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](funtion) Fix utc_time result when input null [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57716:
URL: https://github.com/apache/doris/pull/57716#issuecomment-3489276529
<details>
<summary>ClickBench: <b>Total hot run time: 27.55 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 7c1bb4d05006872d12bf04f4a742ec694abeba3c, data reload: false
query1 0.06 0.04 0.04
query2 0.09 0.06 0.05
query3 0.25 0.08 0.08
query4 1.61 0.12 0.11
query5 0.27 0.26 0.25
query6 1.19 0.64 0.64
query7 0.03 0.03 0.03
query8 0.06 0.05 0.04
query9 0.59 0.53 0.53
query10 0.57 0.57 0.56
query11 0.16 0.11 0.11
query12 0.16 0.12 0.11
query13 0.62 0.61 0.61
query14 0.99 1.00 1.00
query15 0.85 0.83 0.85
query16 0.40 0.39 0.39
query17 1.04 1.06 1.05
query18 0.22 0.21 0.20
query19 1.87 1.84 1.81
query20 0.01 0.01 0.01
query21 15.47 0.19 0.13
query22 4.99 0.06 0.04
query23 15.67 0.25 0.10
query24 2.76 0.57 0.44
query25 0.08 0.07 0.06
query26 0.14 0.13 0.14
query27 0.07 0.06 0.05
query28 4.85 1.12 0.93
query29 12.56 3.86 3.28
query30 0.28 0.14 0.12
query31 2.81 0.59 0.38
query32 3.23 0.55 0.47
query33 2.99 2.99 3.09
query34 15.80 5.17 4.58
query35 4.54 4.56 4.55
query36 0.68 0.50 0.49
query37 0.10 0.07 0.07
query38 0.06 0.04 0.04
query39 0.04 0.03 0.04
query40 0.17 0.15 0.13
query41 0.09 0.04 0.03
query42 0.04 0.03 0.03
query43 0.04 0.03 0.04
Total cold run time: 98.5 s
Total hot run time: 27.55 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](funtion) Fix utc_time result when input null [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57716:
URL: https://github.com/apache/doris/pull/57716#issuecomment-3489360823
# FE UT Coverage Report
Increment line coverage ` 0.00% (0/10)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/57716_7c1bb4d05006872d12bf04f4a742ec694abeba3c/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/57716_7c1bb4d05006872d12bf04f4a742ec694abeba3c/fe_report/index.html)
--
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](funtion) Fix utc_time result when input null [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #57716:
URL: https://github.com/apache/doris/pull/57716#issuecomment-3489266092
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: 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](funtion) Fix utc_time result when input null [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57716:
URL: https://github.com/apache/doris/pull/57716#issuecomment-3489868561
<details>
<summary>ClickBench: <b>Total hot run time: 27.42 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 0ce8fb867802bbaac003948b3ebabd7407a0c2dc, data reload: false
query1 0.05 0.05 0.05
query2 0.09 0.04 0.05
query3 0.24 0.08 0.08
query4 1.61 0.12 0.12
query5 0.27 0.26 0.25
query6 1.17 0.66 0.64
query7 0.02 0.02 0.02
query8 0.05 0.04 0.05
query9 0.61 0.52 0.53
query10 0.57 0.58 0.56
query11 0.16 0.11 0.11
query12 0.16 0.12 0.13
query13 0.61 0.61 0.61
query14 1.01 1.00 1.00
query15 0.84 0.82 0.82
query16 0.39 0.39 0.42
query17 1.03 1.05 1.00
query18 0.21 0.20 0.20
query19 1.95 1.84 1.74
query20 0.02 0.02 0.02
query21 15.45 0.17 0.13
query22 5.19 0.06 0.05
query23 15.67 0.25 0.10
query24 2.94 1.14 0.42
query25 0.08 0.06 0.05
query26 0.15 0.14 0.14
query27 0.08 0.05 0.06
query28 4.78 1.12 0.93
query29 12.58 3.89 3.21
query30 0.28 0.13 0.12
query31 2.82 0.61 0.39
query32 3.24 0.55 0.47
query33 3.09 3.06 3.05
query34 15.87 5.15 4.54
query35 4.53 4.61 4.60
query36 0.67 0.49 0.50
query37 0.10 0.07 0.07
query38 0.06 0.04 0.03
query39 0.04 0.03 0.03
query40 0.18 0.14 0.15
query41 0.09 0.04 0.03
query42 0.03 0.02 0.02
query43 0.03 0.03 0.04
Total cold run time: 99.01 s
Total hot run time: 27.42 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](funtion) Fix utc_time result when input null [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57716:
URL: https://github.com/apache/doris/pull/57716#issuecomment-3489264610
<details>
<summary>TPC-DS: <b>Total hot run time: 187816 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 7c1bb4d05006872d12bf04f4a742ec694abeba3c, data reload: false
query1 1077 409 399 399
query2 6548 1675 1744 1675
query3 6758 225 224 224
query4 26382 24153 23085 23085
query5 5897 640 453 453
query6 389 235 223 223
query7 4659 502 298 298
query8 334 257 254 254
query9 8705 2639 2625 2625
query10 570 321 288 288
query11 15650 15101 15024 15024
query12 196 121 117 117
query13 1681 550 434 434
query14 12060 9399 9375 9375
query15 253 188 173 173
query16 7756 688 539 539
query17 1422 802 726 726
query18 2107 466 361 361
query19 281 233 217 217
query20 156 141 140 140
query21 227 141 127 127
query22 4831 4723 4504 4504
query23 35065 33826 33879 33826
query24 9065 2573 2562 2562
query25 653 591 523 523
query26 1242 288 181 181
query27 2746 533 382 382
query28 4415 2261 2254 2254
query29 844 655 587 587
query30 302 247 227 227
query31 928 841 771 771
query32 82 74 70 70
query33 639 401 340 340
query34 849 885 557 557
query35 829 868 786 786
query36 1069 1041 923 923
query37 128 115 82 82
query38 3603 3631 3571 3571
query39 1495 1437 1409 1409
query40 213 123 113 113
query41 60 58 55 55
query42 124 113 110 110
query43 495 494 471 471
query44 1218 735 755 735
query45 178 182 184 182
query46 882 1013 650 650
query47 1759 1804 1777 1777
query48 395 434 324 324
query49 756 496 413 413
query50 640 681 407 407
query51 3864 3974 3870 3870
query52 105 108 100 100
query53 232 265 197 197
query54 339 285 293 285
query55 89 82 78 78
query56 326 323 291 291
query57 1170 1196 1130 1130
query58 289 274 270 270
query59 2570 2669 2493 2493
query60 344 337 319 319
query61 166 170 163 163
query62 795 729 668 668
query63 224 198 199 198
query64 4444 1177 853 853
query65 4063 3957 3942 3942
query66 1033 426 325 325
query67 15380 15375 14950 14950
query68 8558 921 593 593
query69 527 310 280 280
query70 1344 1265 1223 1223
query71 510 345 311 311
query72 5840 2684 5378 2684
query73 791 761 358 358
query74 8818 8861 8861 8861
query75 4051 3351 2785 2785
query76 3869 1158 719 719
query77 802 416 311 311
query78 9605 9721 8973 8973
query79 1480 848 579 579
query80 660 581 501 501
query81 476 254 228 228
query82 451 161 134 134
query83 281 273 250 250
query84 302 108 98 98
query85 891 498 446 446
query86 347 306 295 295
query87 3773 3673 3625 3625
query88 2784 2229 2197 2197
query89 384 337 291 291
query90 2047 210 206 206
query91 164 162 142 142
query92 83 68 63 63
query93 1129 1011 641 641
query94 699 457 335 335
query95 390 318 312 312
query96 483 559 269 269
query97 2960 2980 2889 2889
query98 233 220 220 220
query99 1421 1430 1316 1316
Total cold run time: 280199 ms
Total hot run time: 187816 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](funtion) Fix utc_time result when input null [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57716:
URL: https://github.com/apache/doris/pull/57716#issuecomment-3489853491
<details>
<summary>TPC-DS: <b>Total hot run time: 189995 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 0ce8fb867802bbaac003948b3ebabd7407a0c2dc, data reload: false
query1 1106 403 399 399
query2 6558 1699 1714 1699
query3 6753 231 221 221
query4 26209 23680 23370 23370
query5 5188 656 481 481
query6 343 258 233 233
query7 4656 510 303 303
query8 317 283 275 275
query9 8758 2616 2602 2602
query10 539 342 303 303
query11 15257 15159 14777 14777
query12 198 120 116 116
query13 1704 579 465 465
query14 11309 9417 9518 9417
query15 251 194 183 183
query16 7775 695 536 536
query17 1481 763 607 607
query18 2057 478 362 362
query19 229 230 186 186
query20 143 127 130 127
query21 216 132 121 121
query22 4596 4633 4504 4504
query23 34977 33643 33632 33632
query24 8916 2472 2525 2472
query25 596 519 493 493
query26 1347 302 175 175
query27 3185 561 369 369
query28 4390 2306 2230 2230
query29 786 662 487 487
query30 306 229 209 209
query31 967 885 792 792
query32 92 77 69 69
query33 610 410 340 340
query34 820 900 542 542
query35 826 920 790 790
query36 1021 1046 917 917
query37 140 115 92 92
query38 3737 3669 3532 3532
query39 1466 1396 1409 1396
query40 216 131 117 117
query41 61 57 55 55
query42 124 109 112 109
query43 481 498 478 478
query44 1269 736 738 736
query45 184 174 177 174
query46 898 1006 644 644
query47 1745 1784 1736 1736
query48 396 448 328 328
query49 770 513 425 425
query50 660 695 409 409
query51 3913 3907 3862 3862
query52 106 107 104 104
query53 242 277 201 201
query54 315 297 278 278
query55 87 87 83 83
query56 313 330 319 319
query57 1162 1203 1129 1129
query58 303 281 281 281
query59 2592 2694 2581 2581
query60 373 374 379 374
query61 191 192 186 186
query62 776 731 667 667
query63 237 198 200 198
query64 4537 1257 958 958
query65 4028 3984 4001 3984
query66 1096 459 339 339
query67 15394 15133 14963 14963
query68 8340 944 598 598
query69 516 334 308 308
query70 1335 1309 1301 1301
query71 494 346 316 316
query72 5880 4914 4859 4859
query73 672 593 357 357
query74 9242 8847 8779 8779
query75 4004 3427 2812 2812
query76 3668 1158 747 747
query77 826 429 309 309
query78 9603 9749 8919 8919
query79 2019 876 617 617
query80 652 602 498 498
query81 510 267 230 230
query82 427 169 132 132
query83 287 268 243 243
query84 258 117 91 91
query85 897 483 434 434
query86 346 312 293 293
query87 3699 3722 3702 3702
query88 3748 2264 2247 2247
query89 395 333 293 293
query90 2040 224 226 224
query91 169 168 132 132
query92 78 66 60 60
query93 1366 971 642 642
query94 696 443 349 349
query95 407 323 310 310
query96 491 589 292 292
query97 2955 2986 2871 2871
query98 242 214 208 208
query99 1661 1507 1280 1280
Total cold run time: 280217 ms
Total hot run time: 189995 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](funtion) Fix utc_time result when input null [doris]
Posted by "linrrzqqq (via GitHub)" <gi...@apache.org>.
linrrzqqq commented on PR #57716:
URL: https://github.com/apache/doris/pull/57716#issuecomment-3489187514
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