Skip to content

[refine](expr)Check the column returned after each expression execution.#60569

Open
Mryange wants to merge 2 commits intoapache:masterfrom
Mryange:add-expr-exec-check
Open

[refine](expr)Check the column returned after each expression execution.#60569
Mryange wants to merge 2 commits intoapache:masterfrom
Mryange:add-expr-exec-check

Conversation

@Mryange
Copy link
Contributor

@Mryange Mryange commented Feb 6, 2026

What problem does this PR solve?

After every call to execute_column, verify that the returned column is valid.
This PR also adds const to the Selector* selector parameter.

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

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

@Mryange
Copy link
Contributor Author

Mryange commented Feb 6, 2026

run buildall

2 similar comments
@Mryange
Copy link
Contributor Author

Mryange commented Feb 6, 2026

run buildall

@Mryange
Copy link
Contributor Author

Mryange commented Feb 6, 2026

run buildall

@doris-robot
Copy link

TPC-H: Total hot run time: 30451 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit e4c3ff81cbe1092ed083dd2a767eaaa5d6dffad4, data reload: false

------ Round 1 ----------------------------------
q1	17629	4498	4323	4323
q2	2031	399	243	243
q3	10114	1326	752	752
q4	10194	799	324	324
q5	7526	2239	1987	1987
q6	201	183	152	152
q7	881	746	625	625
q8	9279	1417	1189	1189
q9	4820	4633	4664	4633
q10	6821	1924	1558	1558
q11	519	304	295	295
q12	367	376	228	228
q13	17770	4108	3207	3207
q14	232	242	221	221
q15	897	802	818	802
q16	681	673	615	615
q17	702	868	538	538
q18	6532	5771	5652	5652
q19	1101	1015	631	631
q20	502	485	386	386
q21	2596	1828	1801	1801
q22	365	322	289	289
Total cold run time: 101760 ms
Total hot run time: 30451 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4407	4379	4384	4379
q2	272	348	252	252
q3	2110	2659	2245	2245
q4	1338	1778	1290	1290
q5	4413	4135	4322	4135
q6	225	180	140	140
q7	1834	1816	1637	1637
q8	2502	2724	2464	2464
q9	7651	7498	7525	7498
q10	2818	3148	2592	2592
q11	564	482	456	456
q12	659	749	607	607
q13	3910	4501	3531	3531
q14	312	327	322	322
q15	887	858	834	834
q16	680	723	698	698
q17	1154	1347	1415	1347
q18	8093	8037	8016	8016
q19	950	944	970	944
q20	2144	2154	1954	1954
q21	4886	4466	4347	4347
q22	585	598	553	553
Total cold run time: 52394 ms
Total hot run time: 50241 ms

@doris-robot
Copy link

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

query1	0.05	0.04	0.04
query2	0.10	0.04	0.04
query3	0.26	0.08	0.08
query4	1.60	0.11	0.11
query5	0.27	0.25	0.25
query6	1.16	0.67	0.67
query7	0.03	0.03	0.02
query8	0.05	0.04	0.04
query9	0.56	0.50	0.48
query10	0.55	0.56	0.55
query11	0.15	0.10	0.09
query12	0.14	0.11	0.11
query13	0.63	0.61	0.63
query14	1.06	1.04	1.05
query15	0.87	0.86	0.87
query16	0.40	0.39	0.42
query17	1.14	1.10	1.16
query18	0.22	0.21	0.22
query19	2.06	1.95	1.98
query20	0.02	0.02	0.01
query21	15.40	0.25	0.14
query22	5.24	0.06	0.05
query23	16.09	0.30	0.10
query24	1.87	0.40	0.66
query25	0.08	0.06	0.09
query26	0.15	0.13	0.14
query27	0.06	0.09	0.06
query28	4.85	1.14	0.97
query29	12.56	3.97	3.21
query30	0.28	0.14	0.12
query31	2.82	0.65	0.42
query32	3.23	0.62	0.49
query33	3.21	3.30	3.26
query34	16.02	5.39	4.76
query35	4.81	4.80	4.69
query36	0.65	0.50	0.48
query37	0.11	0.07	0.08
query38	0.07	0.04	0.05
query39	0.04	0.03	0.03
query40	0.19	0.16	0.15
query41	0.09	0.04	0.03
query42	0.05	0.03	0.03
query43	0.05	0.04	0.04
Total cold run time: 99.24 s
Total hot run time: 28.38 s

@Mryange
Copy link
Contributor Author

Mryange commented Feb 7, 2026

run buildall

@doris-robot
Copy link

TPC-H: Total hot run time: 30184 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit ea68e5a9b449d01a4e5c9906b964b4579f1f7e77, data reload: false

------ Round 1 ----------------------------------
q1	17628	4400	4301	4301
q2	2007	353	236	236
q3	10175	1317	717	717
q4	10199	784	317	317
q5	7537	2250	1901	1901
q6	198	179	145	145
q7	888	749	630	630
q8	9272	1367	1114	1114
q9	4815	4634	4540	4540
q10	6861	1947	1553	1553
q11	528	297	275	275
q12	401	376	219	219
q13	17802	4082	3234	3234
q14	251	239	219	219
q15	890	808	811	808
q16	684	673	634	634
q17	702	810	539	539
q18	6478	5734	5727	5727
q19	1504	983	604	604
q20	507	488	372	372
q21	2570	1871	1814	1814
q22	363	326	285	285
Total cold run time: 102260 ms
Total hot run time: 30184 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4437	4367	4359	4359
q2	257	339	254	254
q3	2101	2687	2191	2191
q4	1349	1737	1289	1289
q5	4275	4239	4174	4174
q6	226	177	134	134
q7	1864	1772	1678	1678
q8	2519	2678	2531	2531
q9	7588	7533	7521	7521
q10	2875	3095	2560	2560
q11	539	509	453	453
q12	727	772	595	595
q13	3911	4530	3852	3852
q14	344	322	290	290
q15	874	813	806	806
q16	856	710	670	670
q17	1156	1378	1405	1378
q18	8247	8182	7802	7802
q19	910	878	853	853
q20	2036	2313	1974	1974
q21	4898	4755	4324	4324
q22	581	533	488	488
Total cold run time: 52570 ms
Total hot run time: 50176 ms

@doris-robot
Copy link

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

