[fix](auth)fix some ldap bug

[zddr]

What problem does this PR solve?

fix:

• roles in ldapUser may be null
• not support refresh ldap
• user not have priv when refresh ldap selfName
• unclear error message
• show grants for ldapUser not display roles which grant in doris

Issue Number: close #xxx

Related PR: #xxx

Problem Summary:

Release note

None

Check List (For Author)

• Test

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

  • [x] No.
  • [ ] Yes.

• Does this need documentation?

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

[zddr]

run buildall

[doris-robot]

TPC-H: Total hot run time: 36919 ms

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

------ Round 1 ----------------------------------
q1	17592	5242	5080	5080
q2	2066	323	201	201
q3	10240	1482	756	756
q4	10220	898	324	324
q5	7531	2690	2460	2460
q6	204	180	140	140
q7	1030	838	640	640
q8	9360	1580	1216	1216
q9	7022	5578	5530	5530
q10	6859	2228	1762	1762
q11	529	328	291	291
q12	338	405	232	232
q13	17774	3781	2993	2993
q14	245	249	219	219
q15	581	518	511	511
q16	903	874	804	804
q17	684	867	566	566
q18	7727	7785	7861	7785
q19	1106	1163	682	682
q20	398	371	235	235
q21	4501	4287	3476	3476
q22	1125	1100	1016	1016
Total cold run time: 108035 ms
Total hot run time: 36919 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5502	5518	5409	5409
q2	340	427	325	325
q3	2416	2909	2472	2472
q4	1471	1965	1497	1497
q5	4514	4577	4509	4509
q6	257	186	131	131
q7	2092	1952	1725	1725
q8	2955	2749	2714	2714
q9	7567	7485	7409	7409
q10	3189	3193	2710	2710
q11	608	500	475	475
q12	614	706	560	560
q13	3368	3767	2980	2980
q14	269	281	257	257
q15	555	485	491	485
q16	867	894	836	836
q17	1173	1549	1477	1477
q18	7319	7256	7070	7070
q19	878	834	845	834
q20	1938	2003	1853	1853
q21	4838	4307	4260	4260
q22	1105	1049	994	994
Total cold run time: 53835 ms
Total hot run time: 50982 ms

[doris-robot]

TPC-DS: Total hot run time: 182234 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 11f0e62e956a16f8b784ddab202d651edc4b3369, data reload: false

query1	1074	400	392	392
query2	6608	1162	1174	1162
query3	6746	231	227	227
query4	25228	23331	22962	22962
query5	5855	659	487	487
query6	500	234	233	233
query7	5756	523	314	314
query8	340	268	252	252
query9	8746	2689	2692	2689
query10	603	360	306	306
query11	15417	15453	15089	15089
query12	181	119	114	114
query13	1659	566	447	447
query14	10842	5880	6163	5880
query15	275	201	193	193
query16	7801	699	522	522
query17	1347	769	641	641
query18	2089	442	343	343
query19	325	216	187	187
query20	131	125	123	123
query21	217	138	118	118
query22	3905	4008	4053	4008
query23	33086	31919	31902	31902
query24	7835	2385	2414	2385
query25	596	526	461	461
query26	1224	285	170	170
query27	2683	488	350	350
query28	4345	2200	2182	2182
query29	764	614	481	481
query30	309	248	220	220
query31	790	703	631	631
query32	80	73	69	69
query33	594	383	340	340
query34	828	894	547	547
query35	793	833	749	749
query36	893	915	827	827
query37	117	112	88	88
query38	3809	3899	3715	3715
query39	1462	1416	1417	1416
query40	227	136	121	121
query41	70	63	62	62
query42	134	120	117	117
query43	459	450	423	423
query44	1349	769	775	769
query45	208	200	191	191
query46	909	1026	660	660
query47	1683	1752	1667	1667
query48	413	436	346	346
query49	783	510	423	423
query50	710	708	425	425
query51	3889	3936	3862	3862
query52	114	120	106	106
query53	253	266	203	203
query54	333	326	309	309
query55	103	103	97	97
query56	357	361	341	341
query57	1167	1178	1105	1105
query58	306	291	286	286
query59	2277	2502	2291	2291
query60	372	359	362	359
query61	200	189	187	187
query62	785	727	638	638
query63	238	205	201	201
query64	4582	1377	1050	1050
query65	4058	3980	4051	3980
query66	1055	437	328	328
query67	15333	14943	14846	14846
query68	8370	1009	640	640
query69	557	336	313	313
query70	1143	1021	1029	1021
query71	506	328	326	326
query72	5845	4946	4845	4845
query73	676	580	345	345
query74	8598	8775	8529	8529
query75	3792	3021	2447	2447
query76	3697	1170	734	734
query77	821	416	329	329
query78	9417	9579	8846	8846
query79	2263	865	589	589
query80	647	568	501	501
query81	527	267	242	242
query82	453	136	110	110
query83	269	260	250	250
query84	265	120	95	95
query85	890	502	449	449
query86	336	311	271	271
query87	4122	4053	3983	3983
query88	4206	2285	2275	2275
query89	405	339	292	292
query90	1985	227	214	214
query91	169	188	141	141
query92	87	74	65	65
query93	1993	1063	668	668
query94	725	461	334	334
query95	499	414	404	404
query96	546	566	287	287
query97	2616	2654	2593	2593
query98	241	214	214	214
query99	1396	1361	1267	1267
Total cold run time: 276282 ms
Total hot run time: 182234 ms

