1
create table t1 (a tinyint unsigned not null, primary key(a)) engine='InnoDB'
1
create table t1 (a tinyint unsigned not null, primary key(a)) engine='NDB'
2
2
partition by key (a) (
3
partition pa1 DATA DIRECTORY =
4
'/tmp' INDEX DIRECTORY =
5
'/tmp' max_rows=20 min_rows=2,
6
partition pa2 DATA DIRECTORY =
7
'/tmp' INDEX DIRECTORY =
8
'/tmp' max_rows=30 min_rows=3,
9
partition pa3 DATA DIRECTORY =
10
'/tmp' INDEX DIRECTORY =
11
'/tmp' max_rows=30 min_rows=4,
12
partition pa4 DATA DIRECTORY =
13
'/tmp' INDEX DIRECTORY =
14
'/tmp' max_rows=40 min_rows=2);
3
partition pa1 max_rows=20 min_rows=2,
4
partition pa2 max_rows=30 min_rows=3,
5
partition pa3 max_rows=30 min_rows=4,
6
partition pa4 max_rows=40 min_rows=2);
15
7
show create table t1;
17
9
t1 CREATE TABLE `t1` (
18
10
`a` tinyint(3) unsigned NOT NULL,
20
) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) (PARTITION pa1 MAX_ROWS = 20 MIN_ROWS = 2 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = InnoDB, PARTITION pa2 MAX_ROWS = 30 MIN_ROWS = 3 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = InnoDB, PARTITION pa3 MAX_ROWS = 30 MIN_ROWS = 4 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = InnoDB, PARTITION pa4 MAX_ROWS = 40 MIN_ROWS = 2 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = InnoDB) */
12
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) (PARTITION pa1 MAX_ROWS = 20 MIN_ROWS = 2 ENGINE = ndbcluster, PARTITION pa2 MAX_ROWS = 30 MIN_ROWS = 3 ENGINE = ndbcluster, PARTITION pa3 MAX_ROWS = 30 MIN_ROWS = 4 ENGINE = ndbcluster, PARTITION pa4 MAX_ROWS = 40 MIN_ROWS = 2 ENGINE = ndbcluster) */
21
13
insert into t1 values (255), (254), (253), (252), (1), (2), (128);
44
create table t2 (a tinyint unsigned not null, primary key(a)) engine='InnoDB'
36
create table t2 (a tinyint unsigned not null, primary key(a)) engine='NDB'
45
37
partition by key (a) partitions 8;
46
38
show create table t2;
48
40
t2 CREATE TABLE `t2` (
49
41
`a` tinyint(3) unsigned NOT NULL,
51
) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) PARTITIONS 8 */
43
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) PARTITIONS 8 */
52
44
insert into t2 values (255), (254), (253), (252);
74
create table t3 (a tinyint not null, primary key(a)) engine='InnoDB'
75
partition by key (a) partitions 10;
66
create table t3 (a tinyint not null, primary key(a)) engine='NDB'
67
partition by key (a) partitions 7;
76
68
show create table t3;
78
70
t3 CREATE TABLE `t3` (
79
71
`a` tinyint(4) NOT NULL,
81
) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) PARTITIONS 10 */
73
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) PARTITIONS 7 */
82
74
insert into t3 values (127), (126), (125), (124), (-128), (-127), (1), (-1), (0);
97
89
delete from t3 where a=125;
109
create table t1 (a smallint unsigned not null, primary key(a)) engine='InnoDB'
101
create table t1 (a smallint unsigned not null, primary key(a)) engine='NDB'
110
102
partition by key (a) (
111
partition pa1 DATA DIRECTORY =
112
'/tmp' INDEX DIRECTORY =
113
'/tmp' max_rows=20 min_rows=2,
114
partition pa2 DATA DIRECTORY =
115
'/tmp' INDEX DIRECTORY =
116
'/tmp' max_rows=30 min_rows=3,
117
partition pa3 DATA DIRECTORY =
118
'/tmp' INDEX DIRECTORY =
119
'/tmp' max_rows=30 min_rows=4,
120
partition pa4 DATA DIRECTORY =
121
'/tmp' INDEX DIRECTORY =
122
'/tmp' max_rows=40 min_rows=2);
103
partition pa1 max_rows=20 min_rows=2,
104
partition pa2 max_rows=30 min_rows=3,
105
partition pa3 max_rows=30 min_rows=4,
106
partition pa4 max_rows=40 min_rows=2);
123
107
show create table t1;
124
108
Table Create Table
125
109
t1 CREATE TABLE `t1` (
126
110
`a` smallint(5) unsigned NOT NULL,
127
111
PRIMARY KEY (`a`)
128
) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) (PARTITION pa1 MAX_ROWS = 20 MIN_ROWS = 2 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = InnoDB, PARTITION pa2 MAX_ROWS = 30 MIN_ROWS = 3 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = InnoDB, PARTITION pa3 MAX_ROWS = 30 MIN_ROWS = 4 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = InnoDB, PARTITION pa4 MAX_ROWS = 40 MIN_ROWS = 2 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = InnoDB) */
112
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) (PARTITION pa1 MAX_ROWS = 20 MIN_ROWS = 2 ENGINE = ndbcluster, PARTITION pa2 MAX_ROWS = 30 MIN_ROWS = 3 ENGINE = ndbcluster, PARTITION pa3 MAX_ROWS = 30 MIN_ROWS = 4 ENGINE = ndbcluster, PARTITION pa4 MAX_ROWS = 40 MIN_ROWS = 2 ENGINE = ndbcluster) */
129
113
insert into t1 values (65535), (65534), (65533), (65532), (1), (2), (256);
130
114
select * from t1;
152
create table t2 (a smallint unsigned not null, primary key(a)) engine='InnoDB'
136
create table t2 (a smallint unsigned not null, primary key(a)) engine='NDB'
153
137
partition by key (a) partitions 8;
154
138
show create table t2;
155
139
Table Create Table
156
140
t2 CREATE TABLE `t2` (
157
141
`a` smallint(5) unsigned NOT NULL,
158
142
PRIMARY KEY (`a`)
159
) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) PARTITIONS 8 */
143
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) PARTITIONS 8 */
160
144
insert into t2 values (65535), (65534), (65533), (65532);
161
145
select * from t2;
182
create table t3 (a smallint not null, primary key(a)) engine='InnoDB'
183
partition by key (a) partitions 10;
166
create table t3 (a smallint not null, primary key(a)) engine='NDB'
167
partition by key (a) partitions 7;
184
168
show create table t3;
185
169
Table Create Table
186
170
t3 CREATE TABLE `t3` (
187
171
`a` smallint(6) NOT NULL,
188
172
PRIMARY KEY (`a`)
189
) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) PARTITIONS 10 */
173
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) PARTITIONS 7 */
190
174
insert into t3 values (32767), (32766), (32765), (32764), (-32768), (-32767), (1), (-1), (0);
191
175
select * from t3;
205
189
delete from t3 where a=32765;
206
190
select * from t3;
217
create table t1 (a int unsigned not null, primary key(a)) engine='InnoDB'
201
create table t1 (a int unsigned not null, primary key(a)) engine='NDB'
218
202
partition by key (a) (
219
partition pa1 DATA DIRECTORY =
220
'/tmp' INDEX DIRECTORY =
221
'/tmp' max_rows=20 min_rows=2,
222
partition pa2 DATA DIRECTORY =
223
'/tmp' INDEX DIRECTORY =
224
'/tmp' max_rows=30 min_rows=3,
225
partition pa3 DATA DIRECTORY =
226
'/tmp' INDEX DIRECTORY =
227
'/tmp' max_rows=30 min_rows=4,
228
partition pa4 DATA DIRECTORY =
229
'/tmp' INDEX DIRECTORY =
230
'/tmp' max_rows=40 min_rows=2);
203
partition pa1 max_rows=20 min_rows=2,
204
partition pa2 max_rows=30 min_rows=3,
205
partition pa3 max_rows=30 min_rows=4,
206
partition pa4 max_rows=40 min_rows=2);
231
207
show create table t1;
232
208
Table Create Table
233
209
t1 CREATE TABLE `t1` (
234
210
`a` int(10) unsigned NOT NULL,
235
211
PRIMARY KEY (`a`)
236
) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) (PARTITION pa1 MAX_ROWS = 20 MIN_ROWS = 2 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = InnoDB, PARTITION pa2 MAX_ROWS = 30 MIN_ROWS = 3 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = InnoDB, PARTITION pa3 MAX_ROWS = 30 MIN_ROWS = 4 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = InnoDB, PARTITION pa4 MAX_ROWS = 40 MIN_ROWS = 2 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = InnoDB) */
212
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) (PARTITION pa1 MAX_ROWS = 20 MIN_ROWS = 2 ENGINE = ndbcluster, PARTITION pa2 MAX_ROWS = 30 MIN_ROWS = 3 ENGINE = ndbcluster, PARTITION pa3 MAX_ROWS = 30 MIN_ROWS = 4 ENGINE = ndbcluster, PARTITION pa4 MAX_ROWS = 40 MIN_ROWS = 2 ENGINE = ndbcluster) */
237
213
insert into t1 values (4294967295), (4294967294), (4294967293), (4294967292), (1), (2), (65535);
238
214
select * from t1;
247
223
select * from t1 where a=4294967293;
260
create table t2 (a int unsigned not null, primary key(a)) engine='InnoDB'
261
partition by key (a) partitions 10;
236
create table t2 (a int unsigned not null, primary key(a)) engine='NDB'
237
partition by key (a) partitions 8;
262
238
show create table t2;
263
239
Table Create Table
264
240
t2 CREATE TABLE `t2` (
265
241
`a` int(10) unsigned NOT NULL,
266
242
PRIMARY KEY (`a`)
267
) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) PARTITIONS 10 */
243
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) PARTITIONS 8 */
268
244
insert into t2 values (4294967295), (4294967294), (4294967293), (4294967292);
269
245
select * from t2;
290
create table t3 (a int not null, primary key(a)) engine='InnoDB'
291
partition by key (a) partitions 10;
266
create table t3 (a int not null, primary key(a)) engine='NDB'
267
partition by key (a) partitions 7;
292
268
show create table t3;
293
269
Table Create Table
294
270
t3 CREATE TABLE `t3` (
295
271
`a` int(11) NOT NULL,
296
272
PRIMARY KEY (`a`)
297
) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) PARTITIONS 10 */
273
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) PARTITIONS 7 */
298
274
insert into t3 values (2147483647), (2147483646), (2147483645), (2147483644), (-2147483648), (-2147483647), (1), (-1), (0);
299
275
select * from t3;
313
289
delete from t3 where a=2147483645;
314
290
select * from t3;
325
create table t1 (a mediumint unsigned not null, primary key(a)) engine='InnoDB'
301
create table t1 (a mediumint unsigned not null, primary key(a)) engine='NDB'
326
302
partition by key (a) (
327
partition pa1 DATA DIRECTORY =
328
'/tmp' INDEX DIRECTORY =
329
'/tmp' max_rows=20 min_rows=2,
330
partition pa2 DATA DIRECTORY =
331
'/tmp' INDEX DIRECTORY =
332
'/tmp' max_rows=30 min_rows=3,
333
partition pa3 DATA DIRECTORY =
334
'/tmp' INDEX DIRECTORY =
335
'/tmp' max_rows=30 min_rows=4,
336
partition pa4 DATA DIRECTORY =
337
'/tmp' INDEX DIRECTORY =
338
'/tmp' max_rows=40 min_rows=2);
303
partition pa1 max_rows=20 min_rows=2,
304
partition pa2 max_rows=30 min_rows=3,
305
partition pa3 max_rows=30 min_rows=4,
306
partition pa4 max_rows=40 min_rows=2);
339
307
show create table t1;
340
308
Table Create Table
341
309
t1 CREATE TABLE `t1` (
342
310
`a` mediumint(8) unsigned NOT NULL,
343
311
PRIMARY KEY (`a`)
344
) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) (PARTITION pa1 MAX_ROWS = 20 MIN_ROWS = 2 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = InnoDB, PARTITION pa2 MAX_ROWS = 30 MIN_ROWS = 3 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = InnoDB, PARTITION pa3 MAX_ROWS = 30 MIN_ROWS = 4 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = InnoDB, PARTITION pa4 MAX_ROWS = 40 MIN_ROWS = 2 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = InnoDB) */
312
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) (PARTITION pa1 MAX_ROWS = 20 MIN_ROWS = 2 ENGINE = ndbcluster, PARTITION pa2 MAX_ROWS = 30 MIN_ROWS = 3 ENGINE = ndbcluster, PARTITION pa3 MAX_ROWS = 30 MIN_ROWS = 4 ENGINE = ndbcluster, PARTITION pa4 MAX_ROWS = 40 MIN_ROWS = 2 ENGINE = ndbcluster) */
345
313
insert into t1 values (16777215), (16777214), (16777213), (16777212), (1), (2), (65535);
346
314
select * from t1;
355
323
select * from t1 where a=16777213;
359
327
select * from t1;
368
create table t2 (a mediumint unsigned not null, primary key(a)) engine='InnoDB'
336
create table t2 (a mediumint unsigned not null, primary key(a)) engine='NDB'
369
337
partition by key (a) partitions 8;
370
338
show create table t2;
371
339
Table Create Table
372
340
t2 CREATE TABLE `t2` (
373
341
`a` mediumint(8) unsigned NOT NULL,
374
342
PRIMARY KEY (`a`)
375
) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) PARTITIONS 8 */
343
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) PARTITIONS 8 */
376
344
insert into t2 values (16777215), (16777214), (16777213), (16777212);
377
345
select * from t2;
398
create table t3 (a mediumint not null, primary key(a)) engine='InnoDB'
399
partition by key (a) partitions 10;
366
create table t3 (a mediumint not null, primary key(a)) engine='NDB'
367
partition by key (a) partitions 7;
400
368
show create table t3;
401
369
Table Create Table
402
370
t3 CREATE TABLE `t3` (
403
371
`a` mediumint(9) NOT NULL,
404
372
PRIMARY KEY (`a`)
405
) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) PARTITIONS 10 */
373
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) PARTITIONS 7 */
406
374
insert into t3 values (8388607), (8388606), (8388605), (8388604), (-8388608), (-8388607), (1), (-1), (0);
407
375
select * from t3;
421
389
delete from t3 where a=8388605;
422
390
select * from t3;
433
create table t1 (a bigint unsigned not null, primary key(a)) engine='InnoDB'
401
create table t1 (a bigint unsigned not null, primary key(a)) engine='NDB'
434
402
partition by key (a) (
435
partition pa1 DATA DIRECTORY =
436
'/tmp' INDEX DIRECTORY =
437
'/tmp' max_rows=20 min_rows=2,
438
partition pa2 DATA DIRECTORY =
439
'/tmp' INDEX DIRECTORY =
440
'/tmp' max_rows=30 min_rows=3,
441
partition pa3 DATA DIRECTORY =
442
'/tmp' INDEX DIRECTORY =
443
'/tmp' max_rows=30 min_rows=4,
444
partition pa4 DATA DIRECTORY =
445
'/tmp' INDEX DIRECTORY =
446
'/tmp' max_rows=40 min_rows=2);
403
partition pa1 max_rows=20 min_rows=2,
404
partition pa2 max_rows=30 min_rows=3,
405
partition pa3 max_rows=30 min_rows=4,
406
partition pa4 max_rows=40 min_rows=2);
447
407
show create table t1;
448
408
Table Create Table
449
409
t1 CREATE TABLE `t1` (
450
410
`a` bigint(20) unsigned NOT NULL,
451
411
PRIMARY KEY (`a`)
452
) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) (PARTITION pa1 MAX_ROWS = 20 MIN_ROWS = 2 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = InnoDB, PARTITION pa2 MAX_ROWS = 30 MIN_ROWS = 3 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = InnoDB, PARTITION pa3 MAX_ROWS = 30 MIN_ROWS = 4 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = InnoDB, PARTITION pa4 MAX_ROWS = 40 MIN_ROWS = 2 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = InnoDB) */
412
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) (PARTITION pa1 MAX_ROWS = 20 MIN_ROWS = 2 ENGINE = ndbcluster, PARTITION pa2 MAX_ROWS = 30 MIN_ROWS = 3 ENGINE = ndbcluster, PARTITION pa3 MAX_ROWS = 30 MIN_ROWS = 4 ENGINE = ndbcluster, PARTITION pa4 MAX_ROWS = 40 MIN_ROWS = 2 ENGINE = ndbcluster) */
453
413
insert into t1 values (18446744073709551615), (0xFFFFFFFFFFFFFFFE), (18446744073709551613), (18446744073709551612), (1), (2), (65535);
454
414
select * from t1;
459
417
18446744073709551612
460
418
18446744073709551613
461
419
18446744073709551614
462
420
18446744073709551615
463
423
select * from t1 where a=-2;
465
425
delete from t1 where a=-2;
466
426
select * from t1;
471
429
18446744073709551612
472
430
18446744073709551613
473
431
18446744073709551614
474
432
18446744073709551615
475
435
select * from t1 where a=18446744073709551615;
477
437
18446744073709551615
479
439
select * from t1;
484
442
18446744073709551612
485
443
18446744073709551613
486
444
18446744073709551614
488
create table t2 (a bigint unsigned not null, primary key(a)) engine='InnoDB'
489
partition by key (a) partitions 10;
448
create table t2 (a bigint unsigned not null, primary key(a)) engine='NDB'
449
partition by key (a) partitions 8;
490
450
show create table t2;
491
451
Table Create Table
492
452
t2 CREATE TABLE `t2` (
493
453
`a` bigint(20) unsigned NOT NULL,
494
454
PRIMARY KEY (`a`)
495
) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) PARTITIONS 10 */
455
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) PARTITIONS 8 */
496
456
insert into t2 values (18446744073709551615), (0xFFFFFFFFFFFFFFFE), (18446744073709551613), (18446744073709551612);
497
457
select * from t2;
518
create table t3 (a bigint not null, primary key(a)) engine='InnoDB'
519
partition by key (a) partitions 10;
478
create table t3 (a bigint not null, primary key(a)) engine='NDB'
479
partition by key (a) partitions 7;
520
480
show create table t3;
521
481
Table Create Table
522
482
t3 CREATE TABLE `t3` (
523
483
`a` bigint(20) NOT NULL,
524
484
PRIMARY KEY (`a`)
525
) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) PARTITIONS 10 */
485
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) PARTITIONS 7 */
526
486
insert into t3 values (9223372036854775807), (9223372036854775806), (9223372036854775805), (9223372036854775804), (-9223372036854775808), (-9223372036854775807), (1), (-1), (0);
527
487
select * from t3;
529
491
-9223372036854775808
534
494
9223372036854775804