query1	0.05	0.04	0.04
query2	0.09	0.04	0.04
query3	0.25	0.09	0.08
query4	1.61	0.11	0.11
query5	0.28	0.25	0.24
query6	1.17	0.67	0.66
query7	0.03	0.03	0.03
query8	0.05	0.04	0.04
query9	0.56	0.49	0.49
query10	0.55	0.54	0.54
query11	0.13	0.09	0.09
query12	0.14	0.11	0.10
query13	0.65	0.61	0.62
query14	1.05	1.06	1.07
query15	0.89	0.87	0.86
query16	0.40	0.38	0.38
query17	1.15	1.13	1.10
query18	0.22	0.21	0.21
query19	2.01	1.96	2.02
query20	0.02	0.02	0.01
query21	15.39	0.26	0.16
query22	5.01	0.07	0.06
query23	15.74	0.28	0.10
query24	1.51	0.63	0.50
query25	0.13	0.08	0.06
query26	0.14	0.13	0.13
query27	0.07	0.08	0.05
query28	5.08	1.13	0.96
query29	12.55	3.84	3.14
query30	0.28	0.12	0.11
query31	2.82	0.63	0.39
query32	3.23	0.60	0.48
query33	3.26	3.22	3.24
query34	16.40	5.36	4.73
query35	4.76	4.78	4.76
query36	0.66	0.49	0.49
query37	0.11	0.07	0.07
query38	0.07	0.04	0.04
query39	0.04	0.03	0.03
query40	0.20	0.16	0.15
query41	0.09	0.04	0.03
query42	0.04	0.03	0.02
query43	0.04	0.04	0.04
Total cold run time: 98.92 s
Total hot run time: 28.37 s

@doris-robot
Copy link

BE UT Coverage Report

Increment line coverage 34.00% (17/50) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 52.53% (19371/36873)
Line Coverage 36.06% (180215/499789)
Region Coverage 32.41% (139738/431136)
Branch Coverage 33.44% (60519/181002)

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 84.00% (42/50) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 71.72% (25917/36136)
Line Coverage 54.33% (270875/498561)
Region Coverage 51.75% (225392/435522)
Branch Coverage 53.24% (96743/181710)

@Mryange
Copy link
Contributor Author

Mryange commented Feb 8, 2026

run buildall

@doris-robot
Copy link

TPC-H: Total hot run time: 30116 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit ea68e5a9b449d01a4e5c9906b964b4579f1f7e77, data reload: false

------ Round 1 ----------------------------------
q1	17618	4578	4290	4290
q2	2030	377	229	229
q3	10125	1275	723	723
q4	10197	762	315	315
q5	7505	2161	1899	1899
q6	186	174	150	150
q7	881	748	601	601
q8	9249	1342	1135	1135
q9	4635	4618	4584	4584
q10	6781	1921	1540	1540
q11	528	298	295	295
q12	327	417	234	234
q13	17767	4020	3241	3241
q14	234	227	213	213
q15	892	820	808	808
q16	676	664	625	625
q17	681	801	532	532
q18	6532	5876	5612	5612
q19	1247	988	648	648
q20	497	498	379	379
q21	2485	1841	1781	1781
q22	359	315	282	282
Total cold run time: 101432 ms
Total hot run time: 30116 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4317	4362	4306	4306
q2	267	340	264	264
q3	2173	2752	2339	2339
q4	1395	1745	1387	1387
q5	4429	4213	4230	4213
q6	211	177	140	140
q7	1843	1807	1685	1685
q8	2486	2600	2415	2415
q9	7611	7473	7434	7434
q10	2780	3106	2624	2624
q11	539	494	459	459
q12	716	748	585	585
q13	3969	4284	3620	3620
q14	297	319	393	319
q15	858	789	780	780
q16	656	734	651	651
q17	1371	1310	1347	1310
q18	8499	8039	7770	7770
q19	841	794	828	794
q20	2086	2125	2025	2025
q21	4976	4446	4539	4446
q22	572	528	517	517
Total cold run time: 52892 ms
Total hot run time: 50083 ms

@doris-robot
Copy link

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

query1	0.06	0.04	0.04
query2	0.10	0.05	0.05
query3	0.26	0.08	0.08
query4	1.60	0.11	0.12
query5	0.28	0.25	0.24
query6	1.17	0.67	0.68
query7	0.03	0.02	0.03
query8	0.05	0.04	0.04
query9	0.56	0.50	0.49
query10	0.55	0.54	0.55
query11	0.14	0.10	0.10
query12	0.14	0.10	0.10
query13	0.61	0.62	0.61
query14	1.04	1.06	1.06
query15	0.89	0.86	0.87
query16	0.40	0.38	0.37
query17	1.14	1.13	1.14
query18	0.23	0.22	0.21
query19	2.12	1.98	1.98
query20	0.02	0.02	0.01
query21	15.41	0.28	0.14
query22	5.36	0.05	0.06
query23	16.15	0.28	0.11
query24	1.00	0.70	0.23
query25	0.13	0.11	0.05
query26	0.16	0.12	0.13
query27	0.07	0.06	0.05
query28	3.97	1.15	0.96
query29	12.54	3.83	3.12
query30	0.27	0.14	0.11
query31	2.83	0.65	0.41
query32	3.23	0.60	0.50
query33	3.20	3.20	3.23
query34	16.20	5.44	4.70
query35	4.79	4.76	4.73
query36	0.64	0.49	0.49
query37	0.11	0.07	0.07
query38	0.07	0.04	0.04
query39	0.05	0.03	0.03
query40	0.20	0.15	0.15
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: 97.95 s
Total hot run time: 28.06 s

@doris-robot
Copy link

BE UT Coverage Report

Increment line coverage 34.00% (17/50) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 52.53% (19371/36873)
Line Coverage 36.06% (180227/499789)
Region Coverage 32.44% (139867/431136)
Branch Coverage 33.45% (60538/181002)

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 84.00% (42/50) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 71.72% (25917/36136)
Line Coverage 54.33% (270874/498561)
Region Coverage 51.76% (225438/435522)
Branch Coverage 53.24% (96745/181710)

1 similar comment
@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 84.00% (42/50) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 71.72% (25917/36136)
Line Coverage 54.33% (270874/498561)
Region Coverage 51.76% (225438/435522)
Branch Coverage 53.24% (96745/181710)

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 84.00% (42/50) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 71.73% (25922/36136)
Line Coverage 54.34% (270929/498561)
Region Coverage 51.78% (225521/435522)
Branch Coverage 53.26% (96776/181710)

1 similar comment
@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 84.00% (42/50) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 71.73% (25922/36136)
Line Coverage 54.34% (270929/498561)
Region Coverage 51.78% (225521/435522)
Branch Coverage 53.26% (96776/181710)

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 84.00% (42/50) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 71.73% (25922/36136)
Line Coverage 54.35% (270943/498561)
Region Coverage 51.79% (225564/435522)
Branch Coverage 53.27% (96793/181710)

