Debian Codegraph @

mysql-test/suite/ndb_ddl/metadata_immediate_sync.result

raw
1 CREATE LOGFILE GROUP lg1
2 ADD UNDOFILE 'lg1_undofile.dat'
3 INITIAL_SIZE 1M
4 UNDO_BUFFER_SIZE = 1M
5 ENGINE NDB;
6 CREATE TABLESPACE ts1
7 ADD DATAFILE 'ts1_datafile.dat'
8 USE LOGFILE GROUP lg1
9 INITIAL_SIZE 2M
10 ENGINE NDB;
11 USE ndb_ddl_test;
12 CREATE TABLE t10 (
13 a INT PRIMARY KEY,
14 b VARCHAR(255)
15 ) ENGINE NDB
16 TABLESPACE ts1
17 STORAGE DISK;
18 INSERT INTO t10 VALUES(1, 'Beggars can\'t be choosers');
19 CREATE DATABASE ndb_ddl_test3;
20 USE ndb_ddl_test3;
21 CREATE TABLE t1 (
22 a INT,
23 b INT,
24 PRIMARY KEY(a,b)
25 ) ENGINE NDB;
26 CREATE TABLE t2(
27 a INT PRIMARY KEY,
28 b VARCHAR(255)
29 ) ENGINE NDB;
30 CREATE DATABASE ndb_ddl_test4;
31 USE ndb_ddl_test4;
32 CREATE TABLE t1 (
33 a INT,
34 b INT,
35 PRIMARY KEY(a,b)
36 ) ENGINE NDB;
37 CREATE TABLE t2(
38 a INT PRIMARY KEY,
39 b VARCHAR(255)
40 ) ENGINE NDB;
41 CREATE DATABASE ndb_ddl_test5;
42 USE ndb_ddl_test5;
43 CREATE TABLE t1 (
44 a INT,
45 b INT,
46 PRIMARY KEY(a,b)
47 ) ENGINE NDB;
48 USE ndb_ddl_test;
49 DROP TABLE t6;
50 DROP TABLE t7;
51 DROP TABLE t8;
52 DROP TABLE t9;
53 DROP TABLE t10;
54 ALTER TABLESPACE ts1
55 DROP DATAFILE 'ts1_datafile.dat';
56 DROP TABLESPACE ts1;
57 DROP LOGFILE GROUP lg1
58 ENGINE NDB;
59 USE ndb_ddl_test3;
60 DROP TABLE t1;
61 DROP TABLE t2;
62 SET GLOBAL ndb_metadata_sync = true;
63 SHOW DATABASES;
64 Database
65 information_schema
66 mtr
67 mysql
68 ndb_ddl_test
69 ndb_ddl_test2
70 ndb_ddl_test3
71 ndb_ddl_test4
72 ndb_ddl_test5
73 ndbinfo
74 performance_schema
75 sys
76 test
77 USE ndb_ddl_test;
78 SHOW TABLES;
79 Tables_in_ndb_ddl_test
80 t1
81 t10
82 t2
83 t3
84 t4
85 t5
86 t6
87 t7
88 t8
89 t9
90 USE ndb_ddl_test3;
91 SHOW TABLES;
92 Tables_in_ndb_ddl_test3
93 t1
94 t2
95 USE ndb_ddl_test4;
96 SHOW TABLES;
97 Tables_in_ndb_ddl_test4
98 t2
99 USE ndb_ddl_test5;
100 SHOW TABLES;
101 Tables_in_ndb_ddl_test5
102 SELECT * FROM ndb_ddl_test.t6;
103 a
104 value1
105 value2
106 value3
107 value4
108 value5
109 SELECT * FROM ndb_ddl_test.t8;
110 a b c d e
111 1 1-t8 2017-10-20 09:13:01 NULL 1
112 2 2-t8 2017-10-20 09:13:02 NULL 2
113 3 3-t8 2017-10-20 09:13:03 NULL 3
114 4 4-t8 2017-10-20 09:13:04 NULL 4
115 5 5-t8 2017-10-20 09:13:05 NULL 5
116 SELECT * FROM ndb_ddl_test.t10;
117 a b
118 1 Beggars can't be choosers
119 ALTER TABLE ndb_ddl_test3.t1
120 ADD COLUMN c VARCHAR(255);
121 Warnings:
122 Warning 1478 Converted FIXED field 'c' to DYNAMIC to enable online ADD COLUMN
123 INSERT INTO ndb_ddl_test3.t1 VALUES(1, 1, 'Donkey\'s praise');
124 SELECT * FROM ndb_ddl_test3.t1;
125 a b c
126 1 1 Donkey's praise
127 SHOW CREATE TABLE ndb_ddl_test4.t1;
128 ERROR 42S02: Table 'ndb_ddl_test4.t1' doesn't exist
129 SHOW CREATE TABLE ndb_ddl_test5.t1;
130 ERROR 42S02: Table 'ndb_ddl_test5.t1' doesn't exist
131 CREATE TABLESPACE ts2
132 ADD DATAFILE 'ts2_datafile.dat'
133 USE LOGFILE GROUP lg1
134 INITIAL_SIZE 2M
135 ENGINE NDB;
136 ALTER TABLESPACE ts1
137 ADD DATAFILE 'ts1_datafile2.dat';
138 CREATE TABLE ndb_ddl_test4.t1 (
139 a INT PRIMARY KEY,
140 b INT
141 ) ENGINE NDB;
142 INSERT INTO ndb_ddl_test4.t1 VALUES(1,1);
143 SELECT * FROM ndb_ddl_test4.t1;
144 a b
145 1 1
146 DROP DATABASE ndb_ddl_test3;
147 DROP DATABASE ndb_ddl_test4;
148 DROP DATABASE ndb_ddl_test5;
149 ALTER TABLESPACE ts1
150 DROP DATAFILE 'ts1_datafile.dat';
151 ALTER TABLESPACE ts1
152 DROP DATAFILE 'ts1_datafile2.dat';
153 DROP TABLESPACE ts1;
154 ALTER TABLESPACE ts2
155 DROP DATAFILE 'ts2_datafile.dat';
156 DROP TABLESPACE ts2;
157 DROP LOGFILE GROUP lg1
158 ENGINE NDB;
159 CREATE DATABASE db1;
160 USE db1;
161 CREATE TABLE t1_ndb (
162 a INT PRIMARY KEY,
163 b INT
164 ) ENGINE NDB;
165 CREATE TABLE t2_ndb (
166 a INT PRIMARY KEY,
167 b VARCHAR(255)
168 ) ENGINE NDB;
169 CREATE DATABASE db2;
170 USE db2;
171 CREATE TABLE t1_ndb (
172 a INT PRIMARY KEY,
173 b INT
174 ) ENGINE NDB;
175 CREATE TABLE t2_ndb (
176 a INT PRIMARY KEY,
177 b VARCHAR(255)
178 ) ENGINE NDB;
179 CREATE DATABASE db3;
180 USE db3;
181 CREATE TABLE t1_innodb (
182 a INT PRIMARY KEY,
183 b INT
184 );
185 CREATE TABLE t2_innodb (
186 a INT PRIMARY KEY,
187 b VARCHAR(255)
188 );
189 CREATE DATABASE db4;
190 USE db4;
191 CREATE TABLE t1_ndb (
192 a INT PRIMARY KEY,
193 b INT
194 ) ENGINE NDB;
195 CREATE TABLE t2_ndb (
196 a INT PRIMARY KEY,
197 b VARCHAR(255)
198 ) ENGINE NDB;
199 CREATE TABLE t1_innodb (
200 a INT PRIMARY KEY,
201 b INT
202 );
203 CREATE TABLE t2_innodb (
204 a INT PRIMARY KEY,
205 b VARCHAR(255)
206 );
207 DROP DATABASE db1;
208 DROP DATABASE db4;
209 SET GLOBAL ndb_metadata_sync = true;
210 SHOW DATABASES LIKE 'db%';
211 Database (db%)
212 db1
213 db2
214 db3
215 db4
216 USE db1;
217 SHOW TABLES;
218 Tables_in_db1
219 t1_ndb
220 t2_ndb
221 SHOW CREATE TABLE t1_ndb;
222 Table Create Table
223 t1_ndb CREATE TABLE `t1_ndb` (
224 `a` int NOT NULL,
225 `b` int DEFAULT NULL,
226 PRIMARY KEY (`a`)
227 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
228 SHOW CREATE TABLE t2_ndb;
229 Table Create Table
230 t2_ndb CREATE TABLE `t2_ndb` (
231 `a` int NOT NULL,
232 `b` varchar(255) DEFAULT NULL,
233 PRIMARY KEY (`a`)
234 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
235 USE db2;
236 SHOW TABLES;
237 Tables_in_db2
238 t1_ndb
239 t2_ndb
240 USE db3;
241 SHOW TABLES;
242 Tables_in_db3
243 t1_innodb
244 t2_innodb
245 USE db4;
246 SHOW TABLES;
247 Tables_in_db4
248 t1_ndb
249 t2_ndb
250 SHOW CREATE TABLE t1_ndb;
251 Table Create Table
252 t1_ndb CREATE TABLE `t1_ndb` (
253 `a` int NOT NULL,
254 `b` int DEFAULT NULL,
255 PRIMARY KEY (`a`)
256 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
257 SHOW CREATE TABLE t2_ndb;
258 Table Create Table
259 t2_ndb CREATE TABLE `t2_ndb` (
260 `a` int NOT NULL,
261 `b` varchar(255) DEFAULT NULL,
262 PRIMARY KEY (`a`)
263 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
264 DROP DATABASE db1;
265 DROP DATABASE db2;
266 DROP DATABASE db3;
267 DROP DATABASE db4;
268 USE test;
269 CREATE TABLE t1 (
270 a INT PRIMARY KEY,
271 b INT NOT NULL,
272 c INT NOT NULL,
273 UNIQUE ib(b),
274 INDEX ic(c)
275 ) ENGINE NDB;
276 INSERT INTO t1 VALUES (1,2,3),(2,3,5),(3,4,6),(4,5,8),(5,6,2),(6,7,2);
277 CREATE TABLE parent (
278 c1 INT PRIMARY KEY
279 ) ENGINE NDB;
280 INSERT INTO parent VALUES (1),(2);
281 CREATE TABLE child (
282 c1 INT PRIMARY KEY,
283 c2 INT,
284 INDEX xc2(c2),
285 FOREIGN KEY(c2)
286 REFERENCES parent(c1)
287 ON DELETE CASCADE
288 ) ENGINE NDB;
289 INSERT INTO child VALUES (1,1),(2,2);
290 Backup
291 DROP TABLE t1,child,parent;
292 Restore with --disable-indexes
293 SET GLOBAL ndb_metadata_sync = true;
294 SELECT schema_name, name, type FROM performance_schema.ndb_sync_excluded_objects;
295 schema_name name type
296 test child TABLE
297 test parent TABLE
298 test t1 TABLE
299 Rebuild indexes in NDB
300 Retry sync now that the indexes have been created
301 SET GLOBAL ndb_metadata_sync = true;
302 SHOW TABLES;
303 Tables_in_test
304 child
305 parent
306 t1
307 SELECT * FROM t1;
308 a b c
309 1 2 3
310 2 3 5
311 3 4 6
312 4 5 8
313 5 6 2
314 6 7 2
315 SELECT * FROM parent;
316 c1
317 1
318 2
319 SELECT * FROM child;
320 c1 c2
321 1 1
322 2 2
323 SELECT COUNT(*) FROM performance_schema.ndb_sync_excluded_objects;
324 COUNT(*)
325 0
326 DROP TABLE t1,child,parent;
327 SET @old_foreign_key_checks = @@foreign_key_checks;
328 SET foreign_key_checks=0;
329 CREATE TABLE child (
330 c1 INT PRIMARY KEY,
331 c2 INT,
332 INDEX xc2(c2),
333 FOREIGN KEY(c2)
334 REFERENCES parent(c1)
335 ON DELETE CASCADE
336 ) ENGINE NDB;
337 INSERT INTO child VALUES (1,1),(2,2);
338 SET GLOBAL ndb_metadata_sync = true;
339 SELECT CASE COUNT(*) WHEN 0 THEN 'YES' ELSE 'NO' END AS mock_tables_sync_skipped
340 FROM performance_schema.ndb_sync_excluded_objects;
341 mock_tables_sync_skipped
342 YES
343 DROP TABLE child;
344 SET foreign_key_checks = @old_foreign_key_checks;