Debian Codegraph @

mysql-test/suite/ndb/t/ndb_restore_conv_lossy_integral.test

raw
1 ######################################################################
2 # Test restoring backups with lossy conversions on integral types
3 ######################################################################
4
5 -- source include/have_ndb.inc
6 -- source suite/ndb/include/backup_restore_setup.inc
7
8 # mysqld's configuration is not relevant to this test
9
10 # Turn off STRICT sql_mode since test intentionally truncates
11 # data when preparing the test data(those offending statements
12 # are within enable/disable_warnings)
13 --source suite/ndb/include/turn_off_strict_sql_mode.inc
14
15 --echo ************************************************************
16 --echo * Creating table with integral types
17 --echo ************************************************************
18
19 CREATE TABLE t1(
20 t1 tinyint, t2 tinyint, ut1 tinyint unsigned,
21 s1 smallint, s2 smallint, us1 smallint unsigned,
22 m1 mediumint, m2 mediumint, um1 mediumint unsigned,
23 i1 int, i2 int, ui1 int unsigned,
24 b1 bigint, b2 bigint, ub1 bigint unsigned
25 ) ENGINE=NDB;
26
27 INSERT INTO t1 VALUES(
28 -128, 127, 255,
29 -32768, 32767, 65535,
30 -8388608, 8388607, 16777215,
31 -2147483648, 2147483647, 4294967295,
32 -9223372036854775808, 9223372036854775807, 18446744073709551615
33 );
34
35 --echo ************************************************************
36 --echo * Backing up table with integral types
37 --echo ************************************************************
38
39 --source include/ndb_backup.inc
40
41 # command shortcuts
42 --let $restore_cmd=$NDB_RESTORE -b $the_backup_id
43 --let $restore_cmd=$restore_cmd -r --backup_path=$NDB_BACKUPS-$the_backup_id
44
45 --echo ************************************************************
46 --echo * Restoring table with unchanged integral types:
47 --echo * tinyint[unsigned] --> tinyint[unsigned]
48 --echo * smallint[unsigned] --> smallint[unsigned]
49 --echo * mediumint[unsigned] --> mediumint[unsigned]
50 --echo * int[unsigned] --> int[unsigned]
51 --echo * bigint[unsigned] --> bigint[unsigned]
52 --echo ************************************************************
53
54 # create a MyISAM table from NDB table, against which to compare data
55 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
56
57 # restore table
58 DELETE FROM t1;
59 # for debugging:
60 # --exec $NDB_RESTORE -b $the_backup_id -n 1 -L -r --print $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
61 # --exec $NDB_RESTORE -b $the_backup_id -n 2 -L -r --print $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
62 --exec $restore_cmd -n 1 --print -L > /dev/null
63 --exec $restore_cmd -n 2 --print -L > /dev/null
64 SELECT * FROM t1;
65
66 # verify data
67 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
68 DROP TABLE t1_myisam;
69
70 --echo ************************************************************
71 --echo * Restoring table with 1st degree demoted integral types:
72 --echo * tinyint[unsigned] --> tinyint[unsigned]
73 --echo * smallint[unsigned] --> tinyint[unsigned]
74 --echo * mediumint[unsigned] --> smallint[unsigned]
75 --echo * int[unsigned] --> mediumint[unsigned]
76 --echo * bigint[unsigned] --> int[unsigned]
77 --echo ************************************************************
78
79 # demote integral type attibutes
80 --disable_warnings
81 ALTER TABLE t1
82 modify t1 tinyint, modify t2 tinyint, modify ut1 tinyint unsigned,
83 modify s1 tinyint, modify s2 tinyint, modify us1 tinyint unsigned,
84 modify m1 smallint, modify m2 smallint, modify um1 smallint unsigned,
85 modify i1 mediumint, modify i2 mediumint, modify ui1 mediumint unsigned,
86 modify b1 int, modify b2 int, modify ub1 int unsigned;
87 --enable_warnings
88 SELECT * FROM t1;
89
90 # create a MyISAM table from NDB table, against which to compare data
91 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
92
93 # restore table
94 DELETE FROM t1;
95 --exec $restore_cmd -n 1 --print -L > /dev/null
96 --exec $restore_cmd -n 2 --print -L > /dev/null
97 SELECT * FROM t1;
98
99 # verify data
100 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
101 DROP TABLE t1_myisam;
102
103 --echo ************************************************************
104 --echo * Restoring table with 2nd degree demoted integral types:
105 --echo * tinyint[unsigned] --> tinyint[unsigned]
106 --echo * smallint[unsigned] --> tinyint[unsigned]
107 --echo * mediumint[unsigned] --> tinyint[unsigned]
108 --echo * int[unsigned] --> smallint[unsigned]
109 --echo * bigint[unsigned] --> mediumint[unsigned]
110 --echo ************************************************************
111
112 # demote integral type attibutes
113 --disable_warnings
114 ALTER TABLE t1
115 modify t1 tinyint, modify t2 tinyint, modify ut1 tinyint unsigned,
116 modify s1 tinyint, modify s2 tinyint, modify us1 tinyint unsigned,
117 modify m1 tinyint, modify m2 tinyint, modify um1 tinyint unsigned,
118 modify i1 smallint, modify i2 smallint, modify ui1 smallint unsigned,
119 modify b1 mediumint, modify b2 mediumint, modify ub1 mediumint unsigned;
120 --enable_warnings
121 SELECT * FROM t1;
122
123 # create a MyISAM table from NDB table, against which to compare data
124 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
125
126 # restore table
127 DELETE FROM t1;
128 --exec $restore_cmd -n 1 --print -L > /dev/null
129 --exec $restore_cmd -n 2 --print -L > /dev/null
130 SELECT * FROM t1;
131
132 # verify data
133 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
134 DROP TABLE t1_myisam;
135
136 --echo ************************************************************
137 --echo * Restoring table with 3rd degree demoted integral types:
138 --echo * tinyint[unsigned] --> tinyint[unsigned]
139 --echo * smallint[unsigned] --> tinyint[unsigned]
140 --echo * mediumint[unsigned] --> tinyint[unsigned]
141 --echo * int[unsigned] --> tinyint[unsigned]
142 --echo * bigint[unsigned] --> smallint[unsigned]
143 --echo ************************************************************
144
145 # demote integral type attibutes
146 --disable_warnings
147 ALTER TABLE t1
148 modify t1 tinyint, modify t2 tinyint, modify ut1 tinyint unsigned,
149 modify s1 tinyint, modify s2 tinyint, modify us1 tinyint unsigned,
150 modify m1 tinyint, modify m2 tinyint, modify um1 tinyint unsigned,
151 modify i1 tinyint, modify i2 tinyint, modify ui1 tinyint unsigned,
152 modify b1 smallint, modify b2 smallint, modify ub1 smallint unsigned;
153 --enable_warnings
154 SELECT * FROM t1;
155
156 # create a MyISAM table from NDB table, against which to compare data
157 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
158
159 # restore table
160 DELETE FROM t1;
161 --exec $restore_cmd -n 1 --print -L > /dev/null
162 --exec $restore_cmd -n 2 --print -L > /dev/null
163 SELECT * FROM t1;
164
165 # verify data
166 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
167 DROP TABLE t1_myisam;
168
169 --echo ************************************************************
170 --echo * Restoring table with 4th degree demoted integral types:
171 --echo * tinyint[unsigned] --> tinyint[unsigned]
172 --echo * smallint[unsigned] --> tinyint[unsigned]
173 --echo * mediumint[unsigned] --> tinyint[unsigned]
174 --echo * int[unsigned] --> tinyint[unsigned]
175 --echo * bigint[unsigned] --> tinyint[unsigned]
176 --echo ************************************************************
177
178 # demote integral type attibutes
179 --disable_warnings
180 ALTER TABLE t1
181 modify t1 tinyint, modify t2 tinyint, modify ut1 tinyint unsigned,
182 modify s1 tinyint, modify s2 tinyint, modify us1 tinyint unsigned,
183 modify m1 tinyint, modify m2 tinyint, modify um1 tinyint unsigned,
184 modify i1 tinyint, modify i2 tinyint, modify ui1 tinyint unsigned,
185 modify b1 tinyint, modify b2 tinyint, modify ub1 tinyint unsigned;
186 --enable_warnings
187 SELECT * FROM t1;
188
189 # create a MyISAM table from NDB table, against which to compare data
190 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
191
192 # restore table
193 DELETE FROM t1;
194 --exec $restore_cmd -n 1 --print -L > /dev/null
195 --exec $restore_cmd -n 2 --print -L > /dev/null
196 SELECT * FROM t1;
197
198 # verify data
199 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
200 DROP TABLE t1_myisam;
201
202 --echo ************************************************************
203 --echo * Restoring table with changed signedness:
204 --echo * tinyint unsigned/signed --> tinyint signed/unsigned
205 --echo * smallint unsigned/signed --> smallint signed/unsigned
206 --echo * mediumint unsigned/signed --> mediumint signed/unsigned
207 --echo * int unsigned/signed --> int signed/unsigned
208 --echo * bigint unsigned/signed --> bigint signed/unsigned
209 --echo ************************************************************
210
211 # convert signedness of integral type attibutes
212 --disable_warnings
213 DELETE FROM t1;
214 ALTER TABLE t1
215 modify t1 tinyint unsigned, modify t2 tinyint unsigned, modify ut1 tinyint signed,
216 modify s1 smallint unsigned, modify s2 smallint unsigned, modify us1 smallint signed,
217 modify m1 mediumint unsigned, modify m2 mediumint unsigned, modify um1 mediumint signed,
218 modify i1 int unsigned, modify i2 int unsigned, modify ui1 int signed,
219 modify b1 bigint unsigned, modify b2 bigint unsigned, modify ub1 bigint signed;
220 INSERT INTO t1 VALUES(
221 -128, 127, 255,
222 -32768, 32767, 65535,
223 -8388608, 8388607, 16777215,
224 -2147483648, 2147483647, 4294967295,
225 -9223372036854775808, 9223372036854775807, 18446744073709551615
226 );
227 --enable_warnings
228 SELECT * FROM t1;
229
230 # create a MyISAM table from NDB table, against which to compare data
231 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
232
233 # restore table
234 DELETE FROM t1;
235 --exec $restore_cmd -n 1 --print -L > /dev/null
236 --exec $restore_cmd -n 2 --print -L > /dev/null
237 SELECT * FROM t1;
238
239 # verify data
240 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
241 DROP TABLE t1_myisam;
242
243 --echo ************************************************************
244 --echo * Restoring table with changed signedness + 1st degree promoted types:
245 --echo * tinyint unsigned/signed --> smallint signed/unsigned
246 --echo * smallint unsigned/signed --> mediumint signed/unsigned
247 --echo * mediumint unsigned/signed --> int signed/unsigned
248 --echo * int unsigned/signed --> bigint signed/unsigned
249 --echo * bigint unsigned/signed --> bigint signed/unsigned
250 --echo ************************************************************
251
252 # convert signedness of integral type attibutes
253 --disable_warnings
254 DELETE FROM t1;
255 ALTER TABLE t1
256 modify t1 smallint unsigned, modify t2 smallint unsigned, modify ut1 smallint signed,
257 modify s1 mediumint unsigned, modify s2 mediumint unsigned, modify us1 mediumint signed,
258 modify m1 int unsigned, modify m2 int unsigned, modify um1 int signed,
259 modify i1 bigint unsigned, modify i2 bigint unsigned, modify ui1 bigint signed,
260 modify b1 bigint unsigned, modify b2 bigint unsigned, modify ub1 bigint signed;
261 INSERT INTO t1 VALUES(
262 -128, 127, 255,
263 -32768, 32767, 65535,
264 -8388608, 8388607, 16777215,
265 -2147483648, 2147483647, 4294967295,
266 -9223372036854775808, 9223372036854775807, 18446744073709551615
267 );
268 --enable_warnings
269 SELECT * FROM t1;
270
271 # create a MyISAM table from NDB table, against which to compare data
272 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
273
274 # restore table
275 DELETE FROM t1;
276 --exec $restore_cmd -n 1 --print -L > /dev/null
277 --exec $restore_cmd -n 2 --print -L > /dev/null
278 SELECT * FROM t1;
279
280 # verify data
281 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
282 DROP TABLE t1_myisam;
283
284 --echo ************************************************************
285 --echo * Restoring table with changed signedness + 2nd degree promoted types:
286 --echo * tinyint unsigned/signed --> mediumint signed/unsigned
287 --echo * smallint unsigned/signed --> int signed/unsigned
288 --echo * mediumint unsigned/signed --> bigint signed/unsigned
289 --echo * int unsigned/signed --> bigint signed/unsigned
290 --echo * bigint unsigned/signed --> bigint signed/unsigned
291 --echo ************************************************************
292
293 # convert signedness of integral type attibutes
294 --disable_warnings
295 DELETE FROM t1;
296 ALTER TABLE t1
297 modify t1 mediumint unsigned, modify t2 mediumint unsigned, modify ut1 mediumint signed,
298 modify s1 int unsigned, modify s2 int unsigned, modify us1 int signed,
299 modify m1 bigint unsigned, modify m2 bigint unsigned, modify um1 bigint signed,
300 modify i1 bigint unsigned, modify i2 bigint unsigned, modify ui1 bigint signed,
301 modify b1 bigint unsigned, modify b2 bigint unsigned, modify ub1 bigint signed;
302 INSERT INTO t1 VALUES(
303 -128, 127, 255,
304 -32768, 32767, 65535,
305 -8388608, 8388607, 16777215,
306 -2147483648, 2147483647, 4294967295,
307 -9223372036854775808, 9223372036854775807, 18446744073709551615
308 );
309 --enable_warnings
310 SELECT * FROM t1;
311
312 # create a MyISAM table from NDB table, against which to compare data
313 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
314
315 # restore table
316 DELETE FROM t1;
317 --exec $restore_cmd -n 1 --print -L > /dev/null
318 --exec $restore_cmd -n 2 --print -L > /dev/null
319 SELECT * FROM t1;
320
321 # verify data
322 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
323 DROP TABLE t1_myisam;
324
325 --echo ************************************************************
326 --echo * Restoring table with changed signedness + 3rd degree promoted types:
327 --echo * tinyint unsigned/signed --> int signed/unsigned
328 --echo * smallint unsigned/signed --> bigint signed/unsigned
329 --echo * mediumint unsigned/signed --> bigint signed/unsigned
330 --echo * int unsigned/signed --> bigint signed/unsigned
331 --echo * bigint unsigned/signed --> bigint signed/unsigned
332 --echo ************************************************************
333
334 # convert signedness of integral type attibutes
335 --disable_warnings
336 DELETE FROM t1;
337 ALTER TABLE t1
338 modify t1 int unsigned, modify t2 int unsigned, modify ut1 int signed,
339 modify s1 bigint unsigned, modify s2 bigint unsigned, modify us1 bigint signed,
340 modify m1 bigint unsigned, modify m2 bigint unsigned, modify um1 bigint signed,
341 modify i1 bigint unsigned, modify i2 bigint unsigned, modify ui1 bigint signed,
342 modify b1 bigint unsigned, modify b2 bigint unsigned, modify ub1 bigint signed;
343 INSERT INTO t1 VALUES(
344 -128, 127, 255,
345 -32768, 32767, 65535,
346 -8388608, 8388607, 16777215,
347 -2147483648, 2147483647, 4294967295,
348 -9223372036854775808, 9223372036854775807, 18446744073709551615
349 );
350 --enable_warnings
351 SELECT * FROM t1;
352
353 # create a MyISAM table from NDB table, against which to compare data
354 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
355
356 # restore table
357 DELETE FROM t1;
358 --exec $restore_cmd -n 1 --print -L > /dev/null
359 --exec $restore_cmd -n 2 --print -L > /dev/null
360 SELECT * FROM t1;
361
362 # verify data
363 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
364 DROP TABLE t1_myisam;
365
366 --echo ************************************************************
367 --echo * Restoring table with changed signedness + 4th degree promoted types:
368 --echo * tinyint unsigned/signed --> bigint signed/unsigned
369 --echo * smallint unsigned/signed --> bigint signed/unsigned
370 --echo * mediumint unsigned/signed --> bigint signed/unsigned
371 --echo * int unsigned/signed --> bigint signed/unsigned
372 --echo * bigint unsigned/signed --> bigint signed/unsigned
373 --echo ************************************************************
374
375 # convert signedness of integral type attibutes
376 --disable_warnings
377 DELETE FROM t1;
378 ALTER TABLE t1
379 modify t1 bigint unsigned, modify t2 bigint unsigned, modify ut1 bigint signed,
380 modify s1 bigint unsigned, modify s2 bigint unsigned, modify us1 bigint signed,
381 modify m1 bigint unsigned, modify m2 bigint unsigned, modify um1 bigint signed,
382 modify i1 bigint unsigned, modify i2 bigint unsigned, modify ui1 bigint signed,
383 modify b1 bigint unsigned, modify b2 bigint unsigned, modify ub1 bigint signed;
384 INSERT INTO t1 VALUES(
385 -128, 127, 255,
386 -32768, 32767, 65535,
387 -8388608, 8388607, 16777215,
388 -2147483648, 2147483647, 4294967295,
389 -9223372036854775808, 9223372036854775807, 18446744073709551615
390 );
391 --enable_warnings
392 SELECT * FROM t1;
393
394 # create a MyISAM table from NDB table, against which to compare data
395 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
396
397 # restore table
398 DELETE FROM t1;
399 --exec $restore_cmd -n 1 --print -L > /dev/null
400 --exec $restore_cmd -n 2 --print -L > /dev/null
401 SELECT * FROM t1;
402
403 # verify data
404 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
405 DROP TABLE t1_myisam;
406
407 --echo ************************************************************
408 --echo * Restoring table with changed signedness + 1st degree demoted types:
409 --echo * tinyint unsigned/signed --> tinyint signed/unsigned
410 --echo * smallint unsigned/signed --> tinyint signed/unsigned
411 --echo * mediumint unsigned/signed --> smallint signed/unsigned
412 --echo * int unsigned/signed --> mediumint signed/unsigned
413 --echo * bigint unsigned/signed --> int signed/unsigned
414 --echo ************************************************************
415
416 # convert signedness of integral type attibutes
417 --disable_warnings
418 DELETE FROM t1;
419 ALTER TABLE t1
420 modify t1 tinyint unsigned, modify t2 tinyint unsigned, modify ut1 tinyint signed,
421 modify s1 tinyint unsigned, modify s2 tinyint unsigned, modify us1 tinyint signed,
422 modify m1 smallint unsigned, modify m2 smallint unsigned, modify um1 smallint signed,
423 modify i1 mediumint unsigned, modify i2 mediumint unsigned, modify ui1 mediumint signed,
424 modify b1 int unsigned, modify b2 int unsigned, modify ub1 int signed;
425 INSERT INTO t1 VALUES(
426 -128, 127, 255,
427 -32768, 32767, 65535,
428 -8388608, 8388607, 16777215,
429 -2147483648, 2147483647, 4294967295,
430 -9223372036854775808, 9223372036854775807, 18446744073709551615
431 );
432 --enable_warnings
433 SELECT * FROM t1;
434
435 # create a MyISAM table from NDB table, against which to compare data
436 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
437
438 # restore table
439 DELETE FROM t1;
440 --exec $restore_cmd -n 1 --print -L > /dev/null
441 --exec $restore_cmd -n 2 --print -L > /dev/null
442 SELECT * FROM t1;
443
444 # verify data
445 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
446 DROP TABLE t1_myisam;
447
448 --echo ************************************************************
449 --echo * Restoring table with changed signedness + 2nd degree demoted types:
450 --echo * tinyint unsigned/signed --> tinyint signed/unsigned
451 --echo * smallint unsigned/signed --> tinyint signed/unsigned
452 --echo * mediumint unsigned/signed --> tinyint signed/unsigned
453 --echo * int unsigned/signed --> smallint signed/unsigned
454 --echo * bigint unsigned/signed --> mediumint signed/unsigned
455 --echo ************************************************************
456
457 # convert signedness of integral type attibutes
458 --disable_warnings
459 DELETE FROM t1;
460 ALTER TABLE t1
461 modify t1 tinyint unsigned, modify t2 tinyint unsigned, modify ut1 tinyint signed,
462 modify s1 tinyint unsigned, modify s2 tinyint unsigned, modify us1 tinyint signed,
463 modify m1 tinyint unsigned, modify m2 tinyint unsigned, modify um1 tinyint signed,
464 modify i1 smallint unsigned, modify i2 smallint unsigned, modify ui1 smallint signed,
465 modify b1 mediumint unsigned, modify b2 mediumint unsigned, modify ub1 mediumint signed;
466 INSERT INTO t1 VALUES(
467 -128, 127, 255,
468 -32768, 32767, 65535,
469 -8388608, 8388607, 16777215,
470 -2147483648, 2147483647, 4294967295,
471 -9223372036854775808, 9223372036854775807, 18446744073709551615
472 );
473 --enable_warnings
474 SELECT * FROM t1;
475
476 # create a MyISAM table from NDB table, against which to compare data
477 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
478
479 # restore table
480 DELETE FROM t1;
481 --exec $restore_cmd -n 1 --print -L > /dev/null
482 --exec $restore_cmd -n 2 --print -L > /dev/null
483 SELECT * FROM t1;
484
485 # verify data
486 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
487 DROP TABLE t1_myisam;
488
489 --echo ************************************************************
490 --echo * Restoring table with changed signedness + 3rd degree demoted types:
491 --echo * tinyint unsigned/signed --> tinyint signed/unsigned
492 --echo * smallint unsigned/signed --> tinyint signed/unsigned
493 --echo * mediumint unsigned/signed --> tinyint signed/unsigned
494 --echo * int unsigned/signed --> tinyint signed/unsigned
495 --echo * bigint unsigned/signed --> smallint signed/unsigned
496 --echo ************************************************************
497
498 # convert signedness of integral type attibutes
499 --disable_warnings
500 DELETE FROM t1;
501 ALTER TABLE t1
502 modify t1 tinyint unsigned, modify t2 tinyint unsigned, modify ut1 tinyint signed,
503 modify s1 tinyint unsigned, modify s2 tinyint unsigned, modify us1 tinyint signed,
504 modify m1 tinyint unsigned, modify m2 tinyint unsigned, modify um1 tinyint signed,
505 modify i1 tinyint unsigned, modify i2 tinyint unsigned, modify ui1 tinyint signed,
506 modify b1 smallint unsigned, modify b2 smallint unsigned, modify ub1 smallint signed;
507 INSERT INTO t1 VALUES(
508 -128, 127, 255,
509 -32768, 32767, 65535,
510 -8388608, 8388607, 16777215,
511 -2147483648, 2147483647, 4294967295,
512 -9223372036854775808, 9223372036854775807, 18446744073709551615
513 );
514 --enable_warnings
515 SELECT * FROM t1;
516
517 # create a MyISAM table from NDB table, against which to compare data
518 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
519
520 # restore table
521 DELETE FROM t1;
522 --exec $restore_cmd -n 1 --print -L > /dev/null
523 --exec $restore_cmd -n 2 --print -L > /dev/null
524 SELECT * FROM t1;
525
526 # verify data
527 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
528 DROP TABLE t1_myisam;
529
530 --echo ************************************************************
531 --echo * Restoring table with changed signedness + 4th degree demoted types:
532 --echo * tinyint unsigned/signed --> tinyint signed/unsigned
533 --echo * smallint unsigned/signed --> tinyint signed/unsigned
534 --echo * mediumint unsigned/signed --> tinyint signed/unsigned
535 --echo * int unsigned/signed --> tinyint signed/unsigned
536 --echo * bigint unsigned/signed --> tinyint signed/unsigned
537 --echo ************************************************************
538
539 # convert signedness of integral type attibutes
540 --disable_warnings
541 DELETE FROM t1;
542 ALTER TABLE t1
543 modify t1 tinyint unsigned, modify t2 tinyint unsigned, modify ut1 tinyint signed,
544 modify s1 tinyint unsigned, modify s2 tinyint unsigned, modify us1 tinyint signed,
545 modify m1 tinyint unsigned, modify m2 tinyint unsigned, modify um1 tinyint signed,
546 modify i1 tinyint unsigned, modify i2 tinyint unsigned, modify ui1 tinyint signed,
547 modify b1 tinyint unsigned, modify b2 tinyint unsigned, modify ub1 tinyint signed;
548 INSERT INTO t1 VALUES(
549 -128, 127, 255,
550 -32768, 32767, 65535,
551 -8388608, 8388607, 16777215,
552 -2147483648, 2147483647, 4294967295,
553 -9223372036854775808, 9223372036854775807, 18446744073709551615
554 );
555 --enable_warnings
556 SELECT * FROM t1;
557
558 # create a MyISAM table from NDB table, against which to compare data
559 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
560
561 # restore table
562 DELETE FROM t1;
563 --exec $restore_cmd -n 1 --print -L > /dev/null
564 --exec $restore_cmd -n 2 --print -L > /dev/null
565 SELECT * FROM t1;
566
567 # verify data
568 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
569 DROP TABLE t1_myisam;
570
571 --echo ************************************************************
572 --echo * Deleting table with integral types
573 --echo ************************************************************
574
575 DROP TABLE t1;
576
577 --source suite/ndb/include/restore_sql_mode_after_turn_off_strict.inc
578 --source suite/ndb/include/backup_restore_cleanup.inc
579 --remove_file $NDB_TOOLS_OUTPUT