@Mryange Mryange force-pushed the add-expr-exec-check branch from ea68e5a to 7dfd970 Compare February 11, 2026 01:55
@Mryange
Copy link
Contributor Author

Mryange commented Feb 11, 2026

run buildall

2 similar comments
@Mryange
Copy link
Contributor Author

Mryange commented Feb 11, 2026

run buildall

@Mryange
Copy link
Contributor Author

Mryange commented Feb 11, 2026

run buildall

@doris-robot
Copy link

TPC-H: Total hot run time: 30795 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 262f8a1fc4a75500576cc54c14705d79cf3fe2bf, data reload: false

------ Round 1 ----------------------------------
q1	17593	4475	4271	4271
q2	2107	358	255	255
q3	10092	1335	742	742
q4	10195	779	306	306
q5	7542	2252	1940	1940
q6	201	180	149	149
q7	861	761	605	605
q8	9261	1408	1111	1111
q9	4944	4700	4652	4652
q10	6836	1960	1566	1566
q11	460	249	239	239
q12	400	384	220	220
q13	17792	4088	3236	3236
q14	232	246	226	226
q15	888	816	807	807
q16	693	677	650	650
q17	698	825	577	577
q18	6571	5931	6253	5931
q19	1235	1084	675	675
q20	568	605	445	445
q21	2788	1997	1919	1919
q22	348	303	273	273
Total cold run time: 102305 ms
Total hot run time: 30795 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4581	4577	4585	4577
q2	265	352	272	272
q3	2412	2931	2401	2401
q4	1445	1938	1373	1373
q5	4704	4562	4428	4428
q6	228	181	138	138
q7	1986	1867	1739	1739
q8	2799	2348	2412	2348
q9	7607	7632	7340	7340
q10	2859	3096	2691	2691
q11	502	430	409	409
q12	721	719	668	668
q13	3954	4445	3436	3436
q14	278	318	280	280
q15	858	888	814	814
q16	676	749	654	654
q17	1189	1316	1457	1316
q18	7694	7308	7526	7308
q19	816	790	799	790
q20	1950	2067	1874	1874
q21	4612	4190	4097	4097
q22	498	459	428	428
Total cold run time: 52634 ms
Total hot run time: 49381 ms

@doris-robot
Copy link

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

query1	0.05	0.05	0.05
query2	0.10	0.05	0.04
query3	0.27	0.09	0.09
query4	1.60	0.12	0.11
query5	0.27	0.26	0.25
query6	1.17	0.66	0.67
query7	0.03	0.02	0.02
query8	0.05	0.04	0.04
query9	0.56	0.50	0.50
query10	0.55	0.55	0.53
query11	0.15	0.10	0.09
query12	0.14	0.10	0.11
query13	0.63	0.62	0.63
query14	1.07	1.08	1.06
query15	0.88	0.85	0.89
query16	0.42	0.42	0.42
query17	1.15	1.12	1.17
query18	0.24	0.21	0.21
query19	2.13	2.04	2.06
query20	0.02	0.01	0.02
query21	15.39	0.27	0.15
query22	5.18	0.05	0.05
query23	15.96	0.29	0.11
query24	2.21	0.29	0.60
query25	0.12	0.09	0.07
query26	0.15	0.15	0.14
query27	0.06	0.06	0.06
query28	5.30	1.14	0.96
query29	12.58	3.93	3.21
query30	0.28	0.13	0.12
query31	2.82	0.65	0.42
query32	3.25	0.60	0.50
query33	3.35	3.26	3.28
query34	16.43	5.42	4.71
query35	4.90	4.82	4.77
query36	0.65	0.49	0.48
query37	0.11	0.07	0.07
query38	0.08	0.04	0.05
query39	0.05	0.03	0.02
query40	0.19	0.16	0.16
query41	0.10	0.03	0.03
query42	0.04	0.03	0.03
query43	0.05	0.04	0.04
Total cold run time: 100.73 s
Total hot run time: 28.5 s

@Mryange
Copy link
Contributor Author

Mryange commented Feb 11, 2026

run buildall

@doris-robot
Copy link

TPC-H: Total hot run time: 30821 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 4e661e221e75a51440a219aa47f522e1b2370d91, data reload: false

------ Round 1 ----------------------------------
q1	17626	4497	4303	4303
q2	2010	349	258	258
q3	10150	1311	736	736
q4	10199	790	308	308
q5	7523	2224	1935	1935
q6	206	180	146	146
q7	922	722	609	609
q8	9279	1456	1122	1122
q9	4911	4696	4715	4696
q10	6902	1921	1542	1542
q11	471	263	253	253
q12	406	381	232	232
q13	17788	4097	3290	3290
q14	242	230	215	215
q15	871	796	803	796
q16	686	673	631	631
q17	707	827	522	522
q18	6816	5919	6354	5919
q19	1289	1038	666	666
q20	572	534	388	388
q21	2854	2003	1997	1997
q22	356	299	257	257
Total cold run time: 102786 ms
Total hot run time: 30821 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4690	4641	4568	4568
q2	274	360	258	258
q3	2307	2974	2540	2540
q4	1531	1834	1391	1391
q5	4770	4880	4557	4557
q6	224	176	140	140
q7	2001	1937	1737	1737
q8	2556	2378	2377	2377
q9	7520	7725	7379	7379
q10	2782	3248	2569	2569
q11	511	437	421	421
q12	685	747	625	625
q13	3746	4088	3196	3196
q14	270	287	268	268
q15	821	774	776	774
q16	635	673	642	642
q17	1090	1281	1338	1281
q18	7702	7442	7193	7193
q19	869	844	808	808
q20	1964	2067	1885	1885
q21	4541	4210	4228	4210
q22	518	454	446	446
Total cold run time: 52007 ms
Total hot run time: 49265 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 190780 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 4e661e221e75a51440a219aa47f522e1b2370d91, data reload: false

