[improve](function) keep BIN function behavior consistent with MySQL

[uchenily]

What problem does this PR solve?

This PR adds support for the BIN function to handle numeric strings, same with:

https://dev.mysql.com/doc/refman/8.4/en/string-functions.html#function_bin

create table test_bin (col_vchar varchar(10), col_str string) properties ( replication_num = 1 );
insert into test_bin values ("123abc", "123abc"), ("-123abc", "-123abc"), ("abc123", "abc123"), (" 123", " 123");

before:

mysql> select BIN("abc123");
+---------------+
| BIN("abc123") |
+---------------+
| NULL          |
+---------------+
1 row in set (0.01 sec)

mysql> select BIN("123abc");
+---------------+
| BIN("123abc") |
+---------------+
| NULL          |
+---------------+
1 row in set (0.01 sec)

mysql> select bin(col_vchar), bin(col_str) from test_bin;
+----------------+--------------+
| bin(col_vchar) | bin(col_str) |
+----------------+--------------+
| 1111011        | 1111011      |
| NULL           | NULL         |
| NULL           | NULL         |
| NULL           | NULL         |
+----------------+--------------+
4 rows in set (0.02 sec)

after:

mysql> select BIN("abc123");
+---------------+
| BIN("abc123") |
+---------------+
| 0             |
+---------------+
1 row in set (0.01 sec)

mysql> select BIN("123abc");
+---------------+
| BIN("123abc") |
+---------------+
| 1111011       |
+---------------+
1 row in set (0.00 sec)

mysql> select bin(col_vchar), bin(col_str) from test_bin;
+------------------------------------------------------------------+------------------------------------------------------------------+
| bin(col_vchar)                                                   | bin(col_str)                                                     |
+------------------------------------------------------------------+------------------------------------------------------------------+
| 1111011                                                          | 1111011                                                          |
| 1111111111111111111111111111111111111111111111111111111110000101 | 1111111111111111111111111111111111111111111111111111111110000101 |
| 1111011                                                          | 1111011                                                          |
| 0                                                                | 0                                                                |
+------------------------------------------------------------------+------------------------------------------------------------------+
4 rows in set (0.03 sec)

Related PR: #xxx

Problem Summary:

Release note

None

Check List (For Author)

• Test

  • [x] 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

• Behavior changed:

  • [ ] No.
  • [ ] Yes.

• Does this need documentation?

  • [ ] No.
  • [ ] Yes.

Check List (For Reviewer who merge this PR)

• [ ] Confirm the release note
• [ ] Confirm test cases
• [ ] Confirm document
• [ ] Add branch pick label

[hello-stephen]

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?

[uchenily]

run buildall

[doris-robot]

TPC-H: Total hot run time: 34136 ms

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 354447c2619d4485fb5175aa3680d5cd70b6bba7, data reload: false

------ Round 1 ----------------------------------
q1	17610	5060	4884	4884
q2	2035	313	200	200
q3	10245	1309	743	743
q4	10233	882	316	316
q5	7517	2395	2191	2191
q6	191	180	139	139
q7	961	781	632	632
q8	9366	1440	1139	1139
q9	7021	5339	5343	5339
q10	6779	2197	1777	1777
q11	526	302	296	296
q12	337	370	229	229
q13	17774	3626	3051	3051
q14	238	238	221	221
q15	582	518	510	510
q16	893	857	808	808
q17	671	847	416	416
q18	7906	7028	6960	6960
q19	1096	964	609	609
q20	359	347	223	223
q21	3964	3400	2510	2510
q22	1027	1006	943	943
Total cold run time: 107331 ms
Total hot run time: 34136 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4978	4941	4916	4916
q2	323	398	295	295
q3	2145	2693	2306	2306
q4	1329	1732	1281	1281
q5	4228	4773	4696	4696
q6	225	174	128	128
q7	2062	1973	1836	1836
q8	2724	2637	2606	2606
q9	7794	7474	7651	7474
q10	3189	3227	2815	2815
q11	589	499	486	486
q12	692	786	629	629
q13	3568	3910	3312	3312
q14	340	324	279	279
q15	554	504	515	504
q16	875	945	889	889
q17	1363	1486	1418	1418
q18	8010	7765	7563	7563
q19	893	809	870	809
q20	2012	2057	1944	1944
q21	4710	4258	4200	4200
q22	1072	1005	962	962
Total cold run time: 53675 ms
Total hot run time: 51348 ms

