This is an automated email from the ASF dual-hosted git repository.
hellostephen pushed a commit to branch branch-3.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-3.0 by this push:
new 422f61f8d6e [Fix](cases) remove unstable cases (#41858)
422f61f8d6e is described below
commit 422f61f8d6e250a3bc8320aa3e13ca36395906c3
Author: LiBinfeng <46676950+libinfeng...@users.noreply.github.com>
AuthorDate: Tue Oct 15 17:03:21 2024 +0800
[Fix](cases) remove unstable cases (#41858)
remove unstable cases in multi-leading test
---
.../data/nereids_p0/hint/multi_leading.out | 401 ---------------------
.../suites/nereids_p0/hint/multi_leading.groovy | 3 -
2 files changed, 404 deletions(-)
diff --git a/regression-test/data/nereids_p0/hint/multi_leading.out
b/regression-test/data/nereids_p0/hint/multi_leading.out
index be90f0ef094..eac055ef7da 100644
--- a/regression-test/data/nereids_p0/hint/multi_leading.out
+++ b/regression-test/data/nereids_p0/hint/multi_leading.out
@@ -59,404 +59,3 @@
-- !sql4_res_7 --
6224
--- !sql5_2 --
-2
-10
-11
-12
-18
-21
-28
-29
-31
-32
-40
-41
-47
-53
-54
-58
-62
-68
-70
-77
-80
-81
-87
-94
-96
-97
-106
-121
-129
-131
-135
-142
-151
-154
-155
-158
-160
-162
-165
-170
-173
-178
-184
-186
-188
-189
-190
-192
-193
-203
-205
-209
-214
-215
-218
-221
-225
-228
-236
-237
-238
-241
-242
-243
-246
-247
-251
-253
-255
-256
-257
-259
-260
-262
-267
-269
-271
-276
-279
-281
-286
-291
-296
-305
-308
-314
-318
-322
-323
-327
-331
-339
-340
-344
-346
-351
-363
-374
-380
-386
-388
-389
-390
-393
-394
-399
-400
-409
-410
-420
-421
-423
-424
-425
-428
-433
-434
-435
-441
-446
-449
-458
-461
-462
-467
-474
-478
-486
-488
-489
-490
-499
-0
-1
-3
-8
-13
-17
-27
-30
-34
-35
-36
-43
-44
-61
-63
-69
-71
-72
-73
-76
-79
-82
-84
-85
-89
-90
-92
-93
-98
-100
-111
-113
-114
-122
-124
-127
-137
-143
-147
-148
-149
-150
-153
-159
-168
-169
-171
-175
-179
-181
-197
-201
-202
-204
-206
-217
-220
-227
-229
-240
-261
-265
-268
-270
-273
-275
-278
-280
-285
-287
-288
-293
-294
-297
-299
-301
-303
-310
-311
-313
-315
-317
-319
-326
-329
-332
-333
-336
-343
-345
-358
-359
-370
-371
-372
-373
-376
-378
-385
-391
-398
-405
-406
-414
-430
-432
-445
-447
-452
-454
-455
-456
-459
-464
-465
-468
-477
-481
-482
-492
-494
-495
-500
-4
-6
-7
-14
-16
-20
-23
-25
-33
-37
-38
-39
-45
-46
-48
-49
-51
-57
-59
-60
-64
-65
-67
-83
-88
-99
-101
-102
-104
-107
-108
-109
-112
-117
-118
-119
-120
-123
-125
-128
-130
-132
-134
-136
-138
-140
-141
-152
-157
-161
-163
-166
-172
-174
-194
-195
-199
-200
-210
-212
-213
-216
-223
-226
-230
-231
-232
-233
-235
-248
-249
-252
-254
-258
-263
-264
-266
-272
-274
-282
-284
-290
-298
-300
-302
-304
-312
-316
-321
-324
-325
-334
-335
-338
-341
-347
-348
-352
-353
-357
-362
-366
-367
-368
-369
-375
-379
-381
-382
-383
-387
-396
-397
-402
-404
-407
-408
-411
-412
-415
-417
-418
-419
-427
-429
-431
-439
-440
-443
-444
-448
-453
-457
-460
-463
-466
-470
-473
-476
-480
-484
-487
-497
-\N
-
diff --git a/regression-test/suites/nereids_p0/hint/multi_leading.groovy
b/regression-test/suites/nereids_p0/hint/multi_leading.groovy
index fe63db1b636..1f2f41822c7 100644
--- a/regression-test/suites/nereids_p0/hint/multi_leading.groovy
+++ b/regression-test/suites/nereids_p0/hint/multi_leading.groovy
@@ -118,7 +118,4 @@ suite("multi_leading") {
qt_sql4_res_5 """select /*+ leading(t3 alias1) */ count(*) from (select
c1, c11 from t1 join (select /*+ leading(t4 t2) */ c2, c22 from t2 join t4 on
c2 = c4) as alias2 on c1 = alias2.c2) as alias1 join t3 on alias1.c1 = t3.c3;"""
qt_sql4_res_6 """select count(*) from (select /*+ leading(alias2 t1) */
c1, c11 from t1 join (select /*+ leading(t4 t2) */ c2, c22 from t2 join t4 on
c2 = c4) as alias2 on c1 = alias2.c2) as alias1 join t3 on alias1.c1 = t3.c3;"""
qt_sql4_res_7 """select /*+ leading(t3 alias1) */ count(*) from (select
/*+ leading(alias2 t1) */ c1, c11 from t1 join (select /*+ leading(t4 t2) */
c2, c22 from t2 join t4 on c2 = c4) as alias2 on c1 = alias2.c2) as alias1 join
t3 on alias1.c1 = t3.c3;"""
-
- // use cte in scalar query
- qt_sql5_2 """with cte as (select c11, c1 from t1) SELECT c1 FROM cte
group by c1 having sum(cte.c11) > (select /*+ leading(cte t1) */ 0.05 *
avg(t1.c11) from t1 join cte on t1.c1 = cte.c11 )"""
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