query5	4314	597	471	471
query6	323	208	199	199
query7	4215	469	269	269
query8	331	243	234	234
query9	8681	2777	2747	2747
query10	508	402	336	336
query11	16450	16525	16179	16179
query12	180	122	120	120
query13	1271	456	367	367
query14	6173	3212	3032	3032
query14_1	2832	2827	2742	2742
query15	207	191	173	173
query16	960	474	440	440
query17	1089	700	586	586
query18	2457	439	346	346
query19	204	208	196	196
query20	137	123	122	122
query21	213	147	131	131
query22	4992	5088	4822	4822
query23	19024	18555	18238	18238
query23_1	18561	18422	18516	18422
query24	7169	1603	1193	1193
query24_1	1217	1200	1223	1200
query25	561	461	413	413
query26	1245	265	150	150
query27	2758	461	292	292
query28	4528	1891	1869	1869
query29	838	564	469	469
query30	320	260	219	219
query31	854	737	677	677
query32	88	78	74	74
query33	532	340	297	297
query34	902	908	563	563
query35	638	684	600	600
query36	1116	1154	1004	1004
query37	145	105	91	91
query38	2950	2954	2835	2835
query39	946	906	896	896
query39_1	877	883	869	869
query40	222	136	123	123
query41	71	71	68	68
query42	105	103	101	101
query43	470	449	401	401
query44	1339	727	725	725
query45	205	195	180	180
query46	889	1025	633	633
query47	2160	2169	2076	2076
query48	308	317	234	234
query49	593	421	349	349
query50	665	265	221	221
query51	4116	4046	4064	4046
query52	100	107	94	94
query53	294	338	275	275
query54	289	269	255	255
query55	93	89	74	74
query56	315	303	310	303
query57	1404	1350	1269	1269
query58	272	264	261	261
query59	2124	2087	2098	2087
query60	349	332	313	313
query61	154	138	143	138
query62	593	577	534	534
query63	296	273	263	263
query64	5040	1222	928	928
query65	4536	4430	4465	4430
query66	1437	434	345	345
query67	16190	16342	16207	16207
query68	2435	1076	708	708
query69	405	318	288	288
query70	993	997	971	971
query71	328	315	294	294
query72	2849	2774	2600	2600
query73	514	552	308	308
query74	9670	9704	9555	9555
query75	2763	2761	2442	2442
query76	2299	1061	662	662
query77	352	372	312	312
query78	11357	11487	10891	10891
query79	1069	917	628	628
query80	1100	587	501	501
query81	559	292	264	264
query82	1334	151	111	111
query83	320	261	241	241
query84	260	118	101	101
query85	893	475	410	410
query86	386	324	293	293
query87	3141	3112	3012	3012
query88	3525	2653	2655	2653
query89	393	354	319	319
query90	1846	170	170	170
query91	163	152	137	137
query92	78	75	69	69
query93	890	840	475	475
query94	528	329	269	269
query95	568	341	389	341
query96	653	504	228	228
query97	2458	2528	2426	2426
query98	227	214	214	214
query99	964	941	852	852
Total cold run time: 261866 ms
Total hot run time: 190780 ms

@doris-robot
Copy link

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

query1	0.06	0.05	0.05
query2	0.09	0.04	0.04
query3	0.26	0.08	0.08
query4	1.60	0.12	0.11
query5	0.27	0.26	0.25
query6	1.19	0.68	0.68
query7	0.03	0.02	0.02
query8	0.05	0.04	0.04
query9	0.56	0.50	0.49
query10	0.56	0.55	0.55
query11	0.14	0.10	0.10
query12	0.15	0.11	0.10
query13	0.64	0.61	0.62
query14	1.07	1.07	1.04
query15	0.87	0.86	0.88
query16	0.39	0.39	0.40
query17	1.14	1.14	1.16
query18	0.23	0.22	0.22
query19	2.09	1.98	2.07
query20	0.02	0.01	0.01
query21	15.42	0.30	0.15
query22	5.31	0.06	0.05
query23	15.96	0.29	0.10
query24	2.06	0.31	0.73
query25	0.11	0.08	0.08
query26	0.14	0.13	0.14
query27	0.09	0.05	0.07
query28	4.80	1.16	0.96
query29	12.59	3.91	3.11
query30	0.28	0.13	0.11
query31	2.81	0.64	0.40
query32	3.23	0.60	0.50
query33	3.24	3.23	3.24
query34	16.04	5.40	4.74
query35	4.75	4.73	4.77
query36	0.64	0.50	0.48
query37	0.11	0.07	0.07
query38	0.07	0.04	0.05
query39	0.05	0.03	0.03
query40	0.19	0.16	0.15
query41	0.08	0.04	0.03
query42	0.05	0.03	0.03
query43	0.05	0.04	0.03
Total cold run time: 99.48 s
Total hot run time: 28.27 s

@doris-robot
Copy link

BE UT Coverage Report

Increment line coverage 38.18% (21/55) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 52.78% (19480/36907)
Line Coverage 36.28% (181608/500571)
Region Coverage 32.62% (140691/431280)
Branch Coverage 33.66% (61030/181296)

@Mryange
Copy link
Contributor Author

Mryange commented Feb 11, 2026

run buildall

@doris-robot
Copy link

TPC-H: Total hot run time: 30381 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 52de5d414c3380e7ecd2761e7f940e4c0a92da26, data reload: false

------ Round 1 ----------------------------------
q1	17615	4614	4315	4315
q2	2043	366	236	236
q3	10155	1268	710	710
q4	10194	791	310	310
q5	7495	2164	1921	1921
q6	190	175	142	142
q7	890	735	617	617
q8	9251	1408	1144	1144
q9	4745	4650	4565	4565
q10	6806	1934	1554	1554
q11	485	265	245	245
q12	348	376	220	220
q13	17784	4065	3274	3274
q14	232	238	220	220
q15	922	806	824	806
q16	702	682	622	622
q17	696	760	586	586
q18	6556	5782	5878	5782
q19	1270	1047	621	621
q20	518	503	405	405
q21	2637	1863	1838	1838
q22	338	288	248	248
Total cold run time: 101872 ms
Total hot run time: 30381 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4391	4359	4352	4352
q2	251	341	258	258
q3	2075	2683	2203	2203
q4	1351	1748	1323	1323
q5	4311	4253	4258	4253
q6	221	180	137	137
q7	1856	1823	1699	1699
q8	2417	2736	2559	2559
q9	7744	7496	7552	7496
q10	2926	3085	2674	2674
q11	540	448	430	430
q12	673	728	639	639
q13	3906	4427	3587	3587
q14	300	343	380	343
q15	858	789	816	789
q16	674	704	705	704
q17	1140	1441	1371	1371
q18	8248	7888	8137	7888
q19	875	848	839	839
q20	2053	2176	1999	1999
q21	4909	4207	4095	4095
q22	523	468	419	419
Total cold run time: 52242 ms
Total hot run time: 50057 ms

@doris-robot
Copy link

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

