[feature](pipeline) mock sink execution with const blocks in BE tests

[Mryange]

What problem does this PR solve?

Release note

None

Check List (For Author)

• Test

  • 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

[Mryange]

run buildall

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

[Mryange]

run buildall

[hello-stephen]

TPC-H: Total hot run time: 29782 ms

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

------ Round 1 ----------------------------------
orders	Doris	NULL	NULL	0	0	0	NULL	0	NULL	NULL	2023-12-26 18:27:23	2023-12-26 18:42:55	NULL	utf-8	NULL	NULL	
============================================
q1	17990	4240	4059	4059
q2	q3	10818	1517	894	894
q4	4689	497	352	352
q5	7603	889	600	600
q6	184	173	137	137
q7	777	866	632	632
q8	9339	1612	1606	1606
q9	5986	4575	4565	4565
q10	6834	1823	1512	1512
q11	438	275	258	258
q12	636	433	298	298
q13	18114	3481	2765	2765
q14	271	264	235	235
q15	q16	825	774	714	714
q17	1028	954	988	954
q18	7075	5854	5683	5683
q19	1312	1322	1135	1135
q20	490	398	272	272
q21	6439	2895	2782	2782
q22	473	391	329	329
Total cold run time: 101321 ms
Total hot run time: 29782 ms

----- Round 2, with runtime_filter_mode=off -----
orders	Doris	NULL	NULL	150000000	42	6422171781	NULL	22778155	NULL	NULL	2023-12-26 18:27:23	2023-12-26 18:42:55	NULL	utf-8	NULL	NULL	
============================================
q1	5157	4730	4902	4730
q2	q3	4920	5288	4751	4751
q4	2285	2381	1418	1418
q5	4988	4959	4829	4829
q6	237	176	128	128
q7	1887	1809	1595	1595
q8	2485	2128	2285	2128
q9	8071	7749	7497	7497
q10	4785	4665	4223	4223
q11	544	399	355	355
q12	743	751	534	534
q13	3048	3436	2791	2791
q14	290	275	254	254
q15	q16	679	723	611	611
q17	1327	1289	1298	1289
q18	7323	6856	7034	6856
q19	1147	1110	1115	1110
q20	2226	2241	1974	1974
q21	5437	4750	4561	4561
q22	569	487	417	417
Total cold run time: 58148 ms
Total hot run time: 52051 ms

[hello-stephen]

TPC-DS: Total hot run time: 169831 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 953596c3a2276d862124be65675af1122180ef89, data reload: false

query5	4338	626	483	483
query6	434	198	182	182
query7	4821	559	298	298
query8	371	225	208	208
query9	8801	4042	4045	4042
query10	450	311	262	262
query11	5865	2584	2216	2216
query12	164	103	97	97
query13	1293	623	462	462
query14	6443	5500	5113	5113
query14_1	4447	4465	4442	4442
query15	213	207	186	186
query16	1028	422	462	422
query17	1132	730	606	606
query18	2504	500	366	366
query19	211	195	149	149
query20	112	113	110	110
query21	224	148	124	124
query22	13712	13642	13442	13442
query23	17527	16575	16174	16174
query23_1	16278	16312	16406	16312
query24	7678	1800	1325	1325
query24_1	1305	1329	1327	1327
query25	552	450	386	386
query26	1297	317	165	165
query27	2689	542	345	345
query28	4446	2025	2007	2007
query29	1089	635	481	481
query30	309	243	198	198
query31	1105	1077	970	970
query32	106	65	57	57
query33	527	314	251	251
query34	1216	1154	647	647
query35	739	786	685	685
query36	1372	1418	1208	1208
query37	152	108	93	93
query38	3321	3179	3022	3022
query39	938	926	894	894
query39_1	892	899	881	881
query40	229	133	112	112
query41	65	62	62	62
query42	97	122	96	96
query43	318	324	285	285
query44	
query45	201	191	182	182
query46	1101	1197	765	765
query47	2364	2400	2231	2231
query48	412	402	286	286
query49	633	471	355	355
query50	1006	343	254	254
query51	4349	4467	4337	4337
query52	90	89	79	79
query53	258	272	194	194
query54	269	220	204	204
query55	80	77	75	75
query56	250	249	216	216
query57	1455	1394	1337	1337
query58	246	219	210	210
query59	1623	1680	1432	1432
query60	289	246	240	240
query61	164	151	169	151
query62	695	665	584	584
query63	238	188	186	186
query64	2594	810	638	638
query65	
query66	1788	462	350	350
query67	29891	29702	29613	29613
query68	
query69	427	304	262	262
query70	981	983	964	964
query71	306	236	214	214
query72	3081	2760	2423	2423
query73	832	767	437	437
query74	5104	4995	4787	4787
query75	2684	2593	2253	2253
query76	2348	1171	757	757
query77	361	372	283	283
query78	12368	12583	11825	11825
query79	1321	1021	774	774
query80	586	470	404	404
query81	452	288	242	242
query82	619	156	121	121
query83	354	278	250	250
query84	260	143	110	110
query85	883	531	456	456
query86	398	302	280	280
query87	3359	3337	3162	3162
query88	3623	2712	2711	2711
query89	425	378	328	328
query90	1878	185	182	182
query91	179	170	143	143
query92	68	67	58	58
query93	1495	1506	876	876
query94	559	385	319	319
query95	683	497	369	369
query96	1122	817	365	365
query97	2738	2743	2622	2622
query98	212	204	214	204
query99	1183	1202	1057	1057
Total cold run time: 252008 ms
Total hot run time: 169831 ms

