Debian Codegraph @

mysql-test/suite/ndb_ddl/rename_multi.result

raw
1 RENAME TABLE t1 to t1_new_name, t3 to ndb_ddl_test2.t3, t4 to ndb_ddl_test2.t4_new_name;
2 == verify_mysql_dd.inc ==
3 USE ndb_ddl_test;
4 RENAME TABLE t5 to t50, t2 to t2;
5 ERROR 42S01: Table 't2' already exists
6 == verify_mysql_dd.inc ==
7 USE ndb_ddl_test;
8 SHOW CREATE TABLE t2;
9 Table Create Table
10 t2 CREATE TABLE `t2` (
11 `a` int NOT NULL,
12 `b` varchar(255) DEFAULT NULL,
13 `c` datetime DEFAULT NULL,
14 PRIMARY KEY (`a`),
15 KEY `b` (`b`),
16 KEY `b_2` (`b`,`c`)
17 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
18 SHOW CREATE TABLE t5;
19 Table Create Table
20 t5 CREATE TABLE `t5` (
21 `a` int NOT NULL,
22 `b` int NOT NULL,
23 `c` int NOT NULL,
24 `d` int NOT NULL,
25 `e` int DEFAULT NULL,
26 PRIMARY KEY (`c`,`b`,`a`,`d`),
27 KEY `d` (`d`),
28 KEY `c` (`c`)
29 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
30 RENAME TABLE t2 to t2_temp_name, t5 to t2, t2_temp_name to t5;
31 SHOW CREATE TABLE t2;
32 Table Create Table
33 t2 CREATE TABLE `t2` (
34 `a` int NOT NULL,
35 `b` int NOT NULL,
36 `c` int NOT NULL,
37 `d` int NOT NULL,
38 `e` int DEFAULT NULL,
39 PRIMARY KEY (`c`,`b`,`a`,`d`),
40 KEY `d` (`d`),
41 KEY `c` (`c`)
42 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
43 SHOW CREATE TABLE t5;
44 Table Create Table
45 t5 CREATE TABLE `t5` (
46 `a` int NOT NULL,
47 `b` varchar(255) DEFAULT NULL,
48 `c` datetime DEFAULT NULL,
49 PRIMARY KEY (`a`),
50 KEY `b` (`b`),
51 KEY `b_2` (`b`,`c`)
52 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
53 == verify_mysql_dd.inc ==
54 USE ndb_ddl_test;
55 RENAME TABLE t5 to t50, t50 to t500, t500 to t2;
56 ERROR 42S01: Table 't2' already exists
57 SHOW CREATE TABLE t2;
58 Table Create Table
59 t2 CREATE TABLE `t2` (
60 `a` int NOT NULL,
61 `b` int NOT NULL,
62 `c` int NOT NULL,
63 `d` int NOT NULL,
64 `e` int DEFAULT NULL,
65 PRIMARY KEY (`c`,`b`,`a`,`d`),
66 KEY `d` (`d`),
67 KEY `c` (`c`)
68 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
69 SHOW CREATE TABLE t5;
70 Table Create Table
71 t5 CREATE TABLE `t5` (
72 `a` int NOT NULL,
73 `b` varchar(255) DEFAULT NULL,
74 `c` datetime DEFAULT NULL,
75 PRIMARY KEY (`a`),
76 KEY `b` (`b`),
77 KEY `b_2` (`b`,`c`)
78 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
79 == verify_mysql_dd.inc ==