query1	0.06	0.04	0.05
query2	0.10	0.04	0.04
query3	0.25	0.08	0.08
query4	1.60	0.12	0.11
query5	0.28	0.26	0.24
query6	1.19	0.68	0.67
query7	0.03	0.02	0.02
query8	0.05	0.04	0.04
query9	0.57	0.49	0.49
query10	0.54	0.54	0.54
query11	0.14	0.09	0.10
query12	0.14	0.10	0.10
query13	0.63	0.62	0.62
query14	1.06	1.06	1.06
query15	0.87	0.87	0.87
query16	0.39	0.40	0.39
query17	1.14	1.12	1.14
query18	0.22	0.21	0.21
query19	2.06	2.04	2.04
query20	0.02	0.01	0.01
query21	15.39	0.27	0.14
query22	5.31	0.05	0.05
query23	16.08	0.29	0.11
query24	0.96	0.32	0.58
query25	0.11	0.07	0.08
query26	0.15	0.13	0.14
query27	0.08	0.08	0.05
query28	4.47	1.15	0.97
query29	12.57	3.86	3.16
query30	0.29	0.14	0.11
query31	2.81	0.65	0.41
query32	3.23	0.59	0.50
query33	3.27	3.23	3.23
query34	16.04	5.44	4.75
query35	4.79	4.76	4.80
query36	0.66	0.49	0.49
query37	0.11	0.07	0.07
query38	0.07	0.04	0.04
query39	0.04	0.03	0.03
query40	0.18	0.16	0.16
query41	0.09	0.04	0.03
query42	0.05	0.03	0.03
query43	0.04	0.03	0.04
Total cold run time: 98.13 s
Total hot run time: 28.42 s

@hello-stephen
Copy link
Contributor

BE UT Coverage Report

Increment line coverage 37.50% (21/56) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 52.78% (19480/36907)
Line Coverage 36.29% (181640/500569)
Region Coverage 32.64% (140766/431287)
Branch Coverage 33.66% (61032/181301)

@Mryange
Copy link
Contributor Author

Mryange commented Feb 11, 2026

run buildall

@doris-robot
Copy link

TPC-H: Total hot run time: 30418 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit d8b36037d014f483846c1ccc200db6eb073fee44, data reload: false

------ Round 1 ----------------------------------
q1	17596	4579	4277	4277
q2	2050	349	229	229
q3	10180	1276	701	701
q4	10187	783	307	307
q5	7525	2228	1936	1936
q6	188	173	143	143
q7	865	758	606	606
q8	9262	1381	1160	1160
q9	4718	4625	4583	4583
q10	6815	1960	1562	1562
q11	466	259	246	246
q12	346	374	218	218
q13	17768	4110	3205	3205
q14	233	238	214	214
q15	904	825	834	825
q16	713	704	625	625
q17	710	804	548	548
q18	6632	5954	5947	5947
q19	1102	1024	650	650
q20	531	502	395	395
q21	2615	1895	1800	1800
q22	321	274	241	241
Total cold run time: 101727 ms
Total hot run time: 30418 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4377	4315	4373	4315
q2	265	344	247	247
q3	2070	2664	2256	2256
q4	1316	1750	1282	1282
q5	4305	4139	4265	4139
q6	213	182	136	136
q7	1819	1755	1664	1664
q8	2449	2721	2368	2368
q9	7537	7476	7674	7476
q10	2855	3145	2713	2713
q11	514	439	417	417
q12	692	757	656	656
q13	3934	4399	3613	3613
q14	308	299	274	274
q15	851	822	814	814
q16	669	718	683	683
q17	1134	1332	1359	1332
q18	8383	7978	7982	7978
q19	891	894	835	835
q20	2064	2206	1987	1987
q21	4937	4530	4258	4258
q22	488	455	426	426
Total cold run time: 52071 ms
Total hot run time: 49869 ms

@doris-robot
Copy link

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

query5	4333	610	490	490
query6	352	226	208	208
query7	4215	464	276	276
query8	333	242	237	237
query9	8727	2764	2761	2761
query10	509	363	328	328
query11	16474	16367	16211	16211
query12	207	122	122	122
query13	1272	479	370	370
query14	6571	3225	2969	2969
query14_1	2836	2812	2764	2764
query15	208	195	170	170
query16	1004	493	422	422
query17	1062	669	569	569
query18	2625	428	336	336
query19	208	199	178	178
query20	130	120	117	117
query21	219	144	128	128
query22	5119	4920	4828	4828
query23	18956	18474	18268	18268
query23_1	18444	18493	18399	18399
query24	7176	1580	1214	1214
query24_1	1203	1208	1228	1208
query25	520	429	384	384
query26	1233	265	147	147
query27	2775	457	283	283
query28	4550	1876	1876	1876
query29	782	542	431	431
query30	315	252	219	219
query31	843	742	647	647
query32	87	78	75	75
query33	525	344	287	287
query34	922	907	558	558
query35	656	692	596	596
query36	1073	1090	995	995
query37	135	101	88	88
query38	2921	2943	2854	2854
query39	932	902	912	902
query39_1	895	894	880	880
query40	214	131	115	115
query41	66	61	64	61
query42	103	100	128	100
query43	463	469	392	392
query44	1367	721	735	721
query45	193	185	180	180
query46	883	986	608	608
query47	2097	2127	2001	2001
query48	310	313	233	233
query49	617	428	335	335
query50	676	274	211	211
query51	4037	4081	4014	4014
query52	102	104	91	91
query53	284	332	270	270
query54	289	263	274	263
query55	88	80	78	78
query56	299	296	306	296
query57	1386	1358	1307	1307
query58	277	258	250	250
query59	2062	2038	2066	2038
query60	326	337	328	328
query61	160	145	144	144
query62	602	569	496	496
query63	298	269	265	265
query64	4854	1216	940	940
query65	4551	4454	4467	4454
query66	1373	441	329	329
query67	16458	16345	16304	16304
query68	2424	1070	720	720
query69	400	313	271	271
query70	1026	945	907	907
query71	323	312	297	297
query72	2924	2762	2694	2694
query73	519	554	322	322
query74	9652	9678	9548	9548
query75	2781	2788	2405	2405
query76	2313	1065	644	644
query77	350	375	314	314
query78	11239	11336	10948	10948
query79	965	909	593	593
query80	629	606	516	516
query81	493	290	265	265
query82	226	159	117	117
query83	373	267	242	242
query84	259	163	100	100
query85	822	462	419	419
query86	366	313	298	298
query87	3207	3131	2988	2988
query88	3590	2685	2671	2671
query89	369	344	319	319
query90	1852	187	183	183
query91	158	158	139	139
query92	72	75	71	71
query93	876	864	485	485
query94	452	302	293	293
query95	589	340	379	340
query96	637	531	227	227
query97	2446	2449	2413	2413
query98	219	213	204	204
query99	938	916	853	853
Total cold run time: 260311 ms
Total hot run time: 190843 ms