[doris-robot]

ClickBench: Total hot run time: 27.24 s

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

query1	0.05	0.04	0.04
query2	0.11	0.05	0.05
query3	0.26	0.08	0.08
query4	1.62	0.12	0.11
query5	0.25	0.25	0.28
query6	1.17	0.64	0.63
query7	0.04	0.02	0.02
query8	0.05	0.04	0.04
query9	0.57	0.51	0.51
query10	0.57	0.55	0.54
query11	0.15	0.11	0.11
query12	0.15	0.11	0.12
query13	0.63	0.61	0.61
query14	0.99	0.99	0.98
query15	0.81	0.81	0.80
query16	0.40	0.39	0.38
query17	1.06	1.07	1.04
query18	0.25	0.21	0.21
query19	1.84	1.84	1.84
query20	0.02	0.01	0.01
query21	15.43	0.31	0.15
query22	4.72	0.05	0.05
query23	15.99	0.28	0.10
query24	1.98	1.12	0.27
query25	0.11	0.06	0.05
query26	0.14	0.14	0.13
query27	0.06	0.08	0.05
query28	4.64	1.23	1.02
query29	12.60	3.98	3.16
query30	0.27	0.14	0.12
query31	2.83	0.63	0.40
query32	3.23	0.55	0.47
query33	3.02	3.15	3.04
query34	17.08	5.27	4.52
query35	4.51	4.53	4.52
query36	0.65	0.50	0.48
query37	0.10	0.06	0.06
query38	0.07	0.04	0.04
query39	0.04	0.03	0.03
query40	0.17	0.15	0.13
query41	0.09	0.04	0.03
query42	0.05	0.03	0.03
query43	0.04	0.04	0.03
Total cold run time: 98.81 s
Total hot run time: 27.24 s

[hello-stephen]

FE Regression Coverage Report

Increment line coverage 17.39% (4/23) :tada: Increment coverage report Complete coverage report

[zddr]

run buildall

[doris-robot]

TPC-H: Total hot run time: 35389 ms

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

------ Round 1 ----------------------------------
q1	17603	5086	4915	4915
q2	2040	305	196	196
q3	10267	1315	731	731
q4	10217	861	314	314
q5	7529	2436	2148	2148
q6	189	173	133	133
q7	981	782	640	640
q8	9354	1409	1175	1175
q9	7046	5310	5412	5310
q10	6782	2242	1762	1762
q11	521	315	286	286
q12	342	373	230	230
q13	17796	3705	3082	3082
q14	242	243	218	218
q15	584	518	523	518
q16	890	869	825	825
q17	695	837	483	483
q18	7379	7999	7848	7848
q19	1253	1052	636	636
q20	412	342	221	221
q21	4451	3974	2708	2708
q22	1263	1042	1010	1010
Total cold run time: 107836 ms
Total hot run time: 35389 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5112	5136	5359	5136
q2	314	383	310	310
q3	2340	2767	2549	2549
q4	1419	1904	1387	1387
q5	4494	4431	4382	4382
q6	215	182	131	131
q7	2039	1960	1839	1839
q8	2725	2519	2495	2495
q9	7589	7436	7597	7436
q10	3051	3273	2854	2854
q11	604	518	503	503
q12	681	747	591	591
q13	3570	3717	3017	3017
q14	266	290	257	257
q15	532	498	478	478
q16	855	896	833	833
q17	1127	1387	1381	1381
q18	7299	7186	6979	6979
q19	823	809	816	809
q20	1909	1933	1776	1776
q21	4556	4230	4237	4230
q22	1131	1007	949	949
Total cold run time: 52651 ms
Total hot run time: 50322 ms

