Debian Codegraph @

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

raw
1 Backup from 7.5 restored
2 Restart server 1 to trigger schema synchronization
3 # restart
4 Restart server 2 to trigger schema synchronization
5 # restart
6 SHOW TABLES;
7 Tables_in_test
8 t1
9 t2
10 t3
11 SHOW CREATE TABLE t1;
12 Table Create Table
13 t1 CREATE TABLE `t1` (
14 `c1` int NOT NULL AUTO_INCREMENT,
15 `c2` int unsigned NOT NULL,
16 `c3` float DEFAULT NULL,
17 `c4` varchar(255) DEFAULT NULL,
18 `c5` time DEFAULT NULL,
19 `c6` date DEFAULT NULL,
20 `c7` datetime DEFAULT NULL,
21 `c8` blob,
22 `c9` char(30) DEFAULT NULL,
23 `c10` varbinary(255) DEFAULT NULL,
24 PRIMARY KEY (`c1`),
25 UNIQUE KEY `xc2` (`c2`)
26 ) ENGINE=ndbcluster AUTO_INCREMENT=2 DEFAULT CHARSET=latin1
27 SELECT * FROM t1;
28 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10
29 1 1 2.5 a 23:59:59 2018-01-30 2018-01-30 13:46:00 b c d
30 ALTER TABLE t1 DROP COLUMN c9;
31 INSERT INTO t1 VALUES (2,2,2.5,'a','23:59:59','2018-01-30','2018-01-30 13:46:00','b','d');
32 SELECT * FROM t1;
33 c1 c2 c3 c4 c5 c6 c7 c8 c10
34 1 1 2.5 a 23:59:59 2018-01-30 2018-01-30 13:46:00 b d
35 2 2 2.5 a 23:59:59 2018-01-30 2018-01-30 13:46:00 b d
36 DROP TABLE t1;
37 SHOW CREATE TABLE t2;
38 Table Create Table
39 t2 CREATE TABLE `t2` (
40 `c1` int NOT NULL,
41 `c2` int GENERATED ALWAYS AS ((`c1` * `c1`)) VIRTUAL,
42 PRIMARY KEY (`c1`)
43 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1
44 SELECT * FROM t2;
45 c1 c2
46 2 4
47 ALTER TABLE t2 RENAME t4;
48 INSERT INTO t4(c1) VALUES (3);
49 SELECT * FROM t4;
50 c1 c2
51 2 4
52 3 9
53 DROP TABLE t4;
54 SHOW CREATE TABLE t3;
55 Table Create Table
56 t3 CREATE TABLE `t3` (
57 `c1` int NOT NULL AUTO_INCREMENT,
58 `c2` varchar(100) DEFAULT NULL,
59 `c3` varchar(100) DEFAULT NULL,
60 PRIMARY KEY (`c1`)
61 ) ENGINE=ndbcluster AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='NDB_TABLE=READ_BACKUP=0,PARTITION_BALANCE=FOR_RP_BY_NODE'
62 SELECT * FROM t3;
63 c1 c2 c3
64 1 a a
65 ALTER TABLE t3 ALGORITHM=COPY, ADD COLUMN c4 int;
66 INSERT INTO t3 VALUES (2,'b','b',2);
67 SELECT * FROM t3;
68 c1 c2 c3 c4
69 1 a a NULL
70 2 b b 2
71 DROP TABLE t3;
72 SHOW CREATE TABLE t1;
73 Table Create Table
74 t1 CREATE TABLE `t1` (
75 `c1` int NOT NULL AUTO_INCREMENT,
76 `c2` int unsigned NOT NULL,
77 `c3` float DEFAULT NULL,
78 `c4` varchar(255) DEFAULT NULL,
79 `c5` time DEFAULT NULL,
80 `c6` date DEFAULT NULL,
81 `c7` datetime DEFAULT NULL,
82 `c8` blob,
83 `c9` char(30) DEFAULT NULL,
84 `c10` varbinary(255) DEFAULT NULL,
85 PRIMARY KEY (`c1`),
86 UNIQUE KEY `xc2` (`c2`)
87 ) ENGINE=ndbcluster AUTO_INCREMENT=2 DEFAULT CHARSET=latin1
88 SELECT * FROM t1;
89 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10
90 1 1 2.5 a 23:59:59 2018-01-30 2018-01-30 13:46:00 b c d
91 ALTER TABLE t1 DROP COLUMN c9;
92 INSERT INTO t1 VALUES (2,2,2.5,'a','23:59:59','2018-01-30','2018-01-30 13:46:00','b','d');
93 SELECT * FROM t1;
94 c1 c2 c3 c4 c5 c6 c7 c8 c10
95 1 1 2.5 a 23:59:59 2018-01-30 2018-01-30 13:46:00 b d
96 2 2 2.5 a 23:59:59 2018-01-30 2018-01-30 13:46:00 b d
97 DROP TABLE t1;
98 SHOW CREATE TABLE t2;
99 Table Create Table
100 t2 CREATE TABLE `t2` (
101 `c1` int NOT NULL,
102 `c2` int GENERATED ALWAYS AS ((`c1` * `c1`)) VIRTUAL,
103 PRIMARY KEY (`c1`)
104 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1
105 SELECT * FROM t2;
106 c1 c2
107 2 4
108 SHOW CREATE TABLE t2;
109 Table Create Table
110 t2 CREATE TABLE `t2` (
111 `c1` int NOT NULL,
112 `c2` int GENERATED ALWAYS AS ((`c1` * `c1`)) VIRTUAL,
113 PRIMARY KEY (`c1`)
114 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1
115 ALTER TABLE t2 RENAME t4;
116 INSERT INTO t4(c1) VALUES (3);
117 SELECT * FROM t4;
118 c1 c2
119 2 4
120 3 9
121 DROP TABLE t4;
122 SHOW CREATE TABLE t3;
123 Table Create Table
124 t3 CREATE TABLE `t3` (
125 `c1` int NOT NULL AUTO_INCREMENT,
126 `c2` varchar(100) DEFAULT NULL,
127 `c3` varchar(100) DEFAULT NULL,
128 PRIMARY KEY (`c1`)
129 ) ENGINE=ndbcluster AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='NDB_TABLE=READ_BACKUP=0,PARTITION_BALANCE=FOR_RP_BY_NODE'
130 SELECT * FROM t3;
131 c1 c2 c3
132 1 a a
133 ALTER TABLE t3 ALGORITHM=COPY, ADD COLUMN c4 int;
134 INSERT INTO t3 VALUES (2,'b','b',2);
135 SELECT * FROM t3;
136 c1 c2 c3 c4
137 1 a a NULL
138 2 b b 2
139 DROP TABLE t3;
140 Restore metadata and data but do not create indexes
141 Confirm that the tables haven't been synced
142 SHOW TABLES;
143 Tables_in_test
144 Rebuild indexes in NDB
145 Confirm that the tables have been synced
146 SHOW TABLES;
147 Tables_in_test
148 t1
149 t2
150 t3
151 SELECT * FROM t1;
152 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10
153 1 1 2.5 a 23:59:59 2018-01-30 2018-01-30 13:46:00 b c d
154 SELECT * FROM t2;
155 c1 c2
156 2 4
157 SELECT * FROM t3;
158 c1 c2 c3
159 1 a a
160 DROP TABLE t1,t2,t3;
161 Backup from 7.6 restored
162 Restart server 1 to trigger schema synchronization
163 # restart
164 Restart server 2 to trigger schema synchronization
165 # restart
166 SHOW TABLES;
167 Tables_in_test
168 t1
169 SHOW CREATE TABLE t1;
170 Table Create Table
171 t1 CREATE TABLE `t1` (
172 `a` int NOT NULL,
173 `b` varchar(255) DEFAULT NULL,
174 PRIMARY KEY (`a`)
175 ) /*!50100 TABLESPACE `ts1` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
176 SELECT * FROM t1;
177 a b
178 1 Sad Cypress
179 ALTER TABLE t1 DROP COLUMN b;
180 INSERT INTO t1 VALUES (2);
181 SELECT * FROM t1;
182 a
183 1
184 2
185 DROP TABLE t1;
186 ALTER TABLESPACE ts1
187 DROP DATAFILE 'ts1_datafile.dat';
188 DROP TABLESPACE ts1;
189 DROP LOGFILE GROUP lg1
190 ENGINE NDB;