Debian Codegraph @

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

raw
1 CREATE TABLE `t1_c` (
2 `capgoaledatta` mediumint(5) unsigned NOT NULL auto_increment,
3 `goaledatta` char(2) NOT NULL default '',
4 `maturegarbagefa` varchar(32) NOT NULL default '',
5 PRIMARY KEY (`capgoaledatta`,`goaledatta`,`maturegarbagefa`)
6 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
7 Warnings:
8 Warning 1681 Integer display width is deprecated and will be removed in a future release.
9 INSERT INTO `t1_c` VALUES (2,'3','q3plus.qt'),(400,'4','q3plus.qt'),(1,'3','q3.net'),(3,'4','q3.net'),(3000,'20','threetrees.qt');
10 CREATE TABLE `t2_c` (
11 `capgotod` smallint(5) unsigned NOT NULL auto_increment,
12 `gotod` smallint(5) unsigned NOT NULL default '0',
13 `goaledatta` char(2) default NULL,
14 `maturegarbagefa` varchar(32) default NULL,
15 `descrpooppo` varchar(64) default NULL,
16 `svcutonsa` varchar(64) NOT NULL default '',
17 PRIMARY KEY (`capgotod`),
18 KEY `i quadaddsvr` (`gotod`)
19 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
20 Warnings:
21 Warning 1681 Integer display width is deprecated and will be removed in a future release.
22 Warning 1681 Integer display width is deprecated and will be removed in a future release.
23 INSERT INTO `t2_c` VALUES (500,4,'','q3.net','addavp:MK_CASELECTOR=1','postorod rattoaa'),(2,1,'4','','addavp:MK_BRANDTAD=345','REDS Brandtad'),(3,2,'4','q3.net','execorder','fixedRatediPO REDS'),(1,1,'3','','addavp:MK_BRANDTAD=123','TEST Brandtad'),(6,5,'','told.q3.net','addavp:MK_BRANDTAD=123','Brandtad Toldzone'),(4,3,'3','q3.net','addavp:MK_POOLHINT=2','ratedi PO TEST'),(5,0,'',NULL,NULL,'');
24 CREATE TABLE `t3_c` (
25 `CapGoaledatta` smallint(5) unsigned NOT NULL default '0',
26 `capgotod` smallint(5) unsigned NOT NULL default '0',
27 PRIMARY KEY (`capgotod`,`CapGoaledatta`)
28 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
29 Warnings:
30 Warning 1681 Integer display width is deprecated and will be removed in a future release.
31 Warning 1681 Integer display width is deprecated and will be removed in a future release.
32 INSERT INTO `t3_c` VALUES (5,3),(2,4),(5,4),(1,3);
33 CREATE TABLE `t4_c` (
34 `capfa` bigint(20) unsigned NOT NULL auto_increment,
35 `realm` varchar(32) NOT NULL default '',
36 `authpwchap` varchar(32) default NULL,
37 `fa` varchar(32) NOT NULL default '',
38 `payyingatta` tinyint(4) NOT NULL default '0',
39 `status` char(1) default NULL,
40 PRIMARY KEY (`fa`,`realm`),
41 KEY `capfa` (`capfa`),
42 KEY `i_quadentity` (`fa`,`realm`)
43 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
44 Warnings:
45 Warning 1681 Integer display width is deprecated and will be removed in a future release.
46 Warning 1681 Integer display width is deprecated and will be removed in a future release.
47 INSERT INTO `t4_c` VALUES (18,'john.smith','q3.net','dessjohn.smith',0,NULL),(21,'quad_katt_with_brandtad','q3.net','acne',0,NULL),(2200,'quad_katt_carattoaa','q3.net','acne',0,NULL),(26,'436462612809','sqasdt.q3.net','N/A',0,'6'),(19,'john','smith.qt','dessjohn',0,NULL),(33,'436643196120','sqasdt.q3.net','N/A',1,'6'),(28,'436642900019','sqasdt.q3.net','N/A',0,'6'),(30,'436462900209','sqasdt.q3.net','N/A',0,'6'),(16,'436640006666','sqasdt.q3.net','',0,NULL),(19,'dette','el-redun.com','dessdette',0,NULL),(12,'quad_kattPP','q3.net','acne',2,NULL),(14,'436640008888','sqasdt.q3.net','',0,NULL),(29,'463624900028','sqasdt.q3.net','N/A',0,'6'),(15,'436640099099','sqasdt.q3.net','',0,NULL),(13,'pap','q3plus.qt','acne',1,NULL),(19,'436642612091','sqasdt.q3.net','N/A',0,'6'),(12,'quad_katt','q3.net','acne',0,NULL),(11,'quad_kattVK','q3.net','acne',1,NULL),(32000,'463641969502','sqasdt.q3.net','N/A',1,'6'),(20,'joe','q3.net','joedesswd',0,NULL),(290000000,'436642900034','sqasdt.q3.net','N/A',0,'6'),(25,'contind','armerde.qt','acne',1,NULL);
48 CREATE TABLE `t5_c` (
49 `capfa` bigint(20) unsigned NOT NULL default '0',
50 `gotod` smallint(5) unsigned NOT NULL default '0',
51 `orderutonsa` varchar(64) NOT NULL default '',
52 PRIMARY KEY (`capfa`,`gotod`,`orderutonsa`)
53 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
54 Warnings:
55 Warning 1681 Integer display width is deprecated and will be removed in a future release.
56 Warning 1681 Integer display width is deprecated and will be removed in a future release.
57 INSERT INTO `t5_c` VALUES (21,2,''),(21,1,''),(22,4,'');
58 CREATE TABLE `t6_c` (
59 `capfa_parent` bigint(20) unsigned NOT NULL default '0',
60 `capfa_child` bigint(20) unsigned NOT NULL default '0',
61 `relatta` smallint(5) unsigned NOT NULL default '0',
62 PRIMARY KEY (`capfa_child`,`capfa_parent`,`relatta`)
63 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
64 Warnings:
65 Warning 1681 Integer display width is deprecated and will be removed in a future release.
66 Warning 1681 Integer display width is deprecated and will be removed in a future release.
67 Warning 1681 Integer display width is deprecated and will be removed in a future release.
68 INSERT INTO `t6_c` VALUES (15,16,0),(19,20,0),(18326932092909551615,30,0),(26,29,0),(18326932092909551615,29,0),(19,18,0),(26,28,0),(12,14,0);
69 CREATE TABLE `t7_c` (
70 `dardpo` char(15) NOT NULL default '',
71 `dardtestard` tinyint(3) unsigned NOT NULL auto_increment,
72 `FastFA` char(5) NOT NULL default '',
73 `FastCode` char(6) NOT NULL default '',
74 `Fastca` char(1) NOT NULL default '',
75 `Fastmag` char(1) NOT NULL default '',
76 `Beareratta` char(2) NOT NULL default '',
77 PRIMARY KEY (`dardpo`,`dardtestard`)
78 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
79 Warnings:
80 Warning 1681 Integer display width is deprecated and will be removed in a future release.
81 Warning 1063 Max value for column dardtestard in table test.t7_c is less than autoincrement prefetch size. Please decrease ndb_autoincrement_prefetch_sz
82 INSERT INTO `t7_c` VALUES ('2.6.2.4',24,'CECHP','54545','0','0','5'),('2.2.5.4',26,'CANFA','33223','1','1','4'),('4.3.2.4',28,'ITALD','54222','1','0','5'),('129..0.0.eins',28,'G','99999','1','1','5'),('1.1.1.1',24,'AUTPT','32323','0','1','3');
83 CREATE TABLE `t8_c` (
84 `kattjame` varchar(32) NOT NULL default '',
85 `realm` varchar(32) NOT NULL default '',
86 `realm_entered` varchar(32) NOT NULL default '',
87 `maturegarbagefa` varchar(32) NOT NULL default '',
88 `hunderaaarbagefa_parent` varchar(32) NOT NULL default '',
89 `kattjame_entered` varchar(32) NOT NULL default '',
90 `hunderaaarbagefa` varchar(32) NOT NULL default '',
91 `gest` varchar(16) default NULL,
92 `hassetino` varchar(16) NOT NULL default '',
93 `aaaproxysessfa` varchar(255) default NULL,
94 `autologonallowed` char(1) default NULL,
95 `squardporoot` varchar(15) NOT NULL default '',
96 `naspo` varchar(15) default NULL,
97 `beareratta` char(2) default NULL,
98 `fastCode` varchar(6) default NULL,
99 `fastFA` varchar(5) default NULL,
100 `fastca` char(1) default NULL,
101 `fastmag` char(1) default NULL,
102 `lastupdate` datetime default NULL,
103 `hassetistart` datetime NOT NULL,
104 `accthassetitime` int(10) unsigned default NULL,
105 `acctoutputoctets` bigint(20) unsigned default NULL,
106 `acctinputoctets` bigint(20) unsigned default NULL,
107 PRIMARY KEY (`kattjame`,`hunderaaarbagefa`,`hassetistart`,`hassetino`),
108 KEY `squardporoot` (`squardporoot`)
109 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
110 Warnings:
111 Warning 1681 Integer display width is deprecated and will be removed in a future release.
112 Warning 1681 Integer display width is deprecated and will be removed in a future release.
113 Warning 1681 Integer display width is deprecated and will be removed in a future release.
114 INSERT INTO `t8_c` VALUES ('4tt45345235','pap','q3plus.qt','q3plus.qt','q3.net','436643196120','436643196929','8956234534568968','5524595699','uxasmt21.net.acne.qt/481889229462692422','','1.1.1.1','2.2.4.6','4','86989','34','x','x','2012-03-12 12:55:34','2012-12-05 11:20:04',3223433,3369,9565),('4545435545','john','q3.net','q3.net','acne.li','436643196120','436643196929','45345234568968','995696699','uxasmt21.net.acne.qt/481889229462692423','','1.1.1.1','2.2.9.8','2','86989','34','x','x','2012-03-12 11:35:03','2012-12-05 08:50:04',8821923,169,3565),('versteckter_q3net_katt','joe','q3.net','elredun.com','q3.net','436643196120','436643196939','91341234568968','695595699','uxasmt21.net.acne.qt/481889229462692421','','1.1.1.1','2.5.2.5','3','86989','34','x','x','2012-03-12 18:35:04','2012-12-05 12:35:04',1923123,9569,6565);
115 CREATE TABLE `t9_c` (
116 `kattjame` varchar(32) NOT NULL default '',
117 `kattjame_entered` varchar(32) NOT NULL default '',
118 `realm` varchar(32) NOT NULL default '',
119 `realm_entered` varchar(32) NOT NULL default '',
120 `maturegarbagefa` varchar(32) NOT NULL default '',
121 `hunderaaarbagefa` varchar(32) NOT NULL default '',
122 `hunderaaarbagefa_parent` varchar(32) NOT NULL default '',
123 `gest` varchar(16) default NULL,
124 `hassetino` varchar(16) NOT NULL default '',
125 `squardporoot` varchar(15) NOT NULL default '',
126 `naspo` varchar(15) default NULL,
127 `beareratta` char(2) default NULL,
128 `fastCode` varchar(6) default NULL,
129 `fastFA` varchar(5) default NULL,
130 `fastca` char(1) default NULL,
131 `fastmag` char(1) default NULL,
132 `lastupdate` datetime default NULL,
133 `hassetistart` datetime NOT NULL,
134 `accthassetitime` int(10) unsigned default NULL,
135 `actcoutpuocttets` bigint(20) unsigned default NULL,
136 `actinputocctets` bigint(20) unsigned default NULL,
137 `terminateraste` tinyint(3) unsigned default NULL,
138 PRIMARY KEY (`kattjame`,`hunderaaarbagefa`,`hassetistart`,`hassetino`)
139 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
140 Warnings:
141 Warning 1681 Integer display width is deprecated and will be removed in a future release.
142 Warning 1681 Integer display width is deprecated and will be removed in a future release.
143 Warning 1681 Integer display width is deprecated and will be removed in a future release.
144 Warning 1681 Integer display width is deprecated and will be removed in a future release.
145 INSERT INTO `t9_c` VALUES ('3g4jh8gar2t','joe','q3.net','elredun.com','q3.net','436643316120','436643316939','91341234568968','695595699','1.1.1.1','2.2.6.2','3','86989','34','x','x','2012-03-12 18:35:04','2012-12-05 12:35:04',3123123,9569,6565,1),('4tt45345235','pap','q3plus.qt','q3plus.qt','q3.net','436643316120','436643316939','8956234534568968','5254595969','1.1.1.1','8.6.2.2','4','86989','34','x','x','2012-03-12 12:55:34','2012-12-05 11:20:04',3223433,3369,9565,2),('4545435545','john','q3.net','q3.net','acne.li','436643316120','436643316939','45345234568968','995696699','1.1.1.1','2.9.9.2','2','86998','34','x','x','2012-03-12 11:35:03','2012-12-05 08:50:04',8823123,169,3565,3);
146 CREATE TABLE t10_c (a INT AUTO_INCREMENT KEY) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
147 INSERT INTO t10_c VALUES (1),(2),(3);
148 insert into t10_c values (10000),(2000),(3000);
149 CREATE TABLE t11_c (a int, b00 int null, b01 int null,b02 int null,b03 int null,b04 int null,b05 int null,b06 int null,b07 int null,b08 int null,b90 int null,b10 int null,b11 int null,b12 int null,b13 int null,b14 int null,b15 int null,b16 int null,b17 int null,b18 int null,b19 int null,b20 int null,b21 int null,b22 int null,b23 int null,b24 int null,b25 int null,b26 int null,b27 int null,b28 int null,b29 int null,b30 int null,b31 int null,b32 int null) engine = ndb;
150 insert into t11_c values (1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1);
151 create table t1 engine=myisam as select * from t1_c;
152 create table t2 engine=myisam as select * from t2_c;
153 create table t3 engine=myisam as select * from t3_c;
154 create table t4 engine=myisam as select * from t4_c;
155 create table t5 engine=myisam as select * from t5_c;
156 create table t6 engine=myisam as select * from t6_c;
157 create table t7 engine=myisam as select * from t7_c;
158 create table t8 engine=myisam as select * from t8_c;
159 create table t9 engine=myisam as select * from t9_c;
160 create table t10 engine=myisam as select * from t10_c;
161 create table t11 engine=myisam as select * from t11_c;
162 ForceVarPart: 0
163 ForceVarPart: 1
164 SET @old_ndb_metadata_check_server2 = @@global.ndb_metadata_check;
165 SET GLOBAL ndb_metadata_check = false;
166 SET @old_ndb_metadata_check_server1 = @@global.ndb_metadata_check;
167 SET GLOBAL ndb_metadata_check = false;
168 drop table t1_c,t2_c,t3_c,t4_c,t5_c,t6_c,t7_c,t8_c,t9_c,t10_c,t11_c;
169 ForceVarPart: 0
170 ForceVarPart: 1
171 select count(*) from t1;
172 count(*)
173 5
174 select count(*) from t1_c;
175 count(*)
176 5
177 select count(*)
178 from (select * from t1 union
179 select * from t1_c) a;
180 count(*)
181 5
182 select count(*) from t2;
183 count(*)
184 7
185 select count(*) from t2_c;
186 count(*)
187 7
188 select count(*)
189 from (select * from t2 union
190 select * from t2_c) a;
191 count(*)
192 7
193 select count(*) from t3;
194 count(*)
195 4
196 select count(*) from t3_c;
197 count(*)
198 4
199 select count(*)
200 from (select * from t3 union
201 select * from t3_c) a;
202 count(*)
203 4
204 select count(*) from t4;
205 count(*)
206 22
207 select count(*) from t4_c;
208 count(*)
209 22
210 select count(*)
211 from (select * from t4 union
212 select * from t4_c) a;
213 count(*)
214 22
215 select count(*) from t5;
216 count(*)
217 3
218 select count(*) from t5_c;
219 count(*)
220 3
221 select count(*)
222 from (select * from t5 union
223 select * from t5_c) a;
224 count(*)
225 3
226 select count(*) from t6;
227 count(*)
228 8
229 select count(*) from t6_c;
230 count(*)
231 8
232 select count(*)
233 from (select * from t6 union
234 select * from t6_c) a;
235 count(*)
236 8
237 select count(*) from t7;
238 count(*)
239 5
240 select count(*) from t7_c;
241 count(*)
242 5
243 select count(*)
244 from (select * from t7 union
245 select * from t7_c) a;
246 count(*)
247 5
248 select count(*) from t8;
249 count(*)
250 3
251 select count(*) from t8_c;
252 count(*)
253 3
254 select count(*)
255 from (select * from t8 union
256 select * from t8_c) a;
257 count(*)
258 3
259 select count(*) from t9;
260 count(*)
261 3
262 select count(*) from t9_c;
263 count(*)
264 3
265 select count(*)
266 from (select * from t9 union
267 select * from t9_c) a;
268 count(*)
269 3
270 select count(*) from t10;
271 count(*)
272 6
273 select count(*) from t10_c;
274 count(*)
275 6
276 select count(*)
277 from (select * from t10 union
278 select * from t10_c) a;
279 count(*)
280 6
281 select count(*) from t11;
282 count(*)
283 1
284 select count(*) from t11_c;
285 count(*)
286 1
287 select count(*)
288 from (select * from t11 union
289 select * from t11_c) a;
290 count(*)
291 1
292 select * from t10_c order by a;
293 a
294 1
295 2
296 3
297 2000
298 3000
299 10000
300 select max(capgoaledatta) from t1_c;
301 max(capgoaledatta)
302 3000
303 select auto_increment from information_schema.tables
304 where table_name = 't1_c';
305 AUTO_INCREMENT
306 3001
307 select max(capgotod) from t2_c;
308 max(capgotod)
309 500
310 select auto_increment from information_schema.tables
311 where table_name = 't2_c';
312 AUTO_INCREMENT
313 501
314 select max(capfa) from t4_c;
315 max(capfa)
316 290000000
317 select auto_increment from information_schema.tables
318 where table_name = 't4_c';
319 AUTO_INCREMENT
320 290000001
321 select max(dardtestard) from t7_c;
322 max(dardtestard)
323 28
324 select auto_increment from information_schema.tables
325 where table_name = 't7_c';
326 AUTO_INCREMENT
327 29
328 select max(a) from t10_c;
329 max(a)
330 10000
331 select auto_increment from information_schema.tables
332 where table_name = 't10_c';
333 AUTO_INCREMENT
334 10001
335 ALTER TABLE t7_c
336 PARTITION BY LINEAR KEY (`dardtestard`);
337 drop table t1_c,t2_c,t3_c,t4_c,t5_c,t6_c,t7_c,t8_c,t9_c,t10_c,t11_c;
338 select count(*) from t1;
339 count(*)
340 5
341 select count(*) from t1_c;
342 count(*)
343 5
344 select count(*)
345 from (select * from t1 union
346 select * from t1_c) a;
347 count(*)
348 5
349 select count(*) from t2;
350 count(*)
351 7
352 select count(*) from t2_c;
353 count(*)
354 7
355 select count(*)
356 from (select * from t2 union
357 select * from t2_c) a;
358 count(*)
359 7
360 select count(*) from t3;
361 count(*)
362 4
363 select count(*) from t3_c;
364 count(*)
365 4
366 select count(*)
367 from (select * from t3 union
368 select * from t3_c) a;
369 count(*)
370 4
371 select count(*) from t4;
372 count(*)
373 22
374 select count(*) from t4_c;
375 count(*)
376 22
377 select count(*)
378 from (select * from t4 union
379 select * from t4_c) a;
380 count(*)
381 22
382 select count(*) from t5;
383 count(*)
384 3
385 select count(*) from t5_c;
386 count(*)
387 3
388 select count(*)
389 from (select * from t5 union
390 select * from t5_c) a;
391 count(*)
392 3
393 select count(*) from t6;
394 count(*)
395 8
396 select count(*) from t6_c;
397 count(*)
398 8
399 select count(*)
400 from (select * from t6 union
401 select * from t6_c) a;
402 count(*)
403 8
404 select count(*) from t7;
405 count(*)
406 5
407 select count(*) from t7_c;
408 count(*)
409 5
410 select count(*)
411 from (select * from t7 union
412 select * from t7_c) a;
413 count(*)
414 5
415 select count(*) from t8;
416 count(*)
417 3
418 select count(*) from t8_c;
419 count(*)
420 3
421 select count(*)
422 from (select * from t8 union
423 select * from t8_c) a;
424 count(*)
425 3
426 select count(*) from t9;
427 count(*)
428 3
429 select count(*) from t9_c;
430 count(*)
431 3
432 select count(*)
433 from (select * from t9 union
434 select * from t9_c) a;
435 count(*)
436 3
437 select count(*) from t10;
438 count(*)
439 6
440 select count(*) from t10_c;
441 count(*)
442 6
443 select count(*)
444 from (select * from t10 union
445 select * from t10_c) a;
446 count(*)
447 6
448 select count(*) from t11;
449 count(*)
450 1
451 select count(*) from t11_c;
452 count(*)
453 1
454 select count(*)
455 from (select * from t11 union
456 select * from t11_c) a;
457 count(*)
458 1
459 drop table t1_c,t2_c,t3_c,t4_c,t5_c,t6_c,t7_c,t8_c,t9_c,t10_c,t11_c;
460 select count(*) from t1;
461 count(*)
462 5
463 select count(*) from t1_c;
464 count(*)
465 5
466 select count(*)
467 from (select * from t1 union
468 select * from t1_c) a;
469 count(*)
470 5
471 select count(*) from t2;
472 count(*)
473 7
474 select count(*) from t2_c;
475 count(*)
476 7
477 select count(*)
478 from (select * from t2 union
479 select * from t2_c) a;
480 count(*)
481 7
482 select count(*) from t3;
483 count(*)
484 4
485 select count(*) from t3_c;
486 count(*)
487 4
488 select count(*)
489 from (select * from t3 union
490 select * from t3_c) a;
491 count(*)
492 4
493 select count(*) from t4;
494 count(*)
495 22
496 select count(*) from t4_c;
497 count(*)
498 22
499 select count(*)
500 from (select * from t4 union
501 select * from t4_c) a;
502 count(*)
503 22
504 select count(*) from t5;
505 count(*)
506 3
507 select count(*) from t5_c;
508 count(*)
509 3
510 select count(*)
511 from (select * from t5 union
512 select * from t5_c) a;
513 count(*)
514 3
515 select count(*) from t6;
516 count(*)
517 8
518 select count(*) from t6_c;
519 count(*)
520 8
521 select count(*)
522 from (select * from t6 union
523 select * from t6_c) a;
524 count(*)
525 8
526 select count(*) from t7;
527 count(*)
528 5
529 select count(*) from t7_c;
530 count(*)
531 5
532 select count(*)
533 from (select * from t7 union
534 select * from t7_c) a;
535 count(*)
536 5
537 select count(*) from t8;
538 count(*)
539 3
540 select count(*) from t8_c;
541 count(*)
542 3
543 select count(*)
544 from (select * from t8 union
545 select * from t8_c) a;
546 count(*)
547 3
548 select count(*) from t9;
549 count(*)
550 3
551 select count(*) from t9_c;
552 count(*)
553 3
554 select count(*)
555 from (select * from t9 union
556 select * from t9_c) a;
557 count(*)
558 3
559 select count(*) from t10;
560 count(*)
561 6
562 select count(*) from t10_c;
563 count(*)
564 6
565 select count(*)
566 from (select * from t10 union
567 select * from t10_c) a;
568 count(*)
569 6
570 select count(*) from t11;
571 count(*)
572 1
573 select count(*) from t11_c;
574 count(*)
575 1
576 select count(*)
577 from (select * from t11 union
578 select * from t11_c) a;
579 count(*)
580 1
581 drop table t1_c,t3_c,t4_c,t5_c,t6_c,t7_c,t8_c,t9_c,t10_c,t11_c;
582 select output_line from ndb_restore_output where output_line like '%t2_c%' order by output_line;
583 output_line
584 Create table `test/def/t2_c` failed: 721: Schema object with given name already exists
585 Restore: Failed to restore table: `test/def/t2_c` ... Exiting
586 CREATE TABLE t11_c (
587 c1 int primary key, c2 char(10), c3 varchar(10)
588 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
589 CREATE TABLE t12_c (
590 c1 int primary key, c2 char(10), c3 varchar(10)
591 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
592 INSERT INTO t11_c VALUES(1, "aaaaa", "bbbbb"), (2, "ccccc", "ddddd"), (3, "eeeee","fffff");
593 INSERT INTO t12_c VALUES(4, "ggggg", "hhhhh"), (5, "iiiii", "jjjjj"), (6, "kkkkk","lllll");
594 drop table t2_c,t11_c,t12_c;
595 SELECT * FROM t11_c ORDER BY c1;
596 c1 c2 c3
597 1 aaaaa bbbbb
598 2 ccccc ddddd
599 3 eeeee fffff
600 drop table t1,t2,t3,t4,t5,t6,t7,t8,t9,t10,t11,t11_c;
601 select epoch from mysql.ndb_apply_status where server_id=0;
602 epoch
603 332
604 select epoch from mysql.ndb_apply_status where server_id=0;
605 epoch
606 152
607 select epoch > (1 << 32) from mysql.ndb_apply_status where server_id=0;
608 epoch > (1 << 32)
609 1
610 create table t1 (a int not null primary key auto_increment, b int) auto_increment=200
611 engine=ndb;
612 show create table t1;
613 Table Create Table
614 t1 CREATE TABLE `t1` (
615 `a` int NOT NULL AUTO_INCREMENT,
616 `b` int DEFAULT NULL,
617 PRIMARY KEY (`a`)
618 ) ENGINE=ndbcluster AUTO_INCREMENT=200 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
619 drop table t1;
620 show create table t1;
621 Table Create Table
622 t1 CREATE TABLE `t1` (
623 `a` int NOT NULL AUTO_INCREMENT,
624 `b` int DEFAULT NULL,
625 PRIMARY KEY (`a`)
626 ) ENGINE=ndbcluster AUTO_INCREMENT=200 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
627 drop table t1;
628 drop table t1;
629 create table t1 (a int, b int, c int not null,
630 primary key (a) using hash, unique(c) using hash)
631 engine = ndb;
632 insert into t1 values (1,1,1), (2,2,2), (3,3,3);
633 select * from t1 order by 1;
634 a b c
635 1 1 1
636 2 2 2
637 3 3 3
638 drop table t1;
639 create table t1 (a int primary key) engine = ndb;
640 drop table t1;
641 create table t1 ( c499 int, c498 int, c497 int, c496 int, c495 int, c494 int, c493 int, c492 int, c491 int, c490 int, c489 int, c488 int, c487 int, c486 int, c485 int, c484 int, c483 int, c482 int, c481 int, c480 int, c479 int, c478 int, c477 int, c476 int, c475 int, c474 int, c473 int, c472 int, c471 int, c470 int, c469 int, c468 int, c467 int, c466 int, c465 int, c464 int, c463 int, c462 int, c461 int, c460 int, c459 int, c458 int, c457 int, c456 int, c455 int, c454 int, c453 int, c452 int, c451 int, c450 int, c449 int, c448 int, c447 int, c446 int, c445 int, c444 int, c443 int, c442 int, c441 int, c440 int, c439 int, c438 int, c437 int, c436 int, c435 int, c434 int, c433 int, c432 int, c431 int, c430 int, c429 int, c428 int, c427 int, c426 int, c425 int, c424 int, c423 int, c422 int, c421 int, c420 int, c419 int, c418 int, c417 int, c416 int, c415 int, c414 int, c413 int, c412 int, c411 int, c410 int, c409 int, c408 int, c407 int, c406 int, c405 int, c404 int, c403 int, c402 int, c401 int, c400 int, c399 int, c398 int, c397 int, c396 int, c395 int, c394 int, c393 int, c392 int, c391 int, c390 int, c389 int, c388 int, c387 int, c386 int, c385 int, c384 int, c383 int, c382 int, c381 int, c380 int, c379 int, c378 int, c377 int, c376 int, c375 int, c374 int, c373 int, c372 int, c371 int, c370 int, c369 int, c368 int, c367 int, c366 int, c365 int, c364 int, c363 int, c362 int, c361 int, c360 int, c359 int, c358 int, c357 int, c356 int, c355 int, c354 int, c353 int, c352 int, c351 int, c350 int, c349 int, c348 int, c347 int, c346 int, c345 int, c344 int, c343 int, c342 int, c341 int, c340 int, c339 int, c338 int, c337 int, c336 int, c335 int, c334 int, c333 int, c332 int, c331 int, c330 int, c329 int, c328 int, c327 int, c326 int, c325 int, c324 int, c323 int, c322 int, c321 int, c320 int, c319 int, c318 int, c317 int, c316 int, c315 int, c314 int, c313 int, c312 int, c311 int, c310 int, c309 int, c308 int, c307 int, c306 int, c305 int, c304 int, c303 int, c302 int, c301 int, c300 int, c299 int, c298 int, c297 int, c296 int, c295 int, c294 int, c293 int, c292 int, c291 int, c290 int, c289 int, c288 int, c287 int, c286 int, c285 int, c284 int, c283 int, c282 int, c281 int, c280 int, c279 int, c278 int, c277 int, c276 int, c275 int, c274 int, c273 int, c272 int, c271 int, c270 int, c269 int, c268 int, c267 int, c266 int, c265 int, c264 int, c263 int, c262 int, c261 int, c260 int, c259 int, c258 int, c257 int, c256 int, c255 int, c254 int, c253 int, c252 int, c251 int, c250 int, c249 int, c248 int, c247 int, c246 int, c245 int, c244 int, c243 int, c242 int, c241 int, c240 int, c239 int, c238 int, c237 int, c236 int, c235 int, c234 int, c233 int, c232 int, c231 int, c230 int, c229 int, c228 int, c227 int, c226 int, c225 int, c224 int, c223 int, c222 int, c221 int, c220 int, c219 int, c218 int, c217 int, c216 int, c215 int, c214 int, c213 int, c212 int, c211 int, c210 int, c209 int, c208 int, c207 int, c206 int, c205 int, c204 int, c203 int, c202 int, c201 int, c200 int, c199 int, c198 int, c197 int, c196 int, c195 int, c194 int, c193 int, c192 int, c191 int, c190 int, c189 int, c188 int, c187 int, c186 int, c185 int, c184 int, c183 int, c182 int, c181 int, c180 int, c179 int, c178 int, c177 int, c176 int, c175 int, c174 int, c173 int, c172 int, c171 int, c170 int, c169 int, c168 int, c167 int, c166 int, c165 int, c164 int, c163 int, c162 int, c161 int, c160 int, c159 int, c158 int, c157 int, c156 int, c155 int, c154 int, c153 int, c152 int, c151 int, c150 int, c149 int, c148 int, c147 int, c146 int, c145 int, c144 int, c143 int, c142 int, c141 int, c140 int, c139 int, c138 int, c137 int, c136 int, c135 int, c134 int, c133 int, c132 int, c131 int, c130 int, c129 int, c128 int, c127 int, c126 int, c125 int, c124 int, c123 int, c122 int, c121 int, c120 int, c119 int, c118 int, c117 int, c116 int, c115 int, c114 int, c113 int, c112 int, c111 int, c110 int, c109 int, c108 int, c107 int, c106 int, c105 int, c104 int, c103 int, c102 int, c101 int, c100 int, c99 int, c98 int, c97 int, c96 int, c95 int, c94 int, c93 int, c92 int, c91 int, c90 int, c89 int, c88 int, c87 int, c86 int, c85 int, c84 int, c83 int, c82 int, c81 int, c80 int, c79 int, c78 int, c77 int, c76 int, c75 int, c74 int, c73 int, c72 int, c71 int, c70 int, c69 int, c68 int, c67 int, c66 int, c65 int, c64 int, c63 int, c62 int, c61 int, c60 int, c59 int, c58 int, c57 int, c56 int, c55 int, c54 int, c53 int, c52 int, c51 int, c50 int, c49 int, c48 int, c47 int, c46 int, c45 int, c44 int, c43 int, c42 int, c41 int, c40 int, c39 int, c38 int, c37 int, c36 int, c35 int, c34 int, c33 int, c32 int, c31 int, c30 int, c29 int, c28 int, c27 int, c26 int, c25 int, c24 int, c23 int, c22 int, c21 int, c20 int, c19 int, c18 int, c17 int, c16 int, c15 int, c14 int, c13 int, c12 int, c11 int, c10 int, c9 int, c8 int, c7 int, c6 int, c5 int, c4 int, c3 int, c2 int, c1 int, c500 varchar(11000) CHARACTER SET latin1, primary key using hash(c1)) engine=ndb;
642 set @v10 = '0123456789';
643 set @v100 = concat(@v10,@v10,@v10,@v10,@v10,@v10,@v10,@v10,@v10,@v10);
644 set @v1000 =concat(@v100,@v100,@v100,@v100,@v100,@v100,@v100,@v100,@v100,@v100);
645 set @v10000 = concat(@v1000,@v1000,@v1000,@v1000,@v1000,@v1000,@v1000,@v1000,@v1000,@v1000);
646 set @v11000 = concat(@v10000, @v1000);
647 insert into t1 (c1,c500) values (1,@v11000), (2,@v11000), (3,@v11000);
648 drop table t1;
649 # Trying to start another backup as wait started with same id should return error
650 Waiting for started, this may take several minutes
651 Backup failed
652 * 3001: Could not start backup
653 * Backup failed: file already exists (use 'START BACKUP <backup id>'): Temporary error: Temporary Resource error
654 # Trying to start another backup as wait completed with same id should return error
655 Waiting for completed, this may take several minutes
656 Backup failed
657 * 3001: Could not start backup
658 * Backup failed: file already exists (use 'START BACKUP <backup id>'): Temporary error: Temporary Resource error
659 # Trying to start another backup as nowait with same id should not return error
660 create database db1;
661 use db1;
662 CREATE TABLE t1 (a INT) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
663 CREATE TABLE t2 (b INT) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
664 CREATE TABLE t3 (c INT) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
665 INSERT INTO t1 VALUES (1),(2),(3);
666 INSERT INTO t2 VALUES (4),(5),(6);
667 INSERT INTO t3 VALUES (7),(8),(9);
668 truncate t1;
669 truncate t2;
670 drop table t3;
671 #without 'exclude-missing-tables' should fail
672 #calling 'exclude-missing-tables' with 'restore-meta' should fail
673 #with 'exclude-missing-tables'
674 select count(*) from t1;
675 count(*)
676 3
677 select count(*) from t2;
678 count(*)
679 3
680 #with exclusive include, exclude tables arguments
681 #exclude non missing table
682 truncate t1;
683 truncate t2;
684 select count(*) from t1;
685 count(*)
686 0
687 select count(*) from t2;
688 count(*)
689 3
690 #exclude missing table
691 truncate t1;
692 truncate t2;
693 select count(*) from t1;
694 count(*)
695 3
696 select count(*) from t2;
697 count(*)
698 3
699 #include non missing table
700 truncate t1;
701 truncate t2;
702 select count(*) from t1;
703 count(*)
704 3
705 select count(*) from t2;
706 count(*)
707 0
708 #include missing table
709 truncate t1;
710 truncate t2;
711 select count(*) from t1;
712 count(*)
713 3
714 select count(*) from t2;
715 count(*)
716 0
717 #clearup
718 drop database db1;
719 # ndb_restore with unique index, check behaviour of --restore-epoch
720 use test;
721 create table t1(id int primary key, val int unique) engine=ndb;
722 drop table t1;
723 delete from mysql.ndb_apply_status;
724 select count(1) from mysql.ndb_apply_status where server_id=0;
725 count(1)
726 1
727 drop table t1;
728 select output_line from ndb_restore_output where output_line like '%not specified%' order by output_line;
729 output_line
730 Backup file node ID not specified, please provide --nodeid
731 select output_line from ndb_restore_output where output_line like '%not specified%' order by output_line;
732 output_line
733 Backup file node ID not specified, please provide --nodeid
734 Backup ID not specified, please provide --backupid
735 SET GLOBAL ndb_metadata_check = @old_ndb_metadata_check_server2;
736 SET GLOBAL ndb_metadata_check = @old_ndb_metadata_check_server1;
737 Coverage of increased --parallelism setting
738 create table t1 (a int primary key, b int) engine=ndb;
739 Insert enough rows to get some volume of data
740 per backup PART
741 select count(1), sum(a) from t1;
742 count(1) sum(a)
743 40000 800020000
744 truncate t1;
745 select count(1), sum(a) from t1;
746 count(1) sum(a)
747 40000 800020000
748 Cleanup
749 drop table t1;
750 Coverage of ndb_restore read_size setting
751 Create table with one partition to increase individual
752 backup filesize
753 Avoid redo log overload on restore by using nologging
754 CREATE TABLE t1 (a int primary key, b longblob) engine=ndb
755 COMMENT="NDB_TABLE=NOLOGGING=1"
756 partition by key(a) partitions 1;
757 Insert lots of rows
758 set block_encryption_mode=@saved_block_encryption_mode;
759 select count(1) from t1;
760 count(1)
761 2560
762 Backup
763 Restore with large backup read filesize
764 truncate t1;
765 Check row count
766 select count(1) from t1;
767 count(1)
768 2560
769 drop table t1;
770 Test backupid ranges
771 Test generation backup with max explicit id (2^32 - 2)
772 Check ndb_restore can open max id backup
773 Test behaviour of generating auto-numbered
774 next backup of 2^32-1
775 Check ndb_restore can open max id backup
776 Test behaviour of generating auto-numbered
777 next backup of 0
778 Check ndb_restore can open zero id backup
779 Test behaviour with start backup + out-of-range backup ids
780 MGM client allows 1..4294967294 (not 0 or 4294967295)
781 Invalid command: backup 0
782 Backup ID out of range [1 - 4294967294]
783 Type HELP for help.
784
785 Invalid command: backup 4294967295
786 Backup ID out of range [1 - 4294967294]
787 Type HELP for help.
788
789 Invalid command: backup 4294967296
790 Backup ID out of range [1 - 4294967294]
791 Type HELP for help.
792
793 Invalid command: backup 999999999999
794 Backup ID out of range [1 - 4294967294]
795 Type HELP for help.
796
797 Test behaviour of ndb_restore with various backup ids
798 Too large are rejected
799 Negative are rejected
800 No id is rejected
801 Nodeid = 1