[doris-robot]

TPC-DS: Total hot run time: 179338 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 11f0e62e956a16f8b784ddab202d651edc4b3369, data reload: false

query5	5218	648	538	538
query6	361	237	215	215
query7	4666	476	279	279
query8	316	253	244	244
query9	8725	2658	2657	2657
query10	557	333	287	287
query11	15498	14978	14481	14481
query12	193	119	114	114
query13	1687	488	369	369
query14	6681	3239	2977	2977
query14_1	2909	2973	3069	2973
query15	216	197	177	177
query16	7679	487	452	452
query17	1383	732	623	623
query18	2053	436	320	320
query19	208	185	156	156
query20	129	119	115	115
query21	221	137	116	116
query22	3938	4006	3810	3810
query23	16788	16087	16015	16015
query23_1	16047	15962	15935	15935
query24	6976	1627	1204	1204
query24_1	1203	1176	1182	1176
query25	613	523	434	434
query26	1263	295	169	169
query27	2876	463	303	303
query28	4385	2195	2167	2167
query29	802	560	449	449
query30	317	246	211	211
query31	841	689	608	608
query32	88	68	69	68
query33	665	343	296	296
query34	860	891	536	536
query35	800	815	727	727
query36	867	928	844	844
query37	127	92	81	81
query38	3847	3809	3729	3729
query39	759	814	728	728
query39_1	717	710	691	691
query40	228	129	118	118
query41	70	66	65	65
query42	128	102	101	101
query43	440	422	387	387
query44	1321	769	769	769
query45	202	194	183	183
query46	911	956	589	589
query47	1687	1711	1645	1645
query48	403	315	249	249
query49	760	436	354	354
query50	676	298	244	244
query51	3819	3868	3863	3863
query52	115	103	86	86
query53	238	231	179	179
query54	314	250	239	239
query55	96	76	77	76
query56	341	295	305	295
query57	1152	1146	1106	1106
query58	287	256	247	247
query59	2306	2364	2236	2236
query60	386	353	299	299
query61	167	167	194	167
query62	788	706	629	629
query63	236	181	187	181
query64	4600	1356	1037	1037
query65	4061	3935	3933	3933
query66	1150	458	338	338
query67	15051	14871	14782	14782
query68	6655	926	666	666
query69	508	294	269	269
query70	1073	998	945	945
query71	426	293	268	268
query72	5959	4809	4853	4809
query73	670	551	302	302
query74	9053	8735	8622	8622
query75	3038	3021	2460	2460
query76	3307	1152	754	754
query77	520	412	316	316
query78	9374	9601	8850	8850
query79	1742	868	588	588
query80	697	535	460	460
query81	514	274	244	244
query82	197	128	104	104
query83	274	268	251	251
query84	261	109	99	99
query85	889	496	457	457
query86	335	284	279	279
query87	4042	4060	3971	3971
query88	2942	2144	2124	2124
query89	395	328	290	290
query90	1977	156	154	154
query91	186	188	164	164
query92	72	67	67	67
query93	1239	1036	681	681
query94	711	314	287	287
query95	575	383	320	320
query96	544	487	218	218
query97	2589	2678	2546	2546
query98	244	199	199	199
query99	1331	1333	1280	1280
Total cold run time: 268137 ms
Total hot run time: 179338 ms

[doris-robot]

ClickBench: Total hot run time: 27.27 s

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