[hello-stephen]

TPC-H: Total hot run time: 29483 ms

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

------ Round 1 ----------------------------------
orders	Doris	NULL	NULL	0	0	0	NULL	0	NULL	NULL	2023-12-26 18:27:23	2023-12-26 18:42:55	NULL	utf-8	NULL	NULL	
============================================
q1	17690	4032	4020	4020
q2	q3	10747	1445	793	793
q4	4688	482	343	343
q5	7595	877	595	595
q6	185	171	137	137
q7	811	832	647	647
q8	9393	1701	1651	1651
q9	5854	4531	4534	4531
q10	6764	1818	1523	1523
q11	439	272	251	251
q12	631	428	295	295
q13	18093	3361	2825	2825
q14	265	263	255	255
q15	q16	819	775	710	710
q17	999	982	1028	982
q18	7114	5849	5552	5552
q19	1309	1335	1098	1098
q20	506	395	257	257
q21	6304	2859	2687	2687
q22	480	390	331	331
Total cold run time: 100686 ms
Total hot run time: 29483 ms

----- Round 2, with runtime_filter_mode=off -----
orders	Doris	NULL	NULL	150000000	42	6422171781	NULL	22778155	NULL	NULL	2023-12-26 18:27:23	2023-12-26 18:42:55	NULL	utf-8	NULL	NULL	
============================================
q1	5058	4737	4825	4737
q2	q3	4873	5263	4646	4646
q4	2150	2210	1405	1405
q5	4760	4847	4664	4664
q6	232	175	124	124
q7	1861	1937	1611	1611
q8	2414	2072	2085	2072
q9	7909	7713	7382	7382
q10	4739	4668	4182	4182
q11	538	388	358	358
q12	742	748	527	527
q13	3025	3398	2805	2805
q14	284	272	257	257
q15	q16	676	707	605	605
q17	1287	1262	1269	1262
q18	7224	6733	6833	6733
q19	1163	1099	1129	1099
q20	2227	2222	1945	1945
q21	5364	4584	4514	4514
q22	525	467	432	432
Total cold run time: 57051 ms
Total hot run time: 51360 ms

[hello-stephen]

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

