~clint-fewbar/ubuntu/natty/mysql-5.1/merge-5.1.49-2

« back to all changes in this revision

Viewing changes to mysql-test/r/innodb_bug30919.result

  • Committer: Bazaar Package Importer
  • Author(s): Chuck Short
  • Date: 2010-08-04 13:18:27 UTC
  • mfrom: (1.2.2 upstream) (2.1.5 sid)
  • Revision ID: james.westby@ubuntu.com-20100804131827-4tjg88vr9dd49s3k
Tags: 5.1.49-1ubuntu1
* Merge from debian unstable:
  + debian/control:
     * Update maintainer according to spec.
     * Move section from "misc" to "database".
     * Added libmysqlclient16-dev an empty transitional package. 
     * Added mysql-client-core-5.1 package.
     * Suggest mailx for mysql-server-5.1
     * Add mysql-testsuite package so you can run the testsuite seperately.
  + debian/additions/my.cnf:
    * Remove language options. Error message files are located in a different directory in Mysql
      5.0. Setting the language option to use /usr/share/mysql/english breaks Mysql 5.0. Both 5.0
      and 5.1 use a different value that works. (LP: #316974)
  + Add apparmor profile:
    + debian/apparmor-profile: apparmor-profile
    + debian/rules, debian/mysql-server-5.1.files: install apparmor profile
    + debian/mysql-server-5.1.dirs: add etc/apparmor.d/fore-complain
    + debian/mysql-server-5.1.postrm: remove symlink in force-complain/ on purge.
    + debian/mysql-server-5.1.README.Debian: add apparmor documentation.
    + debian/additions/my.cnf: Add warning about apparmor. (LP: #201799)
    + debian/mysql-server-5.1.postinst: reload apparmor profiles
  * Convert the package from sysvinit to upstart:
    + debian/mysql-server-5.1.mysql.upstart: Add upstart script.
    + debian/mysql-server-5.1.mysql.init: Dropped, unused now with upstart.
    + debian/additions/mysqld_safe_syslog.cnf: Dropped, unused now with upstart.
    + debian/additons/my.cnf: Remove pid declaration and setup error logging to /var/log/mysql since
      we're not piping anything around logger anymore.
    + debian/rules, debian/mysql-server-5.1.logcheck.ignore.{paranoid,worstation},
      debian/mysql-server-5.1.logcheck.ignore.server: : Remove references to mysqld_safe
    + debian/patches/38_scripts_mysqld_safe.sh_signals.dpatch: Dropped
  * Added -fno-strict-aliasing to CFLAGS to get around mysql testsuite build failures.
  * Add Apport hook (LP: #354188):
    + debian/mysql-server-5.1.py: apport package hook
    + debian/rules: Make it installable
  * debian/mysql-server-5.1.mysql-server.logrotate: Check to see if mysql is running before
    running logrotate. (LP: #513135)
  * Make the testsuite installable. (LP: #530752)
    + debian/mysql-server-5.1.files, debian/rules: install apport package hook
  * debian/mysql-server-5.1.preinst: Set mysql user's home directory
    to /nonexistent to protect against having the /var/lib/mysql
    user-writeable. If an attacker can trick mysqld into creating
    dot files in the home directory, he could do .rhost-like attacks
    on the system. (LP: #293258)
  * debian/control: mysql-client-5.1 should depend on mysql-core-client-5.1.
    (LP: #590952) 

Show diffs side-by-side

added added

removed removed

Lines of Context:
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;