query1	0.06	0.05	0.05
query2	0.10	0.04	0.04
query3	0.25	0.09	0.08
query4	1.61	0.12	0.11
query5	0.27	0.25	0.25
query6	1.17	0.63	0.63
query7	0.04	0.03	0.03
query8	0.05	0.04	0.04
query9	0.59	0.52	0.50
query10	0.56	0.56	0.55
query11	0.15	0.11	0.11
query12	0.15	0.12	0.11
query13	0.64	0.61	0.60
query14	0.99	1.00	0.99
query15	0.82	0.80	0.81
query16	0.39	0.42	0.41
query17	1.00	1.07	1.05
query18	0.24	0.21	0.21
query19	1.88	1.89	1.82
query20	0.02	0.01	0.02
query21	15.46	0.27	0.14
query22	4.87	0.06	0.04
query23	16.08	0.28	0.11
query24	1.51	0.26	0.18
query25	0.10	0.07	0.06
query26	0.14	0.14	0.13
query27	0.04	0.06	0.05
query28	3.94	1.24	1.03
query29	12.59	3.98	3.15
query30	0.29	0.17	0.12
query31	2.84	0.64	0.40
query32	3.23	0.56	0.48
query33	3.07	3.10	3.10
query34	16.71	5.23	4.54
query35	4.57	4.50	4.53
query36	0.64	0.49	0.49
query37	0.11	0.07	0.06
query38	0.07	0.04	0.03
query39	0.05	0.03	0.03
query40	0.18	0.15	0.15
query41	0.09	0.03	0.04
query42	0.04	0.03	0.03
query43	0.05	0.03	0.04
Total cold run time: 97.65 s
Total hot run time: 27.27 s

[hello-stephen]

FE Regression Coverage Report

Increment line coverage 17.39% (4/23) :tada: Increment coverage report Complete coverage report

[hello-stephen]

FE Regression Coverage Report

Increment line coverage 17.39% (4/23) :tada: Increment coverage report Complete coverage report

[zddr]

run buildall

[hello-stephen]

FE UT Coverage Report

Increment line coverage 52.17% (12/23) :tada: Increment coverage report Complete coverage report

[doris-robot]

TPC-H: Total hot run time: 35311 ms

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

------ Round 1 ----------------------------------
q1	17597	4199	4056	4056
q2	2032	349	239	239
q3	10175	1328	754	754
q4	10209	867	308	308
q5	7575	2165	1946	1946
q6	217	168	134	134
q7	995	853	705	705
q8	9357	1477	1139	1139
q9	7275	5351	5428	5351
q10	6872	2397	1972	1972
q11	536	322	297	297
q12	712	740	570	570
q13	17777	3702	3081	3081
q14	294	299	289	289
q15	596	521	513	513
q16	931	912	886	886
q17	720	824	520	520
q18	7513	7114	7047	7047
q19	1101	975	607	607
q20	407	361	250	250
q21	4275	4003	3686	3686
q22	1082	1023	961	961
Total cold run time: 108248 ms
Total hot run time: 35311 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4097	4038	4211	4038
q2	324	415	323	323
q3	2138	2666	2294	2294
q4	1318	1751	1321	1321
q5	4248	4739	4748	4739
q6	216	174	134	134
q7	2064	2006	1779	1779
q8	2765	2550	2586	2550
q9	7589	7572	7575	7572
q10	3030	3226	2890	2890
q11	581	504	496	496
q12	838	794	698	698
q13	3511	3865	3357	3357
q14	289	317	298	298
q15	558	512	529	512
q16	938	919	918	918
q17	1190	1497	1585	1497
q18	7885	7643	7492	7492
q19	910	954	963	954
q20	2039	2097	1964	1964
q21	4847	4327	4178	4178
q22	1083	1061	966	966
Total cold run time: 52458 ms
Total hot run time: 50970 ms

[doris-robot]

TPC-DS: Total hot run time: 181717 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 11f0e62e956a16f8b784ddab202d651edc4b3369, data reload: false

