Skip to content

branch-3.0: [fix](test) fix some regression test cases (#53588) - #53589

Merged
dataroaring merged 2 commits into
apache:branch-3.0from
morningman:fix_test_cases_v20250719
Jul 20, 2025
Merged

branch-3.0: [fix](test) fix some regression test cases (#53588)#53589
dataroaring merged 2 commits into
apache:branch-3.0from
morningman:fix_test_cases_v20250719

Conversation

@morningman

@morningman morningman commented Jul 19, 2025

Copy link
Copy Markdown
Contributor

bp #53588
And fix some test cases in branch-3.0

@morningman
morningman requested a review from dataroaring as a code owner July 19, 2025 18:41
@Thearas

Thearas commented Jul 19, 2025

Copy link
Copy Markdown
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?

@morningman

morningman commented Jul 19, 2025

Copy link
Copy Markdown
Contributor Author

run buildall

@doris-robot

doris-robot commented Jul 19, 2025

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

------ Round 1 ----------------------------------
q1	17581	6805	6598	6598
q2	2062	201	180	180
q3	10641	1114	1158	1114
q4	10504	739	760	739
q5	7752	2846	2775	2775
q6	213	130	129	129
q7	976	601	598	598
q8	9334	1944	2006	1944
q9	6584	6399	6320	6320
q10	7029	2257	2312	2257
q11	461	259	264	259
q12	395	213	210	210
q13	17804	2978	3002	2978
q14	233	210	206	206
q15	518	475	465	465
q16	520	389	368	368
q17	975	558	556	556
q18	7239	6716	6624	6624
q19	1399	1084	1050	1050
q20	477	206	201	201
q21	3874	3144	2940	2940
q22	1100	1007	1018	1007
Total cold run time: 107671 ms
Total hot run time: 39518 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6639	6583	6559	6559
q2	321	236	231	231
q3	2894	2925	2970	2925
q4	2043	1808	1886	1808
q5	5810	5809	5858	5809
q6	206	128	128	128
q7	2230	1829	1860	1829
q8	3401	3579	3543	3543
q9	8794	9001	8837	8837
q10	3597	3545	3583	3545
q11	593	493	509	493
q12	826	614	636	614
q13	9178	3191	3116	3116
q14	295	268	288	268
q15	510	453	471	453
q16	479	427	445	427
q17	1841	1629	1626	1626
q18	8222	7723	7768	7723
q19	1685	1468	1611	1468
q20	2059	1848	1854	1848
q21	5058	4957	5094	4957
q22	1174	1072	1020	1020
Total cold run time: 67855 ms
Total hot run time: 59227 ms

@doris-robot

doris-robot commented Jul 19, 2025

Copy link
Copy Markdown
TPC-DS: Total hot run time: 196141 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 7cd6ba3485e0a2a985bf433d48a68f900b00a5de, data reload: false

query1	1275	923	894	894
query2	6286	1877	1908	1877
query3	10907	4231	4134	4134
query4	33347	24070	23930	23930
query5	4452	455	446	446
query6	289	187	193	187
query7	4005	318	317	317
query8	287	221	216	216
query9	9640	2557	2564	2557
query10	480	264	251	251
query11	18020	15126	15198	15126
query12	163	105	103	103
query13	1561	416	417	416
query14	8479	6512	6586	6512
query15	230	189	195	189
query16	7847	504	518	504
query17	1632	585	581	581
query18	2105	298	299	298
query19	217	157	152	152
query20	116	111	109	109
query21	202	103	103	103
query22	4810	4442	4518	4442
query23	35009	34339	33970	33970
query24	12551	2871	2866	2866
query25	673	394	396	394
query26	1483	166	163	163
query27	3003	351	342	342
query28	7554	2188	2157	2157
query29	989	449	432	432
query30	267	155	157	155
query31	989	801	808	801
query32	96	59	55	55
query33	736	301	295	295
query34	1212	503	521	503
query35	875	722	722	722
query36	1118	990	970	970
query37	132	67	69	67
query38	4091	3990	3948	3948
query39	1518	1482	1450	1450
query40	265	104	103	103
query41	51	52	50	50
query42	112	99	101	99
query43	529	492	494	492
query44	1289	816	816	816
query45	185	173	171	171
query46	1162	752	731	731
query47	2035	1961	1943	1943
query48	491	409	416	409
query49	1087	428	392	392
query50	830	433	441	433
query51	7394	7256	7139	7139
query52	99	95	89	89
query53	261	187	190	187
query54	1000	473	487	473
query55	81	79	80	79
query56	262	270	268	268
query57	1315	1216	1207	1207
query58	238	215	236	215
query59	3241	2963	2937	2937
query60	284	252	248	248
query61	112	104	104	104
query62	842	699	696	696
query63	216	185	192	185
query64	4196	653	630	630
query65	3332	3286	3265	3265
query66	1147	301	314	301
query67	16029	15571	15628	15571
query68	4468	597	578	578
query69	425	258	263	258
query70	1178	1078	1100	1078
query71	345	255	246	246
query72	6283	4063	3942	3942
query73	759	343	359	343
query74	10175	8920	9364	8920
query75	3405	2632	2679	2632
query76	2639	1083	1137	1083
query77	363	263	268	263
query78	10703	9577	9684	9577
query79	1636	589	599	589
query80	1103	411	415	411
query81	553	218	214	214
query82	941	87	86	86
query83	237	137	138	137
query84	233	72	80	72
query85	1305	290	285	285
query86	387	290	291	290
query87	4371	4233	4247	4233
query88	3450	2427	2352	2352
query89	409	290	288	288
query90	1936	178	180	178
query91	175	151	148	148
query92	58	46	51	46
query93	1782	543	554	543
query94	839	299	285	285
query95	361	263	262	262
query96	607	281	282	281
query97	3326	3160	3165	3160
query98	212	209	200	200
query99	1523	1314	1294	1294
Total cold run time: 302918 ms
Total hot run time: 196141 ms

@doris-robot

doris-robot commented Jul 19, 2025

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

query1	0.03	0.03	0.03
query2	0.07	0.04	0.03
query3	0.23	0.06	0.06
query4	1.64	0.11	0.11
query5	0.55	0.52	0.52
query6	1.14	0.72	0.72
query7	0.02	0.01	0.01
query8	0.04	0.04	0.02
query9	0.56	0.49	0.51
query10	0.55	0.56	0.57
query11	0.14	0.09	0.10
query12	0.14	0.12	0.11
query13	0.61	0.59	0.60
query14	0.78	0.79	0.82
query15	0.83	0.82	0.82
query16	0.37	0.38	0.40
query17	1.06	1.07	1.00
query18	0.24	0.22	0.22
query19	1.93	1.86	1.87
query20	0.01	0.02	0.01
query21	15.41	0.59	0.58
query22	2.58	1.40	2.31
query23	16.87	1.15	0.84
query24	3.02	0.65	1.18
query25	0.28	0.15	0.04
query26	0.38	0.14	0.13
query27	0.04	0.05	0.04
query28	10.67	0.50	0.46
query29	12.55	3.25	3.21
query30	0.25	0.06	0.06
query31	2.87	0.39	0.39
query32	3.23	0.45	0.46
query33	2.96	3.00	3.05
query34	17.32	4.48	4.48
query35	4.55	4.59	4.57
query36	0.68	0.47	0.47
query37	0.08	0.06	0.06
query38	0.05	0.03	0.04
query39	0.04	0.02	0.02
query40	0.16	0.12	0.12
query41	0.07	0.02	0.02
query42	0.03	0.03	0.02
query43	0.03	0.03	0.03
Total cold run time: 105.06 s
Total hot run time: 29.49 s

@hello-stephen

hello-stephen commented Jul 19, 2025

Copy link
Copy Markdown
Contributor

FE UT Coverage Report

Increment line coverage 66.67% (4/6) 🎉
Increment coverage report
Complete coverage report

dataroaring
dataroaring approved these changes Jul 20, 2025
View reviewed changes

@dataroaring dataroaring left a comment

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM

@dataroaring
dataroaring merged commit 4595c4f into apache:branch-3.0 Jul 20, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

@dataroaring dataroaring dataroaring approved these changes

Assignees

No one assigned

Labels

None yet

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

5 participants

@morningman @Thearas @doris-robot @hello-stephen @dataroaring