[doris-robot]

TPC-DS: Total hot run time: 180262 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 354447c2619d4485fb5175aa3680d5cd70b6bba7, data reload: false

query5	4916	655	499	499
query6	354	247	220	220
query7	4672	486	287	287
query8	332	268	250	250
query9	8744	2653	2648	2648
query10	556	334	301	301
query11	15307	14863	15022	14863
query12	194	118	119	118
query13	1705	486	377	377
query14	6389	3284	3090	3090
query14_1	2948	2968	2878	2878
query15	220	200	192	192
query16	7710	497	440	440
query17	1206	721	605	605
query18	2056	442	353	353
query19	226	193	165	165
query20	131	123	122	122
query21	224	143	117	117
query22	3865	4180	3798	3798
query23	16557	16172	15988	15988
query23_1	16039	16018	15956	15956
query24	7243	1631	1191	1191
query24_1	1234	1222	1215	1215
query25	633	516	422	422
query26	1261	284	179	179
query27	2893	463	306	306
query28	4375	2163	2150	2150
query29	808	556	453	453
query30	316	242	212	212
query31	812	702	619	619
query32	88	70	69	69
query33	650	344	297	297
query34	858	890	534	534
query35	794	817	726	726
query36	884	908	812	812
query37	127	92	79	79
query38	3843	3886	3762	3762
query39	745	747	708	708
query39_1	697	702	696	696
query40	233	133	114	114
query41	65	62	62	62
query42	126	99	98	98
query43	437	424	398	398
query44	1305	764	757	757
query45	230	194	188	188
query46	901	965	592	592
query47	1700	1675	1649	1649
query48	398	317	238	238
query49	801	438	347	347
query50	680	311	251	251
query51	3961	3928	3895	3895
query52	113	96	90	90
query53	229	228	181	181
query54	331	262	241	241
query55	98	80	73	73
query56	343	295	299	295
query57	1176	1153	1113	1113
query58	299	263	257	257
query59	2355	2463	2400	2400
query60	374	322	304	304
query61	162	167	158	158
query62	791	710	647	647
query63	232	175	179	175
query64	4525	1214	916	916
query65	4061	3933	3953	3933
query66	1187	455	344	344
query67	15175	15003	14720	14720
query68	8506	926	700	700
query69	527	310	267	267
query70	1133	1001	980	980
query71	457	288	265	265
query72	5966	4867	4967	4867
query73	731	607	296	296
query74	8795	8871	8599	8599
query75	3030	3018	2536	2536
query76	3383	1137	718	718
query77	510	389	308	308
query78	9399	9491	8833	8833
query79	1682	847	584	584
query80	642	573	465	465
query81	503	273	238	238
query82	482	128	102	102
query83	274	275	261	261
query84	268	116	100	100
query85	978	506	457	457
query86	392	288	287	287
query87	3978	4074	4019	4019
query88	4258	2120	2116	2116
query89	390	333	279	279
query90	2091	163	164	163
query91	170	175	145	145
query92	90	70	62	62
query93	1784	1049	676	676
query94	842	308	300	300
query95	564	375	325	325
query96	539	499	213	213
query97	2590	2676	2618	2618
query98	261	209	208	208
query99	1362	1364	1228	1228
Total cold run time: 271208 ms
Total hot run time: 180262 ms

[doris-robot]

ClickBench: Total hot run time: 27.68 s

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 354447c2619d4485fb5175aa3680d5cd70b6bba7, data reload: false