@doris-robot
Copy link

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

query1	0.05	0.05	0.04
query2	0.09	0.04	0.04
query3	0.26	0.08	0.09
query4	1.61	0.12	0.10
query5	0.27	0.23	0.24
query6	1.16	0.68	0.68
query7	0.03	0.03	0.03
query8	0.05	0.04	0.04
query9	0.57	0.49	0.48
query10	0.54	0.54	0.55
query11	0.14	0.10	0.10
query12	0.13	0.10	0.10
query13	0.62	0.60	0.62
query14	1.06	1.05	1.06
query15	0.88	0.88	0.87
query16	0.39	0.39	0.39
query17	1.16	1.18	1.14
query18	0.23	0.21	0.21
query19	2.07	2.00	2.07
query20	0.02	0.02	0.02
query21	15.41	0.31	0.15
query22	4.90	0.06	0.05
query23	15.95	0.29	0.11
query24	1.51	0.72	0.98
query25	0.12	0.20	0.08
query26	0.13	0.14	0.15
query27	0.05	0.06	0.04
query28	5.12	1.18	0.97
query29	12.55	3.92	3.19
query30	0.29	0.13	0.12
query31	2.81	0.66	0.41
query32	3.22	0.59	0.50
query33	3.23	3.30	3.25
query34	16.22	5.41	4.72
query35	4.77	4.81	4.88
query36	0.65	0.50	0.49
query37	0.12	0.07	0.07
query38	0.08	0.04	0.04
query39	0.04	0.03	0.03
query40	0.18	0.16	0.15
query41	0.09	0.03	0.04
query42	0.04	0.04	0.02
query43	0.04	0.04	0.03
Total cold run time: 98.85 s
Total hot run time: 28.86 s

@doris-robot
Copy link

BE UT Coverage Report

Increment line coverage 36.21% (21/58) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 52.80% (19488/36907)
Line Coverage 36.27% (181568/500571)
Region Coverage 32.65% (140820/431289)
Branch Coverage 33.68% (61054/181303)

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 86.21% (50/58) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 73.53% (26592/36164)
Line Coverage 56.69% (283105/499368)
Region Coverage 54.39% (237024/435753)
Branch Coverage 56.06% (102044/182022)

@Mryange
Copy link
Contributor Author

Mryange commented Feb 12, 2026

run buildall

@doris-robot
Copy link

TPC-H: Total hot run time: 30614 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 633eca5d8a30ab335ea2f0fe9ac7e38f9bdd646c, data reload: false

------ Round 1 ----------------------------------
q1	17615	4491	4293	4293
q2	2092	357	235	235
q3	10117	1340	722	722
q4	10196	780	301	301
q5	7597	2220	1899	1899
q6	191	177	143	143
q7	883	728	618	618
q8	9258	1345	1111	1111
q9	4749	4657	4637	4637
q10	6751	1944	1544	1544
q11	480	279	247	247
q12	337	377	224	224
q13	17772	4084	3275	3275
q14	231	229	215	215
q15	898	803	812	803
q16	695	684	625	625
q17	687	810	516	516
q18	6441	5947	6168	5947
q19	1856	1025	706	706
q20	552	523	416	416
q21	2752	1933	1851	1851
q22	351	289	286	286
Total cold run time: 102501 ms
Total hot run time: 30614 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4678	4513	4613	4513
q2	272	358	260	260
q3	2416	2861	2501	2501
q4	1491	1915	1393	1393
q5	4760	4692	4419	4419
q6	225	174	132	132
q7	1946	1861	1751	1751
q8	2545	2428	2426	2426
q9	7515	7677	7297	7297
q10	2795	3221	2597	2597
q11	520	441	424	424
q12	728	762	621	621
q13	3599	4002	3229	3229
q14	288	291	268	268
q15	823	785	773	773
q16	627	677	633	633
q17	1100	1238	1322	1238
q18	7346	7211	7397	7211
q19	831	801	816	801
q20	1949	2028	1861	1861
q21	4564	4273	4106	4106
q22	531	465	415	415
Total cold run time: 51549 ms
Total hot run time: 48869 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 190751 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 633eca5d8a30ab335ea2f0fe9ac7e38f9bdd646c, data reload: false

query5	4748	609	490	490
query6	335	231	210	210
query7	4234	465	287	287
query8	352	249	241	241
query9	8751	2751	2716	2716
query10	498	377	332	332
query11	16608	16450	16108	16108
query12	199	125	123	123
query13	1274	460	363	363
query14	6513	3160	2946	2946
query14_1	2801	2791	2767	2767
query15	201	191	172	172
query16	1005	454	464	454
query17	1076	701	622	622
query18	2618	439	332	332
query19	206	203	176	176
query20	128	130	120	120
query21	216	145	123	123
query22	4758	4839	4903	4839
query23	19158	18675	18314	18314
query23_1	18525	18414	18479	18414
query24	7164	1571	1233	1233
query24_1	1190	1222	1221	1221
query25	519	429	388	388
query26	1237	271	161	161
query27	2767	467	290	290
query28	4506	1864	1882	1864
query29	787	558	442	442
query30	317	259	215	215
query31	847	748	649	649
query32	84	78	73	73
query33	543	352	279	279
query34	922	908	561	561
query35	652	685	611	611
query36	1059	1131	1004	1004
query37	138	99	85	85
query38	2972	2972	2884	2884
query39	930	935	903	903
query39_1	890	889	891	889
query40	216	135	119	119
query41	65	62	64	62
query42	105	98	99	98
query43	432	423	413	413
query44	1310	723	715	715
query45	196	191	179	179
query46	884	974	622	622
query47	2113	2132	2062	2062
query48	317	309	231	231
query49	611	429	347	347
query50	671	281	214	214
query51	4079	4098	4102	4098
query52	99	106	94	94
query53	277	323	267	267
query54	281	258	263	258
query55	84	80	81	80
query56	316	310	313	310
query57	1404	1384	1251	1251
query58	284	266	259	259
query59	2076	2129	2088	2088
query60	341	330	325	325
query61	154	146	151	146
query62	604	583	541	541
query63	294	273	264	264
query64	4877	1228	936	936
query65	4522	4426	4452	4426
query66	1400	439	374	374
query67	16436	16199	16212	16199
query68	2411	1061	727	727
query69	412	314	278	278
query70	1040	977	967	967
query71	332	321	292	292
query72	2914	2787	2518	2518
query73	514	550	317	317
query74	9720	9746	9576	9576
query75	2823	2756	2434	2434
query76	2278	1062	652	652
query77	352	372	292	292
query78	11271	11396	10910	10910
query79	1110	856	597	597
query80	679	581	551	551
query81	487	284	259	259
query82	1372	146	117	117
query83	351	256	241	241
query84	252	123	99	99
query85	839	469	431	431
query86	367	298	341	298
query87	3103	3053	2992	2992
query88	3548	2674	2646	2646
query89	375	343	328	328
query90	1936	172	172	172
query91	174	156	132	132
query92	78	72	73	72
query93	893	828	481	481
query94	451	325	251	251
query95	595	394	323	323
query96	672	512	232	232
query97	2472	2538	2400	2400
query98	222	218	205	205
query99	954	929	855	855
Total cold run time: 262513 ms
Total hot run time: 190751 ms