query5	4897	622	463	463
query6	343	231	231	231
query7	4220	457	300	300
query8	315	245	245	245
query9	8756	2557	2581	2557
query10	560	384	326	326
query11	15472	14815	14947	14815
query12	185	117	116	116
query13	1259	520	414	414
query14	6322	3230	3027	3027
query14_1	2880	2882	2875	2875
query15	210	202	178	178
query16	858	488	515	488
query17	1116	728	619	619
query18	2575	464	362	362
query19	229	230	235	230
query20	130	117	113	113
query21	223	142	115	115
query22	4028	3907	3921	3907
query23	16450	16248	15806	15806
query23_1	16185	16024	16120	16024
query24	7429	1674	1247	1247
query24_1	1244	1243	1270	1243
query25	601	496	448	448
query26	1256	277	169	169
query27	2740	470	319	319
query28	4469	2155	2143	2143
query29	820	588	466	466
query30	330	236	214	214
query31	816	708	671	671
query32	84	70	75	70
query33	544	366	307	307
query34	911	922	552	552
query35	772	818	744	744
query36	865	961	812	812
query37	130	95	72	72
query38	3866	3805	3868	3805
query39	773	744	718	718
query39_1	705	711	709	709
query40	227	137	119	119
query41	69	62	65	62
query42	109	106	111	106
query43	425	428	397	397
query44	1359	775	753	753
query45	193	188	180	180
query46	896	989	626	626
query47	1653	1690	1618	1618
query48	319	330	259	259
query49	640	430	354	354
query50	714	305	223	223
query51	3819	3853	3907	3853
query52	111	113	98	98
query53	327	347	296	296
query54	301	266	252	252
query55	77	75	71	71
query56	301	298	293	293
query57	1148	1137	1095	1095
query58	271	263	254	254
query59	2320	2441	2352	2352
query60	324	304	289	289
query61	166	154	153	153
query62	692	663	634	634
query63	331	294	303	294
query64	4933	1337	1010	1010
query65	4038	3974	3971	3971
query66	1430	440	316	316
query67	15237	15023	14978	14978
query68	8344	1024	761	761
query69	491	344	316	316
query70	1052	976	978	976
query71	370	314	289	289
query72	6151	4973	5180	4973
query73	718	641	309	309
query74	8573	8855	8551	8551
query75	3613	3527	3166	3166
query76	3872	1131	774	774
query77	669	406	293	293
query78	9489	9827	8902	8902
query79	1376	838	608	608
query80	683	670	568	568
query81	510	265	236	236
query82	232	141	115	115
query83	259	261	244	244
query84	259	122	104	104
query85	915	516	469	469
query86	356	295	290	290
query87	4020	4056	3968	3968
query88	3612	2299	2314	2299
query89	467	430	402	402
query90	2216	156	154	154
query91	179	169	151	151
query92	83	69	66	66
query93	1436	914	575	575
query94	450	298	278	278
query95	576	387	314	314
query96	594	468	212	212
query97	2580	2669	2564	2564
query98	214	195	199	195
query99	1270	1269	1226	1226
Total cold run time: 263613 ms
Total hot run time: 181717 ms

[doris-robot]

ClickBench: Total hot run time: 27.23 s

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

query1	0.06	0.06	0.04
query2	0.10	0.05	0.05
query3	0.26	0.10	0.09
query4	1.61	0.12	0.11
query5	0.28	0.25	0.24
query6	1.16	0.65	0.62
query7	0.03	0.02	0.02
query8	0.06	0.04	0.04
query9	0.56	0.51	0.52
query10	0.57	0.56	0.54
query11	0.15	0.11	0.11
query12	0.14	0.11	0.10
query13	0.63	0.60	0.61
query14	1.00	0.98	0.98
query15	0.82	0.80	0.81
query16	0.40	0.42	0.42
query17	1.05	0.97	1.01
query18	0.24	0.22	0.22
query19	1.89	1.74	1.88
query20	0.02	0.01	0.01
query21	15.46	0.29	0.14
query22	4.96	0.05	0.05
query23	16.11	0.30	0.10
query24	1.42	0.37	0.63
query25	0.12	0.08	0.06
query26	0.13	0.14	0.13
query27	0.07	0.06	0.05
query28	4.02	1.23	1.02
query29	12.58	4.04	3.12
query30	0.28	0.14	0.12
query31	2.81	0.64	0.39
query32	3.25	0.54	0.46
query33	2.98	3.05	3.06
query34	16.95	5.20	4.52
query35	4.52	4.60	4.61
query36	0.66	0.49	0.48
query37	0.12	0.07	0.08
query38	0.08	0.04	0.04
query39	0.05	0.03	0.03
query40	0.17	0.14	0.14
query41	0.09	0.04	0.03
query42	0.04	0.02	0.03
query43	0.05	0.04	0.03
Total cold run time: 97.95 s
Total hot run time: 27.23 s

[hello-stephen]

FE Regression Coverage Report

Increment line coverage 17.39% (4/23) :tada: Increment coverage report Complete coverage report

[zddr]

run buildall

[doris-robot]

TPC-H: Total hot run time: 35787 ms

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