query5	4338	636	489	489
query6	452	204	184	184
query7	4942	579	299	299
query8	366	209	209	209
query9	8793	4031	4033	4031
query10	455	343	269	269
query11	5919	2346	2147	2147
query12	163	106	101	101
query13	1300	623	445	445
query14	6389	5422	5050	5050
query14_1	4384	4400	4387	4387
query15	201	195	179	179
query16	1056	481	458	458
query17	1106	696	566	566
query18	2708	474	366	366
query19	205	181	143	143
query20	110	106	104	104
query21	215	138	118	118
query22	13713	13587	13528	13528
query23	17319	16546	16147	16147
query23_1	16333	16270	16360	16270
query24	7559	1797	1331	1331
query24_1	1329	1317	1306	1306
query25	583	483	420	420
query26	1309	325	180	180
query27	2646	569	346	346
query28	4500	2010	2031	2010
query29	1113	641	506	506
query30	317	239	204	204
query31	1116	1080	957	957
query32	108	64	62	62
query33	553	335	287	287
query34	1203	1131	647	647
query35	765	791	689	689
query36	1425	1412	1251	1251
query37	155	111	98	98
query38	3222	3146	3080	3080
query39	963	916	894	894
query39_1	894	889	886	886
query40	227	140	107	107
query41	70	69	68	68
query42	98	99	98	98
query43	318	329	284	284
query44	
query45	203	189	186	186
query46	1085	1217	754	754
query47	2332	2405	2232	2232
query48	406	432	298	298
query49	662	492	407	407
query50	1028	358	260	260
query51	4399	4292	4284	4284
query52	91	91	79	79
query53	245	273	194	194
query54	287	237	220	220
query55	84	80	75	75
query56	251	247	230	230
query57	1420	1429	1315	1315
query58	270	222	223	222
query59	1565	1656	1461	1461
query60	305	306	225	225
query61	155	154	157	154
query62	695	667	589	589
query63	234	189	182	182
query64	2523	815	609	609
query65	
query66	1740	467	357	357
query67	29914	29113	29716	29113
query68	
query69	420	304	276	276
query70	984	935	950	935
query71	305	213	213	213
query72	2956	2712	2455	2455
query73	906	757	431	431
query74	5134	4938	4785	4785
query75	2666	2599	2243	2243
query76	2302	1174	754	754
query77	363	370	288	288
query78	12429	12549	11944	11944
query79	1444	1047	780	780
query80	955	470	416	416
query81	524	282	240	240
query82	560	159	123	123
query83	350	279	244	244
query84	253	141	111	111
query85	927	535	441	441
query86	413	296	282	282
query87	3461	3329	3177	3177
query88	3632	2727	2693	2693
query89	440	382	334	334
query90	1910	186	177	177
query91	181	168	142	142
query92	70	61	58	58
query93	1436	1405	896	896
query94	630	354	336	336
query95	676	476	340	340
query96	1056	812	345	345
query97	2691	2705	2551	2551
query98	214	205	204	204
query99	1191	1174	1032	1032
Total cold run time: 252672 ms
Total hot run time: 169663 ms

[Mryange]

run buildall

[Mryange]

run buildall

[Mryange]

run buildall

[hello-stephen]

TPC-H: Total hot run time: 29522 ms

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

------ Round 1 ----------------------------------
orders	Doris	NULL	NULL	0	0	0	NULL	0	NULL	NULL	2023-12-26 18:27:23	2023-12-26 18:42:55	NULL	utf-8	NULL	NULL	
============================================
q1	17770	4064	4032	4032
q2	q3	10759	1447	799	799
q4	4689	481	344	344
q5	7548	901	575	575
q6	175	172	134	134
q7	777	871	640	640
q8	9347	1684	1652	1652
q9	5840	4534	4558	4534
q10	6792	1848	1568	1568
q11	440	273	254	254
q12	635	434	297	297
q13	18119	3439	2830	2830
q14	266	253	235	235
q15	q16	820	772	711	711
q17	1011	1009	978	978
q18	6795	5697	5535	5535
q19	1154	1276	1122	1122
q20	491	399	259	259
q21	6027	2875	2697	2697
q22	470	372	326	326
Total cold run time: 99925 ms
Total hot run time: 29522 ms

----- Round 2, with runtime_filter_mode=off -----
orders	Doris	NULL	NULL	150000000	42	6422171781	NULL	22778155	NULL	NULL	2023-12-26 18:27:23	2023-12-26 18:42:55	NULL	utf-8	NULL	NULL	
============================================
q1	5158	4871	4859	4859
q2	q3	4848	5306	4719	4719
q4	2152	2206	1363	1363
q5	4808	4919	4733	4733
q6	230	173	126	126
q7	1858	1782	1589	1589
q8	2461	2138	2068	2068
q9	8004	7684	7431	7431
q10	4762	4692	4218	4218
q11	536	384	351	351
q12	725	736	519	519
q13	3017	3433	2829	2829
q14	269	272	249	249
q15	q16	671	715	607	607
q17	1279	1290	1258	1258
q18	7215	6707	6858	6707
q19	1111	1104	1093	1093
q20	2221	2221	1939	1939
q21	5269	4579	4371	4371
q22	507	456	418	418
Total cold run time: 57101 ms
Total hot run time: 51447 ms