query1	0.05	0.05	0.04
query2	0.09	0.05	0.05
query3	0.26	0.09	0.09
query4	1.60	0.11	0.11
query5	0.26	0.24	0.26
query6	1.16	0.63	0.64
query7	0.03	0.02	0.02
query8	0.05	0.05	0.04
query9	0.55	0.52	0.50
query10	0.57	0.56	0.55
query11	0.16	0.11	0.10
query12	0.14	0.11	0.11
query13	0.63	0.61	0.60
query14	1.01	0.98	0.99
query15	0.82	0.80	0.79
query16	0.39	0.39	0.39
query17	1.06	1.03	1.04
query18	0.23	0.22	0.22
query19	1.86	1.88	1.83
query20	0.02	0.01	0.01
query21	15.44	0.28	0.15
query22	4.90	0.05	0.05
query23	16.06	0.27	0.09
query24	0.96	0.68	0.64
query25	0.08	0.06	0.06
query26	0.14	0.13	0.14
query27	0.06	0.06	0.05
query28	4.75	1.22	1.02
query29	12.62	4.10	3.23
query30	0.28	0.13	0.12
query31	2.81	0.62	0.40
query32	3.22	0.55	0.46
query33	3.09	3.04	3.07
query34	16.80	5.17	4.54
query35	4.59	4.62	4.54
query36	0.67	0.51	0.49
query37	0.11	0.06	0.07
query38	0.07	0.04	0.04
query39	0.04	0.02	0.03
query40	0.17	0.13	0.14
query41	0.08	0.03	0.03
query42	0.04	0.03	0.03
query43	0.04	0.04	0.03
Total cold run time: 97.96 s
Total hot run time: 27.68 s

[doris-robot]

BE UT Coverage Report

Increment line coverage 37.50% (24/64) :tada:

Increment coverage report Complete coverage report

Category	Coverage
Function Coverage	53.36% (18714/35072)
Line Coverage	39.05% (172879/442664)
Region Coverage	33.70% (134030/397671)
Branch Coverage	34.61% (57574/166344)

[hello-stephen]

BE Regression && UT Coverage Report

Increment line coverage 96.88% (62/64) :tada:

Increment coverage report Complete coverage report

Category	Coverage
Function Coverage	73.11% (25132/34376)
Line Coverage	60.22% (266302/442188)
Region Coverage	55.81% (224593/402396)
Branch Coverage	57.05% (95402/167219)

[hello-stephen]

FE Regression Coverage Report

Increment line coverage 86.96% (20/23) :tada: Increment coverage report Complete coverage report

[uchenily]

run buildall

[doris-robot]

TPC-H: Total hot run time: 35745 ms

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit fa9739ac352d41885fdd80e9089ce6003b60c4e1, data reload: false

------ Round 1 ----------------------------------
q1	17625	5090	4857	4857
q2	2048	365	252	252
q3	10154	1296	753	753
q4	10211	821	317	317
q5	7543	2160	1922	1922
q6	190	171	141	141
q7	1015	870	699	699
q8	9358	1451	1116	1116
q9	7011	5327	5411	5327
q10	6832	2407	1972	1972
q11	527	307	292	292
q12	653	725	555	555
q13	17822	3629	2989	2989
q14	289	290	277	277
q15	602	510	500	500
q16	944	897	861	861
q17	708	836	500	500
q18	7651	7052	6998	6998
q19	1102	974	611	611
q20	396	374	253	253
q21	4149	3924	3605	3605
q22	1013	993	948	948
Total cold run time: 107843 ms
Total hot run time: 35745 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4941	4895	4866	4866
q2	309	396	310	310
q3	2109	2727	2275	2275
q4	1306	1766	1308	1308
q5	4665	4763	4583	4583
q6	220	177	132	132
q7	2013	1977	1747	1747
q8	2725	2509	2531	2509
q9	7590	7490	7539	7490
q10	3037	3247	2998	2998
q11	610	515	491	491
q12	697	744	609	609
q13	3464	3900	3334	3334
q14	292	286	269	269
q15	559	510	513	510
q16	886	895	867	867
q17	1172	1410	1424	1410
q18	8065	7609	7352	7352
q19	823	819	825	819
q20	1886	1973	1815	1815
q21	4562	4277	4140	4140
q22	1088	1044	975	975
Total cold run time: 53019 ms
Total hot run time: 50809 ms