@doris-robot
Copy link

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

query1	0.05	0.05	0.05
query2	0.10	0.05	0.05
query3	0.26	0.08	0.08
query4	1.60	0.11	0.11
query5	0.26	0.25	0.25
query6	1.16	0.70	0.67
query7	0.04	0.03	0.03
query8	0.05	0.04	0.03
query9	0.57	0.50	0.49
query10	0.55	0.56	0.56
query11	0.14	0.09	0.10
query12	0.14	0.11	0.10
query13	0.63	0.61	0.61
query14	1.07	1.06	1.06
query15	0.88	0.87	0.85
query16	0.40	0.40	0.40
query17	1.14	1.16	1.15
query18	0.22	0.21	0.22
query19	2.09	2.03	1.94
query20	0.01	0.01	0.01
query21	15.39	0.29	0.15
query22	5.12	0.05	0.05
query23	16.03	0.29	0.11
query24	1.21	0.25	0.48
query25	0.09	0.08	0.09
query26	0.14	0.14	0.13
query27	0.12	0.05	0.09
query28	3.98	1.17	0.97
query29	12.55	3.97	3.18
query30	0.29	0.14	0.11
query31	2.80	0.64	0.41
query32	3.25	0.62	0.49
query33	3.23	3.30	3.28
query34	16.12	5.40	4.74
query35	4.81	4.80	4.77
query36	0.65	0.51	0.49
query37	0.11	0.07	0.07
query38	0.08	0.04	0.04
query39	0.05	0.03	0.03
query40	0.20	0.17	0.15
query41	0.09	0.03	0.04
query42	0.05	0.03	0.02
query43	0.04	0.04	0.04
Total cold run time: 97.76 s
Total hot run time: 28.38 s

@doris-robot
Copy link

BE UT Coverage Report

Increment line coverage 37.29% (22/59) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 52.81% (19490/36909)
Line Coverage 36.28% (181614/500610)
Region Coverage 32.66% (140900/431377)
Branch Coverage 33.70% (61099/181320)

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 46.77% (29/62) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 57.53% (20806/36164)
Line Coverage 40.48% (202128/499371)
Region Coverage 37.34% (162720/435756)
Branch Coverage 37.94% (69064/182024)

@Mryange Mryange force-pushed the add-expr-exec-check branch from 633eca5 to 47ee04d Compare February 26, 2026 06:40
@Mryange
Copy link
Contributor Author

Mryange commented Feb 26, 2026

run buildall

@doris-robot
Copy link

TPC-H: Total hot run time: 28794 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 47ee04ddee2ef699592807c82aeae6d435de737d, data reload: false

------ Round 1 ----------------------------------
============================================
q1	17674	4520	4275	4275
q2	q3	10646	794	521	521
q4	4676	363	256	256
q5	7562	1218	1024	1024
q6	179	180	153	153
q7	785	846	671	671
q8	9886	1456	1350	1350
q9	5321	4758	4783	4758
q10	6823	1867	1621	1621
q11	472	265	246	246
q12	777	561	470	470
q13	17778	4224	3430	3430
q14	234	229	225	225
q15	957	794	792	792
q16	763	712	654	654
q17	730	870	442	442
q18	6690	5402	5221	5221
q19	1543	984	636	636
q20	518	498	388	388
q21	4683	1859	1421	1421
q22	345	288	240	240
Total cold run time: 99042 ms
Total hot run time: 28794 ms

----- Round 2, with runtime_filter_mode=off -----
============================================
q1	4458	4331	4355	4331
q2	q3	1771	2169	1724	1724
q4	842	1167	753	753
q5	4030	4324	4302	4302
q6	180	173	144	144
q7	1725	1588	1472	1472
q8	2430	2689	2521	2521
q9	7727	7414	7426	7414
q10	2805	2890	2407	2407
q11	510	450	401	401
q12	511	585	449	449
q13	3923	4467	3705	3705
q14	302	313	275	275
q15	842	813	799	799
q16	728	784	739	739
q17	1202	1559	1315	1315
q18	6879	6770	6659	6659
q19	939	878	925	878
q20	2117	2191	2010	2010
q21	4163	3488	3420	3420
q22	488	437	384	384
Total cold run time: 48572 ms
Total hot run time: 46102 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 184367 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 47ee04ddee2ef699592807c82aeae6d435de737d, data reload: false

