Debian Codegraph @

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

raw
1 #############################################################
2 # Author: Guangbao
3 # Date: 2007-10-31
4 # Purpose: mix backup/restore test for basic online alter table
5 ##############################################################
6
7 --source include/have_multi_ndb.inc
8 --source suite/ndb/include/backup_restore_setup.inc
9
10 ##############################
11 # mix endian restore section #
12 ##############################
13 #
14 # Restore backup files (from little endian)
15 #
16 --echo *********************************
17 --echo * restore tables w/ new column from little endian
18 --echo *********************************
19 --exec $NDB_RESTORE $NDB_RESTORE_NO_ENCR -b 1 -n 1 -m -r $NDB_SAVED_BACKUPS/51_d2_le >> $NDB_TOOLS_OUTPUT 2>&1
20 --exec $NDB_RESTORE $NDB_RESTORE_NO_ENCR -b 1 -n 2 -r $NDB_SAVED_BACKUPS/51_d2_le >> $NDB_TOOLS_OUTPUT 2>&1
21
22 --disable_query_log
23 call mtr.add_suppression("Table upgrade required");
24 call mtr.add_suppression("Table definition contains obsolete data types");
25 call mtr.add_suppression("Failed to create entry in DD");
26 call mtr.add_suppression("Failed to install table");
27 --connection server2
28 call mtr.add_suppression("Table upgrade required");
29 call mtr.add_suppression("Table definition contains obsolete data types");
30 call mtr.add_suppression("Failed to create entry in DD");
31 call mtr.add_suppression("Failed to install table");
32 --enable_query_log
33 --connection server1
34
35 --error ER_NO_SUCH_TABLE
36 SHOW CREATE TABLE t1;
37 SHOW WARNINGS;
38 --exec $NDB_DROP_TABLE -d test t1 >> $NDB_TOOLS_OUTPUT
39
40 #
41 # Restore backup files (from big endian)
42 #
43 --echo *********************************
44 --echo * restore tables w/ new column from big endian
45 --echo *********************************
46 --exec $NDB_RESTORE $NDB_RESTORE_NO_ENCR -b 1 -n 1 -m -r $NDB_SAVED_BACKUPS/51_d2_be >> $NDB_TOOLS_OUTPUT 2>&1
47 --exec $NDB_RESTORE $NDB_RESTORE_NO_ENCR -b 1 -n 2 -r $NDB_SAVED_BACKUPS/51_d2_be >> $NDB_TOOLS_OUTPUT 2>&1
48
49 --error ER_NO_SUCH_TABLE
50 SHOW CREATE TABLE t1;
51 SHOW WARNINGS;
52
53 --exec $NDB_DROP_TABLE -d test t1 >> $NDB_TOOLS_OUTPUT
54 --remove_file $NDB_TOOLS_OUTPUT