Skip to content

Conversation

@github-actions
Copy link
Contributor

Cherry-picked from #56648

…, sub_binary for VarBinary type (#56648)

add some functions for varbinary
```text
length(varbinary) -> int
from_base64_binary(string) -> varbinary
to_base64_bianry(varbinary) -> string
sub_binary(varbinary, <pos> [, <len>]) ->varbinary
```
Issue Number: [#56426](#56426)
@github-actions github-actions bot requested a review from yiguolei as a code owner October 26, 2025 13:57
@hello-stephen
Copy link
Contributor

Thank you for your contribution to Apache Doris.
Don't know what should be done next? See 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?

@dataroaring dataroaring reopened this Oct 26, 2025
@hello-stephen
Copy link
Contributor

run buildall

@doris-robot
Copy link

ClickBench: Total hot run time: 29.97 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit c90394edf3c758cd38856a515f3aeb9f3afe57ab, data reload: false

query1	0.05	0.06	0.05
query2	0.10	0.05	0.06
query3	0.25	0.09	0.09
query4	1.61	0.12	0.12
query5	0.28	0.25	0.25
query6	1.19	0.65	0.64
query7	0.03	0.03	0.02
query8	0.06	0.05	0.05
query9	0.59	0.54	0.52
query10	0.60	0.58	0.58
query11	0.16	0.11	0.11
query12	0.15	0.12	0.12
query13	0.62	0.61	0.61
query14	1.04	1.06	1.02
query15	0.87	0.85	0.87
query16	0.41	0.39	0.40
query17	1.08	1.04	1.04
query18	0.22	0.20	0.22
query19	1.95	1.82	1.93
query20	0.02	0.02	0.02
query21	15.42	0.96	0.59
query22	0.80	1.20	0.61
query23	15.19	1.40	0.62
query24	7.46	1.84	0.43
query25	0.51	0.17	0.11
query26	0.53	0.15	0.14
query27	0.06	0.06	0.06
query28	9.85	1.34	0.93
query29	12.60	4.01	3.33
query30	0.28	0.14	0.12
query31	2.86	0.59	0.39
query32	3.27	0.55	0.49
query33	3.17	3.02	3.14
query34	16.34	5.52	4.84
query35	4.93	4.88	4.98
query36	0.72	0.55	0.49
query37	0.10	0.07	0.07
query38	0.06	0.05	0.04
query39	0.03	0.03	0.03
query40	0.19	0.15	0.15
query41	0.09	0.04	0.03
query42	0.04	0.03	0.02
query43	0.05	0.03	0.03
Total cold run time: 105.83 s
Total hot run time: 29.97 s

@github-actions github-actions bot added the approved Indicates a PR has been approved by one committer. label Oct 27, 2025
@github-actions
Copy link
Contributor Author

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

@github-actions
Copy link
Contributor Author

PR approved by anyone and no changes requested.

@yiguolei yiguolei merged commit da37966 into branch-4.0 Oct 27, 2025
23 of 26 checks passed
@github-actions github-actions bot deleted the auto-pick-56648-branch-4.0 branch October 27, 2025 01:48
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

approved Indicates a PR has been approved by one committer. reviewed

Projects

None yet

Development

Successfully merging this pull request may close these issues.

6 participants