Debian Codegraph @

mysql-test/suite/max_parts/r/partition_max_parts_hash_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 hash (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 HASH (`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 7
20 select count(*) from t2 partition (p10);
21 count(*)
22 8
23 select count(*) from t2 partition (p100);
24 count(*)
25 8
26 select count(*) from t2 partition (p1000);
27 count(*)
28 8
29 select count(*) from t2 partition (p4000);
30 count(*)
31 8
32 select count(*) from t2 partition (p8000);
33 count(*)
34 8
35 select count(*) from t2 partition (p8191);
36 count(*)
37 8
38 select * from t2 partition (p0);
39 a
40 8192
41 16384
42 24576
43 32768
44 40960
45 49152
46 57344
47 select * from t2 partition (p10);
48 a
49 10
50 8202
51 16394
52 24586
53 32778
54 40970
55 49162
56 57354
57 select * from t2 partition (p100);
58 a
59 100
60 8292
61 16484
62 24676
63 32868
64 41060
65 49252
66 57444
67 select * from t2 partition (p1000);
68 a
69 1000
70 9192
71 17384
72 25576
73 33768
74 41960
75 50152
76 58344
77 select * from t2 partition (p4000);
78 a
79 4000
80 12192
81 20384
82 28576
83 36768
84 44960
85 53152
86 61344
87 select * from t2 partition (p8000);
88 a
89 8000
90 16192
91 24384
92 32576
93 40768
94 48960
95 57152
96 65344
97 select * from t2 partition (p8191);
98 a
99 8191
100 16383
101 24575
102 32767
103 40959
104 49151
105 57343
106 65535
107 delete from t2 partition (p8191);
108 select * from t2 partition (p8191);
109 a
110 insert into t2 partition (p8191) values (8191), (65535);
111 select * from t2 partition (p8191);
112 a
113 8191
114 65535
115 update t2 partition (p8191) set a=16383 where a= 8191;
116 select * from t2 partition (p8191);
117 a
118 16383
119 65535
120 load data infile 'MYSQL_TMP_DIR/data01' into table t2 partition (p8191) fields terminated by ',';
121 select * from t2 partition (p8191);
122 a
123 8191
124 16383
125 57343
126 65535
127 drop table t2;