Debian Codegraph @

mysql-test/suite/engines/funcs/r/tc_structure_create_select_string.result

raw
1 DROP TABLE IF EXISTS src,dest;
2 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 CHAR(10) NULL, PRIMARY KEY(c1));
3 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
4 SHOW TABLES;
5 Tables_in_test
6 dst
7 src
8 SHOW CREATE TABLE dst;
9 Table Create Table
10 dst CREATE TABLE `dst` (
11 `c1` int NOT NULL AUTO_INCREMENT,
12 `c2` char(10) DEFAULT NULL,
13 PRIMARY KEY (`c1`)
14 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
15 DROP TABLE dst;
16 SHOW TABLES;
17 Tables_in_test
18 src
19 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
20 SHOW TABLES;
21 Tables_in_test
22 dst
23 src
24 SHOW CREATE TABLE dst;
25 Table Create Table
26 dst CREATE TABLE `dst` (
27 `c1` int NOT NULL AUTO_INCREMENT,
28 `c2` char(10) DEFAULT NULL,
29 PRIMARY KEY (`c1`)
30 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
31 DROP TABLE dst;
32 SHOW TABLES;
33 Tables_in_test
34 src
35 DROP TABLE src;
36 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 VARCHAR(10) NULL, PRIMARY KEY(c1));
37 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
38 SHOW TABLES;
39 Tables_in_test
40 dst
41 src
42 SHOW CREATE TABLE dst;
43 Table Create Table
44 dst CREATE TABLE `dst` (
45 `c1` int NOT NULL AUTO_INCREMENT,
46 `c2` varchar(10) DEFAULT NULL,
47 PRIMARY KEY (`c1`)
48 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
49 DROP TABLE dst;
50 SHOW TABLES;
51 Tables_in_test
52 src
53 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
54 SHOW TABLES;
55 Tables_in_test
56 dst
57 src
58 SHOW CREATE TABLE dst;
59 Table Create Table
60 dst CREATE TABLE `dst` (
61 `c1` int NOT NULL AUTO_INCREMENT,
62 `c2` varchar(10) DEFAULT NULL,
63 PRIMARY KEY (`c1`)
64 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
65 DROP TABLE dst;
66 SHOW TABLES;
67 Tables_in_test
68 src
69 DROP TABLE src;
70 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 BINARY(10) NULL, PRIMARY KEY(c1));
71 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
72 SHOW TABLES;
73 Tables_in_test
74 dst
75 src
76 SHOW CREATE TABLE dst;
77 Table Create Table
78 dst CREATE TABLE `dst` (
79 `c1` int NOT NULL AUTO_INCREMENT,
80 `c2` binary(10) DEFAULT NULL,
81 PRIMARY KEY (`c1`)
82 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
83 DROP TABLE dst;
84 SHOW TABLES;
85 Tables_in_test
86 src
87 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
88 SHOW TABLES;
89 Tables_in_test
90 dst
91 src
92 SHOW CREATE TABLE dst;
93 Table Create Table
94 dst CREATE TABLE `dst` (
95 `c1` int NOT NULL AUTO_INCREMENT,
96 `c2` binary(10) DEFAULT NULL,
97 PRIMARY KEY (`c1`)
98 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
99 DROP TABLE dst;
100 SHOW TABLES;
101 Tables_in_test
102 src
103 DROP TABLE src;
104 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 VARBINARY(10) NULL, PRIMARY KEY(c1));
105 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
106 SHOW TABLES;
107 Tables_in_test
108 dst
109 src
110 SHOW CREATE TABLE dst;
111 Table Create Table
112 dst CREATE TABLE `dst` (
113 `c1` int NOT NULL AUTO_INCREMENT,
114 `c2` varbinary(10) DEFAULT NULL,
115 PRIMARY KEY (`c1`)
116 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
117 DROP TABLE dst;
118 SHOW TABLES;
119 Tables_in_test
120 src
121 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
122 SHOW TABLES;
123 Tables_in_test
124 dst
125 src
126 SHOW CREATE TABLE dst;
127 Table Create Table
128 dst CREATE TABLE `dst` (
129 `c1` int NOT NULL AUTO_INCREMENT,
130 `c2` varbinary(10) DEFAULT NULL,
131 PRIMARY KEY (`c1`)
132 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
133 DROP TABLE dst;
134 SHOW TABLES;
135 Tables_in_test
136 src
137 DROP TABLE src;