------ Round 1 ----------------------------------
q1	17606	4179	4050	4050
q2	2070	345	237	237
q3	10152	1325	737	737
q4	10199	834	309	309
q5	7524	2066	1943	1943
q6	179	172	132	132
q7	987	844	709	709
q8	9353	1442	1112	1112
q9	7088	5385	5302	5302
q10	6847	2404	1990	1990
q11	533	307	290	290
q12	648	722	577	577
q13	18306	3639	3093	3093
q14	307	301	285	285
q15	612	519	517	517
q16	955	936	873	873
q17	743	825	540	540
q18	7667	7217	7228	7217
q19	1132	1007	622	622
q20	417	365	260	260
q21	4273	4066	3992	3992
q22	1073	1034	1000	1000
Total cold run time: 108671 ms
Total hot run time: 35787 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4141	4319	4030	4030
q2	335	413	313	313
q3	2155	2635	2310	2310
q4	1303	1741	1303	1303
q5	4249	4846	4736	4736
q6	219	173	131	131
q7	2018	1959	1830	1830
q8	2658	2468	2490	2468
q9	7557	7466	7468	7466
q10	3098	3242	2780	2780
q11	659	539	483	483
q12	698	756	609	609
q13	3474	3900	3422	3422
q14	293	301	291	291
q15	547	525	538	525
q16	917	909	907	907
q17	1205	1481	1444	1444
q18	7845	7638	7710	7638
q19	880	847	864	847
q20	1887	1974	1812	1812
q21	4626	4267	4193	4193
q22	1103	1049	979	979
Total cold run time: 51867 ms
Total hot run time: 50517 ms

[doris-robot]

TPC-DS: Total hot run time: 181670 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 2df940deca5b1ad4c663357698d86c9a3f344388, data reload: false

query5	4811	619	504	504
query6	333	249	235	235
query7	4221	474	286	286
query8	324	251	239	239
query9	8765	2574	2575	2574
query10	532	387	330	330
query11	15187	15259	14577	14577
query12	185	122	116	116
query13	1283	521	421	421
query14	6519	3291	3102	3102
query14_1	2940	2935	2932	2932
query15	209	202	179	179
query16	1008	474	477	474
query17	1147	720	600	600
query18	2654	442	355	355
query19	236	235	207	207
query20	122	116	114	114
query21	225	136	118	118
query22	3946	4242	3897	3897
query23	16565	16151	15967	15967
query23_1	16279	16143	16022	16022
query24	7431	1690	1257	1257
query24_1	1229	1235	1241	1235
query25	588	504	442	442
query26	1255	276	163	163
query27	2745	469	323	323
query28	4466	2174	2136	2136
query29	835	575	469	469
query30	318	248	217	217
query31	853	693	623	623
query32	78	69	67	67
query33	593	327	294	294
query34	895	916	553	553
query35	799	806	722	722
query36	896	943	802	802
query37	133	92	79	79
query38	3957	3883	3776	3776
query39	757	746	722	722
query39_1	718	697	699	697
query40	220	134	119	119
query41	66	83	77	77
query42	108	103	103	103
query43	434	447	406	406
query44	1317	745	754	745
query45	193	183	185	183
query46	894	982	640	640
query47	1654	1715	1637	1637
query48	311	320	249	249
query49	632	450	361	361
query50	670	306	227	227
query51	3831	3993	3897	3897
query52	105	106	95	95
query53	324	351	300	300
query54	294	262	250	250
query55	79	73	73	73
query56	299	310	298	298
query57	1148	1145	1069	1069
query58	270	263	250	250
query59	2434	2517	2334	2334
query60	312	322	299	299
query61	163	159	174	159
query62	720	699	631	631
query63	332	295	305	295
query64	4981	1316	1007	1007
query65	4008	3958	3946	3946
query66	1403	433	314	314
query67	15159	14948	15193	14948
query68	8407	1027	744	744
query69	495	342	309	309
query70	1086	988	972	972
query71	389	323	292	292
query72	6076	4957	5135	4957
query73	734	665	322	322
query74	8829	8800	8579	8579
query75	3583	3540	3166	3166
query76	4017	1156	755	755
query77	569	408	288	288
query78	9366	9620	8845	8845
query79	1664	882	604	604
query80	701	653	560	560
query81	502	270	234	234
query82	212	133	106	106
query83	276	264	231	231
query84	251	122	104	104
query85	907	516	466	466
query86	345	297	285	285
query87	4129	4019	3974	3974
query88	4081	2313	2276	2276
query89	465	422	397	397
query90	2223	160	156	156
query91	173	168	145	145
query92	85	69	68	68
query93	1150	880	579	579
query94	471	312	275	275
query95	576	375	329	329
query96	605	479	207	207
query97	2577	2700	2559	2559
query98	217	204	191	191
query99	1279	1307	1265	1265
Total cold run time: 264908 ms
Total hot run time: 181670 ms

[doris-robot]

ClickBench: Total hot run time: 27.36 s

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

