Debian Codegraph @

mysql-test/suite/max_parts/r/partition_max_parts_key_innodb.result

raw
1 call mtr.add_suppression("A long semaphore wait");
2 call mtr.add_suppression("Could not increase number of max_open_files");
3 create table t2 (a int not null, primary key(a)) engine='InnoDB'
4 partition by key (a) partitions 8192;
5 show create table t2;
6 Table Create Table
7 t2 CREATE TABLE `t2` (
8 `a` int NOT NULL,
9 PRIMARY KEY (`a`)
10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
11 /*!50100 PARTITION BY KEY (a)
12 PARTITIONS 8192 */
13 65535 inserts;
14 select count(*) from t2;
15 count(*)
16 65535
17 select count(*) from t2 partition (p0);
18 count(*)
19 8
20 select count(*) from t2 partition (p10);
21 count(*)
22 0
23 select count(*) from t2 partition (p100);
24 count(*)
25 2
26 select count(*) from t2 partition (p1000);
27 count(*)
28 22
29 select count(*) from t2 partition (p4000);
30 count(*)
31 2
32 select count(*) from t2 partition (p8000);
33 count(*)
34 2
35 select count(*) from t2 partition (p8191);
36 count(*)
37 7
38 select * from t2 partition (p0);
39 a
40 35503
41 37977
42 38009
43 38108
44 38109
45 38140
46 38141
47 39061
48 select * from t2 partition (p10);
49 a
50 select * from t2 partition (p100);
51 a
52 14987
53 15903
54 select * from t2 partition (p1000);
55 a
56 9883
57 13835
58 20549
59 20581
60 20680
61 20681
62 20682
63 20683
64 20712
65 20713
66 20714
67 20715
68 28741
69 28773
70 28872
71 28873
72 28874
73 28875
74 28904
75 28905
76 28906
77 28907
78 select * from t2 partition (p4000);
79 a
80 18959
81 27151
82 select * from t2 partition (p8000);
83 a
84 10373
85 32379
86 select * from t2 partition (p8191);
87 a
88 690
89 1471
90 1503
91 4690
92 4722
93 7230
94 14597
95 delete from t2 partition (p8191);
96 select * from t2 partition (p8191);
97 a
98 insert into t2 partition (p8191) values (690), (1471);
99 select * from t2 partition (p8191);
100 a
101 690
102 1471
103 update t2 partition (p8191) set a=4690 where a= 690;
104 select * from t2 partition (p8191);
105 a
106 1471
107 4690
108 load data infile 'MYSQL_TMP_DIR/data01' into table t2 partition (p8191) fields terminated by ',';
109 select * from t2 partition (p8191);
110 a
111 1471
112 4690
113 7230
114 14597
115 drop table t2;