[doris-robot]

TPC-DS: Total hot run time: 181993 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 fa9739ac352d41885fdd80e9089ce6003b60c4e1, data reload: false

query5	4984	640	505	505
query6	335	218	201	201
query7	4650	480	270	270
query8	328	250	260	250
query9	8733	2673	2622	2622
query10	598	374	303	303
query11	15353	15216	15018	15018
query12	190	114	112	112
query13	1684	485	390	390
query14	6489	3166	2970	2970
query14_1	2853	2849	2838	2838
query15	216	204	181	181
query16	7690	486	450	450
query17	1204	707	589	589
query18	2027	441	353	353
query19	255	232	210	210
query20	128	117	116	116
query21	223	138	119	119
query22	4155	4106	4152	4106
query23	16589	16174	15946	15946
query23_1	15943	16116	16108	16108
query24	7288	1655	1230	1230
query24_1	1227	1260	1230	1230
query25	655	504	450	450
query26	1274	285	166	166
query27	2939	473	315	315
query28	4396	2178	2159	2159
query29	843	582	473	473
query30	321	242	222	222
query31	817	707	642	642
query32	84	75	67	67
query33	672	348	304	304
query34	897	901	548	548
query35	788	811	735	735
query36	902	905	810	810
query37	128	94	77	77
query38	3793	3793	3836	3793
query39	750	743	712	712
query39_1	700	713	700	700
query40	239	135	127	127
query41	72	70	69	69
query42	129	105	105	105
query43	441	434	396	396
query44	1313	762	794	762
query45	195	190	185	185
query46	937	977	620	620
query47	1716	1759	1654	1654
query48	457	331	263	263
query49	816	443	368	368
query50	671	299	226	226
query51	3812	3867	3832	3832
query52	121	119	99	99
query53	333	354	304	304
query54	349	273	303	273
query55	91	79	71	71
query56	357	291	300	291
query57	1191	1174	1112	1112
query58	279	249	247	247
query59	2321	2427	2375	2375
query60	352	316	286	286
query61	165	161	157	157
query62	779	694	632	632
query63	339	295	298	295
query64	4480	1283	1016	1016
query65	4031	3963	3946	3946
query66	1145	439	326	326
query67	15190	15166	15656	15166
query68	8307	975	750	750
query69	608	344	308	308
query70	1066	983	969	969
query71	480	298	288	288
query72	5970	4916	4872	4872
query73	712	552	310	310
query74	8735	8815	8611	8611
query75	3568	3511	3145	3145
query76	3518	1128	735	735
query77	779	391	299	299
query78	9418	9804	8866	8866
query79	1673	843	634	634
query80	730	686	557	557
query81	506	267	248	248
query82	439	130	106	106
query83	257	257	241	241
query84	261	113	99	99
query85	1005	508	491	491
query86	331	313	276	276
query87	4052	4152	3952	3952
query88	4076	2285	2298	2285
query89	500	416	381	381
query90	2084	155	148	148
query91	173	176	151	151
query92	78	75	62	62
query93	1323	922	572	572
query94	780	318	299	299
query95	580	325	331	325
query96	588	481	210	210
query97	2615	2657	2600	2600
query98	240	211	185	185
query99	1347	1322	1193	1193
Total cold run time: 271685 ms
Total hot run time: 181993 ms

[doris-robot]