query1	0.05	0.05	0.05
query2	0.10	0.04	0.05
query3	0.25	0.09	0.09
query4	1.61	0.12	0.11
query5	0.29	0.26	0.26
query6	1.18	0.64	0.64
query7	0.04	0.03	0.02
query8	0.06	0.04	0.04
query9	0.58	0.52	0.51
query10	0.56	0.56	0.54
query11	0.14	0.12	0.12
query12	0.15	0.12	0.12
query13	0.62	0.60	0.62
query14	0.99	1.02	0.98
query15	0.82	0.79	0.82
query16	0.43	0.40	0.39
query17	1.04	1.05	1.02
query18	0.23	0.22	0.21
query19	1.93	1.79	1.87
query20	0.02	0.01	0.02
query21	15.44	0.31	0.15
query22	4.79	0.04	0.04
query23	15.98	0.28	0.10
query24	1.20	0.26	0.31
query25	0.08	0.05	0.06
query26	0.14	0.14	0.14
query27	0.10	0.04	0.05
query28	3.22	1.24	1.02
query29	12.63	3.98	3.31
query30	0.27	0.14	0.11
query31	2.82	0.62	0.39
query32	3.24	0.54	0.47
query33	3.01	3.02	3.14
query34	16.83	5.24	4.54
query35	4.62	4.54	4.60
query36	0.66	0.51	0.48
query37	0.11	0.07	0.07
query38	0.08	0.04	0.04
query39	0.04	0.03	0.04
query40	0.17	0.15	0.14
query41	0.08	0.04	0.03
query42	0.04	0.03	0.03
query43	0.05	0.03	0.03
Total cold run time: 96.69 s
Total hot run time: 27.36 s

[hello-stephen]

FE UT Coverage Report

Increment line coverage 52.17% (12/23) :tada: Increment coverage report Complete coverage report

[zddr]

run buildall

[doris-robot]

TPC-H: Total hot run time: 34953 ms

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

------ Round 1 ----------------------------------
q1	19063	4239	4134	4134
q2	2042	352	242	242
q3	10236	1326	755	755
q4	10203	850	316	316
q5	7542	2112	1904	1904
q6	187	174	137	137
q7	1008	837	723	723
q8	9372	1433	1069	1069
q9	6981	5290	5321	5290
q10	6824	2389	1916	1916
q11	536	311	308	308
q12	688	717	629	629
q13	17771	3692	3014	3014
q14	310	291	273	273
q15	591	512	516	512
q16	660	664	641	641
q17	696	802	526	526
q18	7581	7189	7042	7042
q19	1310	953	599	599
q20	403	357	244	244
q21	4304	3863	3702	3702
q22	1059	1032	977	977
Total cold run time: 109367 ms
Total hot run time: 34953 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4145	4038	4039	4038
q2	331	396	303	303
q3	2122	2705	2330	2330
q4	1312	1733	1311	1311
q5	4280	4760	4830	4760
q6	244	181	141	141
q7	2062	1931	1825	1825
q8	2590	2525	2731	2525
q9	7567	7542	7495	7495
q10	3114	3212	2864	2864
q11	603	508	594	508
q12	751	774	633	633
q13	3605	4057	3420	3420
q14	397	291	266	266
q15	559	509	504	504
q16	643	686	635	635
q17	1182	1376	1333	1333
q18	8064	7799	7638	7638
q19	855	817	828	817
q20	1889	1957	1831	1831
q21	4701	4308	4074	4074
q22	1082	1038	987	987
Total cold run time: 52098 ms
Total hot run time: 50238 ms

[doris-robot]

TPC-DS: Total hot run time: 179305 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 2df940deca5b1ad4c663357698d86c9a3f344388, data reload: false