[hello-stephen]

TPC-DS: Total hot run time: 169248 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 3eaec4bb26375a3f3d933a03233813f2ab73544a, data reload: false

query5	4339	635	496	496
query6	442	207	181	181
query7	4850	584	303	303
query8	371	215	205	205
query9	8792	4130	4092	4092
query10	455	311	267	267
query11	5927	2336	2129	2129
query12	159	108	104	104
query13	1259	575	439	439
query14	6591	5410	5055	5055
query14_1	4484	4397	4422	4397
query15	214	195	196	195
query16	1050	494	454	454
query17	1153	699	594	594
query18	2728	481	350	350
query19	212	189	154	154
query20	119	108	105	105
query21	223	149	117	117
query22	13705	13571	13334	13334
query23	17377	16448	16180	16180
query23_1	16369	16324	16292	16292
query24	7474	1759	1293	1293
query24_1	1276	1308	1303	1303
query25	545	464	381	381
query26	1304	304	165	165
query27	2585	571	343	343
query28	4431	2066	2072	2066
query29	1100	589	481	481
query30	311	236	189	189
query31	1110	1073	942	942
query32	104	62	58	58
query33	515	319	240	240
query34	1188	1108	667	667
query35	759	793	673	673
query36	1386	1362	1204	1204
query37	158	107	92	92
query38	3259	3154	3077	3077
query39	928	922	900	900
query39_1	880	909	886	886
query40	222	123	100	100
query41	65	64	63	63
query42	97	97	94	94
query43	319	326	281	281
query44	
query45	191	186	185	185
query46	1108	1204	767	767
query47	2344	2376	2266	2266
query48	376	406	303	303
query49	654	464	349	349
query50	1008	336	256	256
query51	4304	4279	4256	4256
query52	120	89	78	78
query53	257	267	192	192
query54	266	217	193	193
query55	75	74	72	72
query56	245	219	222	219
query57	1437	1398	1324	1324
query58	247	226	204	204
query59	1565	1634	1419	1419
query60	283	254	228	228
query61	162	158	160	158
query62	682	668	577	577
query63	240	184	178	178
query64	2524	795	635	635
query65	
query66	1740	484	343	343
query67	29782	29640	29667	29640
query68	
query69	428	315	265	265
query70	1000	960	945	945
query71	290	221	208	208
query72	2993	2725	2433	2433
query73	865	760	425	425
query74	5115	4934	4785	4785
query75	2670	2562	2266	2266
query76	2323	1133	778	778
query77	353	380	289	289
query78	12401	12296	11906	11906
query79	1359	1056	766	766
query80	522	469	400	400
query81	442	277	259	259
query82	233	156	121	121
query83	270	274	251	251
query84	256	141	114	114
query85	842	530	452	452
query86	346	293	280	280
query87	3343	3348	3201	3201
query88	3596	2746	2763	2746
query89	429	384	337	337
query90	2207	185	186	185
query91	177	166	144	144
query92	65	65	53	53
query93	1540	1384	984	984
query94	528	338	307	307
query95	681	468	359	359
query96	1057	767	355	355
query97	2708	2699	2525	2525
query98	212	209	205	205
query99	1149	1171	1029	1029
Total cold run time: 251306 ms
Total hot run time: 169248 ms

[hello-stephen]

TPC-H: Total hot run time: 29257 ms

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

------ Round 1 ----------------------------------
orders	Doris	NULL	NULL	0	0	0	NULL	0	NULL	NULL	2023-12-26 18:27:23	2023-12-26 18:42:55	NULL	utf-8	NULL	NULL	
============================================
q1	17633	4007	4025	4007
q2	q3	10801	1388	809	809
q4	4683	475	341	341
q5	7575	875	591	591
q6	183	169	141	141
q7	809	842	643	643
q8	9639	1644	1599	1599
q9	6823	4487	4524	4487
q10	6828	1789	1519	1519
q11	438	262	245	245
q12	651	423	288	288
q13	18130	3405	2693	2693
q14	263	255	244	244
q15	q16	816	776	706	706
q17	979	946	976	946
q18	6853	5724	5671	5671
q19	1294	1304	1020	1020
q20	504	394	265	265
q21	6355	2843	2721	2721
q22	465	360	321	321
Total cold run time: 101722 ms
Total hot run time: 29257 ms