ClickBench: Total hot run time: 27.16 s

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit fa9739ac352d41885fdd80e9089ce6003b60c4e1, data reload: false

query1	0.06	0.05	0.04
query2	0.10	0.04	0.05
query3	0.27	0.08	0.09
query4	1.60	0.11	0.10
query5	0.28	0.24	0.27
query6	1.16	0.65	0.62
query7	0.04	0.02	0.02
query8	0.06	0.04	0.05
query9	0.57	0.50	0.50
query10	0.56	0.55	0.56
query11	0.16	0.11	0.12
query12	0.14	0.11	0.12
query13	0.62	0.60	0.60
query14	0.98	1.00	0.97
query15	0.81	0.81	0.80
query16	0.40	0.39	0.41
query17	1.00	1.10	1.04
query18	0.22	0.22	0.21
query19	1.83	1.82	1.80
query20	0.02	0.01	0.02
query21	15.46	0.28	0.14
query22	4.90	0.05	0.05
query23	16.11	0.28	0.10
query24	0.98	0.24	0.27
query25	0.08	0.06	0.09
query26	0.15	0.13	0.14
query27	0.07	0.05	0.06
query28	3.11	1.22	1.02
query29	12.57	4.03	3.24
query30	0.28	0.14	0.14
query31	2.82	0.64	0.40
query32	3.23	0.56	0.46
query33	3.05	3.16	3.01
query34	16.85	5.19	4.50
query35	4.49	4.58	4.51
query36	0.67	0.50	0.51
query37	0.13	0.07	0.06
query38	0.08	0.04	0.04
query39	0.04	0.02	0.02
query40	0.18	0.14	0.14
query41	0.08	0.03	0.03
query42	0.04	0.04	0.02
query43	0.04	0.04	0.03
Total cold run time: 96.29 s
Total hot run time: 27.16 s

[hello-stephen]

BE UT Coverage Report

Increment line coverage 37.50% (24/64) :tada:

Increment coverage report Complete coverage report

Category	Coverage
Function Coverage	53.35% (18714/35077)
Line Coverage	39.05% (172971/442912)
Region Coverage	33.72% (134136/397773)
Branch Coverage	34.63% (57646/166443)

[hello-stephen]

FE UT Coverage Report

Increment line coverage 12.50% (3/24) :tada: Increment coverage report Complete coverage report

[uchenily]

run cloud_p0

[hello-stephen]

BE Regression && UT Coverage Report

Increment line coverage 37.50% (24/64) :tada:

Increment coverage report Complete coverage report

Category	Coverage
Function Coverage	58.27% (20034/34379)
Line Coverage	43.90% (194208/442432)
Region Coverage	38.69% (155742/402496)
Branch Coverage	39.31% (65765/167318)

[hello-stephen]

FE Regression Coverage Report

Increment line coverage 87.50% (21/24) :tada: Increment coverage report Complete coverage report

[hello-stephen]

BE Regression && UT Coverage Report

Increment line coverage 37.50% (24/64) :tada:

Increment coverage report Complete coverage report

Category	Coverage
Function Coverage	58.27% (20034/34379)
Line Coverage	43.90% (194208/442432)
Region Coverage	38.69% (155742/402496)
Branch Coverage	39.31% (65765/167318)

[zclllyybb]

在pr content里面描述下改动前后的行为，and mysql相关文档链接吧

[uchenily]

run buildall

[doris-robot]

TPC-H: Total hot run time: 36614 ms

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 94b86b4e7a8852d06820a6f2d9d58ea579cafd7f, data reload: false

