branch-3.1: [fix](dialect)fix starrocks dialect #50099

[github-actions[bot]]

Cherry-picked from #50099

[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?

[hello-stephen]

run buildall

[morrySnow]

run buildall

[doris-robot]

TPC-H: Total hot run time: 40033 ms

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

------ Round 1 ----------------------------------
q1	17569	6917	6635	6635
q2	2047	176	183	176
q3	10687	1096	1160	1096
q4	10553	779	664	664
q5	7775	2900	2873	2873
q6	227	140	138	138
q7	972	624	615	615
q8	9353	1987	2005	1987
q9	6638	6429	6432	6429
q10	7048	2292	2258	2258
q11	474	287	270	270
q12	416	220	223	220
q13	17826	2989	2991	2989
q14	230	211	209	209
q15	520	466	469	466
q16	521	401	394	394
q17	1000	590	598	590
q18	7253	6740	6701	6701
q19	1509	1068	1024	1024
q20	478	205	203	203
q21	4145	3536	3112	3112
q22	1087	1003	984	984
Total cold run time: 108328 ms
Total hot run time: 40033 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6605	6596	6717	6596
q2	335	234	242	234
q3	2961	2798	2967	2798
q4	2038	1849	1778	1778
q5	5842	5737	5758	5737
q6	206	135	138	135
q7	2215	1790	1838	1790
q8	3415	3565	3535	3535
q9	8984	8905	8854	8854
q10	3576	3531	3554	3531
q11	604	510	483	483
q12	801	601	583	583
q13	9601	3223	3166	3166
q14	302	271	280	271
q15	513	473	461	461
q16	496	459	450	450
q17	1862	1632	1610	1610
q18	8282	7731	7734	7731
q19	1701	1676	1513	1513
q20	2078	1814	1876	1814
q21	5104	5021	5121	5021
q22	1108	1069	997	997
Total cold run time: 68629 ms
Total hot run time: 59088 ms

[doris-robot]

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

query1	1281	932	914	914
query2	6341	1954	1896	1896
query3	10819	4356	4325	4325
query4	61391	28646	23894	23894
query5	5198	472	466	466
query6	425	191	180	180
query7	5491	342	322	322
query8	325	230	223	223
query9	8697	2608	2599	2599
query10	476	273	265	265
query11	17607	15339	15823	15339
query12	159	109	105	105
query13	1453	468	476	468
query14	10790	7255	7093	7093
query15	201	177	180	177
query16	7137	472	515	472
query17	1249	591	600	591
query18	1851	338	319	319
query19	217	165	169	165
query20	116	113	110	110
query21	208	104	109	104
query22	4648	4473	4641	4473
query23	35264	34168	34302	34168
query24	6267	2930	3002	2930
query25	546	445	425	425
query26	694	172	167	167
query27	1812	368	363	363
query28	4021	2219	2122	2122
query29	692	480	448	448
query30	235	163	159	159
query31	973	837	843	837
query32	67	55	63	55
query33	450	304	303	303
query34	937	526	542	526
query35	878	748	755	748
query36	1076	984	975	975
query37	118	71	67	67
query38	3990	3972	3981	3972
query39	1539	1504	1472	1472
query40	198	101	102	101
query41	62	46	48	46
query42	114	100	102	100
query43	545	478	476	476
query44	1198	817	821	817
query45	183	176	169	169
query46	1174	750	741	741
query47	2026	1920	1941	1920
query48	467	392	391	391
query49	712	400	401	400
query50	853	434	437	434
query51	7419	7316	7336	7316
query52	112	95	93	93
query53	274	191	189	189
query54	625	475	475	475
query55	79	79	81	79
query56	284	249	239	239
query57	1353	1214	1210	1210
query58	231	220	227	220
query59	3281	3118	3030	3030
query60	274	260	254	254
query61	115	131	156	131
query62	766	674	671	671
query63	217	191	189	189
query64	1385	650	622	622
query65	3280	3193	3228	3193
query66	633	296	299	296
query67	16049	15963	15627	15627
query68	4310	577	564	564
query69	434	271	265	265
query70	1172	1116	1085	1085
query71	321	264	253	253
query72	6431	4071	4033	4033
query73	775	364	355	355
query74	10233	8962	9259	8962
query75	3409	2676	2665	2665
query76	1900	1115	1036	1036
query77	489	272	264	264
query78	10552	9588	9543	9543
query79	2396	608	617	608
query80	1382	424	426	424
query81	526	216	217	216
query82	1251	90	88	88
query83	161	148	142	142
query84	287	80	76	76
query85	1010	300	298	298
query86	379	294	303	294
query87	4489	4218	4272	4218
query88	4074	2495	2526	2495
query89	430	293	299	293
query90	1873	188	191	188
query91	186	154	149	149
query92	69	50	52	50
query93	2850	578	565	565
query94	754	300	304	300
query95	352	256	260	256
query96	624	292	284	284
query97	3310	3121	3163	3121
query98	213	200	196	196
query99	1581	1275	1286	1275
Total cold run time: 317771 ms
Total hot run time: 198227 ms

[doris-robot]

ClickBench: Total hot run time: 30.71 s

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

query1	0.03	0.03	0.03
query2	0.07	0.03	0.03
query3	0.23	0.07	0.06
query4	1.62	0.10	0.10
query5	0.53	0.51	0.51
query6	1.13	0.72	0.73
query7	0.02	0.02	0.01
query8	0.03	0.04	0.03
query9	0.59	0.52	0.49
query10	0.56	0.54	0.56
query11	0.14	0.10	0.10
query12	0.14	0.11	0.12
query13	0.61	0.60	0.59
query14	0.77	0.81	0.80
query15	0.85	0.82	0.84
query16	0.39	0.39	0.40
query17	1.02	1.06	1.05
query18	0.24	0.22	0.23
query19	1.85	1.76	1.84
query20	0.02	0.01	0.01
query21	15.40	0.58	0.58
query22	2.31	2.31	1.75
query23	16.72	1.00	0.72
query24	3.57	1.50	2.46
query25	0.25	0.20	0.13
query26	0.58	0.14	0.15
query27	0.04	0.03	0.04
query28	8.26	0.55	0.50
query29	12.58	3.41	3.36
query30	0.25	0.06	0.06
query31	2.87	0.40	0.38
query32	3.24	0.47	0.45
query33	2.98	2.98	3.04
query34	17.18	4.47	4.45
query35	4.55	4.53	4.52
query36	0.70	0.48	0.48
query37	0.09	0.06	0.06
query38	0.05	0.04	0.03
query39	0.03	0.02	0.02
query40	0.16	0.13	0.13
query41	0.08	0.03	0.03
query42	0.03	0.02	0.03
query43	0.04	0.03	0.02
Total cold run time: 102.8 s
Total hot run time: 30.71 s