You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "yujun777 (via GitHub)" <gi...@apache.org> on 2025/10/14 07:10:55 UTC

[PR] [feat](case when) Push upper function into case when branch [doris]

yujun777 opened a new pull request, #56941:
URL: https://github.com/apache/doris/pull/56941

   
   push upper function into case when branch.
   
   example:
   
   ```
   2 > case when c1 then 1 
                  when c2 then 2
                  else 3
           end
   ```
   
   will rewrite to 
   
   ```
   case when c1 then true
           when c2 then false
           else false
   end
   ```
   
   ### Release note
   
   None
   
   ### Check List (For Author)
   
   - Test <!-- At least one of them must be included. -->
       - [ ] 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 <!-- Add your reason?  -->
   
   - Behavior changed:
       - [ ] No.
       - [ ] Yes. <!-- Explain the behavior change -->
   
   - Does this need documentation?
       - [ ] No.
       - [ ] Yes. <!-- Add document PR link here. eg: https://github.com/apache/doris-website/pull/1214 -->
   
   ### Check List (For Reviewer who merge this PR)
   
   - [ ] Confirm the release note
   - [ ] Confirm test cases
   - [ ] Confirm document
   - [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into -->
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3413759242

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 190099 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit d02c24c3a242d0060b6fc1bfee6d741cece966cd, data reload: false
   
   query1	1073	444	414	414
   query2	6592	1696	1682	1682
   query3	6754	220	228	220
   query4	26588	23930	23202	23202
   query5	4673	649	506	506
   query6	330	274	237	237
   query7	4661	503	310	310
   query8	342	275	282	275
   query9	8721	2591	2566	2566
   query10	513	340	300	300
   query11	15211	15149	14821	14821
   query12	182	119	113	113
   query13	1667	552	431	431
   query14	11090	9330	9286	9286
   query15	200	194	176	176
   query16	7688	674	519	519
   query17	1213	773	618	618
   query18	2031	427	339	339
   query19	234	254	185	185
   query20	144	135	140	135
   query21	222	140	124	124
   query22	4802	4812	4479	4479
   query23	34769	33934	33731	33731
   query24	8594	2650	2495	2495
   query25	593	523	480	480
   query26	1246	287	191	191
   query27	2803	530	377	377
   query28	4378	2230	2212	2212
   query29	856	625	491	491
   query30	341	229	215	215
   query31	949	839	1063	839
   query32	80	70	68	68
   query33	579	386	327	327
   query34	819	875	537	537
   query35	807	890	790	790
   query36	979	1053	927	927
   query37	128	118	98	98
   query38	3667	3730	3635	3635
   query39	1506	1408	1428	1408
   query40	217	128	117	117
   query41	61	59	59	59
   query42	121	116	108	108
   query43	494	479	473	473
   query44	1314	827	845	827
   query45	187	178	171	171
   query46	834	997	641	641
   query47	1749	1784	1682	1682
   query48	399	426	334	334
   query49	767	507	397	397
   query50	645	690	402	402
   query51	3977	3893	3827	3827
   query52	110	103	101	101
   query53	241	262	197	197
   query54	606	594	538	538
   query55	87	87	88	87
   query56	315	317	295	295
   query57	1182	1209	1117	1117
   query58	290	288	287	287
   query59	2591	2721	2602	2602
   query60	351	345	369	345
   query61	160	152	151	151
   query62	806	755	663	663
   query63	229	195	187	187
   query64	4364	1131	819	819
   query65	4033	3974	3971	3971
   query66	1086	430	334	334
   query67	15484	15054	15021	15021
   query68	6469	906	594	594
   query69	495	320	293	293
   query70	1327	1248	1264	1248
   query71	450	349	316	316
   query72	6002	5135	5047	5047
   query73	652	582	358	358
   query74	8859	9072	8742	8742
   query75	3315	3279	2893	2893
   query76	3261	1173	745	745
   query77	516	418	313	313
   query78	9584	9733	8981	8981
   query79	2430	852	606	606
   query80	759	554	510	510
   query81	527	269	221	221
   query82	455	164	132	132
   query83	262	382	249	249
   query84	267	109	95	95
   query85	911	476	425	425
   query86	390	313	312	312
   query87	3745	3717	3605	3605
   query88	3816	2246	2211	2211
   query89	389	336	296	296
   query90	1941	218	225	218
   query91	186	164	130	130
   query92	83	69	70	69
   query93	1944	978	633	633
   query94	739	431	345	345
   query95	410	323	308	308
   query96	490	590	281	281
   query97	2942	3002	2913	2913
   query98	243	221	225	221
   query99	1468	1399	1277	1277
   Total cold run time: 276052 ms
   Total hot run time: 190099 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3506041693

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 27.57 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit a7b43fb0e933fc9c58cf8e0b4a26b2de28ea1880, data reload: false
   
   query1	0.06	0.05	0.05
   query2	0.10	0.04	0.04
   query3	0.27	0.09	0.08
   query4	1.94	0.12	0.12
   query5	0.26	0.26	0.26
   query6	1.18	0.64	0.64
   query7	0.03	0.03	0.02
   query8	0.05	0.04	0.04
   query9	0.60	0.52	0.53
   query10	0.59	0.58	0.57
   query11	0.18	0.12	0.11
   query12	0.15	0.12	0.11
   query13	0.62	0.61	0.60
   query14	1.00	0.99	1.04
   query15	0.86	0.82	0.82
   query16	0.39	0.38	0.39
   query17	1.05	1.04	1.03
   query18	0.21	0.20	0.20
   query19	2.08	1.82	1.78
   query20	0.01	0.01	0.01
   query21	15.48	0.21	0.13
   query22	4.99	0.08	0.04
   query23	16.01	0.27	0.10
   query24	2.82	0.66	0.60
   query25	0.08	0.08	0.06
   query26	0.14	0.13	0.13
   query27	0.08	0.06	0.05
   query28	5.02	1.15	0.92
   query29	12.55	3.84	3.20
   query30	0.28	0.13	0.11
   query31	2.82	0.58	0.39
   query32	3.59	0.54	0.48
   query33	3.01	3.08	3.18
   query34	15.92	5.18	4.52
   query35	4.58	4.56	4.60
   query36	0.70	0.51	0.49
   query37	0.11	0.07	0.07
   query38	0.06	0.04	0.04
   query39	0.05	0.02	0.02
   query40	0.17	0.13	0.14
   query41	0.11	0.03	0.02
   query42	0.06	0.03	0.03
   query43	0.04	0.03	0.04
   Total cold run time: 100.3 s
   Total hot run time: 27.57 s
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3413775753

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.53 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit d02c24c3a242d0060b6fc1bfee6d741cece966cd, data reload: false
   
   query1	0.06	0.06	0.05
   query2	0.09	0.06	0.06
   query3	0.26	0.09	0.09
   query4	1.62	0.12	0.12
   query5	0.28	0.27	0.25
   query6	1.18	0.66	0.65
   query7	0.04	0.03	0.03
   query8	0.06	0.04	0.04
   query9	0.64	0.52	0.52
   query10	0.58	0.59	0.58
   query11	0.16	0.11	0.12
   query12	0.15	0.13	0.12
   query13	0.63	0.62	0.62
   query14	1.04	1.05	1.03
   query15	0.87	0.84	0.87
   query16	0.43	0.39	0.39
   query17	1.08	1.04	1.04
   query18	0.22	0.20	0.19
   query19	1.94	1.89	1.82
   query20	0.02	0.02	0.01
   query21	15.46	0.96	0.58
   query22	0.76	1.13	0.63
   query23	15.04	1.40	0.63
   query24	6.72	2.03	0.90
   query25	0.44	0.10	0.14
   query26	0.67	0.16	0.13
   query27	0.06	0.07	0.05
   query28	9.66	1.34	0.94
   query29	12.63	3.94	3.28
   query30	0.31	0.15	0.11
   query31	2.83	0.58	0.39
   query32	3.26	0.56	0.47
   query33	2.99	3.16	3.11
   query34	16.02	5.45	4.88
   query35	4.93	4.87	4.91
   query36	0.72	0.51	0.52
   query37	0.10	0.08	0.08
   query38	0.06	0.04	0.04
   query39	0.04	0.03	0.03
   query40	0.18	0.15	0.14
   query41	0.08	0.03	0.04
   query42	0.04	0.03	0.03
   query43	0.04	0.04	0.04
   Total cold run time: 104.39 s
   Total hot run time: 30.53 s
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "starocean999 (via GitHub)" <gi...@apache.org>.
starocean999 merged PR #56941:
URL: https://github.com/apache/doris/pull/56941


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3546870566

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 28.07 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 20dee04388464e8c370b9fbc1c58572de608cc51, data reload: false
   
   query1	0.06	0.05	0.05
   query2	0.09	0.05	0.05
   query3	0.26	0.08	0.08
   query4	1.61	0.12	0.11
   query5	0.26	0.26	0.24
   query6	1.19	0.65	0.63
   query7	0.03	0.03	0.02
   query8	0.05	0.04	0.04
   query9	0.60	0.53	0.52
   query10	0.59	0.58	0.57
   query11	0.16	0.11	0.11
   query12	0.15	0.12	0.13
   query13	0.62	0.61	0.61
   query14	1.00	0.99	0.99
   query15	0.85	0.83	0.83
   query16	0.39	0.39	0.39
   query17	1.04	1.00	1.00
   query18	0.21	0.20	0.20
   query19	1.88	1.82	1.80
   query20	0.02	0.01	0.02
   query21	15.44	0.22	0.13
   query22	4.88	0.08	0.06
   query23	15.65	0.26	0.10
   query24	2.68	1.04	1.00
   query25	0.09	0.05	0.06
   query26	0.15	0.14	0.13
   query27	0.06	0.05	0.05
   query28	5.10	1.18	0.94
   query29	12.62	3.90	3.24
   query30	0.28	0.14	0.12
   query31	2.82	0.59	0.39
   query32	3.23	0.55	0.46
   query33	3.02	3.04	3.06
   query34	15.87	5.32	4.57
   query35	4.57	4.60	4.56
   query36	0.66	0.51	0.50
   query37	0.10	0.07	0.06
   query38	0.06	0.04	0.04
   query39	0.04	0.03	0.03
   query40	0.17	0.14	0.15
   query41	0.08	0.03	0.04
   query42	0.04	0.03	0.03
   query43	0.04	0.03	0.03
   Total cold run time: 98.71 s
   Total hot run time: 28.07 s
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3551026298

   run cloud_p0


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3503018166

   # FE Regression Coverage Report
   Increment line coverage `  92.00% (92/100)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/56941_5a0df8ec586cff8aadf8ed24293d09a1beb34d48_merge_fe/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/56941_5a0df8ec586cff8aadf8ed24293d09a1beb34d48_merge_fe/report/index.html)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3506148342

   # FE Regression Coverage Report
   Increment line coverage `  92.00% (92/100)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/56941_a7b43fb0e933fc9c58cf8e0b4a26b2de28ea1880_merge_fe/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/56941_a7b43fb0e933fc9c58cf8e0b4a26b2de28ea1880_merge_fe/report/index.html)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3502237316

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3541033731

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3541279600

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 188725 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit caf1efb71eb2e24e58b51104280ade8282e1b387, data reload: false
   
   query1	1023	446	391	391
   query2	6550	1666	1692	1666
   query3	6760	241	221	221
   query4	27218	23432	23345	23345
   query5	4486	641	515	515
   query6	343	249	240	240
   query7	4645	508	314	314
   query8	309	275	256	256
   query9	8662	2955	2939	2939
   query10	515	369	309	309
   query11	15806	14921	14885	14885
   query12	190	128	120	120
   query13	1692	583	472	472
   query14	10499	9439	9389	9389
   query15	203	188	171	171
   query16	7680	696	467	467
   query17	1252	796	646	646
   query18	2042	435	353	353
   query19	226	207	190	190
   query20	143	131	121	121
   query21	222	141	121	121
   query22	3970	3930	4036	3930
   query23	34102	32884	32883	32883
   query24	8156	2436	2448	2436
   query25	645	550	498	498
   query26	1246	279	179	179
   query27	2715	521	380	380
   query28	4434	2278	2249	2249
   query29	849	666	554	554
   query30	308	229	202	202
   query31	931	810	745	745
   query32	96	91	81	81
   query33	611	432	370	370
   query34	821	867	543	543
   query35	868	833	746	746
   query36	957	1001	931	931
   query37	130	121	93	93
   query38	3487	3535	3446	3446
   query39	1504	1420	1430	1420
   query40	227	135	127	127
   query41	62	58	58	58
   query42	139	122	119	119
   query43	485	483	464	464
   query44	1306	810	795	795
   query45	187	183	172	172
   query46	934	1010	666	666
   query47	1754	1755	1690	1690
   query48	403	439	330	330
   query49	758	497	416	416
   query50	692	706	424	424
   query51	3888	4026	3844	3844
   query52	124	126	111	111
   query53	247	272	215	215
   query54	341	319	300	300
   query55	96	94	97	94
   query56	351	356	346	346
   query57	1157	1176	1111	1111
   query58	302	284	292	284
   query59	2562	2603	2459	2459
   query60	374	415	369	369
   query61	154	163	157	157
   query62	832	755	655	655
   query63	243	203	196	196
   query64	4443	1156	875	875
   query65	4009	3917	3968	3917
   query66	1140	445	348	348
   query67	15002	15011	14714	14714
   query68	8254	973	643	643
   query69	490	340	321	321
   query70	1333	1254	1275	1254
   query71	491	360	343	343
   query72	6030	4895	4953	4895
   query73	713	636	372	372
   query74	9345	9086	8934	8934
   query75	3983	3269	2760	2760
   query76	3772	1138	750	750
   query77	818	435	347	347
   query78	9598	9567	8768	8768
   query79	2462	844	632	632
   query80	665	609	534	534
   query81	509	262	230	230
   query82	477	160	137	137
   query83	269	268	252	252
   query84	251	112	93	93
   query85	927	477	456	456
   query86	398	320	297	297
   query87	3693	3679	3622	3622
   query88	3863	2293	2271	2271
   query89	400	335	288	288
   query90	1962	233	233	233
   query91	170	170	139	139
   query92	91	77	74	74
   query93	1930	1014	679	679
   query94	701	421	339	339
   query95	434	349	340	340
   query96	496	608	288	288
   query97	2963	2959	2859	2859
   query98	275	229	214	214
   query99	1417	1424	1288	1288
   Total cold run time: 277688 ms
   Total hot run time: 188725 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3454898565

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3502428742

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 188215 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 5a0df8ec586cff8aadf8ed24293d09a1beb34d48, data reload: false
   
   query1	1074	394	397	394
   query2	6584	1726	1726	1726
   query3	6757	227	232	227
   query4	26955	24296	23592	23592
   query5	4441	654	478	478
   query6	326	236	220	220
   query7	4642	504	314	314
   query8	333	256	252	252
   query9	8658	2590	2557	2557
   query10	475	337	277	277
   query11	15913	15060	14801	14801
   query12	182	117	116	116
   query13	1714	570	430	430
   query14	11198	9345	9269	9269
   query15	202	193	179	179
   query16	7557	673	545	545
   query17	1296	793	626	626
   query18	2020	438	331	331
   query19	209	209	180	180
   query20	129	130	123	123
   query21	221	143	117	117
   query22	4328	4162	3985	3985
   query23	33750	33063	32894	32894
   query24	8444	2433	2456	2433
   query25	588	500	449	449
   query26	1242	269	158	158
   query27	2766	488	352	352
   query28	4385	2202	2187	2187
   query29	783	609	492	492
   query30	310	231	198	198
   query31	915	800	714	714
   query32	86	76	80	76
   query33	584	375	313	313
   query34	790	872	534	534
   query35	851	840	741	741
   query36	955	1001	903	903
   query37	119	117	85	85
   query38	3492	3560	3503	3503
   query39	1503	1436	1430	1430
   query40	222	128	119	119
   query41	63	60	61	60
   query42	131	110	115	110
   query43	512	494	476	476
   query44	1274	746	743	743
   query45	192	183	176	176
   query46	884	1006	648	648
   query47	1767	1807	1698	1698
   query48	407	427	320	320
   query49	767	536	435	435
   query50	649	690	423	423
   query51	3934	3853	3848	3848
   query52	112	111	105	105
   query53	247	267	196	196
   query54	325	283	279	279
   query55	88	86	84	84
   query56	327	312	307	307
   query57	1172	1190	1119	1119
   query58	286	271	272	271
   query59	2517	2697	2552	2552
   query60	342	360	326	326
   query61	157	162	157	157
   query62	788	745	677	677
   query63	235	197	197	197
   query64	4478	1178	951	951
   query65	4041	3926	3986	3926
   query66	1144	452	362	362
   query67	15225	15114	14985	14985
   query68	6873	878	606	606
   query69	500	341	296	296
   query70	1330	1323	1319	1319
   query71	439	348	318	318
   query72	5643	5011	4723	4723
   query73	644	574	362	362
   query74	8860	8891	8950	8891
   query75	3326	3326	2824	2824
   query76	3312	1176	749	749
   query77	516	419	312	312
   query78	9608	9699	8863	8863
   query79	2846	808	603	603
   query80	810	569	503	503
   query81	534	262	225	225
   query82	458	158	130	130
   query83	269	264	251	251
   query84	261	117	93	93
   query85	946	482	448	448
   query86	409	324	291	291
   query87	3733	3743	3652	3652
   query88	3915	2298	2284	2284
   query89	397	327	296	296
   query90	1909	236	237	236
   query91	169	167	138	138
   query92	79	67	65	65
   query93	2593	997	636	636
   query94	765	440	341	341
   query95	397	329	319	319
   query96	481	575	284	284
   query97	2884	2944	2842	2842
   query98	260	220	209	209
   query99	1361	1434	1355	1355
   Total cold run time: 275590 ms
   Total hot run time: 188215 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3454970168

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3546769768

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 33888 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 20dee04388464e8c370b9fbc1c58572de608cc51, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17612	5135	4934	4934
   q2	2015	308	202	202
   q3	10298	1281	723	723
   q4	10229	890	365	365
   q5	7484	2420	2297	2297
   q6	184	170	135	135
   q7	939	764	618	618
   q8	9359	1322	1109	1109
   q9	7041	5133	5188	5133
   q10	6898	2214	1794	1794
   q11	518	310	285	285
   q12	385	365	227	227
   q13	17788	3631	2986	2986
   q14	238	233	211	211
   q15	579	506	509	506
   q16	1029	999	938	938
   q17	584	858	366	366
   q18	7606	7192	7006	7006
   q19	1093	934	530	530
   q20	355	354	234	234
   q21	3849	3187	2311	2311
   q22	1071	1051	978	978
   Total cold run time: 107154 ms
   Total hot run time: 33888 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4919	4931	4932	4931
   q2	249	319	226	226
   q3	2155	2661	2354	2354
   q4	1328	1806	1355	1355
   q5	4212	4315	4489	4315
   q6	214	175	128	128
   q7	2007	2030	1790	1790
   q8	2671	2566	2690	2566
   q9	7179	7324	7317	7317
   q10	3032	3318	2828	2828
   q11	593	562	505	505
   q12	696	999	626	626
   q13	3455	3835	3330	3330
   q14	302	304	269	269
   q15	561	495	494	494
   q16	1057	1146	1043	1043
   q17	1174	1574	1396	1396
   q18	7937	7769	7533	7533
   q19	781	760	870	760
   q20	2037	2129	1889	1889
   q21	4700	4330	4311	4311
   q22	1116	1027	1026	1026
   Total cold run time: 52375 ms
   Total hot run time: 50992 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3551024107

   run feut


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3544778230

   run cloud_p0


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3551026574

   run external


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3502452852

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 27.16 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 5a0df8ec586cff8aadf8ed24293d09a1beb34d48, data reload: false
   
   query1	0.05	0.04	0.04
   query2	0.10	0.05	0.04
   query3	0.26	0.08	0.08
   query4	1.61	0.11	0.11
   query5	0.28	0.25	0.24
   query6	1.18	0.66	0.64
   query7	0.03	0.03	0.02
   query8	0.05	0.04	0.04
   query9	0.59	0.52	0.52
   query10	0.57	0.56	0.58
   query11	0.16	0.11	0.11
   query12	0.14	0.12	0.11
   query13	0.61	0.61	0.60
   query14	1.00	1.00	1.01
   query15	0.84	0.83	0.83
   query16	0.38	0.40	0.39
   query17	1.05	1.02	1.01
   query18	0.22	0.19	0.20
   query19	1.90	1.72	1.81
   query20	0.02	0.02	0.01
   query21	15.43	0.17	0.13
   query22	5.17	0.07	0.04
   query23	15.69	0.26	0.10
   query24	2.66	0.79	0.39
   query25	0.08	0.07	0.06
   query26	0.17	0.15	0.12
   query27	0.06	0.05	0.05
   query28	4.60	1.12	0.92
   query29	12.54	3.87	3.22
   query30	0.28	0.14	0.10
   query31	2.82	0.58	0.37
   query32	3.23	0.56	0.47
   query33	3.03	3.10	3.05
   query34	15.93	5.18	4.50
   query35	4.58	4.58	4.54
   query36	0.68	0.51	0.49
   query37	0.10	0.07	0.06
   query38	0.06	0.04	0.04
   query39	0.04	0.03	0.03
   query40	0.17	0.14	0.13
   query41	0.08	0.03	0.03
   query42	0.04	0.03	0.03
   query43	0.04	0.03	0.03
   Total cold run time: 98.52 s
   Total hot run time: 27.16 s
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3502377721

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 34298 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 5a0df8ec586cff8aadf8ed24293d09a1beb34d48, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17596	5255	5064	5064
   q2	1998	343	197	197
   q3	10286	1280	716	716
   q4	10211	851	375	375
   q5	7546	2460	2291	2291
   q6	184	165	138	138
   q7	951	770	619	619
   q8	9337	1343	1224	1224
   q9	6928	5127	5200	5127
   q10	6896	2218	1794	1794
   q11	488	303	284	284
   q12	336	376	238	238
   q13	17776	3670	3056	3056
   q14	232	236	211	211
   q15	580	508	506	506
   q16	1019	988	936	936
   q17	589	875	375	375
   q18	7506	7183	6984	6984
   q19	1225	946	576	576
   q20	362	350	231	231
   q21	3928	2574	2370	2370
   q22	1045	1051	986	986
   Total cold run time: 107019 ms
   Total hot run time: 34298 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5186	5130	5084	5084
   q2	251	324	227	227
   q3	2194	2666	2279	2279
   q4	1368	1748	1337	1337
   q5	4235	4352	4541	4352
   q6	219	171	137	137
   q7	2052	1992	1740	1740
   q8	2701	2655	2521	2521
   q9	7388	7232	7261	7232
   q10	3007	3376	2870	2870
   q11	588	531	512	512
   q12	689	798	639	639
   q13	3541	4003	3207	3207
   q14	268	295	272	272
   q15	551	500	514	500
   q16	1075	1090	1081	1081
   q17	1173	1519	1635	1519
   q18	7883	7735	7492	7492
   q19	874	865	889	865
   q20	2008	2130	1945	1945
   q21	4994	4299	4344	4299
   q22	1079	1083	994	994
   Total cold run time: 53324 ms
   Total hot run time: 51104 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3455003425

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3400462088

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3401313262

   # FE Regression Coverage Report
   Increment line coverage `  94.51% (86/91)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/56941_858da7fe4ae69a9a91ea92f0411e1a80a40782cf_merge_fe/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/56941_858da7fe4ae69a9a91ea92f0411e1a80a40782cf_merge_fe/report/index.html)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3506025534

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 34351 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit a7b43fb0e933fc9c58cf8e0b4a26b2de28ea1880, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17738	5205	5076	5076
   q2	2272	346	209	209
   q3	10287	1247	719	719
   q4	10335	888	371	371
   q5	7525	2313	2357	2313
   q6	178	166	136	136
   q7	888	771	621	621
   q8	9379	1328	1148	1148
   q9	7151	5337	5227	5227
   q10	7271	2268	1843	1843
   q11	548	307	300	300
   q12	451	368	236	236
   q13	18116	3647	3016	3016
   q14	252	231	208	208
   q15	575	508	510	508
   q16	1031	1008	944	944
   q17	582	869	363	363
   q18	7770	7082	7156	7082
   q19	1201	931	539	539
   q20	351	340	231	231
   q21	3688	2519	2287	2287
   q22	1070	1026	974	974
   Total cold run time: 108659 ms
   Total hot run time: 34351 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5170	5096	5038	5038
   q2	246	329	232	232
   q3	2157	2719	2317	2317
   q4	1350	1759	1316	1316
   q5	4438	4506	4371	4371
   q6	208	189	138	138
   q7	2029	1997	1899	1899
   q8	2606	2624	2603	2603
   q9	7369	7409	7267	7267
   q10	3068	3357	2789	2789
   q11	595	543	486	486
   q12	629	755	603	603
   q13	3483	3913	3291	3291
   q14	310	311	267	267
   q15	538	508	500	500
   q16	1069	1103	1059	1059
   q17	1197	1561	1490	1490
   q18	7943	7770	7602	7602
   q19	774	802	919	802
   q20	1928	1946	1838	1838
   q21	4786	4354	4352	4352
   q22	1083	1055	963	963
   Total cold run time: 52976 ms
   Total hot run time: 51223 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3454972878

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3546838777

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 189012 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 20dee04388464e8c370b9fbc1c58572de608cc51, data reload: false
   
   query1	1020	426	393	393
   query2	6569	1707	1687	1687
   query3	6761	232	222	222
   query4	26786	22825	22904	22825
   query5	4433	667	511	511
   query6	349	263	229	229
   query7	4640	499	315	315
   query8	311	265	254	254
   query9	8659	2937	2949	2937
   query10	506	367	306	306
   query11	15915	15024	14752	14752
   query12	193	126	124	124
   query13	1712	593	451	451
   query14	11060	9364	9351	9351
   query15	206	192	180	180
   query16	7445	656	537	537
   query17	1256	784	651	651
   query18	2018	427	342	342
   query19	224	210	183	183
   query20	138	128	129	128
   query21	219	135	117	117
   query22	4093	4227	4021	4021
   query23	34117	33187	33008	33008
   query24	8146	2405	2412	2405
   query25	631	580	494	494
   query26	1241	282	178	178
   query27	2737	514	360	360
   query28	4412	2252	2241	2241
   query29	826	667	528	528
   query30	301	227	199	199
   query31	920	816	719	719
   query32	96	85	86	85
   query33	600	407	376	376
   query34	792	864	525	525
   query35	871	837	776	776
   query36	916	981	889	889
   query37	134	115	99	99
   query38	3530	3479	3470	3470
   query39	1469	1453	1394	1394
   query40	234	137	129	129
   query41	63	59	62	59
   query42	134	119	116	116
   query43	484	468	461	461
   query44	1253	799	803	799
   query45	189	186	193	186
   query46	889	992	638	638
   query47	1745	1786	1750	1750
   query48	413	438	326	326
   query49	783	495	418	418
   query50	656	681	403	403
   query51	3871	3963	3929	3929
   query52	118	114	111	111
   query53	254	293	200	200
   query54	347	320	297	297
   query55	95	97	89	89
   query56	352	346	328	328
   query57	1182	1242	1113	1113
   query58	296	294	286	286
   query59	2421	2567	2561	2561
   query60	370	374	352	352
   query61	163	157	159	157
   query62	815	696	641	641
   query63	227	199	195	195
   query64	4427	1200	883	883
   query65	4018	3933	3943	3933
   query66	1177	438	352	352
   query67	15273	15059	15021	15021
   query68	8235	948	651	651
   query69	506	358	307	307
   query70	1409	1255	1296	1255
   query71	473	354	359	354
   query72	5901	4893	5044	4893
   query73	707	576	368	368
   query74	8913	9047	8869	8869
   query75	3920	3249	2742	2742
   query76	3681	1129	759	759
   query77	821	424	337	337
   query78	9485	9706	9279	9279
   query79	2179	870	613	613
   query80	680	605	547	547
   query81	481	257	236	236
   query82	431	164	135	135
   query83	266	261	247	247
   query84	245	123	92	92
   query85	894	482	451	451
   query86	349	331	324	324
   query87	3656	3697	3628	3628
   query88	3427	2229	2206	2206
   query89	389	325	297	297
   query90	1966	239	228	228
   query91	175	166	139	139
   query92	90	78	74	74
   query93	1407	1019	703	703
   query94	715	429	342	342
   query95	416	351	347	347
   query96	482	581	284	284
   query97	2897	2989	2846	2846
   query98	240	223	225	223
   query99	1405	1383	1241	1241
   Total cold run time: 275342 ms
   Total hot run time: 189012 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3551025548

   run p0


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3454986213

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3400774378

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.27 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 858da7fe4ae69a9a91ea92f0411e1a80a40782cf, data reload: false
   
   query1	0.05	0.04	0.05
   query2	0.09	0.04	0.06
   query3	0.26	0.09	0.08
   query4	1.61	0.12	0.12
   query5	0.28	0.26	0.25
   query6	1.18	0.64	0.65
   query7	0.04	0.03	0.03
   query8	0.06	0.04	0.05
   query9	0.64	0.54	0.52
   query10	0.59	0.58	0.59
   query11	0.16	0.11	0.11
   query12	0.15	0.11	0.12
   query13	0.63	0.61	0.62
   query14	1.04	1.03	1.02
   query15	0.89	0.85	0.88
   query16	0.40	0.40	0.39
   query17	1.02	1.11	1.01
   query18	0.22	0.20	0.20
   query19	1.95	1.82	1.86
   query20	0.01	0.01	0.02
   query21	15.41	0.92	0.59
   query22	0.76	1.22	0.68
   query23	14.92	1.39	0.66
   query24	7.18	0.79	0.47
   query25	0.48	0.26	0.10
   query26	0.56	0.17	0.13
   query27	0.07	0.06	0.06
   query28	9.38	1.39	0.95
   query29	12.64	4.00	3.34
   query30	0.27	0.13	0.12
   query31	2.82	0.58	0.39
   query32	3.24	0.56	0.51
   query33	3.08	3.10	3.09
   query34	16.19	5.45	4.87
   query35	4.97	4.96	4.94
   query36	0.71	0.52	0.50
   query37	0.10	0.08	0.08
   query38	0.07	0.05	0.05
   query39	0.03	0.03	0.03
   query40	0.18	0.15	0.15
   query41	0.09	0.04	0.03
   query42	0.04	0.03	0.04
   query43	0.05	0.03	0.03
   Total cold run time: 104.51 s
   Total hot run time: 30.27 s
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3546311117

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3551308920

   PR approved by at least one committer and no changes requested.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3551403684

   # FE Regression Coverage Report
   Increment line coverage `  93.75% (90/96)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/56941_20dee04388464e8c370b9fbc1c58572de608cc51_merge_fe/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/56941_20dee04388464e8c370b9fbc1c58572de608cc51_merge_fe/report/index.html)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3414223141

   # FE Regression Coverage Report
   Increment line coverage `  94.51% (86/91)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/56941_d02c24c3a242d0060b6fc1bfee6d741cece966cd_merge_fe/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/56941_d02c24c3a242d0060b6fc1bfee6d741cece966cd_merge_fe/report/index.html)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3541835174

   # FE Regression Coverage Report
   Increment line coverage `  92.00% (92/100)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/56941_caf1efb71eb2e24e58b51104280ade8282e1b387_merge_fe/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/56941_caf1efb71eb2e24e58b51104280ade8282e1b387_merge_fe/report/index.html)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3400419897

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3400755512

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 190920 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 858da7fe4ae69a9a91ea92f0411e1a80a40782cf, data reload: false
   
   query1	1087	440	406	406
   query2	6604	1640	1686	1640
   query3	6748	229	223	223
   query4	26807	23737	23587	23587
   query5	5684	626	479	479
   query6	360	228	223	223
   query7	4660	491	307	307
   query8	318	267	244	244
   query9	8695	2558	2545	2545
   query10	545	332	292	292
   query11	15557	15093	15518	15093
   query12	199	143	138	138
   query13	1700	582	458	458
   query14	11664	9532	9502	9502
   query15	216	201	185	185
   query16	7900	743	569	569
   query17	2003	827	653	653
   query18	2227	436	339	339
   query19	209	211	181	181
   query20	130	125	121	121
   query21	216	134	137	134
   query22	4648	4678	4642	4642
   query23	34736	34393	33943	33943
   query24	8731	2472	2429	2429
   query25	572	486	446	446
   query26	1227	265	153	153
   query27	2732	502	341	341
   query28	4393	2163	2151	2151
   query29	774	596	469	469
   query30	299	218	196	196
   query31	904	780	745	745
   query32	80	65	70	65
   query33	615	368	313	313
   query34	811	841	508	508
   query35	779	833	759	759
   query36	967	991	933	933
   query37	115	109	84	84
   query38	3501	3528	3497	3497
   query39	1475	1424	1420	1420
   query40	216	123	116	116
   query41	60	64	61	61
   query42	120	107	110	107
   query43	488	500	474	474
   query44	1301	821	812	812
   query45	179	180	178	178
   query46	827	987	638	638
   query47	1739	1819	1767	1767
   query48	390	426	316	316
   query49	755	509	414	414
   query50	626	697	413	413
   query51	3905	3909	3862	3862
   query52	116	112	107	107
   query53	242	262	216	216
   query54	617	589	545	545
   query55	83	90	88	88
   query56	343	317	305	305
   query57	1199	1222	1127	1127
   query58	284	284	271	271
   query59	2553	2644	2496	2496
   query60	352	332	319	319
   query61	152	150	153	150
   query62	806	727	677	677
   query63	221	200	190	190
   query64	4384	1202	827	827
   query65	4039	3999	3970	3970
   query66	1036	420	353	353
   query67	15821	15574	15192	15192
   query68	7942	926	597	597
   query69	529	314	282	282
   query70	1266	1294	1279	1279
   query71	466	336	308	308
   query72	5741	5029	4902	4902
   query73	628	582	361	361
   query74	8856	9254	8872	8872
   query75	3652	3352	2865	2865
   query76	3497	1156	736	736
   query77	725	412	322	322
   query78	9544	9714	8903	8903
   query79	2156	847	593	593
   query80	632	561	509	509
   query81	483	258	232	232
   query82	424	168	134	134
   query83	301	270	249	249
   query84	304	118	94	94
   query85	912	475	427	427
   query86	351	321	287	287
   query87	3727	3811	3672	3672
   query88	3574	2231	2259	2231
   query89	396	317	296	296
   query90	1968	216	213	213
   query91	164	164	132	132
   query92	79	71	64	64
   query93	1697	970	646	646
   query94	731	455	340	340
   query95	395	326	316	316
   query96	485	571	278	278
   query97	2955	2995	2882	2882
   query98	251	216	209	209
   query99	1413	1402	1285	1285
   Total cold run time: 279986 ms
   Total hot run time: 190920 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3505999308

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3506036790

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 185655 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit a7b43fb0e933fc9c58cf8e0b4a26b2de28ea1880, data reload: false
   
   query1	1660	406	386	386
   query2	6748	1692	1735	1692
   query3	6881	228	221	221
   query4	26241	23615	23394	23394
   query5	4467	636	447	447
   query6	324	252	225	225
   query7	4653	526	299	299
   query8	307	248	230	230
   query9	8671	2573	2571	2571
   query10	480	337	292	292
   query11	15820	15203	14943	14943
   query12	173	119	113	113
   query13	1718	574	445	445
   query14	10618	9216	9170	9170
   query15	199	186	178	178
   query16	7379	705	553	553
   query17	1294	798	647	647
   query18	2072	432	347	347
   query19	235	211	183	183
   query20	137	124	122	122
   query21	520	138	121	121
   query22	4193	4257	3924	3924
   query23	33923	33184	32885	32885
   query24	8518	2440	2397	2397
   query25	642	528	446	446
   query26	1254	265	156	156
   query27	2738	493	343	343
   query28	4347	2202	2187	2187
   query29	833	617	482	482
   query30	320	224	203	203
   query31	943	826	726	726
   query32	87	68	73	68
   query33	597	383	323	323
   query34	772	858	546	546
   query35	813	843	757	757
   query36	943	1001	906	906
   query37	142	111	95	95
   query38	3498	3597	3532	3532
   query39	1499	1479	1482	1479
   query40	417	128	119	119
   query41	67	62	64	62
   query42	128	110	110	110
   query43	476	464	459	459
   query44	1230	757	760	757
   query45	190	189	178	178
   query46	868	984	629	629
   query47	1745	1810	1703	1703
   query48	414	429	325	325
   query49	983	520	425	425
   query50	637	690	402	402
   query51	3897	3975	4003	3975
   query52	110	110	100	100
   query53	243	263	192	192
   query54	313	296	277	277
   query55	88	86	86	86
   query56	340	319	327	319
   query57	1198	1201	1154	1154
   query58	291	280	272	272
   query59	2661	2608	2497	2497
   query60	339	339	314	314
   query61	161	150	158	150
   query62	796	748	664	664
   query63	219	190	194	190
   query64	4573	1143	841	841
   query65	4017	3986	3969	3969
   query66	1219	437	344	344
   query67	15230	15287	14917	14917
   query68	7936	915	596	596
   query69	546	318	276	276
   query70	1282	1282	1288	1282
   query71	433	328	321	321
   query72	6005	2663	5358	2663
   query73	758	766	361	361
   query74	9004	8942	9099	8942
   query75	3270	3295	2860	2860
   query76	3338	1146	726	726
   query77	502	418	317	317
   query78	9557	9533	8855	8855
   query79	2229	804	586	586
   query80	617	563	498	498
   query81	521	270	234	234
   query82	485	161	126	126
   query83	270	260	236	236
   query84	275	114	92	92
   query85	934	486	440	440
   query86	384	318	311	311
   query87	3767	3783	3589	3589
   query88	3923	2248	2201	2201
   query89	394	327	287	287
   query90	1991	216	211	211
   query91	171	172	138	138
   query92	77	69	62	62
   query93	1870	980	634	634
   query94	730	459	356	356
   query95	422	338	320	320
   query96	481	574	287	287
   query97	2914	2977	2878	2878
   query98	248	218	210	210
   query99	1357	1439	1296	1296
   Total cold run time: 276200 ms
   Total hot run time: 185655 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3546416736

   PR approved by at least one committer and no changes requested.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3541232469

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 34336 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit caf1efb71eb2e24e58b51104280ade8282e1b387, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17621	5128	4998	4998
   q2	2084	305	208	208
   q3	10250	1254	717	717
   q4	10235	940	374	374
   q5	7513	2466	2298	2298
   q6	185	170	139	139
   q7	906	753	613	613
   q8	9327	1358	1287	1287
   q9	6857	5034	5231	5034
   q10	6936	2256	1845	1845
   q11	518	305	281	281
   q12	349	371	242	242
   q13	18066	3722	3079	3079
   q14	230	241	221	221
   q15	619	504	492	492
   q16	1022	1016	958	958
   q17	594	876	389	389
   q18	7867	7267	7075	7075
   q19	1091	949	575	575
   q20	347	339	235	235
   q21	3687	3210	2291	2291
   q22	1081	1047	985	985
   Total cold run time: 107385 ms
   Total hot run time: 34336 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5102	5083	5112	5083
   q2	246	356	232	232
   q3	2117	2661	2290	2290
   q4	1403	1752	1331	1331
   q5	4171	4483	4434	4434
   q6	211	186	141	141
   q7	2015	1999	1799	1799
   q8	2652	2634	2580	2580
   q9	7341	7152	7391	7152
   q10	3089	3244	2810	2810
   q11	621	511	502	502
   q12	681	813	664	664
   q13	3843	3850	3206	3206
   q14	283	287	285	285
   q15	546	497	499	497
   q16	1099	1155	1067	1067
   q17	1211	1484	1405	1405
   q18	7940	7777	7524	7524
   q19	845	863	891	863
   q20	1877	2011	1819	1819
   q21	4721	4297	4152	4152
   q22	1091	1049	999	999
   Total cold run time: 53105 ms
   Total hot run time: 50835 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3455122175

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 27.41 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 34d00c92288c72ce5cd057473306aeaeb03fe9d2, data reload: false
   
   query1	0.05	0.05	0.04
   query2	0.10	0.06	0.05
   query3	0.25	0.09	0.08
   query4	1.61	0.11	0.11
   query5	0.29	0.27	0.25
   query6	1.18	0.67	0.66
   query7	0.03	0.03	0.03
   query8	0.05	0.04	0.04
   query9	0.62	0.53	0.53
   query10	0.58	0.58	0.58
   query11	0.16	0.11	0.11
   query12	0.16	0.13	0.12
   query13	0.63	0.61	0.60
   query14	1.01	1.02	1.01
   query15	0.84	0.83	0.84
   query16	0.40	0.41	0.40
   query17	1.03	1.09	1.02
   query18	0.21	0.20	0.20
   query19	1.94	1.78	1.90
   query20	0.01	0.02	0.02
   query21	15.42	0.20	0.13
   query22	5.03	0.07	0.05
   query23	15.67	0.26	0.10
   query24	2.41	0.74	0.30
   query25	0.08	0.06	0.07
   query26	0.14	0.14	0.12
   query27	0.07	0.05	0.06
   query28	3.82	1.18	0.94
   query29	12.69	4.04	3.25
   query30	0.28	0.15	0.11
   query31	2.82	0.61	0.39
   query32	3.23	0.54	0.48
   query33	3.00	3.00	3.01
   query34	15.87	5.12	4.55
   query35	4.55	4.55	4.56
   query36	0.67	0.50	0.50
   query37	0.10	0.07	0.07
   query38	0.07	0.05	0.04
   query39	0.04	0.03	0.03
   query40	0.17	0.13	0.15
   query41	0.08	0.04	0.03
   query42	0.04	0.03	0.03
   query43	0.04	0.04	0.04
   Total cold run time: 97.44 s
   Total hot run time: 27.41 s
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3400730074

   # FE UT Coverage Report
   Increment line coverage `  98.90% (90/91)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/56941_858da7fe4ae69a9a91ea92f0411e1a80a40782cf/fe_increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/56941_858da7fe4ae69a9a91ea92f0411e1a80a40782cf/fe_report/index.html)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3454908597

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3455598365

   # FE Regression Coverage Report
   Increment line coverage `  91.84% (90/98)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/56941_34d00c92288c72ce5cd057473306aeaeb03fe9d2_merge_fe/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/56941_34d00c92288c72ce5cd057473306aeaeb03fe9d2_merge_fe/report/index.html)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3502376442

   run feut


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3551395796

   # FE Regression Coverage Report
   Increment line coverage `  93.75% (90/96)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/56941_20dee04388464e8c370b9fbc1c58572de608cc51_merge_fe/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/56941_20dee04388464e8c370b9fbc1c58572de608cc51_merge_fe/report/index.html)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3541299527

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 27.35 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit caf1efb71eb2e24e58b51104280ade8282e1b387, data reload: false
   
   query1	0.05	0.04	0.05
   query2	0.09	0.05	0.05
   query3	0.25	0.08	0.09
   query4	1.63	0.11	0.11
   query5	0.27	0.25	0.25
   query6	1.19	0.64	0.66
   query7	0.03	0.03	0.02
   query8	0.05	0.04	0.04
   query9	0.59	0.53	0.52
   query10	0.57	0.56	0.57
   query11	0.17	0.11	0.11
   query12	0.14	0.12	0.12
   query13	0.62	0.61	0.60
   query14	1.00	1.00	1.00
   query15	0.85	0.83	0.84
   query16	0.40	0.39	0.39
   query17	1.06	1.05	0.99
   query18	0.21	0.20	0.20
   query19	1.98	1.86	1.80
   query20	0.01	0.02	0.01
   query21	15.44	0.20	0.13
   query22	5.01	0.06	0.06
   query23	15.66	0.26	0.10
   query24	2.16	1.42	0.40
   query25	0.07	0.06	0.05
   query26	0.14	0.13	0.15
   query27	0.07	0.06	0.04
   query28	4.81	1.10	0.93
   query29	12.61	3.96	3.22
   query30	0.28	0.13	0.12
   query31	2.82	0.59	0.38
   query32	3.23	0.55	0.46
   query33	3.07	3.08	3.11
   query34	15.78	5.21	4.51
   query35	4.57	4.55	4.62
   query36	0.68	0.50	0.49
   query37	0.09	0.06	0.06
   query38	0.06	0.04	0.04
   query39	0.04	0.02	0.02
   query40	0.17	0.14	0.13
   query41	0.09	0.04	0.03
   query42	0.04	0.03	0.03
   query43	0.05	0.03	0.03
   Total cold run time: 98.1 s
   Total hot run time: 27.35 s
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3546416911

   PR approved by anyone and no changes requested.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3546431386

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [feat](case when) Push upper function into case when branch [doris]

Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3413685671

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org