------ Round 1 ----------------------------------
q1	17601	4318	4146	4146
q2	2009	352	257	257
q3	10195	1334	737	737
q4	10218	847	318	318
q5	7504	2093	1935	1935
q6	192	170	138	138
q7	1038	852	710	710
q8	9597	1477	1123	1123
q9	7025	5357	5392	5357
q10	6856	2400	1953	1953
q11	528	318	296	296
q12	667	713	592	592
q13	17795	3629	3000	3000
q14	297	305	264	264
q15	609	515	519	515
q16	919	933	881	881
q17	703	848	504	504
q18	7657	7882	7799	7799
q19	1117	1035	610	610
q20	414	385	274	274
q21	4534	4151	4153	4151
q22	1082	1054	1062	1054
Total cold run time: 108557 ms
Total hot run time: 36614 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4281	4304	4331	4304
q2	354	408	321	321
q3	2434	2782	2515	2515
q4	1451	1878	1428	1428
q5	4549	4441	4422	4422
q6	208	166	129	129
q7	1999	1982	1780	1780
q8	2676	2517	2454	2454
q9	7640	7266	6978	6978
q10	2907	3100	2662	2662
q11	562	495	462	462
q12	636	695	555	555
q13	3338	3593	3015	3015
q14	268	288	250	250
q15	533	505	499	499
q16	866	881	820	820
q17	1129	1296	1339	1296
q18	7336	7210	7008	7008
q19	845	792	850	792
q20	1878	1974	1791	1791
q21	4586	4218	4158	4158
q22	1084	1044	954	954
Total cold run time: 51560 ms
Total hot run time: 48593 ms

[doris-robot]

TPC-DS: Total hot run time: 181234 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 94b86b4e7a8852d06820a6f2d9d58ea579cafd7f, data reload: false

query5	5156	629	466	466
query6	335	257	227	227
query7	4220	470	288	288
query8	311	259	240	240
query9	8794	2573	2563	2563
query10	561	372	331	331
query11	15243	15319	14902	14902
query12	202	119	115	115
query13	1269	506	400	400
query14	6640	3214	3015	3015
query14_1	2879	2850	2843	2843
query15	218	203	184	184
query16	938	492	470	470
query17	1166	729	605	605
query18	2714	449	359	359
query19	236	234	209	209
query20	125	114	110	110
query21	221	139	118	118
query22	3939	4064	3989	3989
query23	16547	16011	15924	15924
query23_1	16083	15980	15987	15980
query24	7321	1623	1257	1257
query24_1	1210	1222	1248	1222
query25	575	500	450	450
query26	1264	285	168	168
query27	2759	473	310	310
query28	4429	2160	2163	2160
query29	825	562	477	477
query30	323	234	215	215
query31	827	726	612	612
query32	84	73	73	73
query33	576	359	297	297
query34	888	910	534	534
query35	839	810	733	733
query36	874	922	818	818
query37	127	91	75	75
query38	3824	3864	3786	3786
query39	750	908	730	730
query39_1	703	701	696	696
query40	225	141	118	118
query41	67	63	65	63
query42	107	107	105	105
query43	420	423	400	400
query44	1321	755	752	752
query45	198	191	184	184
query46	879	971	614	614
query47	1664	1693	1611	1611
query48	318	340	255	255
query49	627	435	369	369
query50	664	298	223	223
query51	3869	3894	3783	3783
query52	107	110	95	95
query53	323	354	288	288
query54	287	268	261	261
query55	74	72	79	72
query56	294	296	336	296
query57	1139	1134	1069	1069
query58	263	258	259	258
query59	2366	2521	2292	2292
query60	310	303	283	283
query61	159	162	158	158
query62	710	668	618	618
query63	325	286	294	286
query64	4862	1316	1014	1014
query65	3987	3936	3920	3920
query66	1386	453	327	327
query67	15100	15289	14780	14780
query68	8545	1029	743	743
query69	519	364	316	316
query70	1013	988	991	988
query71	370	317	282	282
query72	6114	4959	5007	4959
query73	701	613	306	306
query74	8526	8892	8604	8604
query75	3550	3542	3190	3190
query76	3974	1145	752	752
query77	533	406	281	281
query78	9367	9434	8810	8810
query79	1535	863	620	620
query80	694	657	555	555
query81	500	272	228	228
query82	204	128	110	110
query83	260	265	241	241
query84	257	118	98	98
query85	902	518	486	486
query86	380	298	264	264
query87	4157	4034	3934	3934
query88	3537	2284	2267	2267
query89	477	426	391	391
query90	2226	156	144	144
query91	178	169	152	152
query92	83	65	65	65
query93	1840	902	569	569
query94	466	315	292	292
query95	579	395	314	314
query96	594	473	208	208
query97	2576	2643	2573	2573
query98	224	190	192	190
query99	1273	1274	1206	1206
Total cold run time: 263694 ms
Total hot run time: 181234 ms