query5	5202	658	495	495
query6	347	243	236	236
query7	4234	473	273	273
query8	332	261	247	247
query9	8779	2571	2522	2522
query10	558	374	351	351
query11	15485	14860	15061	14860
query12	189	117	115	115
query13	1261	483	372	372
query14	6829	3218	3024	3024
query14_1	2812	2888	2862	2862
query15	205	202	186	186
query16	934	477	462	462
query17	1079	703	606	606
query18	2698	432	334	334
query19	225	251	200	200
query20	118	113	110	110
query21	220	141	115	115
query22	4012	3966	3989	3966
query23	17164	16262	15986	15986
query23_1	16192	16072	16157	16072
query24	7335	1657	1233	1233
query24_1	1252	1226	1235	1226
query25	539	468	428	428
query26	826	270	160	160
query27	2733	468	307	307
query28	4444	2096	2101	2096
query29	844	554	456	456
query30	308	234	218	218
query31	810	717	622	622
query32	80	69	66	66
query33	537	349	295	295
query34	908	901	527	527
query35	787	822	733	733
query36	887	912	815	815
query37	126	98	84	84
query38	2861	2837	2850	2837
query39	761	741	733	733
query39_1	691	701	696	696
query40	228	138	119	119
query41	66	64	65	64
query42	108	107	110	107
query43	427	434	404	404
query44	1343	749	737	737
query45	195	196	183	183
query46	903	990	614	614
query47	1653	1705	1646	1646
query48	323	324	266	266
query49	627	435	357	357
query50	671	316	220	220
query51	3798	3785	3795	3785
query52	103	118	98	98
query53	323	360	293	293
query54	288	261	267	261
query55	80	75	73	73
query56	294	302	310	302
query57	1143	1158	1079	1079
query58	269	260	266	260
query59	2368	2504	2382	2382
query60	324	327	307	307
query61	196	215	189	189
query62	712	677	627	627
query63	332	305	309	305
query64	4324	1437	1162	1162
query65	4019	3930	3955	3930
query66	1346	484	330	330
query67	15212	15036	15057	15036
query68	5735	1024	749	749
query69	528	362	340	340
query70	1096	985	908	908
query71	377	319	327	319
query72	6136	4855	4925	4855
query73	686	579	309	309
query74	8816	8969	8668	8668
query75	3189	3138	2770	2770
query76	3844	1138	760	760
query77	520	395	292	292
query78	9413	9629	8944	8944
query79	1252	862	623	623
query80	924	657	563	563
query81	516	268	232	232
query82	407	134	105	105
query83	269	255	248	248
query84	259	123	102	102
query85	925	513	482	482
query86	327	298	270	270
query87	3053	3081	2979	2979
query88	3231	2265	2254	2254
query89	473	426	397	397
query90	1856	160	160	160
query91	179	177	149	149
query92	72	70	61	61
query93	1109	927	565	565
query94	550	286	280	280
query95	593	396	313	313
query96	596	468	204	204
query97	2284	2327	2243	2243
query98	210	197	202	197
query99	1330	1308	1204	1204
Total cold run time: 258343 ms
Total hot run time: 179305 ms

[doris-robot]

ClickBench: Total hot run time: 27.5 s

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

query1	0.06	0.05	0.04
query2	0.10	0.05	0.05
query3	0.26	0.09	0.09
query4	1.60	0.11	0.11
query5	0.28	0.28	0.27
query6	1.18	0.65	0.63
query7	0.03	0.02	0.03
query8	0.05	0.04	0.04
query9	0.59	0.52	0.52
query10	0.56	0.56	0.55
query11	0.17	0.11	0.12
query12	0.16	0.13	0.12
query13	0.64	0.61	0.60
query14	0.98	1.00	0.99
query15	0.82	0.80	0.80
query16	0.42	0.41	0.43
query17	1.06	0.99	1.00
query18	0.22	0.22	0.22
query19	1.98	1.90	1.87
query20	0.03	0.02	0.01
query21	15.45	0.28	0.15
query22	4.88	0.05	0.05
query23	16.12	0.28	0.10
query24	2.10	0.25	0.38
query25	0.11	0.06	0.06
query26	0.14	0.13	0.13
query27	0.07	0.05	0.05
query28	4.58	1.25	1.03
query29	12.60	4.03	3.32
query30	0.28	0.14	0.12
query31	2.82	0.65	0.39
query32	3.23	0.55	0.45
query33	2.98	3.06	3.13
query34	16.73	5.20	4.53
query35	4.55	4.53	4.54
query36	0.66	0.51	0.48
query37	0.11	0.07	0.08
query38	0.07	0.04	0.04
query39	0.04	0.03	0.03
query40	0.17	0.14	0.13
query41	0.09	0.03	0.03
query42	0.04	0.03	0.03
query43	0.05	0.03	0.03
Total cold run time: 99.06 s
Total hot run time: 27.5 s

[hello-stephen]

FE Regression Coverage Report

Increment line coverage 17.39% (4/23) :tada: Increment coverage report Complete coverage report

[hello-stephen]

FE Regression Coverage Report

Increment line coverage 17.39% (4/23) :tada: Increment coverage report Complete coverage report

[zddr]

run buildall