Debian Codegraph @

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

raw
1 --source include/have_multi_ndb.inc
2 --source suite/ndb/include/backup_restore_setup.inc
3
4 #
5 # The table structure is as follows:
6 # CREATE TABLE t1 (
7 # a INT PRIMARY KEY,
8 # b VARCHAR(30)
9 # ) ENGINE NDB;
10 #
11 # INSERT INTO t1 VALUES
12 # (1, 'a'),
13 # (2, 'bb'),
14 # (3, 'ccc');
15
16 --exec $NDB_RESTORE $NDB_RESTORE_NO_ENCR -b 1 -n 1 -m -r --disable-indexes $NDB_SAVED_BACKUPS/metadata_upgrade_basic_backup >> $NDB_TOOLS_OUTPUT
17 --exec $NDB_RESTORE $NDB_RESTORE_NO_ENCR -b 1 -n 2 -r $NDB_SAVED_BACKUPS/metadata_upgrade_basic_backup >> $NDB_TOOLS_OUTPUT
18 --exec $NDB_RESTORE $NDB_RESTORE_NO_ENCR -b 1 -n 1 --rebuild-indexes $NDB_SAVED_BACKUPS/metadata_upgrade_basic_backup >> $NDB_TOOLS_OUTPUT
19
20 --echo Backup restored
21
22 # Test upgrade of the metadata during schema synchronization
23 --echo Restart server 1 to trigger schema synchronization
24 let $mysqld_name=mysqld.1.1;
25 --source include/restart_mysqld.inc
26
27 connection server2;
28 --echo Restart server 2 to trigger schema synchronization
29 let $mysqld_name=mysqld.2.1;
30 --source include/restart_mysqld.inc
31
32 connection server1;
33 SHOW CREATE TABLE t1;
34 --sorted_result
35 SELECT * FROM t1;
36
37 ALTER TABLE t1 DROP COLUMN b;
38 INSERT INTO t1 values (4),(5);
39 --sorted_result
40 SELECT * FROM t1;
41
42 DROP TABLE t1;
43
44 --exec $NDB_RESTORE $NDB_RESTORE_NO_ENCR -b 1 -n 1 -m -r --disable-indexes $NDB_SAVED_BACKUPS/metadata_upgrade_basic_backup >> $NDB_TOOLS_OUTPUT
45 --exec $NDB_RESTORE $NDB_RESTORE_NO_ENCR -b 1 -n 2 -r $NDB_SAVED_BACKUPS/metadata_upgrade_basic_backup >> $NDB_TOOLS_OUTPUT
46 --exec $NDB_RESTORE $NDB_RESTORE_NO_ENCR -b 1 -n 1 --rebuild-indexes $NDB_SAVED_BACKUPS/metadata_upgrade_basic_backup >> $NDB_TOOLS_OUTPUT
47
48 # Test upgrade of the metadata during discovery from NDB
49 SHOW CREATE TABLE t1;
50 --sorted_result
51 SELECT * FROM t1;
52
53 ALTER TABLE t1 DROP COLUMN b;
54
55 INSERT INTO t1 values (4),(5);
56 --sorted_result
57 SELECT * FROM t1;
58
59 DROP TABLE t1;
60
61 # Test upgrade of the metadata during automatic sync
62
63 --exec $NDB_RESTORE $NDB_RESTORE_NO_ENCR -b 1 -n 1 -m -r --disable-indexes $NDB_SAVED_BACKUPS/metadata_upgrade_basic_backup >> $NDB_TOOLS_OUTPUT
64 --exec $NDB_RESTORE $NDB_RESTORE_NO_ENCR -b 1 -n 2 -r $NDB_SAVED_BACKUPS/metadata_upgrade_basic_backup >> $NDB_TOOLS_OUTPUT
65 --exec $NDB_RESTORE $NDB_RESTORE_NO_ENCR -b 1 -n 1 --rebuild-indexes $NDB_SAVED_BACKUPS/metadata_upgrade_basic_backup >> $NDB_TOOLS_OUTPUT
66
67 # Wait until the changes have been synced
68 --let $max_wait = 60
69 --source wait_immediate_metadata_sync.inc
70
71 --sorted_result
72 SELECT * FROM t1;
73
74 ALTER TABLE t1 DROP COLUMN b;
75
76 INSERT INTO t1 values (4),(5);
77 --sorted_result
78 SELECT * FROM t1;
79
80 DROP TABLE t1;
81
82 --remove_file $NDB_TOOLS_OUTPUT