Debian Codegraph @

mysql-test/suite/ndb_ddl/metadata_sync_restore_disable_index.result

raw
1 CREATE TABLE t1 (
2 a INT PRIMARY KEY,
3 b INT NOT NULL,
4 c INT NOT NULL,
5 UNIQUE ib(b),
6 INDEX ic(c)
7 ) ENGINE NDB;
8 INSERT INTO t1 VALUES (1,2,3),(2,3,5),(3,4,6),(4,5,8),(5,6,2),(6,7,2);
9 CREATE TABLE parent (
10 c1 INT PRIMARY KEY
11 ) ENGINE NDB;
12 INSERT INTO parent VALUES (1),(2);
13 CREATE TABLE child (
14 c1 INT PRIMARY KEY,
15 c2 INT,
16 INDEX xc2(c2),
17 FOREIGN KEY(c2)
18 REFERENCES parent(c1)
19 ON DELETE CASCADE
20 ) ENGINE NDB;
21 INSERT INTO child VALUES (1,1),(2,2);
22 DROP TABLE t1,child,parent;
23 Restore with --disable-indexes
24 include/assert.inc [Synced count has remained unchanged]
25 SHOW TABLES;
26 Tables_in_test
27 Rebuild indexes in NDB
28 Wait until the objects are synced
29 SHOW TABLES;
30 Tables_in_test
31 child
32 parent
33 t1
34 SHOW CREATE TABLE t1;
35 Table Create Table
36 t1 CREATE TABLE `t1` (
37 `a` int NOT NULL,
38 `b` int NOT NULL,
39 `c` int NOT NULL,
40 PRIMARY KEY (`a`),
41 UNIQUE KEY `ib` (`b`),
42 KEY `ic` (`c`)
43 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
44 SELECT * FROM t1;
45 a b c
46 1 2 3
47 2 3 5
48 3 4 6
49 4 5 8
50 5 6 2
51 6 7 2
52 SHOW CREATE TABLE parent;
53 Table Create Table
54 parent CREATE TABLE `parent` (
55 `c1` int NOT NULL,
56 PRIMARY KEY (`c1`)
57 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
58 SELECT * FROM parent;
59 c1
60 1
61 2
62 SHOW CREATE TABLE child;
63 Table Create Table
64 child CREATE TABLE `child` (
65 `c1` int NOT NULL,
66 `c2` int DEFAULT NULL,
67 PRIMARY KEY (`c1`),
68 KEY `xc2` (`c2`),
69 CONSTRAINT `child_fk_1` FOREIGN KEY (`c2`) REFERENCES `parent` (`c1`) ON DELETE CASCADE
70 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
71 SELECT * FROM child;
72 c1 c2
73 1 1
74 2 2
75 DROP TABLE t1,child,parent;