doris
doris copied to clipboard
apache
[fix](pkfk) Fix drop table not drop constraint related info
What problem does this PR solve?
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
Release note
None
Check List (For Author)
-
Test
- [ ] Regression test
- [ ] Unit Test
- [ ] Manual test (add detailed scripts or steps below)
- [ ] No need to test or manual test. Explain why:
- [ ] This is a refactor/code format and no logic has been changed.
- [ ] Previous test can cover this change.
- [ ] No code files have been changed.
- [ ] Other reason
-
Behavior changed:
- [ ] No.
- [ ] Yes.
-
Does this need documentation?
- [ ] No.
- [ ] Yes.
Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label
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:
- What problem was fixed (it's best to include specific error reporting information). How it was fixed.
- Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
- What features were added. Why was this function added?
- Which code was refactored and why was this part of the code refactored?
- Which functions were optimized and what is the difference before and after the optimization?
FE UT Coverage Report
Increment line coverage 73.47% (36/49) :tada:
Increment coverage report
Complete coverage report
FE Regression Coverage Report
Increment line coverage 81.63% (40/49) :tada:
Increment coverage report
Complete coverage report
TPC-H: Total hot run time: 35291 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit fc47c08bb430e18377470c98cb37da4e8f981aa1, data reload: false
------ Round 1 ----------------------------------
q1 17667 4172 4074 4074
q2 2084 360 241 241
q3 10120 1328 724 724
q4 10206 813 316 316
q5 7446 2141 1966 1966
q6 183 171 139 139
q7 1023 871 717 717
q8 9370 1468 1215 1215
q9 7204 5369 5344 5344
q10 6844 2392 1945 1945
q11 517 323 292 292
q12 662 705 587 587
q13 17784 3702 3031 3031
q14 306 306 280 280
q15 596 516 515 515
q16 704 663 632 632
q17 708 780 570 570
q18 7509 7172 7033 7033
q19 1099 980 642 642
q20 403 370 255 255
q21 4245 3923 3794 3794
q22 1041 1030 979 979
Total cold run time: 107721 ms
Total hot run time: 35291 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4136 4056 4094 4056
q2 327 385 313 313
q3 2148 2700 2296 2296
q4 1329 1755 1263 1263
q5 4251 4586 4801 4586
q6 233 184 133 133
q7 2072 2008 1848 1848
q8 2678 2615 2598 2598
q9 7744 7872 7429 7429
q10 3087 3465 2803 2803
q11 618 516 490 490
q12 648 711 618 618
q13 3706 4011 3264 3264
q14 278 310 274 274
q15 552 516 518 516
q16 632 696 638 638
q17 1167 1518 1385 1385
q18 7945 7811 7545 7545
q19 917 882 927 882
q20 2037 2068 1957 1957
q21 5166 4584 4312 4312
q22 1075 1037 962 962
Total cold run time: 52746 ms
Total hot run time: 50168 ms
TPC-DS: Total hot run time: 178392 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 fc47c08bb430e18377470c98cb37da4e8f981aa1, data reload: false
query5 4875 616 482 482
query6 349 233 216 216
query7 4218 465 276 276
query8 325 261 244 244
query9 8800 2586 2587 2586
query10 515 397 336 336
query11 15121 14693 14579 14579
query12 182 117 117 117
query13 1290 523 402 402
query14 6133 3297 3019 3019
query14_1 2890 2872 2874 2872
query15 208 196 185 185
query16 935 468 433 433
query17 1088 695 570 570
query18 2559 440 358 358
query19 224 228 195 195
query20 135 113 110 110
query21 217 142 113 113
query22 3963 3893 3801 3801
query23 16658 16187 15815 15815
query23_1 16038 15997 16057 15997
query24 7360 1638 1206 1206
query24_1 1254 1217 1231 1217
query25 594 517 468 468
query26 1267 267 166 166
query27 2759 475 312 312
query28 4469 2166 2146 2146
query29 842 575 476 476
query30 314 245 221 221
query31 821 711 633 633
query32 83 76 75 75
query33 550 343 304 304
query34 924 896 543 543
query35 788 820 723 723
query36 866 913 825 825
query37 130 95 82 82
query38 2814 2904 2845 2845
query39 760 748 725 725
query39_1 697 706 719 706
query40 228 143 126 126
query41 74 68 66 66
query42 108 112 110 110
query43 442 439 419 419
query44 1343 746 753 746
query45 194 197 186 186
query46 920 982 625 625
query47 1630 1677 1634 1634
query48 335 335 252 252
query49 638 457 367 367
query50 674 292 230 230
query51 3777 3867 3899 3867
query52 112 114 105 105
query53 329 358 292 292
query54 315 282 278 278
query55 81 76 74 74
query56 306 318 317 317
query57 1158 1134 1092 1092
query58 275 263 246 246
query59 2418 2449 2412 2412
query60 337 327 311 311
query61 241 160 154 154
query62 697 661 620 620
query63 337 295 304 295
query64 5062 1297 1002 1002
query65 4003 3974 3929 3929
query66 1440 466 310 310
query67 15306 15011 14562 14562
query68 8408 1014 728 728
query69 506 362 306 306
query70 1057 959 945 945
query71 394 304 285 285
query72 6065 4965 5005 4965
query73 694 605 315 315
query74 8711 8858 8528 8528
query75 3154 3133 2745 2745
query76 3903 1136 779 779
query77 534 393 305 305
query78 9438 9606 8863 8863
query79 1407 908 629 629
query80 721 666 565 565
query81 533 272 239 239
query82 205 131 113 113
query83 265 259 238 238
query84 265 121 99 99
query85 892 524 463 463
query86 384 299 285 285
query87 3008 3036 2894 2894
query88 3699 2295 2303 2295
query89 473 424 401 401
query90 2195 161 164 161
query91 172 171 146 146
query92 88 67 65 65
query93 1685 932 565 565
query94 474 304 281 281
query95 582 333 363 333
query96 595 497 213 213
query97 2260 2317 2263 2263
query98 212 194 189 189
query99 1300 1299 1221 1221
Total cold run time: 261262 ms
Total hot run time: 178392 ms
ClickBench: Total hot run time: 27.53 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit fc47c08bb430e18377470c98cb37da4e8f981aa1, data reload: false
query1 0.06 0.05 0.05
query2 0.11 0.05 0.04
query3 0.27 0.09 0.09
query4 1.61 0.11 0.11
query5 0.27 0.27 0.26
query6 1.16 0.64 0.62
query7 0.04 0.03 0.02
query8 0.05 0.04 0.04
query9 0.58 0.50 0.51
query10 0.54 0.53 0.56
query11 0.15 0.11 0.11
query12 0.14 0.12 0.12
query13 0.61 0.61 0.62
query14 0.99 0.98 0.98
query15 0.83 0.79 0.82
query16 0.39 0.40 0.41
query17 1.03 1.05 1.07
query18 0.22 0.22 0.22
query19 1.96 1.89 1.75
query20 0.02 0.01 0.01
query21 15.44 0.27 0.14
query22 4.68 0.05 0.06
query23 15.95 0.30 0.10
query24 1.08 0.38 0.98
query25 0.10 0.09 0.05
query26 0.14 0.12 0.14
query27 0.08 0.05 0.05
query28 5.40 1.22 1.04
query29 12.58 4.20 3.41
query30 0.29 0.16 0.14
query31 2.82 0.62 0.39
query32 3.24 0.55 0.47
query33 3.03 3.03 3.05
query34 17.00 5.16 4.54
query35 4.60 4.49 4.57
query36 0.67 0.51 0.49
query37 0.11 0.06 0.06
query38 0.07 0.04 0.04
query39 0.05 0.03 0.03
query40 0.18 0.14 0.13
query41 0.09 0.04 0.03
query42 0.04 0.02 0.02
query43 0.05 0.03 0.04
Total cold run time: 98.72 s
Total hot run time: 27.53 s
FE Regression Coverage Report
Increment line coverage 81.63% (40/49) :tada:
Increment coverage report
Complete coverage report
TPC-H: Total hot run time: 35887 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 7a987c9c039dd78f6ff227e71ad3f15ced7d1d58, data reload: false
------ Round 1 ----------------------------------
q1 17624 4164 4037 4037
q2 2040 357 245 245
q3 10139 1340 730 730
q4 10213 850 318 318
q5 7512 2162 1891 1891
q6 184 168 135 135
q7 1002 855 699 699
q8 9353 1459 1068 1068
q9 7080 5368 5400 5368
q10 6768 2392 1951 1951
q11 517 323 309 309
q12 643 728 616 616
q13 17786 3714 3049 3049
q14 284 300 271 271
q15 576 506 515 506
q16 692 673 620 620
q17 676 770 538 538
q18 7582 7381 8228 7381
q19 1120 1033 744 744
q20 427 388 244 244
q21 4515 4650 4113 4113
q22 1220 1122 1054 1054
Total cold run time: 107953 ms
Total hot run time: 35887 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4281 4242 4276 4242
q2 326 419 312 312
q3 2332 2857 2425 2425
q4 1410 1915 1400 1400
q5 4526 4580 4588 4580
q6 206 185 128 128
q7 1989 1918 1811 1811
q8 2606 2470 2435 2435
q9 7637 7551 7531 7531
q10 3073 3251 2879 2879
q11 615 528 468 468
q12 632 723 548 548
q13 3298 3604 3009 3009
q14 272 280 262 262
q15 537 496 490 490
q16 657 641 589 589
q17 1092 1292 1324 1292
q18 7314 7213 7034 7034
q19 833 778 795 778
q20 1918 1989 1803 1803
q21 4651 4242 4145 4145
q22 1075 1034 986 986
Total cold run time: 51280 ms
Total hot run time: 49147 ms
TPC-DS: Total hot run time: 178303 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 7a987c9c039dd78f6ff227e71ad3f15ced7d1d58, data reload: false
query5 4903 599 431 431
query6 346 227 211 211
query7 4225 458 266 266
query8 321 256 243 243
query9 8755 2500 2514 2500
query10 538 364 321 321
query11 15405 15060 14651 14651
query12 169 119 112 112
query13 1249 480 381 381
query14 6025 3049 2806 2806
query14_1 2629 2642 2625 2625
query15 212 206 184 184
query16 845 466 435 435
query17 1125 721 601 601
query18 2468 450 350 350
query19 230 229 210 210
query20 118 116 116 116
query21 222 140 118 118
query22 3848 3973 4206 3973
query23 16803 16290 16101 16101
query23_1 16156 16171 16067 16067
query24 7324 1625 1239 1239
query24_1 1249 1226 1191 1191
query25 548 472 402 402
query26 1247 264 157 157
query27 2771 463 320 320
query28 4468 2130 2116 2116
query29 801 553 444 444
query30 313 256 210 210
query31 834 705 630 630
query32 83 71 67 67
query33 533 334 286 286
query34 919 935 606 606
query35 797 828 732 732
query36 878 931 802 802
query37 129 93 79 79
query38 2866 2829 2772 2772
query39 774 753 720 720
query39_1 687 690 705 690
query40 231 136 120 120
query41 65 62 66 62
query42 108 105 105 105
query43 423 423 408 408
query44 1325 744 748 744
query45 199 193 179 179
query46 894 982 609 609
query47 1628 1705 1648 1648
query48 308 329 250 250
query49 635 431 353 353
query50 665 290 245 245
query51 3875 3844 3793 3793
query52 107 105 96 96
query53 317 358 289 289
query54 276 255 237 237
query55 76 74 72 72
query56 295 299 304 299
query57 1179 1157 1087 1087
query58 270 256 240 240
query59 2425 2509 2367 2367
query60 316 307 292 292
query61 164 160 158 158
query62 703 663 636 636
query63 334 290 300 290
query64 4985 1289 1007 1007
query65 4009 3930 3972 3930
query66 1460 444 336 336
query67 15101 14908 15053 14908
query68 3660 1055 755 755
query69 518 352 323 323
query70 1119 1012 966 966
query71 369 312 281 281
query72 6287 5032 4829 4829
query73 643 555 306 306
query74 8892 8828 8493 8493
query75 3214 3183 2811 2811
query76 3844 1133 742 742
query77 506 393 285 285
query78 9505 9773 8932 8932
query79 1916 865 615 615
query80 1563 662 564 564
query81 569 272 234 234
query82 398 133 101 101
query83 364 260 238 238
query84 262 115 102 102
query85 976 510 470 470
query86 380 289 283 283
query87 3038 3056 3017 3017
query88 3254 2296 2290 2290
query89 463 428 395 395
query90 1975 159 154 154
query91 172 165 144 144
query92 72 72 66 66
query93 1151 894 551 551
query94 530 307 275 275
query95 572 326 354 326
query96 607 476 211 211
query97 2310 2306 2218 2218
query98 203 201 196 196
query99 1250 1305 1226 1226
Total cold run time: 256877 ms
Total hot run time: 178303 ms
ClickBench: Total hot run time: 28.06 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 7a987c9c039dd78f6ff227e71ad3f15ced7d1d58, data reload: false
query1 0.05 0.05 0.04
query2 0.10 0.05 0.05
query3 0.26 0.11 0.08
query4 1.60 0.11 0.12
query5 0.28 0.24 0.26
query6 1.18 0.65 0.71
query7 0.04 0.03 0.03
query8 0.06 0.04 0.05
query9 0.61 0.52 0.51
query10 0.56 0.54 0.55
query11 0.15 0.11 0.11
query12 0.14 0.13 0.11
query13 0.62 0.61 0.61
query14 0.97 1.09 0.99
query15 0.81 0.80 0.81
query16 0.39 0.40 0.39
query17 1.05 1.04 1.05
query18 0.23 0.21 0.21
query19 1.94 1.78 1.96
query20 0.02 0.01 0.02
query21 15.46 0.27 0.14
query22 4.81 0.05 0.05
query23 15.84 0.29 0.10
query24 1.18 1.29 0.88
query25 0.09 0.06 0.08
query26 0.13 0.14 0.13
query27 0.05 0.05 0.08
query28 5.72 1.22 1.03
query29 12.56 3.95 3.32
query30 0.27 0.15 0.11
query31 2.82 0.61 0.39
query32 3.25 0.57 0.46
query33 2.96 3.05 3.01
query34 16.81 5.19 4.59
query35 4.53 4.58 4.54
query36 0.66 0.49 0.49
query37 0.11 0.06 0.07
query38 0.07 0.05 0.04
query39 0.04 0.03 0.03
query40 0.17 0.15 0.14
query41 0.09 0.03 0.03
query42 0.04 0.03 0.03
query43 0.05 0.04 0.04
Total cold run time: 98.77 s
Total hot run time: 28.06 s
FE Regression Coverage Report
Increment line coverage 81.63% (40/49) :tada:
Increment coverage report
Complete coverage report
TPC-H: Total hot run time: 36770 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 0b23082d7a7370e755b04b39cdd803d8368ed740, data reload: false
------ Round 1 ----------------------------------
q1 17615 4243 4114 4114
q2 2044 371 244 244
q3 10144 1342 786 786
q4 10280 794 317 317
q5 8774 2176 1966 1966
q6 242 171 139 139
q7 1025 892 726 726
q8 9385 1450 1156 1156
q9 7092 5397 5422 5397
q10 6904 2394 1999 1999
q11 536 327 300 300
q12 699 736 625 625
q13 17779 3767 3100 3100
q14 287 291 278 278
q15 591 527 520 520
q16 684 674 628 628
q17 689 842 570 570
q18 7416 7921 7678 7678
q19 1172 1001 630 630
q20 416 391 289 289
q21 4599 4355 4257 4257
q22 1160 1055 1051 1051
Total cold run time: 109533 ms
Total hot run time: 36770 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4360 4426 4325 4325
q2 344 397 326 326
q3 2526 2778 2517 2517
q4 1474 1896 1410 1410
q5 4569 4482 4478 4478
q6 238 171 125 125
q7 2014 1915 1815 1815
q8 2838 2505 2469 2469
q9 7590 7591 7194 7194
q10 2925 3115 2697 2697
q11 570 506 484 484
q12 669 723 554 554
q13 3364 3715 3075 3075
q14 278 275 256 256
q15 540 506 497 497
q16 614 646 600 600
q17 1126 1327 1347 1327
q18 7248 7016 6927 6927
q19 848 851 855 851
q20 1876 2014 1818 1818
q21 4740 4294 4268 4268
q22 1071 1051 975 975
Total cold run time: 51822 ms
Total hot run time: 48988 ms
TPC-DS: Total hot run time: 179138 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 0b23082d7a7370e755b04b39cdd803d8368ed740, data reload: false
query5 4823 621 468 468
query6 331 261 233 233
query7 4227 479 277 277
query8 302 276 254 254
query9 8765 2563 2566 2563
query10 512 379 335 335
query11 15224 15191 14717 14717
query12 184 121 118 118
query13 1273 535 411 411
query14 6402 3041 2807 2807
query14_1 2701 2662 2666 2662
query15 219 208 177 177
query16 932 484 467 467
query17 1135 738 619 619
query18 2601 441 357 357
query19 231 240 209 209
query20 122 125 111 111
query21 219 141 124 124
query22 3931 3971 3963 3963
query23 16661 16119 15905 15905
query23_1 16128 16074 16021 16021
query24 7331 1696 1239 1239
query24_1 1261 1225 1266 1225
query25 581 510 487 487
query26 1247 268 161 161
query27 2766 446 317 317
query28 4476 2127 2127 2127
query29 812 532 435 435
query30 322 261 213 213
query31 847 704 637 637
query32 80 68 66 66
query33 546 331 278 278
query34 889 899 556 556
query35 772 799 734 734
query36 864 898 805 805
query37 126 91 77 77
query38 2870 2891 2837 2837
query39 753 730 707 707
query39_1 697 706 695 695
query40 224 140 122 122
query41 70 64 61 61
query42 107 107 107 107
query43 441 429 402 402
query44 1342 750 757 750
query45 194 192 186 186
query46 880 981 611 611
query47 1645 1682 1622 1622
query48 317 328 256 256
query49 624 465 351 351
query50 672 287 217 217
query51 3817 3817 3789 3789
query52 107 117 97 97
query53 320 348 292 292
query54 282 256 247 247
query55 77 78 72 72
query56 292 296 309 296
query57 1128 1148 1074 1074
query58 265 255 274 255
query59 2369 2515 2466 2466
query60 319 315 287 287
query61 164 154 152 152
query62 699 651 618 618
query63 332 302 300 300
query64 5017 1309 1004 1004
query65 4009 3950 3958 3950
query66 1430 434 320 320
query67 15224 15097 14957 14957
query68 5230 1018 725 725
query69 501 350 325 325
query70 1057 1001 977 977
query71 366 303 282 282
query72 6054 5089 5408 5089
query73 699 607 315 315
query74 8818 8725 8659 8659
query75 3182 3159 2832 2832
query76 3914 1136 742 742
query77 514 392 300 300
query78 9406 9619 8911 8911
query79 1665 866 620 620
query80 823 664 553 553
query81 528 269 232 232
query82 406 133 107 107
query83 263 255 239 239
query84 259 115 104 104
query85 933 529 473 473
query86 320 309 286 286
query87 3122 3097 3040 3040
query88 3315 2298 2250 2250
query89 476 430 391 391
query90 1986 169 159 159
query91 175 169 147 147
query92 69 77 67 67
query93 1128 936 566 566
query94 538 293 289 289
query95 586 324 361 324
query96 615 487 226 226
query97 2298 2335 2232 2232
query98 217 193 200 193
query99 1272 1274 1226 1226
Total cold run time: 257056 ms
Total hot run time: 179138 ms
ClickBench: Total hot run time: 27.65 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 0b23082d7a7370e755b04b39cdd803d8368ed740, data reload: false
query1 0.05 0.05 0.05
query2 0.10 0.05 0.04
query3 0.25 0.08 0.09
query4 1.61 0.11 0.11
query5 0.27 0.27 0.26
query6 1.15 0.63 0.64
query7 0.03 0.03 0.03
query8 0.06 0.04 0.04
query9 0.57 0.51 0.52
query10 0.56 0.55 0.56
query11 0.16 0.11 0.12
query12 0.14 0.11 0.12
query13 0.64 0.60 0.60
query14 1.00 0.98 0.98
query15 0.82 0.80 0.82
query16 0.40 0.39 0.39
query17 1.06 1.00 1.02
query18 0.24 0.22 0.22
query19 1.88 1.86 1.74
query20 0.02 0.01 0.01
query21 15.45 0.29 0.15
query22 4.80 0.06 0.04
query23 16.07 0.28 0.10
query24 1.31 0.61 0.52
query25 0.09 0.07 0.06
query26 0.14 0.13 0.13
query27 0.06 0.06 0.05
query28 3.66 1.21 1.02
query29 12.56 4.00 3.33
query30 0.28 0.14 0.12
query31 2.82 0.63 0.40
query32 3.23 0.55 0.45
query33 2.99 3.09 3.03
query34 16.72 5.25 4.53
query35 4.62 4.59 4.61
query36 0.64 0.50 0.51
query37 0.11 0.07 0.07
query38 0.07 0.04 0.04
query39 0.04 0.03 0.03
query40 0.18 0.13 0.14
query41 0.08 0.03 0.04
query42 0.05 0.03 0.03
query43 0.04 0.04 0.04
Total cold run time: 97.02 s
Total hot run time: 27.65 s