query5	5041	669	506	506
query6	336	218	207	207
query7	4204	488	270	270
query8	326	255	239	239
query9	8751	2784	2800	2784
query10	536	381	332	332
query11	17052	17311	17360	17311
query12	203	131	124	124
query13	1281	486	354	354
query14	7271	3509	3130	3130
query14_1	2953	3014	2990	2990
query15	236	216	191	191
query16	4850	524	484	484
query17	1217	799	637	637
query18	2370	482	381	381
query19	230	222	189	189
query20	149	142	131	131
query21	228	150	136	136
query22	5601	5056	4865	4865
query23	17293	16809	16690	16690
query23_1	16648	16725	16763	16725
query24	7146	1631	1221	1221
query24_1	1228	1237	1233	1233
query25	584	490	423	423
query26	1198	271	198	198
query27	2680	481	282	282
query28	4431	1893	1893	1893
query29	756	573	460	460
query30	313	251	208	208
query31	898	715	647	647
query32	85	72	72	72
query33	507	339	280	280
query34	914	910	566	566
query35	649	683	602	602
query36	1071	1104	981	981
query37	134	99	85	85
query38	2948	2960	2916	2916
query39	887	864	847	847
query39_1	825	820	817	817
query40	233	144	138	138
query41	67	61	58	58
query42	104	105	104	104
query43	392	398	368	368
query44	
query45	201	196	188	188
query46	897	994	598	598
query47	2100	2144	2055	2055
query48	309	320	225	225
query49	632	460	370	370
query50	698	285	217	217
query51	4052	4121	4033	4033
query52	110	109	98	98
query53	289	345	286	286
query54	297	266	259	259
query55	89	89	98	89
query56	339	347	309	309
query57	1372	1348	1286	1286
query58	290	275	284	275
query59	2569	2608	2529	2529
query60	331	350	315	315
query61	144	147	145	145
query62	634	599	534	534
query63	310	283	282	282
query64	4441	1250	968	968
query65	
query66	1287	458	362	362
query67	16407	16333	16310	16310
query68	
query69	403	328	285	285
query70	1021	987	973	973
query71	340	316	303	303
query72	2795	2659	2408	2408
query73	546	574	327	327
query74	10018	9958	9753	9753
query75	2842	2760	2489	2489
query76	1882	1059	702	702
query77	378	400	313	313
query78	11251	11304	10744	10744
query79	3395	793	590	590
query80	1720	642	550	550
query81	582	272	242	242
query82	1002	148	114	114
query83	337	270	248	248
query84	253	124	100	100
query85	918	490	426	426
query86	493	297	303	297
query87	3130	3130	3039	3039
query88	3997	2674	2643	2643
query89	430	376	342	342
query90	2139	180	170	170
query91	161	151	131	131
query92	90	74	69	69
query93	2831	844	497	497
query94	649	331	279	279
query95	593	343	326	326
query96	659	544	227	227
query97	2471	2489	2377	2377
query98	233	217	213	213
query99	1005	983	921	921
Total cold run time: 262672 ms
Total hot run time: 184367 ms

@Mryange
Copy link
Contributor Author

Mryange commented Feb 26, 2026

run buildall

@doris-robot
Copy link

TPC-H: Total hot run time: 28962 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 1038dbe04ec0f865b667b6fa1df0e02e8397550b, data reload: false

------ Round 1 ----------------------------------
============================================
q1	17618	4426	4263	4263
q2	q3	10655	797	530	530
q4	4682	369	256	256
q5	7575	1205	1026	1026
q6	182	181	157	157
q7	791	853	685	685
q8	9314	1545	1397	1397
q9	4943	4800	4788	4788
q10	6799	1881	1628	1628
q11	470	257	264	257
q12	709	571	473	473
q13	17795	4259	3431	3431
q14	238	227	213	213
q15	985	805	787	787
q16	744	714	675	675
q17	738	899	424	424
q18	6105	5458	5271	5271
q19	1256	983	643	643
q20	512	501	388	388
q21	4749	1886	1421	1421
q22	349	296	249	249
Total cold run time: 97209 ms
Total hot run time: 28962 ms

----- Round 2, with runtime_filter_mode=off -----
============================================
q1	4394	4336	4340	4336
q2	q3	1772	2183	1728	1728
q4	848	1175	780	780
q5	4115	4349	4328	4328
q6	181	177	142	142
q7	1745	1614	1499	1499
q8	2444	2676	2547	2547
q9	7666	7573	7432	7432
q10	2704	2916	2410	2410
q11	519	445	402	402
q12	523	584	442	442
q13	4011	4405	3654	3654
q14	308	308	290	290
q15	861	830	815	815
q16	721	759	715	715
q17	1241	1563	1343	1343
q18	7383	6963	6677	6677
q19	985	895	898	895
q20	2072	2141	2042	2042
q21	4001	3537	3384	3384
q22	489	440	399	399
Total cold run time: 48983 ms
Total hot run time: 46260 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 185069 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 1038dbe04ec0f865b667b6fa1df0e02e8397550b, data reload: false

query5	4804	630	519	519
query6	320	213	204	204
query7	4227	474	279	279
query8	351	251	256	251
query9	8694	2777	2798	2777
query10	520	387	345	345
query11	17036	17474	17225	17225
query12	202	130	119	119
query13	1332	490	370	370
query14	6694	3386	3206	3206
query14_1	3017	2910	2935	2910
query15	218	197	175	175
query16	1009	505	405	405
query17	1123	801	655	655
query18	2754	470	377	377
query19	218	226	214	214
query20	152	137	143	137
query21	221	140	121	121
query22	5737	5765	5231	5231
query23	17640	17330	16981	16981
query23_1	16935	16717	16756	16717
query24	7272	1629	1274	1274
query24_1	1247	1244	1274	1244
query25	573	489	429	429
query26	1237	264	154	154
query27	2770	475	294	294
query28	4419	1874	1884	1874
query29	781	551	468	468
query30	308	243	208	208
query31	882	718	635	635
query32	83	71	70	70
query33	515	330	286	286
query34	937	891	567	567
query35	636	681	576	576
query36	1083	1141	984	984
query37	139	94	76	76
query38	2952	2917	2881	2881
query39	953	842	844	842
query39_1	809	809	828	809
query40	231	152	134	134
query41	61	64	57	57
query42	104	100	101	100
query43	376	391	356	356
query44	
query45	192	187	181	181
query46	878	990	627	627
query47	2128	2171	2041	2041
query48	300	310	228	228
query49	624	453	370	370
query50	677	269	221	221
query51	4056	4069	4073	4069
query52	109	105	96	96
query53	292	342	286	286
query54	285	282	281	281
query55	84	80	80	80
query56	328	303	297	297
query57	1338	1316	1286	1286
query58	287	271	272	271
query59	2655	2671	2606	2606
query60	359	325	321	321
query61	144	147	145	145
query62	620	590	544	544
query63	311	282	282	282
query64	4820	1247	987	987
query65	
query66	1385	455	386	386
query67	16596	16404	16260	16260
query68	
query69	393	306	293	293
query70	955	982	888	888
query71	339	316	299	299
query72	2733	2615	2439	2439
query73	536	538	315	315
query74	10008	9899	9751	9751
query75	2866	2743	2460	2460
query76	2287	1039	696	696
query77	362	391	328	328
query78	11216	11433	10689	10689
query79	2353	801	610	610
query80	1662	630	543	543
query81	560	280	258	258
query82	960	145	116	116
query83	343	252	239	239
query84	247	120	104	104
query85	881	484	459	459
query86	419	316	329	316
query87	3117	3110	3025	3025
query88	3580	2667	2638	2638
query89	426	360	347	347
query90	2017	187	174	174
query91	162	154	154	154
query92	80	73	66	66
query93	991	865	510	510
query94	646	326	277	277
query95	585	328	318	318
query96	642	522	231	231
query97	2460	2483	2390	2390
query98	230	216	214	214
query99	991	992	894	894
Total cold run time: 256579 ms
Total hot run time: 185069 ms

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants