← Back to branch summary

~linuxjedi/drizzle/trunk-bug-667053

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/r/rpl_innodb_bug30919.result

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl/r/rpl_innodb_bug30919.result
 
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;