[doris-robot]

ClickBench: Total hot run time: 27.17 s

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 94b86b4e7a8852d06820a6f2d9d58ea579cafd7f, data reload: false

query1	0.05	0.04	0.04
query2	0.09	0.04	0.04
query3	0.26	0.09	0.08
query4	1.61	0.12	0.11
query5	0.26	0.27	0.27
query6	1.17	0.62	0.62
query7	0.04	0.02	0.03
query8	0.06	0.04	0.04
query9	0.57	0.51	0.50
query10	0.56	0.57	0.55
query11	0.17	0.11	0.11
query12	0.15	0.12	0.11
query13	0.61	0.60	0.61
query14	0.99	0.99	0.98
query15	0.81	0.79	0.82
query16	0.40	0.39	0.39
query17	1.06	1.04	1.07
query18	0.23	0.21	0.21
query19	1.89	1.86	1.85
query20	0.02	0.02	0.01
query21	15.46	0.32	0.14
query22	4.72	0.05	0.05
query23	16.07	0.29	0.10
query24	0.93	0.24	0.58
query25	0.11	0.05	0.05
query26	0.15	0.14	0.13
query27	0.05	0.05	0.06
query28	3.88	1.21	1.02
query29	12.60	4.04	3.18
query30	0.29	0.14	0.12
query31	2.82	0.64	0.40
query32	3.23	0.54	0.45
query33	3.10	3.02	3.06
query34	16.69	5.17	4.52
query35	4.56	4.52	4.58
query36	0.68	0.49	0.49
query37	0.10	0.06	0.06
query38	0.07	0.04	0.04
query39	0.04	0.02	0.02
query40	0.16	0.14	0.13
query41	0.08	0.03	0.02
query42	0.04	0.03	0.03
query43	0.04	0.04	0.03
Total cold run time: 96.87 s
Total hot run time: 27.17 s

[hello-stephen]

FE UT Coverage Report

Increment line coverage 12.50% (3/24) :tada: Increment coverage report Complete coverage report

[doris-robot]

BE UT Coverage Report

Increment line coverage 89.06% (57/64) :tada:

Increment coverage report Complete coverage report

Category	Coverage
Function Coverage	53.36% (18763/35165)
Line Coverage	39.10% (173492/443674)
Region Coverage	33.77% (134469/398198)
Branch Coverage	34.71% (57839/166642)

[hello-stephen]

BE Regression && UT Coverage Report

Increment line coverage 89.06% (57/64) :tada:

Increment coverage report Complete coverage report

Category	Coverage
Function Coverage	72.30% (24926/34474)
Line Coverage	59.03% (261677/443274)
Region Coverage	54.07% (217890/402970)
Branch Coverage	55.56% (93090/167545)

[hello-stephen]

FE Regression Coverage Report

Increment line coverage 87.50% (21/24) :tada: Increment coverage report Complete coverage report

[uchenily]

run cloud_p0

[uchenily]

run nonConcurrent

[hello-stephen]

BE Regression && UT Coverage Report

Increment line coverage 89.06% (57/64) :tada:

Increment coverage report Complete coverage report

Category	Coverage
Function Coverage	72.30% (24926/34474)
Line Coverage	59.03% (261677/443274)
Region Coverage	54.07% (217890/402970)
Branch Coverage	55.56% (93090/167545)