Debian Codegraph @

mysql-test/suite/engines/funcs/t/tc_structure_create_select.test

raw
1 --disable_warnings
2 let $ENGINE=`select variable_value from performance_schema.global_variables where variable_name='DEFAULT_STORAGE_ENGINE'`;
3 --enable_warnings
4
5 --disable_warnings
6 DROP TABLE IF EXISTS src,dest;
7 --enable_warnings
8 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 BIT NULL, PRIMARY KEY(c1));
9 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
10 SHOW TABLES;
11 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
12 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
13 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
14 SHOW TABLES;
15 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
16 DROP TABLE src;
17 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TINYINT NULL, PRIMARY KEY(c1));
18 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
19 SHOW TABLES;
20 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
21 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
22 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
23 SHOW TABLES;
24 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
25 DROP TABLE src;
26 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 SMALLINT NULL, PRIMARY KEY(c1));
27 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
28 SHOW TABLES;
29 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
30 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
31 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
32 SHOW TABLES;
33 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
34 DROP TABLE src;
35 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 MEDIUMINT NULL, PRIMARY KEY(c1));
36 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
37 SHOW TABLES;
38 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
39 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
40 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
41 SHOW TABLES;
42 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
43 DROP TABLE src;
44 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 INT NULL, PRIMARY KEY(c1));
45 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
46 SHOW TABLES;
47 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
48 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
49 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
50 SHOW TABLES;
51 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
52 DROP TABLE src;
53 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 INTEGER NULL, PRIMARY KEY(c1));
54 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
55 SHOW TABLES;
56 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
57 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
58 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
59 SHOW TABLES;
60 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
61 DROP TABLE src;
62 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 BIGINT NULL, PRIMARY KEY(c1));
63 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
64 SHOW TABLES;
65 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
66 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
67 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
68 SHOW TABLES;
69 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
70 DROP TABLE src;
71 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 REAL NULL, PRIMARY KEY(c1));
72 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
73 SHOW TABLES;
74 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
75 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
76 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
77 SHOW TABLES;
78 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
79 DROP TABLE src;
80 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 DOUBLE NULL, PRIMARY KEY(c1));
81 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
82 SHOW TABLES;
83 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
84 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
85 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
86 SHOW TABLES;
87 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
88 DROP TABLE src;
89 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 FLOAT NULL, PRIMARY KEY(c1));
90 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
91 SHOW TABLES;
92 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
93 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
94 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
95 SHOW TABLES;
96 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
97 DROP TABLE src;
98 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 DECIMAL NULL, PRIMARY KEY(c1));
99 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
100 SHOW TABLES;
101 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
102 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
103 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
104 SHOW TABLES;
105 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
106 DROP TABLE src;
107 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 NUMERIC NULL, PRIMARY KEY(c1));
108 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
109 SHOW TABLES;
110 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
111 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
112 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
113 SHOW TABLES;
114 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
115 DROP TABLE src;
116 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 DATE NULL, PRIMARY KEY(c1));
117 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
118 SHOW TABLES;
119 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
120 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
121 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
122 SHOW TABLES;
123 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
124 DROP TABLE src;
125 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TIME NULL, PRIMARY KEY(c1));
126 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
127 SHOW TABLES;
128 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
129 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
130 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
131 SHOW TABLES;
132 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
133 DROP TABLE src;
134 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 DATETIME NULL, PRIMARY KEY(c1));
135 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
136 SHOW TABLES;
137 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
138 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
139 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
140 SHOW TABLES;
141 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
142 DROP TABLE src;
143 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TIMESTAMP NULL, PRIMARY KEY(c1));
144 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
145 SHOW TABLES;
146 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
147 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
148 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
149 SHOW TABLES;
150 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
151 DROP TABLE src;
152 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 YEAR NULL, PRIMARY KEY(c1));
153 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
154 SHOW TABLES;
155 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
156 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
157 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
158 SHOW TABLES;
159 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
160 DROP TABLE src;
161 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TINYBLOB NULL, PRIMARY KEY(c1));
162 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
163 SHOW TABLES;
164 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
165 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
166 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
167 SHOW TABLES;
168 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
169 DROP TABLE src;
170 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 BLOB NULL, PRIMARY KEY(c1));
171 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
172 SHOW TABLES;
173 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
174 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
175 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
176 SHOW TABLES;
177 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
178 DROP TABLE src;
179 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 MEDIUMBLOB NULL, PRIMARY KEY(c1));
180 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
181 SHOW TABLES;
182 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
183 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
184 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
185 SHOW TABLES;
186 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
187 DROP TABLE src;
188 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 LONGBLOB NULL, PRIMARY KEY(c1));
189 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
190 SHOW TABLES;
191 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
192 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
193 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
194 SHOW TABLES;
195 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
196 DROP TABLE src;
197 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TINYTEXT NULL, PRIMARY KEY(c1));
198 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
199 SHOW TABLES;
200 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
201 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
202 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
203 SHOW TABLES;
204 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
205 DROP TABLE src;
206 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TEXT NULL, PRIMARY KEY(c1));
207 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
208 SHOW TABLES;
209 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
210 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
211 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
212 SHOW TABLES;
213 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
214 DROP TABLE src;
215 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 MEDIUMTEXT NULL, PRIMARY KEY(c1));
216 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
217 SHOW TABLES;
218 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
219 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
220 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
221 SHOW TABLES;
222 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
223 DROP TABLE src;
224 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 LONGTEXT NULL, PRIMARY KEY(c1));
225 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
226 SHOW TABLES;
227 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
228 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
229 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
230 SHOW TABLES;
231 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
232 DROP TABLE src;