Debian Codegraph @

mysql-test/suite/ndb/r/ndb_dd_backuprestore.result

raw
1 Warnings:
2 Warning 1287 '@@new' is deprecated and will be removed in a future release.
3 **** Test 1 Simple DD backup and restore ****
4 CREATE LOGFILE GROUP log_group1
5 ADD UNDOFILE './log_group1/undofile.dat'
6 INITIAL_SIZE 16M
7 UNDO_BUFFER_SIZE = 1M
8 ENGINE=NDB;
9 CREATE TABLESPACE table_space1
10 ADD DATAFILE './table_space1/datafile.dat'
11 USE LOGFILE GROUP log_group1
12 INITIAL_SIZE 24M
13 ENGINE NDB;
14 CREATE TABLE test.t1
15 (pk1 MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY, c2 CHAR(50) NOT NULL, c3 INT NOT NULL, c4 BIT NOT NULL) TABLESPACE table_space1 STORAGE DISK ENGINE=NDB;
16 SELECT COUNT(*) FROM test.t1;
17 COUNT(*)
18 500
19 SELECT pk1, c2, c3, hex(c4) FROM test.t1 ORDER BY pk1 LIMIT 5;
20 pk1 c2 c3 hex(c4)
21 1 Sweden 500 1
22 2 Sweden 499 1
23 3 Sweden 498 1
24 4 Sweden 497 1
25 5 Sweden 496 1
26 DROP TABLE test.t1;
27 ALTER TABLESPACE table_space1
28 DROP DATAFILE './table_space1/datafile.dat';
29 DROP TABLESPACE table_space1;
30 DROP LOGFILE GROUP log_group1
31 ENGINE NDB;
32 SET GLOBAL ndb_metadata_sync = true;
33 SET GLOBAL ndb_metadata_sync = true;
34 SELECT COUNT(*) FROM test.t1;
35 COUNT(*)
36 500
37 SELECT pk1, c2, c3, hex(c4) FROM test.t1 ORDER BY pk1 LIMIT 5;
38 pk1 c2 c3 hex(c4)
39 1 Sweden 500 1
40 2 Sweden 499 1
41 3 Sweden 498 1
42 4 Sweden 497 1
43 5 Sweden 496 1
44 **** Test 2 Mixed Cluster Test backup and restore ****
45 CREATE TABLE test.t2
46 (pk1 MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY, c2 VARCHAR(200) NOT NULL, c3 INT NOT NULL, c4 BIT NOT NULL)ENGINE=NDB;
47 CREATE TABLE test.t3 (c1 int not null auto_increment, data LONGBLOB, PRIMARY KEY(c1))TABLESPACE table_space1 STORAGE DISK ENGINE=NDB;
48 CREATE TABLE test.t4 (c1 int not null auto_increment, data LONGBLOB, PRIMARY KEY(c1))ENGINE=NDB;
49 SELECT COUNT(*) FROM test.t1;
50 COUNT(*)
51 500
52 SELECT pk1, c2, c3, hex(c4) FROM test.t1 ORDER BY pk1 LIMIT 5;
53 pk1 c2 c3 hex(c4)
54 1 Sweden 500 1
55 2 Sweden 499 1
56 3 Sweden 498 1
57 4 Sweden 497 1
58 5 Sweden 496 1
59 SELECT COUNT(*) FROM test.t2;
60 COUNT(*)
61 500
62 SELECT pk1, c2, c3, hex(c4) FROM test.t2 ORDER BY pk1 LIMIT 5;
63 pk1 c2 c3 hex(c4)
64 1 Sweden, Texas 500 0
65 2 Sweden, Texas 499 0
66 3 Sweden, Texas 498 0
67 4 Sweden, Texas 497 0
68 5 Sweden, Texas 496 0
69 SELECT COUNT(*) FROM test.t3;
70 COUNT(*)
71 100
72 SELECT LENGTH(data) FROM test.t3 WHERE c1 = 1;
73 LENGTH(data)
74 1024
75 SELECT LENGTH(data) FROM test.t3 WHERE c1 = 2;
76 LENGTH(data)
77 16384
78 SELECT COUNT(*) FROM test.t4;
79 COUNT(*)
80 100
81 SELECT LENGTH(data) FROM test.t4 WHERE c1 = 1;
82 LENGTH(data)
83 1024
84 SELECT LENGTH(data) FROM test.t4 WHERE c1 = 2;
85 LENGTH(data)
86 16384
87 DROP TABLE test.t1;
88 DROP TABLE test.t2;
89 DROP TABLE test.t3;
90 DROP TABLE test.t4;
91 ALTER TABLESPACE table_space1
92 DROP DATAFILE './table_space1/datafile.dat';
93 DROP TABLESPACE table_space1;
94 DROP LOGFILE GROUP log_group1
95 ENGINE NDB;
96 SET GLOBAL ndb_metadata_sync = true;
97 SET GLOBAL ndb_metadata_sync = true;
98 SELECT COUNT(*) FROM test.t1;
99 COUNT(*)
100 500
101 SELECT pk1, c2, c3, hex(c4) FROM test.t1 ORDER BY pk1 LIMIT 5;
102 pk1 c2 c3 hex(c4)
103 1 Sweden 500 1
104 2 Sweden 499 1
105 3 Sweden 498 1
106 4 Sweden 497 1
107 5 Sweden 496 1
108 SELECT COUNT(*) FROM test.t2;
109 COUNT(*)
110 500
111 SELECT pk1, c2, c3, hex(c4) FROM test.t2 ORDER BY pk1 LIMIT 5;
112 pk1 c2 c3 hex(c4)
113 1 Sweden, Texas 500 0
114 2 Sweden, Texas 499 0
115 3 Sweden, Texas 498 0
116 4 Sweden, Texas 497 0
117 5 Sweden, Texas 496 0
118 SELECT COUNT(*) FROM test.t3;
119 COUNT(*)
120 100
121 SELECT LENGTH(data) FROM test.t3 WHERE c1 = 1;
122 LENGTH(data)
123 1024
124 SELECT LENGTH(data) FROM test.t3 WHERE c1 = 2;
125 LENGTH(data)
126 16384
127 SELECT COUNT(*) FROM test.t4;
128 COUNT(*)
129 100
130 SELECT LENGTH(data) FROM test.t4 WHERE c1 = 1;
131 LENGTH(data)
132 1024
133 SELECT LENGTH(data) FROM test.t4 WHERE c1 = 2;
134 LENGTH(data)
135 16384
136 DROP TABLE test.t1;
137 DROP TABLE test.t2;
138 DROP TABLE test.t3;
139 DROP TABLE test.t4;
140 **** Test 3 Adding partition Test backup and restore ****
141 CREATE TABLESPACE table_space2
142 ADD DATAFILE './table_space2/datafile.dat'
143 USE LOGFILE GROUP log_group1
144 INITIAL_SIZE 12M
145 ENGINE NDB;
146 CREATE TABLE test.t1 (pk1 MEDIUMINT NOT NULL AUTO_INCREMENT, c2 VARCHAR(150) NOT NULL, c3 INT NOT NULL, c4 BIT NOT NULL, PRIMARY KEY(pk1,c3))TABLESPACE table_space1 STORAGE DISK ENGINE=NDB PARTITION BY HASH(c3) PARTITIONS 4;
147 CREATE TABLE test.t4 (pk1 MEDIUMINT NOT NULL AUTO_INCREMENT, c2 VARCHAR(180) NOT NULL, c3 INT NOT NULL, c4 BIT NOT NULL, PRIMARY KEY(pk1,c3))ENGINE=NDB PARTITION BY HASH(c3) PARTITIONS 2;
148 CREATE TABLE test.t2 (pk1 MEDIUMINT NOT NULL AUTO_INCREMENT, c2 TEXT NOT NULL, c3 INT NOT NULL, c4 BIT NOT NULL, PRIMARY KEY(pk1,c3))TABLESPACE table_space2 STORAGE DISK ENGINE=NDB PARTITION BY KEY(c3) (PARTITION p0 ENGINE = NDB, PARTITION p1 ENGINE = NDB);
149 CREATE TABLE test.t5 (pk1 MEDIUMINT NOT NULL AUTO_INCREMENT, c2 TEXT NOT NULL, c3 INT NOT NULL, c4 BIT NOT NULL, PRIMARY KEY(pk1,c3))ENGINE=NDB PARTITION BY KEY(pk1) (PARTITION p0 ENGINE = NDB, PARTITION p1 ENGINE = NDB);
150 CREATE TABLE test.t3 (pk1 MEDIUMINT NOT NULL AUTO_INCREMENT, c2 VARCHAR(202) NOT NULL, c3 INT NOT NULL, c4 BIT NOT NULL, PRIMARY KEY(pk1,c3))TABLESPACE table_space2 STORAGE DISK ENGINE=NDB PARTITION BY RANGE (c3) PARTITIONS 3 (PARTITION x1 VALUES LESS THAN (105), PARTITION x2 VALUES LESS THAN (333), PARTITION x3 VALUES LESS THAN (720));
151 CREATE TABLE test.t6 (pk1 MEDIUMINT NOT NULL AUTO_INCREMENT, c2 VARCHAR(220) NOT NULL, c3 INT NOT NULL, c4 BIT NOT NULL, PRIMARY KEY(pk1,c3))ENGINE=NDB PARTITION BY RANGE (pk1) PARTITIONS 2 (PARTITION x1 VALUES LESS THAN (333), PARTITION x2 VALUES LESS THAN (720));
152 SHOW CREATE TABLE test.t1;
153 Table Create Table
154 t1 CREATE TABLE `t1` (
155 `pk1` mediumint NOT NULL AUTO_INCREMENT,
156 `c2` varchar(150) NOT NULL,
157 `c3` int NOT NULL,
158 `c4` bit(1) NOT NULL,
159 PRIMARY KEY (`pk1`,`c3`)
160 ) /*!50100 TABLESPACE `table_space1` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
161 /*!50100 PARTITION BY HASH (`c3`)
162 PARTITIONS 4 */
163 SHOW CREATE TABLE test.t2;
164 Table Create Table
165 t2 CREATE TABLE `t2` (
166 `pk1` mediumint NOT NULL AUTO_INCREMENT,
167 `c2` text NOT NULL,
168 `c3` int NOT NULL,
169 `c4` bit(1) NOT NULL,
170 PRIMARY KEY (`pk1`,`c3`)
171 ) /*!50100 TABLESPACE `table_space2` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
172 /*!50100 PARTITION BY KEY (c3)
173 (PARTITION p0 ENGINE = ndbcluster,
174 PARTITION p1 ENGINE = ndbcluster) */
175 SHOW CREATE TABLE test.t3;
176 Table Create Table
177 t3 CREATE TABLE `t3` (
178 `pk1` mediumint NOT NULL AUTO_INCREMENT,
179 `c2` varchar(202) NOT NULL,
180 `c3` int NOT NULL,
181 `c4` bit(1) NOT NULL,
182 PRIMARY KEY (`pk1`,`c3`)
183 ) /*!50100 TABLESPACE `table_space2` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
184 /*!50100 PARTITION BY RANGE (`c3`)
185 (PARTITION x1 VALUES LESS THAN (105) ENGINE = ndbcluster,
186 PARTITION x2 VALUES LESS THAN (333) ENGINE = ndbcluster,
187 PARTITION x3 VALUES LESS THAN (720) ENGINE = ndbcluster) */
188 SHOW CREATE TABLE test.t4;
189 Table Create Table
190 t4 CREATE TABLE `t4` (
191 `pk1` mediumint NOT NULL AUTO_INCREMENT,
192 `c2` varchar(180) NOT NULL,
193 `c3` int NOT NULL,
194 `c4` bit(1) NOT NULL,
195 PRIMARY KEY (`pk1`,`c3`)
196 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
197 /*!50100 PARTITION BY HASH (`c3`)
198 PARTITIONS 2 */
199 SHOW CREATE TABLE test.t5;
200 Table Create Table
201 t5 CREATE TABLE `t5` (
202 `pk1` mediumint NOT NULL AUTO_INCREMENT,
203 `c2` text NOT NULL,
204 `c3` int NOT NULL,
205 `c4` bit(1) NOT NULL,
206 PRIMARY KEY (`pk1`,`c3`)
207 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
208 /*!50100 PARTITION BY KEY (pk1)
209 (PARTITION p0 ENGINE = ndbcluster,
210 PARTITION p1 ENGINE = ndbcluster) */
211 SHOW CREATE TABLE test.t6;
212 Table Create Table
213 t6 CREATE TABLE `t6` (
214 `pk1` mediumint NOT NULL AUTO_INCREMENT,
215 `c2` varchar(220) NOT NULL,
216 `c3` int NOT NULL,
217 `c4` bit(1) NOT NULL,
218 PRIMARY KEY (`pk1`,`c3`)
219 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
220 /*!50100 PARTITION BY RANGE (`pk1`)
221 (PARTITION x1 VALUES LESS THAN (333) ENGINE = ndbcluster,
222 PARTITION x2 VALUES LESS THAN (720) ENGINE = ndbcluster) */
223 SELECT table_name, partition_name, partition_ordinal_position, partition_method, partition_expression FROM information_schema.partitions WHERE table_name= 't1';
224 TABLE_NAME PARTITION_NAME PARTITION_ORDINAL_POSITION PARTITION_METHOD PARTITION_EXPRESSION
225 t1 p0 1 HASH `c3`
226 t1 p1 2 HASH `c3`
227 t1 p2 3 HASH `c3`
228 t1 p3 4 HASH `c3`
229 SELECT table_name, partition_name, partition_ordinal_position, partition_method, partition_expression FROM information_schema.partitions WHERE table_name= 't2';
230 TABLE_NAME PARTITION_NAME PARTITION_ORDINAL_POSITION PARTITION_METHOD PARTITION_EXPRESSION
231 t2 p0 1 KEY `c3`
232 t2 p1 2 KEY `c3`
233 SELECT table_name, partition_name, partition_ordinal_position, partition_method, partition_expression, partition_description FROM information_schema.partitions WHERE table_name= 't3';
234 TABLE_NAME PARTITION_NAME PARTITION_ORDINAL_POSITION PARTITION_METHOD PARTITION_EXPRESSION PARTITION_DESCRIPTION
235 t3 x1 1 RANGE `c3` 105
236 t3 x2 2 RANGE `c3` 333
237 t3 x3 3 RANGE `c3` 720
238 SELECT table_name, partition_name, partition_ordinal_position, partition_method, partition_expression FROM information_schema.partitions WHERE table_name= 't4';
239 TABLE_NAME PARTITION_NAME PARTITION_ORDINAL_POSITION PARTITION_METHOD PARTITION_EXPRESSION
240 t4 p0 1 HASH `c3`
241 t4 p1 2 HASH `c3`
242 SELECT table_name, partition_name, partition_ordinal_position, partition_method, partition_expression FROM information_schema.partitions WHERE table_name= 't5';
243 TABLE_NAME PARTITION_NAME PARTITION_ORDINAL_POSITION PARTITION_METHOD PARTITION_EXPRESSION
244 t5 p0 1 KEY `pk1`
245 t5 p1 2 KEY `pk1`
246 SELECT table_name, partition_name, partition_ordinal_position, partition_method, partition_expression, partition_description FROM information_schema.partitions WHERE table_name= 't6';
247 TABLE_NAME PARTITION_NAME PARTITION_ORDINAL_POSITION PARTITION_METHOD PARTITION_EXPRESSION PARTITION_DESCRIPTION
248 t6 x1 1 RANGE `pk1` 333
249 t6 x2 2 RANGE `pk1` 720
250 SELECT COUNT(*) FROM test.t1;
251 COUNT(*)
252 250
253 SELECT pk1, c2, c3, hex(c4) FROM test.t1 ORDER BY c3 LIMIT 5;
254 pk1 c2 c3 hex(c4)
255 250 Sweden, Texas 2 0
256 249 Sweden, Texas 4 0
257 248 Sweden, Texas 6 0
258 247 Sweden, Texas 8 0
259 246 Sweden, Texas 10 0
260 SELECT COUNT(*) FROM test.t2;
261 COUNT(*)
262 250
263 SELECT pk1, c2, c3, hex(c4) FROM test.t2 ORDER BY c3 LIMIT 5;
264 pk1 c2 c3 hex(c4)
265 250 Sweden, Texas, ITALY, Kyle, JO, JBM,TU 1 1
266 249 Sweden, Texas, ITALY, Kyle, JO, JBM,TU 3 1
267 248 Sweden, Texas, ITALY, Kyle, JO, JBM,TU 5 1
268 247 Sweden, Texas, ITALY, Kyle, JO, JBM,TU 7 1
269 246 Sweden, Texas, ITALY, Kyle, JO, JBM,TU 9 1
270 SELECT COUNT(*) FROM test.t3;
271 COUNT(*)
272 250
273 SELECT pk1, c2, c3, hex(c4) FROM test.t3 ORDER BY c3 LIMIT 5;
274 pk1 c2 c3 hex(c4)
275 250 TEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXAS, ITALY, Kyle, JO, JBM,TU 0 1
276 249 TEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXAS, ITALY, Kyle, JO, JBM,TU 2 1
277 248 TEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXAS, ITALY, Kyle, JO, JBM,TU 4 1
278 247 TEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXAS, ITALY, Kyle, JO, JBM,TU 6 1
279 246 TEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXAS, ITALY, Kyle, JO, JBM,TU 8 1
280 SELECT COUNT(*) FROM test.t4;
281 COUNT(*)
282 250
283 SELECT pk1, c2, c3, hex(c4) FROM test.t4 ORDER BY c3 LIMIT 5;
284 pk1 c2 c3 hex(c4)
285 250 Sweden, Texas 2 0
286 249 Sweden, Texas 4 0
287 248 Sweden, Texas 6 0
288 247 Sweden, Texas 8 0
289 246 Sweden, Texas 10 0
290 SELECT COUNT(*) FROM test.t5;
291 COUNT(*)
292 250
293 SELECT pk1, c2, c3, hex(c4) FROM test.t5 ORDER BY c3 LIMIT 5;
294 pk1 c2 c3 hex(c4)
295 250 Sweden, Texas, ITALY, Kyle, JO, JBM,TU 1 1
296 249 Sweden, Texas, ITALY, Kyle, JO, JBM,TU 3 1
297 248 Sweden, Texas, ITALY, Kyle, JO, JBM,TU 5 1
298 247 Sweden, Texas, ITALY, Kyle, JO, JBM,TU 7 1
299 246 Sweden, Texas, ITALY, Kyle, JO, JBM,TU 9 1
300 SELECT COUNT(*) FROM test.t6;
301 COUNT(*)
302 250
303 SELECT pk1, c2, c3, hex(c4) FROM test.t6 ORDER BY c3 LIMIT 5;
304 pk1 c2 c3 hex(c4)
305 250 TEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXAS, ITALY, Kyle, JO, JBM,TU 0 1
306 249 TEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXAS, ITALY, Kyle, JO, JBM,TU 2 1
307 248 TEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXAS, ITALY, Kyle, JO, JBM,TU 4 1
308 247 TEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXAS, ITALY, Kyle, JO, JBM,TU 6 1
309 246 TEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXAS, ITALY, Kyle, JO, JBM,TU 8 1
310 DROP TABLE test.t1;
311 DROP TABLE test.t2;
312 DROP TABLE test.t3;
313 DROP TABLE test.t4;
314 DROP TABLE test.t5;
315 DROP TABLE test.t6;
316 ALTER TABLESPACE table_space1
317 DROP DATAFILE './table_space1/datafile.dat';
318 ALTER TABLESPACE table_space2
319 DROP DATAFILE './table_space2/datafile.dat';
320 DROP TABLESPACE table_space1;
321 DROP TABLESPACE table_space2;
322 DROP LOGFILE GROUP log_group1
323 ENGINE NDB;
324 SET GLOBAL ndb_metadata_sync = true;
325 SET GLOBAL ndb_metadata_sync = true;
326 SHOW CREATE TABLE test.t1;
327 Table Create Table
328 t1 CREATE TABLE `t1` (
329 `pk1` mediumint NOT NULL AUTO_INCREMENT,
330 `c2` varchar(150) NOT NULL,
331 `c3` int NOT NULL,
332 `c4` bit(1) NOT NULL,
333 PRIMARY KEY (`pk1`,`c3`)
334 ) /*!50100 TABLESPACE `table_space1` STORAGE DISK */ ENGINE=ndbcluster AUTO_INCREMENT=513 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
335 /*!50100 PARTITION BY HASH (`c3`)
336 PARTITIONS 4 */
337 SHOW CREATE TABLE test.t2;
338 Table Create Table
339 t2 CREATE TABLE `t2` (
340 `pk1` mediumint NOT NULL AUTO_INCREMENT,
341 `c2` text NOT NULL,
342 `c3` int NOT NULL,
343 `c4` bit(1) NOT NULL,
344 PRIMARY KEY (`pk1`,`c3`)
345 ) /*!50100 TABLESPACE `table_space2` STORAGE DISK */ ENGINE=ndbcluster AUTO_INCREMENT=513 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
346 /*!50100 PARTITION BY KEY (c3)
347 (PARTITION p0 ENGINE = ndbcluster,
348 PARTITION p1 ENGINE = ndbcluster) */
349 SHOW CREATE TABLE test.t3;
350 Table Create Table
351 t3 CREATE TABLE `t3` (
352 `pk1` mediumint NOT NULL AUTO_INCREMENT,
353 `c2` varchar(202) NOT NULL,
354 `c3` int NOT NULL,
355 `c4` bit(1) NOT NULL,
356 PRIMARY KEY (`pk1`,`c3`)
357 ) /*!50100 TABLESPACE `table_space2` STORAGE DISK */ ENGINE=ndbcluster AUTO_INCREMENT=513 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
358 /*!50100 PARTITION BY RANGE (`c3`)
359 (PARTITION x1 VALUES LESS THAN (105) ENGINE = ndbcluster,
360 PARTITION x2 VALUES LESS THAN (333) ENGINE = ndbcluster,
361 PARTITION x3 VALUES LESS THAN (720) ENGINE = ndbcluster) */
362 SHOW CREATE TABLE test.t4;
363 Table Create Table
364 t4 CREATE TABLE `t4` (
365 `pk1` mediumint NOT NULL AUTO_INCREMENT,
366 `c2` varchar(180) NOT NULL,
367 `c3` int NOT NULL,
368 `c4` bit(1) NOT NULL,
369 PRIMARY KEY (`pk1`,`c3`)
370 ) ENGINE=ndbcluster AUTO_INCREMENT=513 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
371 /*!50100 PARTITION BY HASH (`c3`)
372 PARTITIONS 2 */
373 SHOW CREATE TABLE test.t5;
374 Table Create Table
375 t5 CREATE TABLE `t5` (
376 `pk1` mediumint NOT NULL AUTO_INCREMENT,
377 `c2` text NOT NULL,
378 `c3` int NOT NULL,
379 `c4` bit(1) NOT NULL,
380 PRIMARY KEY (`pk1`,`c3`)
381 ) ENGINE=ndbcluster AUTO_INCREMENT=513 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
382 /*!50100 PARTITION BY KEY (pk1)
383 (PARTITION p0 ENGINE = ndbcluster,
384 PARTITION p1 ENGINE = ndbcluster) */
385 SHOW CREATE TABLE test.t6;
386 Table Create Table
387 t6 CREATE TABLE `t6` (
388 `pk1` mediumint NOT NULL AUTO_INCREMENT,
389 `c2` varchar(220) NOT NULL,
390 `c3` int NOT NULL,
391 `c4` bit(1) NOT NULL,
392 PRIMARY KEY (`pk1`,`c3`)
393 ) ENGINE=ndbcluster AUTO_INCREMENT=513 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
394 /*!50100 PARTITION BY RANGE (`pk1`)
395 (PARTITION x1 VALUES LESS THAN (333) ENGINE = ndbcluster,
396 PARTITION x2 VALUES LESS THAN (720) ENGINE = ndbcluster) */
397 SELECT table_name, partition_name, partition_ordinal_position, partition_method, partition_expression FROM information_schema.partitions WHERE table_name= 't1';
398 TABLE_NAME PARTITION_NAME PARTITION_ORDINAL_POSITION PARTITION_METHOD PARTITION_EXPRESSION
399 t1 p0 1 HASH `c3`
400 t1 p1 2 HASH `c3`
401 t1 p2 3 HASH `c3`
402 t1 p3 4 HASH `c3`
403 SELECT table_name, partition_name, partition_ordinal_position, partition_method, partition_expression FROM information_schema.partitions WHERE table_name= 't2';
404 TABLE_NAME PARTITION_NAME PARTITION_ORDINAL_POSITION PARTITION_METHOD PARTITION_EXPRESSION
405 t2 p0 1 KEY `c3`
406 t2 p1 2 KEY `c3`
407 SELECT table_name, partition_name, partition_ordinal_position, partition_method, partition_expression, partition_description FROM information_schema.partitions WHERE table_name= 't3';
408 TABLE_NAME PARTITION_NAME PARTITION_ORDINAL_POSITION PARTITION_METHOD PARTITION_EXPRESSION PARTITION_DESCRIPTION
409 t3 x1 1 RANGE `c3` 105
410 t3 x2 2 RANGE `c3` 333
411 t3 x3 3 RANGE `c3` 720
412 SELECT table_name, partition_name, partition_ordinal_position, partition_method, partition_expression FROM information_schema.partitions WHERE table_name= 't4';
413 TABLE_NAME PARTITION_NAME PARTITION_ORDINAL_POSITION PARTITION_METHOD PARTITION_EXPRESSION
414 t4 p0 1 HASH `c3`
415 t4 p1 2 HASH `c3`
416 SELECT table_name, partition_name, partition_ordinal_position, partition_method, partition_expression FROM information_schema.partitions WHERE table_name= 't5';
417 TABLE_NAME PARTITION_NAME PARTITION_ORDINAL_POSITION PARTITION_METHOD PARTITION_EXPRESSION
418 t5 p0 1 KEY `pk1`
419 t5 p1 2 KEY `pk1`
420 SELECT table_name, partition_name, partition_ordinal_position, partition_method, partition_expression, partition_description FROM information_schema.partitions WHERE table_name= 't6';
421 TABLE_NAME PARTITION_NAME PARTITION_ORDINAL_POSITION PARTITION_METHOD PARTITION_EXPRESSION PARTITION_DESCRIPTION
422 t6 x1 1 RANGE `pk1` 333
423 t6 x2 2 RANGE `pk1` 720
424 SELECT COUNT(*) FROM test.t1;
425 COUNT(*)
426 250
427 SELECT pk1, c2, c3, hex(c4) FROM test.t1 ORDER BY c3 LIMIT 5;
428 pk1 c2 c3 hex(c4)
429 250 Sweden, Texas 2 0
430 249 Sweden, Texas 4 0
431 248 Sweden, Texas 6 0
432 247 Sweden, Texas 8 0
433 246 Sweden, Texas 10 0
434 SELECT COUNT(*) FROM test.t2;
435 COUNT(*)
436 250
437 SELECT pk1, c2, c3, hex(c4) FROM test.t2 ORDER BY c3 LIMIT 5;
438 pk1 c2 c3 hex(c4)
439 250 Sweden, Texas, ITALY, Kyle, JO, JBM,TU 1 1
440 249 Sweden, Texas, ITALY, Kyle, JO, JBM,TU 3 1
441 248 Sweden, Texas, ITALY, Kyle, JO, JBM,TU 5 1
442 247 Sweden, Texas, ITALY, Kyle, JO, JBM,TU 7 1
443 246 Sweden, Texas, ITALY, Kyle, JO, JBM,TU 9 1
444 SELECT COUNT(*) FROM test.t3;
445 COUNT(*)
446 250
447 SELECT pk1, c2, c3, hex(c4) FROM test.t3 ORDER BY c3 LIMIT 5;
448 pk1 c2 c3 hex(c4)
449 250 TEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXAS, ITALY, Kyle, JO, JBM,TU 0 1
450 249 TEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXAS, ITALY, Kyle, JO, JBM,TU 2 1
451 248 TEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXAS, ITALY, Kyle, JO, JBM,TU 4 1
452 247 TEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXAS, ITALY, Kyle, JO, JBM,TU 6 1
453 246 TEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXAS, ITALY, Kyle, JO, JBM,TU 8 1
454 SELECT COUNT(*) FROM test.t4;
455 COUNT(*)
456 250
457 SELECT pk1, c2, c3, hex(c4) FROM test.t4 ORDER BY c3 LIMIT 5;
458 pk1 c2 c3 hex(c4)
459 250 Sweden, Texas 2 0
460 249 Sweden, Texas 4 0
461 248 Sweden, Texas 6 0
462 247 Sweden, Texas 8 0
463 246 Sweden, Texas 10 0
464 SELECT COUNT(*) FROM test.t5;
465 COUNT(*)
466 250
467 SELECT pk1, c2, c3, hex(c4) FROM test.t5 ORDER BY c3 LIMIT 5;
468 pk1 c2 c3 hex(c4)
469 250 Sweden, Texas, ITALY, Kyle, JO, JBM,TU 1 1
470 249 Sweden, Texas, ITALY, Kyle, JO, JBM,TU 3 1
471 248 Sweden, Texas, ITALY, Kyle, JO, JBM,TU 5 1
472 247 Sweden, Texas, ITALY, Kyle, JO, JBM,TU 7 1
473 246 Sweden, Texas, ITALY, Kyle, JO, JBM,TU 9 1
474 SELECT COUNT(*) FROM test.t6;
475 COUNT(*)
476 250
477 SELECT pk1, c2, c3, hex(c4) FROM test.t6 ORDER BY c3 LIMIT 5;
478 pk1 c2 c3 hex(c4)
479 250 TEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXAS, ITALY, Kyle, JO, JBM,TU 0 1
480 249 TEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXAS, ITALY, Kyle, JO, JBM,TU 2 1
481 248 TEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXAS, ITALY, Kyle, JO, JBM,TU 4 1
482 247 TEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXAS, ITALY, Kyle, JO, JBM,TU 6 1
483 246 TEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXASTEXAS, ITALY, Kyle, JO, JBM,TU 8 1
484 DROP TABLE test.t1;
485 DROP TABLE test.t2;
486 DROP TABLE test.t3;
487 DROP TABLE test.t4;
488 DROP TABLE test.t5;
489 DROP TABLE test.t6;
490 ALTER TABLESPACE table_space1 DROP DATAFILE './table_space1/datafile.dat';
491 ALTER TABLESPACE table_space2 DROP DATAFILE './table_space2/datafile.dat';
492 DROP TABLESPACE table_space1;
493 DROP TABLESPACE table_space2;
494 DROP LOGFILE GROUP log_group1 ENGINE = NDB;