| 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; |