----- Round 2, with runtime_filter_mode=off -----
orders	Doris	NULL	NULL	150000000	42	6422171781	NULL	22778155	NULL	NULL	2023-12-26 18:27:23	2023-12-26 18:42:55	NULL	utf-8	NULL	NULL	
============================================
q1	4782	4842	4707	4707
q2	q3	5039	5254	4632	4632
q4	2221	2199	1413	1413
q5	4858	4797	4709	4709
q6	230	185	132	132
q7	1970	1806	1554	1554
q8	2379	1926	1897	1897
q9	7454	7442	7337	7337
q10	4757	4666	4193	4193
q11	527	383	351	351
q12	729	736	523	523
q13	3058	3262	2810	2810
q14	270	284	258	258
q15	q16	680	699	601	601
q17	1264	1241	1240	1240
q18	7373	6804	6781	6781
q19	1128	1079	1101	1079
q20	2198	2225	1941	1941
q21	5261	4608	4429	4429
q22	516	456	423	423
Total cold run time: 56694 ms
Total hot run time: 51010 ms

[hello-stephen]

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

query5	4337	650	483	483
query6	450	207	174	174
query7	4821	555	290	290
query8	366	236	233	233
query9	8750	3994	3995	3994
query10	441	314	255	255
query11	5851	2334	2174	2174
query12	157	104	99	99
query13	1267	623	436	436
query14	6379	5464	5069	5069
query14_1	4412	4405	4416	4405
query15	207	199	177	177
query16	1017	475	470	470
query17	1125	736	613	613
query18	2711	503	359	359
query19	219	191	156	156
query20	120	112	106	106
query21	214	138	119	119
query22	13738	13516	13341	13341
query23	17298	16556	16104	16104
query23_1	16305	16213	16361	16213
query24	7440	1781	1364	1364
query24_1	1314	1296	1324	1296
query25	591	500	419	419
query26	1307	307	174	174
query27	2658	555	357	357
query28	4471	2060	2033	2033
query29	1104	628	501	501
query30	310	241	201	201
query31	1142	1083	948	948
query32	110	65	63	63
query33	531	329	266	266
query34	1190	1177	660	660
query35	767	834	698	698
query36	1404	1434	1240	1240
query37	153	101	88	88
query38	3201	3130	3038	3038
query39	934	918	919	918
query39_1	860	871	902	871
query40	219	122	101	101
query41	64	63	60	60
query42	95	98	91	91
query43	313	314	272	272
query44	
query45	193	185	182	182
query46	1057	1267	766	766
query47	2394	2430	2257	2257
query48	400	398	298	298
query49	627	467	361	361
query50	951	347	263	263
query51	4318	4372	4292	4292
query52	88	88	78	78
query53	233	270	196	196
query54	282	214	202	202
query55	81	76	69	69
query56	249	229	225	225
query57	1467	1442	1346	1346
query58	268	217	210	210
query59	1535	1627	1396	1396
query60	281	251	237	237
query61	166	154	152	152
query62	692	656	586	586
query63	234	187	183	183
query64	2535	771	647	647
query65	
query66	1753	457	345	345
query67	29687	29623	29553	29553
query68	
query69	415	304	277	277
query70	937	943	942	942
query71	295	220	209	209
query72	2928	2734	2432	2432
query73	856	758	442	442
query74	5112	4919	4752	4752
query75	2678	2581	2260	2260
query76	2304	1128	780	780
query77	365	370	283	283
query78	12524	12502	11814	11814
query79	1413	1032	769	769
query80	1311	488	392	392
query81	523	281	240	240
query82	633	156	120	120
query83	325	268	256	256
query84	262	143	115	115
query85	907	526	433	433
query86	424	309	276	276
query87	3365	3397	3152	3152
query88	3633	2753	2712	2712
query89	434	382	333	333
query90	1953	182	176	176
query91	176	164	140	140
query92	64	62	70	62
query93	1617	1391	932	932
query94	720	366	277	277
query95	694	457	344	344
query96	1072	769	322	322
query97	2757	2702	2572	2572
query98	211	204	202	202
query99	1161	1194	1029	1029
Total cold run time: 252198 ms
Total hot run time: 168979 ms