Debian Codegraph @

mysql-test/suite/innodb/r/innodb_bug30919.result

raw
1 use test;
2 CREATE TABLE test.part_tbl(id MEDIUMINT NOT NULL AUTO_INCREMENT,
3 dt TIMESTAMP, user CHAR(255), uuidf LONGBLOB,
4 fkid MEDIUMINT, filler VARCHAR(255),
5 PRIMARY KEY(id)) ENGINE='innodb'
6 PARTITION BY RANGE(id)
7 SUBPARTITION BY hash(id) subpartitions 2
8 (PARTITION pa3 values less than (42),
9 PARTITION pa6 values less than (60),
10 PARTITION pa7 values less than (70),
11 PARTITION pa8 values less than (80),
12 PARTITION pa9 values less than (90),
13 PARTITION pa10 values less than (100),
14 PARTITION pa11 values less than MAXVALUE);
15 CREATE PROCEDURE test.proc_part()
16 BEGIN
17 DECLARE ins_count INT DEFAULT 1000;
18 DECLARE del_count INT;
19 DECLARE cur_user VARCHAR(255);
20 DECLARE local_uuid VARCHAR(255);
21 DECLARE local_time TIMESTAMP;
22 SET local_time= NOW();
23 SET cur_user= CURRENT_USER();
24 SET local_uuid= UUID();
25 WHILE ins_count > 0 DO
26 INSERT INTO test.part_tbl VALUES (NULL, NOW(), USER() , UUID(),
27 ins_count,'Going to test MBR for MySQL');
28 SET ins_count = ins_count - 1;
29 END WHILE;
30 SELECT MAX(id) FROM test.part_tbl INTO del_count;
31 WHILE del_count > 0 DO
32 DELETE FROM test.part_tbl WHERE id = del_count;
33 select count(*) as internal_count, del_count -- these two lines are for
34 FROM test.part_tbl; -- debug to show the problem
35 SET del_count = del_count - 2;
36 END WHILE;
37 END|
38 CALL test.proc_part();
39 internal_count del_count
40 999 1000
41 internal_count del_count
42 998 998
43 internal_count del_count
44 997 996
45 internal_count del_count
46 996 994
47 internal_count del_count
48 995 992
49 internal_count del_count
50 994 990
51 internal_count del_count
52 993 988
53 internal_count del_count
54 992 986
55 internal_count del_count
56 991 984
57 internal_count del_count
58 990 982
59 internal_count del_count
60 989 980
61 internal_count del_count
62 988 978
63 internal_count del_count
64 987 976
65 internal_count del_count
66 986 974
67 internal_count del_count
68 985 972
69 internal_count del_count
70 984 970
71 internal_count del_count
72 983 968
73 internal_count del_count
74 982 966
75 internal_count del_count
76 981 964
77 internal_count del_count
78 980 962
79 internal_count del_count
80 979 960
81 internal_count del_count
82 978 958
83 internal_count del_count
84 977 956
85 internal_count del_count
86 976 954
87 internal_count del_count
88 975 952
89 internal_count del_count
90 974 950
91 internal_count del_count
92 973 948
93 internal_count del_count
94 972 946
95 internal_count del_count
96 971 944
97 internal_count del_count
98 970 942
99 internal_count del_count
100 969 940
101 internal_count del_count
102 968 938
103 internal_count del_count
104 967 936
105 internal_count del_count
106 966 934
107 internal_count del_count
108 965 932
109 internal_count del_count
110 964 930
111 internal_count del_count
112 963 928
113 internal_count del_count
114 962 926
115 internal_count del_count
116 961 924
117 internal_count del_count
118 960 922
119 internal_count del_count
120 959 920
121 internal_count del_count
122 958 918
123 internal_count del_count
124 957 916
125 internal_count del_count
126 956 914
127 internal_count del_count
128 955 912
129 internal_count del_count
130 954 910
131 internal_count del_count
132 953 908
133 internal_count del_count
134 952 906
135 internal_count del_count
136 951 904
137 internal_count del_count
138 950 902
139 internal_count del_count
140 949 900
141 internal_count del_count
142 948 898
143 internal_count del_count
144 947 896
145 internal_count del_count
146 946 894
147 internal_count del_count
148 945 892
149 internal_count del_count
150 944 890
151 internal_count del_count
152 943 888
153 internal_count del_count
154 942 886
155 internal_count del_count
156 941 884
157 internal_count del_count
158 940 882
159 internal_count del_count
160 939 880
161 internal_count del_count
162 938 878
163 internal_count del_count
164 937 876
165 internal_count del_count
166 936 874
167 internal_count del_count
168 935 872
169 internal_count del_count
170 934 870
171 internal_count del_count
172 933 868
173 internal_count del_count
174 932 866
175 internal_count del_count
176 931 864
177 internal_count del_count
178 930 862
179 internal_count del_count
180 929 860
181 internal_count del_count
182 928 858
183 internal_count del_count
184 927 856
185 internal_count del_count
186 926 854
187 internal_count del_count
188 925 852
189 internal_count del_count
190 924 850
191 internal_count del_count
192 923 848
193 internal_count del_count
194 922 846
195 internal_count del_count
196 921 844
197 internal_count del_count
198 920 842
199 internal_count del_count
200 919 840
201 internal_count del_count
202 918 838
203 internal_count del_count
204 917 836
205 internal_count del_count
206 916 834
207 internal_count del_count
208 915 832
209 internal_count del_count
210 914 830
211 internal_count del_count
212 913 828
213 internal_count del_count
214 912 826
215 internal_count del_count
216 911 824
217 internal_count del_count
218 910 822
219 internal_count del_count
220 909 820
221 internal_count del_count
222 908 818
223 internal_count del_count
224 907 816
225 internal_count del_count
226 906 814
227 internal_count del_count
228 905 812
229 internal_count del_count
230 904 810
231 internal_count del_count
232 903 808
233 internal_count del_count
234 902 806
235 internal_count del_count
236 901 804
237 internal_count del_count
238 900 802
239 internal_count del_count
240 899 800
241 internal_count del_count
242 898 798
243 internal_count del_count
244 897 796
245 internal_count del_count
246 896 794
247 internal_count del_count
248 895 792
249 internal_count del_count
250 894 790
251 internal_count del_count
252 893 788
253 internal_count del_count
254 892 786
255 internal_count del_count
256 891 784
257 internal_count del_count
258 890 782
259 internal_count del_count
260 889 780
261 internal_count del_count
262 888 778
263 internal_count del_count
264 887 776
265 internal_count del_count
266 886 774
267 internal_count del_count
268 885 772
269 internal_count del_count
270 884 770
271 internal_count del_count
272 883 768
273 internal_count del_count
274 882 766
275 internal_count del_count
276 881 764
277 internal_count del_count
278 880 762
279 internal_count del_count
280 879 760
281 internal_count del_count
282 878 758
283 internal_count del_count
284 877 756
285 internal_count del_count
286 876 754
287 internal_count del_count
288 875 752
289 internal_count del_count
290 874 750
291 internal_count del_count
292 873 748
293 internal_count del_count
294 872 746
295 internal_count del_count
296 871 744
297 internal_count del_count
298 870 742
299 internal_count del_count
300 869 740
301 internal_count del_count
302 868 738
303 internal_count del_count
304 867 736
305 internal_count del_count
306 866 734
307 internal_count del_count
308 865 732
309 internal_count del_count
310 864 730
311 internal_count del_count
312 863 728
313 internal_count del_count
314 862 726
315 internal_count del_count
316 861 724
317 internal_count del_count
318 860 722
319 internal_count del_count
320 859 720
321 internal_count del_count
322 858 718
323 internal_count del_count
324 857 716
325 internal_count del_count
326 856 714
327 internal_count del_count
328 855 712
329 internal_count del_count
330 854 710
331 internal_count del_count
332 853 708
333 internal_count del_count
334 852 706
335 internal_count del_count
336 851 704
337 internal_count del_count
338 850 702
339 internal_count del_count
340 849 700
341 internal_count del_count
342 848 698
343 internal_count del_count
344 847 696
345 internal_count del_count
346 846 694
347 internal_count del_count
348 845 692
349 internal_count del_count
350 844 690
351 internal_count del_count
352 843 688
353 internal_count del_count
354 842 686
355 internal_count del_count
356 841 684
357 internal_count del_count
358 840 682
359 internal_count del_count
360 839 680
361 internal_count del_count
362 838 678
363 internal_count del_count
364 837 676
365 internal_count del_count
366 836 674
367 internal_count del_count
368 835 672
369 internal_count del_count
370 834 670
371 internal_count del_count
372 833 668
373 internal_count del_count
374 832 666
375 internal_count del_count
376 831 664
377 internal_count del_count
378 830 662
379 internal_count del_count
380 829 660
381 internal_count del_count
382 828 658
383 internal_count del_count
384 827 656
385 internal_count del_count
386 826 654
387 internal_count del_count
388 825 652
389 internal_count del_count
390 824 650
391 internal_count del_count
392 823 648
393 internal_count del_count
394 822 646
395 internal_count del_count
396 821 644
397 internal_count del_count
398 820 642
399 internal_count del_count
400 819 640
401 internal_count del_count
402 818 638
403 internal_count del_count
404 817 636
405 internal_count del_count
406 816 634
407 internal_count del_count
408 815 632
409 internal_count del_count
410 814 630
411 internal_count del_count
412 813 628
413 internal_count del_count
414 812 626
415 internal_count del_count
416 811 624
417 internal_count del_count
418 810 622
419 internal_count del_count
420 809 620
421 internal_count del_count
422 808 618
423 internal_count del_count
424 807 616
425 internal_count del_count
426 806 614
427 internal_count del_count
428 805 612
429 internal_count del_count
430 804 610
431 internal_count del_count
432 803 608
433 internal_count del_count
434 802 606
435 internal_count del_count
436 801 604
437 internal_count del_count
438 800 602
439 internal_count del_count
440 799 600
441 internal_count del_count
442 798 598
443 internal_count del_count
444 797 596
445 internal_count del_count
446 796 594
447 internal_count del_count
448 795 592
449 internal_count del_count
450 794 590
451 internal_count del_count
452 793 588
453 internal_count del_count
454 792 586
455 internal_count del_count
456 791 584
457 internal_count del_count
458 790 582
459 internal_count del_count
460 789 580
461 internal_count del_count
462 788 578
463 internal_count del_count
464 787 576
465 internal_count del_count
466 786 574
467 internal_count del_count
468 785 572
469 internal_count del_count
470 784 570
471 internal_count del_count
472 783 568
473 internal_count del_count
474 782 566
475 internal_count del_count
476 781 564
477 internal_count del_count
478 780 562
479 internal_count del_count
480 779 560
481 internal_count del_count
482 778 558
483 internal_count del_count
484 777 556
485 internal_count del_count
486 776 554
487 internal_count del_count
488 775 552
489 internal_count del_count
490 774 550
491 internal_count del_count
492 773 548
493 internal_count del_count
494 772 546
495 internal_count del_count
496 771 544
497 internal_count del_count
498 770 542
499 internal_count del_count
500 769 540
501 internal_count del_count
502 768 538
503 internal_count del_count
504 767 536
505 internal_count del_count
506 766 534
507 internal_count del_count
508 765 532
509 internal_count del_count
510 764 530
511 internal_count del_count
512 763 528
513 internal_count del_count
514 762 526
515 internal_count del_count
516 761 524
517 internal_count del_count
518 760 522
519 internal_count del_count
520 759 520
521 internal_count del_count
522 758 518
523 internal_count del_count
524 757 516
525 internal_count del_count
526 756 514
527 internal_count del_count
528 755 512
529 internal_count del_count
530 754 510
531 internal_count del_count
532 753 508
533 internal_count del_count
534 752 506
535 internal_count del_count
536 751 504
537 internal_count del_count
538 750 502
539 internal_count del_count
540 749 500
541 internal_count del_count
542 748 498
543 internal_count del_count
544 747 496
545 internal_count del_count
546 746 494
547 internal_count del_count
548 745 492
549 internal_count del_count
550 744 490
551 internal_count del_count
552 743 488
553 internal_count del_count
554 742 486
555 internal_count del_count
556 741 484
557 internal_count del_count
558 740 482
559 internal_count del_count
560 739 480
561 internal_count del_count
562 738 478
563 internal_count del_count
564 737 476
565 internal_count del_count
566 736 474
567 internal_count del_count
568 735 472
569 internal_count del_count
570 734 470
571 internal_count del_count
572 733 468
573 internal_count del_count
574 732 466
575 internal_count del_count
576 731 464
577 internal_count del_count
578 730 462
579 internal_count del_count
580 729 460
581 internal_count del_count
582 728 458
583 internal_count del_count
584 727 456
585 internal_count del_count
586 726 454
587 internal_count del_count
588 725 452
589 internal_count del_count
590 724 450
591 internal_count del_count
592 723 448
593 internal_count del_count
594 722 446
595 internal_count del_count
596 721 444
597 internal_count del_count
598 720 442
599 internal_count del_count
600 719 440
601 internal_count del_count
602 718 438
603 internal_count del_count
604 717 436
605 internal_count del_count
606 716 434
607 internal_count del_count
608 715 432
609 internal_count del_count
610 714 430
611 internal_count del_count
612 713 428
613 internal_count del_count
614 712 426
615 internal_count del_count
616 711 424
617 internal_count del_count
618 710 422
619 internal_count del_count
620 709 420
621 internal_count del_count
622 708 418
623 internal_count del_count
624 707 416
625 internal_count del_count
626 706 414
627 internal_count del_count
628 705 412
629 internal_count del_count
630 704 410
631 internal_count del_count
632 703 408
633 internal_count del_count
634 702 406
635 internal_count del_count
636 701 404
637 internal_count del_count
638 700 402
639 internal_count del_count
640 699 400
641 internal_count del_count
642 698 398
643 internal_count del_count
644 697 396
645 internal_count del_count
646 696 394
647 internal_count del_count
648 695 392
649 internal_count del_count
650 694 390
651 internal_count del_count
652 693 388
653 internal_count del_count
654 692 386
655 internal_count del_count
656 691 384
657 internal_count del_count
658 690 382
659 internal_count del_count
660 689 380
661 internal_count del_count
662 688 378
663 internal_count del_count
664 687 376
665 internal_count del_count
666 686 374
667 internal_count del_count
668 685 372
669 internal_count del_count
670 684 370
671 internal_count del_count
672 683 368
673 internal_count del_count
674 682 366
675 internal_count del_count
676 681 364
677 internal_count del_count
678 680 362
679 internal_count del_count
680 679 360
681 internal_count del_count
682 678 358
683 internal_count del_count
684 677 356
685 internal_count del_count
686 676 354
687 internal_count del_count
688 675 352
689 internal_count del_count
690 674 350
691 internal_count del_count
692 673 348
693 internal_count del_count
694 672 346
695 internal_count del_count
696 671 344
697 internal_count del_count
698 670 342
699 internal_count del_count
700 669 340
701 internal_count del_count
702 668 338
703 internal_count del_count
704 667 336
705 internal_count del_count
706 666 334
707 internal_count del_count
708 665 332
709 internal_count del_count
710 664 330
711 internal_count del_count
712 663 328
713 internal_count del_count
714 662 326
715 internal_count del_count
716 661 324
717 internal_count del_count
718 660 322
719 internal_count del_count
720 659 320
721 internal_count del_count
722 658 318
723 internal_count del_count
724 657 316
725 internal_count del_count
726 656 314
727 internal_count del_count
728 655 312
729 internal_count del_count
730 654 310
731 internal_count del_count
732 653 308
733 internal_count del_count
734 652 306
735 internal_count del_count
736 651 304
737 internal_count del_count
738 650 302
739 internal_count del_count
740 649 300
741 internal_count del_count
742 648 298
743 internal_count del_count
744 647 296
745 internal_count del_count
746 646 294
747 internal_count del_count
748 645 292
749 internal_count del_count
750 644 290
751 internal_count del_count
752 643 288
753 internal_count del_count
754 642 286
755 internal_count del_count
756 641 284
757 internal_count del_count
758 640 282
759 internal_count del_count
760 639 280
761 internal_count del_count
762 638 278
763 internal_count del_count
764 637 276
765 internal_count del_count
766 636 274
767 internal_count del_count
768 635 272
769 internal_count del_count
770 634 270
771 internal_count del_count
772 633 268
773 internal_count del_count
774 632 266
775 internal_count del_count
776 631 264
777 internal_count del_count
778 630 262
779 internal_count del_count
780 629 260
781 internal_count del_count
782 628 258
783 internal_count del_count
784 627 256
785 internal_count del_count
786 626 254
787 internal_count del_count
788 625 252
789 internal_count del_count
790 624 250
791 internal_count del_count
792 623 248
793 internal_count del_count
794 622 246
795 internal_count del_count
796 621 244
797 internal_count del_count
798 620 242
799 internal_count del_count
800 619 240
801 internal_count del_count
802 618 238
803 internal_count del_count
804 617 236
805 internal_count del_count
806 616 234
807 internal_count del_count
808 615 232
809 internal_count del_count
810 614 230
811 internal_count del_count
812 613 228
813 internal_count del_count
814 612 226
815 internal_count del_count
816 611 224
817 internal_count del_count
818 610 222
819 internal_count del_count
820 609 220
821 internal_count del_count
822 608 218
823 internal_count del_count
824 607 216
825 internal_count del_count
826 606 214
827 internal_count del_count
828 605 212
829 internal_count del_count
830 604 210
831 internal_count del_count
832 603 208
833 internal_count del_count
834 602 206
835 internal_count del_count
836 601 204
837 internal_count del_count
838 600 202
839 internal_count del_count
840 599 200
841 internal_count del_count
842 598 198
843 internal_count del_count
844 597 196
845 internal_count del_count
846 596 194
847 internal_count del_count
848 595 192
849 internal_count del_count
850 594 190
851 internal_count del_count
852 593 188
853 internal_count del_count
854 592 186
855 internal_count del_count
856 591 184
857 internal_count del_count
858 590 182
859 internal_count del_count
860 589 180
861 internal_count del_count
862 588 178
863 internal_count del_count
864 587 176
865 internal_count del_count
866 586 174
867 internal_count del_count
868 585 172
869 internal_count del_count
870 584 170
871 internal_count del_count
872 583 168
873 internal_count del_count
874 582 166
875 internal_count del_count
876 581 164
877 internal_count del_count
878 580 162
879 internal_count del_count
880 579 160
881 internal_count del_count
882 578 158
883 internal_count del_count
884 577 156
885 internal_count del_count
886 576 154
887 internal_count del_count
888 575 152
889 internal_count del_count
890 574 150
891 internal_count del_count
892 573 148
893 internal_count del_count
894 572 146
895 internal_count del_count
896 571 144
897 internal_count del_count
898 570 142
899 internal_count del_count
900 569 140
901 internal_count del_count
902 568 138
903 internal_count del_count
904 567 136
905 internal_count del_count
906 566 134
907 internal_count del_count
908 565 132
909 internal_count del_count
910 564 130
911 internal_count del_count
912 563 128
913 internal_count del_count
914 562 126
915 internal_count del_count
916 561 124
917 internal_count del_count
918 560 122
919 internal_count del_count
920 559 120
921 internal_count del_count
922 558 118
923 internal_count del_count
924 557 116
925 internal_count del_count
926 556 114
927 internal_count del_count
928 555 112
929 internal_count del_count
930 554 110
931 internal_count del_count
932 553 108
933 internal_count del_count
934 552 106
935 internal_count del_count
936 551 104
937 internal_count del_count
938 550 102
939 internal_count del_count
940 549 100
941 internal_count del_count
942 548 98
943 internal_count del_count
944 547 96
945 internal_count del_count
946 546 94
947 internal_count del_count
948 545 92
949 internal_count del_count
950 544 90
951 internal_count del_count
952 543 88
953 internal_count del_count
954 542 86
955 internal_count del_count
956 541 84
957 internal_count del_count
958 540 82
959 internal_count del_count
960 539 80
961 internal_count del_count
962 538 78
963 internal_count del_count
964 537 76
965 internal_count del_count
966 536 74
967 internal_count del_count
968 535 72
969 internal_count del_count
970 534 70
971 internal_count del_count
972 533 68
973 internal_count del_count
974 532 66
975 internal_count del_count
976 531 64
977 internal_count del_count
978 530 62
979 internal_count del_count
980 529 60
981 internal_count del_count
982 528 58
983 internal_count del_count
984 527 56
985 internal_count del_count
986 526 54
987 internal_count del_count
988 525 52
989 internal_count del_count
990 524 50
991 internal_count del_count
992 523 48
993 internal_count del_count
994 522 46
995 internal_count del_count
996 521 44
997 internal_count del_count
998 520 42
999 internal_count del_count
1000 519 40
1001 internal_count del_count
1002 518 38
1003 internal_count del_count
1004 517 36
1005 internal_count del_count
1006 516 34
1007 internal_count del_count
1008 515 32
1009 internal_count del_count
1010 514 30
1011 internal_count del_count
1012 513 28
1013 internal_count del_count
1014 512 26
1015 internal_count del_count
1016 511 24
1017 internal_count del_count
1018 510 22
1019 internal_count del_count
1020 509 20
1021 internal_count del_count
1022 508 18
1023 internal_count del_count
1024 507 16
1025 internal_count del_count
1026 506 14
1027 internal_count del_count
1028 505 12
1029 internal_count del_count
1030 504 10
1031 internal_count del_count
1032 503 8
1033 internal_count del_count
1034 502 6
1035 internal_count del_count
1036 501 4
1037 internal_count del_count
1038 500 2
1039 select count(*) as Part from test.part_tbl;
1040 Part
1041 500
1042 DROP PROCEDURE test.proc_part;
1043 DROP TABLE test.part_tbl;