Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 CREATE TABLE t1(c1 BIT NOT NULL, c2 BIT);
5 SHOW TABLES;
6 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
7 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
8 SHOW CREATE TABLE t1;
9 ALTER TABLE t1 RENAME t2;
10 SHOW TABLES;
11 --error 1051
12 DROP TABLE t1;
13 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
14 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
15 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
16 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TINYINT);
17 SHOW TABLES;
18 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
19 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
20 SHOW CREATE TABLE t1;
21 ALTER TABLE t1 RENAME t2;
22 SHOW TABLES;
23 --error 1051
24 DROP TABLE t1;
25 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
26 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
27 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
28 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 SMALLINT);
29 SHOW TABLES;
30 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
31 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
32 SHOW CREATE TABLE t1;
33 ALTER TABLE t1 RENAME t2;
34 SHOW TABLES;
35 --error 1051
36 DROP TABLE t1;
37 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
38 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
39 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
40 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 MEDIUMINT);
41 SHOW TABLES;
42 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
43 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
44 SHOW CREATE TABLE t1;
45 ALTER TABLE t1 RENAME t2;
46 SHOW TABLES;
47 --error 1051
48 DROP TABLE t1;
49 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
50 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
51 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
52 CREATE TABLE t1(c1 INT NOT NULL, c2 INT);
53 SHOW TABLES;
54 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
55 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
56 SHOW CREATE TABLE t1;
57 ALTER TABLE t1 RENAME t2;
58 SHOW TABLES;
59 --error 1051
60 DROP TABLE t1;
61 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
62 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
63 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
64 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INTEGER);
65 SHOW TABLES;
66 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
67 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
68 SHOW CREATE TABLE t1;
69 ALTER TABLE t1 RENAME t2;
70 SHOW TABLES;
71 --error 1051
72 DROP TABLE t1;
73 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
74 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
75 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
76 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 BIGINT);
77 SHOW TABLES;
78 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
79 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
80 SHOW CREATE TABLE t1;
81 ALTER TABLE t1 RENAME t2;
82 SHOW TABLES;
83 --error 1051
84 DROP TABLE t1;
85 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
86 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
87 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
88 CREATE TABLE t1(c1 REAL NOT NULL, c2 REAL);
89 SHOW TABLES;
90 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
91 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
92 SHOW CREATE TABLE t1;
93 ALTER TABLE t1 RENAME t2;
94 SHOW TABLES;
95 --error 1051
96 DROP TABLE t1;
97 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
98 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
99 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
100 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DOUBLE);
101 SHOW TABLES;
102 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
103 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
104 SHOW CREATE TABLE t1;
105 ALTER TABLE t1 RENAME t2;
106 SHOW TABLES;
107 --error 1051
108 DROP TABLE t1;
109 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
110 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
111 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
112 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 FLOAT);
113 SHOW TABLES;
114 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
115 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
116 SHOW CREATE TABLE t1;
117 ALTER TABLE t1 RENAME t2;
118 SHOW TABLES;
119 --error 1051
120 DROP TABLE t1;
121 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
122 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
123 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
124 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DECIMAL);
125 SHOW TABLES;
126 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
127 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
128 SHOW CREATE TABLE t1;
129 ALTER TABLE t1 RENAME t2;
130 SHOW TABLES;
131 --error 1051
132 DROP TABLE t1;
133 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
134 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
135 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
136 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 NUMERIC);
137 SHOW TABLES;
138 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
139 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
140 SHOW CREATE TABLE t1;
141 ALTER TABLE t1 RENAME t2;
142 SHOW TABLES;
143 --error 1051
144 DROP TABLE t1;
145 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
146 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
147 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
148 CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE);
149 SHOW TABLES;
150 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
151 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
152 SHOW CREATE TABLE t1;
153 ALTER TABLE t1 RENAME t2;
154 SHOW TABLES;
155 --error 1051
156 DROP TABLE t1;
157 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
158 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
159 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
160 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME);
161 SHOW TABLES;
162 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
163 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
164 SHOW CREATE TABLE t1;
165 ALTER TABLE t1 RENAME t2;
166 SHOW TABLES;
167 --error 1051
168 DROP TABLE t1;
169 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
170 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
171 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
172 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP);
173 SHOW TABLES;
174 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
175 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
176 SHOW CREATE TABLE t1;
177 ALTER TABLE t1 RENAME t2;
178 SHOW TABLES;
179 --error 1051
180 DROP TABLE t1;
181 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
182 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
183 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
184 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR);
185 SHOW TABLES;
186 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
187 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
188 SHOW CREATE TABLE t1;
189 ALTER TABLE t1 RENAME t2;
190 SHOW TABLES;
191 --error 1051
192 DROP TABLE t1;
193 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
194 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
195 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
196 CREATE TABLE t1(c1 BIT NOT NULL, c2 BIT);
197 SHOW TABLES;
198 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
199 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
200 SHOW CREATE TABLE t1;
201 ALTER TABLE t1 RENAME TO t2;
202 SHOW TABLES;
203 --error 1051
204 DROP TABLE t1;
205 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
206 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
207 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
208 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TINYINT);
209 SHOW TABLES;
210 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
211 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
212 SHOW CREATE TABLE t1;
213 ALTER TABLE t1 RENAME TO t2;
214 SHOW TABLES;
215 --error 1051
216 DROP TABLE t1;
217 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
218 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
219 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
220 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 SMALLINT);
221 SHOW TABLES;
222 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
223 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
224 SHOW CREATE TABLE t1;
225 ALTER TABLE t1 RENAME TO t2;
226 SHOW TABLES;
227 --error 1051
228 DROP TABLE t1;
229 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
230 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
231 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
232 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 MEDIUMINT);
233 SHOW TABLES;
234 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
235 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
236 SHOW CREATE TABLE t1;
237 ALTER TABLE t1 RENAME TO t2;
238 SHOW TABLES;
239 --error 1051
240 DROP TABLE t1;
241 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
242 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
243 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
244 CREATE TABLE t1(c1 INT NOT NULL, c2 INT);
245 SHOW TABLES;
246 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
247 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
248 SHOW CREATE TABLE t1;
249 ALTER TABLE t1 RENAME TO t2;
250 SHOW TABLES;
251 --error 1051
252 DROP TABLE t1;
253 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
254 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
255 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
256 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INTEGER);
257 SHOW TABLES;
258 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
259 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
260 SHOW CREATE TABLE t1;
261 ALTER TABLE t1 RENAME TO t2;
262 SHOW TABLES;
263 --error 1051
264 DROP TABLE t1;
265 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
266 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
267 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
268 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 BIGINT);
269 SHOW TABLES;
270 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
271 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
272 SHOW CREATE TABLE t1;
273 ALTER TABLE t1 RENAME TO t2;
274 SHOW TABLES;
275 --error 1051
276 DROP TABLE t1;
277 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
278 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
279 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
280 CREATE TABLE t1(c1 REAL NOT NULL, c2 REAL);
281 SHOW TABLES;
282 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
283 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
284 SHOW CREATE TABLE t1;
285 ALTER TABLE t1 RENAME TO t2;
286 SHOW TABLES;
287 --error 1051
288 DROP TABLE t1;
289 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
290 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
291 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
292 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DOUBLE);
293 SHOW TABLES;
294 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
295 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
296 SHOW CREATE TABLE t1;
297 ALTER TABLE t1 RENAME TO t2;
298 SHOW TABLES;
299 --error 1051
300 DROP TABLE t1;
301 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
302 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
303 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
304 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 FLOAT);
305 SHOW TABLES;
306 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
307 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
308 SHOW CREATE TABLE t1;
309 ALTER TABLE t1 RENAME TO t2;
310 SHOW TABLES;
311 --error 1051
312 DROP TABLE t1;
313 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
314 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
315 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
316 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DECIMAL);
317 SHOW TABLES;
318 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
319 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
320 SHOW CREATE TABLE t1;
321 ALTER TABLE t1 RENAME TO t2;
322 SHOW TABLES;
323 --error 1051
324 DROP TABLE t1;
325 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
326 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
327 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
328 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 NUMERIC);
329 SHOW TABLES;
330 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
331 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
332 SHOW CREATE TABLE t1;
333 ALTER TABLE t1 RENAME TO t2;
334 SHOW TABLES;
335 --error 1051
336 DROP TABLE t1;
337 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
338 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
339 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
340 CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE);
341 SHOW TABLES;
342 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
343 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
344 SHOW CREATE TABLE t1;
345 ALTER TABLE t1 RENAME TO t2;
346 SHOW TABLES;
347 --error 1051
348 DROP TABLE t1;
349 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
350 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
351 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
352 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME);
353 SHOW TABLES;
354 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
355 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
356 SHOW CREATE TABLE t1;
357 ALTER TABLE t1 RENAME TO t2;
358 SHOW TABLES;
359 --error 1051
360 DROP TABLE t1;
361 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
362 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
363 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
364 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP);
365 SHOW TABLES;
366 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
367 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
368 SHOW CREATE TABLE t1;
369 ALTER TABLE t1 RENAME TO t2;
370 SHOW TABLES;
371 --error 1051
372 DROP TABLE t1;
373 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
374 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
375 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
376 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR);
377 SHOW TABLES;
378 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
379 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
380 SHOW CREATE TABLE t1;
381 ALTER TABLE t1 RENAME TO t2;
382 SHOW TABLES;
383 --error 1051
384 DROP TABLE t1;
385 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
386 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
387 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
388