Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 BIT NOT NULL, c2 BIT);
3 SHOW TABLES;
4 Tables_in_test
5 t1
6 SHOW CREATE TABLE t1;
7 Table Create Table
8 t1 CREATE TABLE `t1` (
9 `c1` bit(1) NOT NULL,
10 `c2` bit(1) DEFAULT NULL
11 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
12 ALTER TABLE t1 RENAME t2;
13 SHOW TABLES;
14 Tables_in_test
15 t2
16 DROP TABLE t1;
17 ERROR 42S02: Unknown table 'test.t1'
18 SHOW CREATE TABLE t2;
19 Table Create Table
20 t2 CREATE TABLE `t2` (
21 `c1` bit(1) NOT NULL,
22 `c2` bit(1) DEFAULT NULL
23 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
24 DROP TABLE t2;
25 SHOW TABLES;
26 Tables_in_test
27 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TINYINT);
28 SHOW TABLES;
29 Tables_in_test
30 t1
31 SHOW CREATE TABLE t1;
32 Table Create Table
33 t1 CREATE TABLE `t1` (
34 `c1` tinyint(4) NOT NULL,
35 `c2` tinyint(4) DEFAULT NULL
36 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
37 ALTER TABLE t1 RENAME t2;
38 SHOW TABLES;
39 Tables_in_test
40 t2
41 DROP TABLE t1;
42 ERROR 42S02: Unknown table 'test.t1'
43 SHOW CREATE TABLE t2;
44 Table Create Table
45 t2 CREATE TABLE `t2` (
46 `c1` tinyint(4) NOT NULL,
47 `c2` tinyint(4) DEFAULT NULL
48 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
49 DROP TABLE t2;
50 SHOW TABLES;
51 Tables_in_test
52 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 SMALLINT);
53 SHOW TABLES;
54 Tables_in_test
55 t1
56 SHOW CREATE TABLE t1;
57 Table Create Table
58 t1 CREATE TABLE `t1` (
59 `c1` smallint(6) NOT NULL,
60 `c2` smallint(6) DEFAULT NULL
61 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
62 ALTER TABLE t1 RENAME t2;
63 SHOW TABLES;
64 Tables_in_test
65 t2
66 DROP TABLE t1;
67 ERROR 42S02: Unknown table 'test.t1'
68 SHOW CREATE TABLE t2;
69 Table Create Table
70 t2 CREATE TABLE `t2` (
71 `c1` smallint(6) NOT NULL,
72 `c2` smallint(6) DEFAULT NULL
73 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
74 DROP TABLE t2;
75 SHOW TABLES;
76 Tables_in_test
77 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 MEDIUMINT);
78 SHOW TABLES;
79 Tables_in_test
80 t1
81 SHOW CREATE TABLE t1;
82 Table Create Table
83 t1 CREATE TABLE `t1` (
84 `c1` mediumint(9) NOT NULL,
85 `c2` mediumint(9) DEFAULT NULL
86 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
87 ALTER TABLE t1 RENAME t2;
88 SHOW TABLES;
89 Tables_in_test
90 t2
91 DROP TABLE t1;
92 ERROR 42S02: Unknown table 'test.t1'
93 SHOW CREATE TABLE t2;
94 Table Create Table
95 t2 CREATE TABLE `t2` (
96 `c1` mediumint(9) NOT NULL,
97 `c2` mediumint(9) DEFAULT NULL
98 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
99 DROP TABLE t2;
100 SHOW TABLES;
101 Tables_in_test
102 CREATE TABLE t1(c1 INT NOT NULL, c2 INT);
103 SHOW TABLES;
104 Tables_in_test
105 t1
106 SHOW CREATE TABLE t1;
107 Table Create Table
108 t1 CREATE TABLE `t1` (
109 `c1` int(11) NOT NULL,
110 `c2` int(11) DEFAULT NULL
111 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
112 ALTER TABLE t1 RENAME t2;
113 SHOW TABLES;
114 Tables_in_test
115 t2
116 DROP TABLE t1;
117 ERROR 42S02: Unknown table 'test.t1'
118 SHOW CREATE TABLE t2;
119 Table Create Table
120 t2 CREATE TABLE `t2` (
121 `c1` int(11) NOT NULL,
122 `c2` int(11) DEFAULT NULL
123 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
124 DROP TABLE t2;
125 SHOW TABLES;
126 Tables_in_test
127 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INTEGER);
128 SHOW TABLES;
129 Tables_in_test
130 t1
131 SHOW CREATE TABLE t1;
132 Table Create Table
133 t1 CREATE TABLE `t1` (
134 `c1` int(11) NOT NULL,
135 `c2` int(11) DEFAULT NULL
136 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
137 ALTER TABLE t1 RENAME t2;
138 SHOW TABLES;
139 Tables_in_test
140 t2
141 DROP TABLE t1;
142 ERROR 42S02: Unknown table 'test.t1'
143 SHOW CREATE TABLE t2;
144 Table Create Table
145 t2 CREATE TABLE `t2` (
146 `c1` int(11) NOT NULL,
147 `c2` int(11) DEFAULT NULL
148 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
149 DROP TABLE t2;
150 SHOW TABLES;
151 Tables_in_test
152 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 BIGINT);
153 SHOW TABLES;
154 Tables_in_test
155 t1
156 SHOW CREATE TABLE t1;
157 Table Create Table
158 t1 CREATE TABLE `t1` (
159 `c1` bigint(20) NOT NULL,
160 `c2` bigint(20) DEFAULT NULL
161 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
162 ALTER TABLE t1 RENAME t2;
163 SHOW TABLES;
164 Tables_in_test
165 t2
166 DROP TABLE t1;
167 ERROR 42S02: Unknown table 'test.t1'
168 SHOW CREATE TABLE t2;
169 Table Create Table
170 t2 CREATE TABLE `t2` (
171 `c1` bigint(20) NOT NULL,
172 `c2` bigint(20) DEFAULT NULL
173 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
174 DROP TABLE t2;
175 SHOW TABLES;
176 Tables_in_test
177 CREATE TABLE t1(c1 REAL NOT NULL, c2 REAL);
178 SHOW TABLES;
179 Tables_in_test
180 t1
181 SHOW CREATE TABLE t1;
182 Table Create Table
183 t1 CREATE TABLE `t1` (
184 `c1` double NOT NULL,
185 `c2` double DEFAULT NULL
186 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
187 ALTER TABLE t1 RENAME t2;
188 SHOW TABLES;
189 Tables_in_test
190 t2
191 DROP TABLE t1;
192 ERROR 42S02: Unknown table 'test.t1'
193 SHOW CREATE TABLE t2;
194 Table Create Table
195 t2 CREATE TABLE `t2` (
196 `c1` double NOT NULL,
197 `c2` double DEFAULT NULL
198 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
199 DROP TABLE t2;
200 SHOW TABLES;
201 Tables_in_test
202 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DOUBLE);
203 SHOW TABLES;
204 Tables_in_test
205 t1
206 SHOW CREATE TABLE t1;
207 Table Create Table
208 t1 CREATE TABLE `t1` (
209 `c1` double NOT NULL,
210 `c2` double DEFAULT NULL
211 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
212 ALTER TABLE t1 RENAME t2;
213 SHOW TABLES;
214 Tables_in_test
215 t2
216 DROP TABLE t1;
217 ERROR 42S02: Unknown table 'test.t1'
218 SHOW CREATE TABLE t2;
219 Table Create Table
220 t2 CREATE TABLE `t2` (
221 `c1` double NOT NULL,
222 `c2` double DEFAULT NULL
223 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
224 DROP TABLE t2;
225 SHOW TABLES;
226 Tables_in_test
227 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 FLOAT);
228 SHOW TABLES;
229 Tables_in_test
230 t1
231 SHOW CREATE TABLE t1;
232 Table Create Table
233 t1 CREATE TABLE `t1` (
234 `c1` float NOT NULL,
235 `c2` float DEFAULT NULL
236 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
237 ALTER TABLE t1 RENAME t2;
238 SHOW TABLES;
239 Tables_in_test
240 t2
241 DROP TABLE t1;
242 ERROR 42S02: Unknown table 'test.t1'
243 SHOW CREATE TABLE t2;
244 Table Create Table
245 t2 CREATE TABLE `t2` (
246 `c1` float NOT NULL,
247 `c2` float DEFAULT NULL
248 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
249 DROP TABLE t2;
250 SHOW TABLES;
251 Tables_in_test
252 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DECIMAL);
253 SHOW TABLES;
254 Tables_in_test
255 t1
256 SHOW CREATE TABLE t1;
257 Table Create Table
258 t1 CREATE TABLE `t1` (
259 `c1` decimal(10,0) NOT NULL,
260 `c2` decimal(10,0) DEFAULT NULL
261 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
262 ALTER TABLE t1 RENAME t2;
263 SHOW TABLES;
264 Tables_in_test
265 t2
266 DROP TABLE t1;
267 ERROR 42S02: Unknown table 'test.t1'
268 SHOW CREATE TABLE t2;
269 Table Create Table
270 t2 CREATE TABLE `t2` (
271 `c1` decimal(10,0) NOT NULL,
272 `c2` decimal(10,0) DEFAULT NULL
273 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
274 DROP TABLE t2;
275 SHOW TABLES;
276 Tables_in_test
277 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 NUMERIC);
278 SHOW TABLES;
279 Tables_in_test
280 t1
281 SHOW CREATE TABLE t1;
282 Table Create Table
283 t1 CREATE TABLE `t1` (
284 `c1` decimal(10,0) NOT NULL,
285 `c2` decimal(10,0) DEFAULT NULL
286 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
287 ALTER TABLE t1 RENAME t2;
288 SHOW TABLES;
289 Tables_in_test
290 t2
291 DROP TABLE t1;
292 ERROR 42S02: Unknown table 'test.t1'
293 SHOW CREATE TABLE t2;
294 Table Create Table
295 t2 CREATE TABLE `t2` (
296 `c1` decimal(10,0) NOT NULL,
297 `c2` decimal(10,0) DEFAULT NULL
298 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
299 DROP TABLE t2;
300 SHOW TABLES;
301 Tables_in_test
302 CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE);
303 SHOW TABLES;
304 Tables_in_test
305 t1
306 SHOW CREATE TABLE t1;
307 Table Create Table
308 t1 CREATE TABLE `t1` (
309 `c1` date NOT NULL,
310 `c2` date DEFAULT NULL
311 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
312 ALTER TABLE t1 RENAME t2;
313 SHOW TABLES;
314 Tables_in_test
315 t2
316 DROP TABLE t1;
317 ERROR 42S02: Unknown table 'test.t1'
318 SHOW CREATE TABLE t2;
319 Table Create Table
320 t2 CREATE TABLE `t2` (
321 `c1` date NOT NULL,
322 `c2` date DEFAULT NULL
323 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
324 DROP TABLE t2;
325 SHOW TABLES;
326 Tables_in_test
327 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME);
328 SHOW TABLES;
329 Tables_in_test
330 t1
331 SHOW CREATE TABLE t1;
332 Table Create Table
333 t1 CREATE TABLE `t1` (
334 `c1` time NOT NULL,
335 `c2` time DEFAULT NULL
336 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
337 ALTER TABLE t1 RENAME t2;
338 SHOW TABLES;
339 Tables_in_test
340 t2
341 DROP TABLE t1;
342 ERROR 42S02: Unknown table 'test.t1'
343 SHOW CREATE TABLE t2;
344 Table Create Table
345 t2 CREATE TABLE `t2` (
346 `c1` time NOT NULL,
347 `c2` time DEFAULT NULL
348 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
349 DROP TABLE t2;
350 SHOW TABLES;
351 Tables_in_test
352 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP);
353 SHOW TABLES;
354 Tables_in_test
355 t1
356 SHOW CREATE TABLE t1;
357 Table Create Table
358 t1 CREATE TABLE `t1` (
359 `c1` timestamp NOT NULL,
360 `c2` timestamp NULL DEFAULT NULL
361 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
362 ALTER TABLE t1 RENAME t2;
363 SHOW TABLES;
364 Tables_in_test
365 t2
366 DROP TABLE t1;
367 ERROR 42S02: Unknown table 'test.t1'
368 SHOW CREATE TABLE t2;
369 Table Create Table
370 t2 CREATE TABLE `t2` (
371 `c1` timestamp NOT NULL,
372 `c2` timestamp NULL DEFAULT NULL
373 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
374 DROP TABLE t2;
375 SHOW TABLES;
376 Tables_in_test
377 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR);
378 SHOW TABLES;
379 Tables_in_test
380 t1
381 SHOW CREATE TABLE t1;
382 Table Create Table
383 t1 CREATE TABLE `t1` (
384 `c1` year(4) NOT NULL,
385 `c2` year(4) DEFAULT NULL
386 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
387 ALTER TABLE t1 RENAME t2;
388 SHOW TABLES;
389 Tables_in_test
390 t2
391 DROP TABLE t1;
392 ERROR 42S02: Unknown table 'test.t1'
393 SHOW CREATE TABLE t2;
394 Table Create Table
395 t2 CREATE TABLE `t2` (
396 `c1` year(4) NOT NULL,
397 `c2` year(4) DEFAULT NULL
398 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
399 DROP TABLE t2;
400 SHOW TABLES;
401 Tables_in_test
402 CREATE TABLE t1(c1 BIT NOT NULL, c2 BIT);
403 SHOW TABLES;
404 Tables_in_test
405 t1
406 SHOW CREATE TABLE t1;
407 Table Create Table
408 t1 CREATE TABLE `t1` (
409 `c1` bit(1) NOT NULL,
410 `c2` bit(1) DEFAULT NULL
411 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
412 ALTER TABLE t1 RENAME TO t2;
413 SHOW TABLES;
414 Tables_in_test
415 t2
416 DROP TABLE t1;
417 ERROR 42S02: Unknown table 'test.t1'
418 SHOW CREATE TABLE t2;
419 Table Create Table
420 t2 CREATE TABLE `t2` (
421 `c1` bit(1) NOT NULL,
422 `c2` bit(1) DEFAULT NULL
423 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
424 DROP TABLE t2;
425 SHOW TABLES;
426 Tables_in_test
427 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TINYINT);
428 SHOW TABLES;
429 Tables_in_test
430 t1
431 SHOW CREATE TABLE t1;
432 Table Create Table
433 t1 CREATE TABLE `t1` (
434 `c1` tinyint(4) NOT NULL,
435 `c2` tinyint(4) DEFAULT NULL
436 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
437 ALTER TABLE t1 RENAME TO t2;
438 SHOW TABLES;
439 Tables_in_test
440 t2
441 DROP TABLE t1;
442 ERROR 42S02: Unknown table 'test.t1'
443 SHOW CREATE TABLE t2;
444 Table Create Table
445 t2 CREATE TABLE `t2` (
446 `c1` tinyint(4) NOT NULL,
447 `c2` tinyint(4) DEFAULT NULL
448 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
449 DROP TABLE t2;
450 SHOW TABLES;
451 Tables_in_test
452 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 SMALLINT);
453 SHOW TABLES;
454 Tables_in_test
455 t1
456 SHOW CREATE TABLE t1;
457 Table Create Table
458 t1 CREATE TABLE `t1` (
459 `c1` smallint(6) NOT NULL,
460 `c2` smallint(6) DEFAULT NULL
461 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
462 ALTER TABLE t1 RENAME TO t2;
463 SHOW TABLES;
464 Tables_in_test
465 t2
466 DROP TABLE t1;
467 ERROR 42S02: Unknown table 'test.t1'
468 SHOW CREATE TABLE t2;
469 Table Create Table
470 t2 CREATE TABLE `t2` (
471 `c1` smallint(6) NOT NULL,
472 `c2` smallint(6) DEFAULT NULL
473 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
474 DROP TABLE t2;
475 SHOW TABLES;
476 Tables_in_test
477 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 MEDIUMINT);
478 SHOW TABLES;
479 Tables_in_test
480 t1
481 SHOW CREATE TABLE t1;
482 Table Create Table
483 t1 CREATE TABLE `t1` (
484 `c1` mediumint(9) NOT NULL,
485 `c2` mediumint(9) DEFAULT NULL
486 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
487 ALTER TABLE t1 RENAME TO t2;
488 SHOW TABLES;
489 Tables_in_test
490 t2
491 DROP TABLE t1;
492 ERROR 42S02: Unknown table 'test.t1'
493 SHOW CREATE TABLE t2;
494 Table Create Table
495 t2 CREATE TABLE `t2` (
496 `c1` mediumint(9) NOT NULL,
497 `c2` mediumint(9) DEFAULT NULL
498 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
499 DROP TABLE t2;
500 SHOW TABLES;
501 Tables_in_test
502 CREATE TABLE t1(c1 INT NOT NULL, c2 INT);
503 SHOW TABLES;
504 Tables_in_test
505 t1
506 SHOW CREATE TABLE t1;
507 Table Create Table
508 t1 CREATE TABLE `t1` (
509 `c1` int(11) NOT NULL,
510 `c2` int(11) DEFAULT NULL
511 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
512 ALTER TABLE t1 RENAME TO t2;
513 SHOW TABLES;
514 Tables_in_test
515 t2
516 DROP TABLE t1;
517 ERROR 42S02: Unknown table 'test.t1'
518 SHOW CREATE TABLE t2;
519 Table Create Table
520 t2 CREATE TABLE `t2` (
521 `c1` int(11) NOT NULL,
522 `c2` int(11) DEFAULT NULL
523 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
524 DROP TABLE t2;
525 SHOW TABLES;
526 Tables_in_test
527 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INTEGER);
528 SHOW TABLES;
529 Tables_in_test
530 t1
531 SHOW CREATE TABLE t1;
532 Table Create Table
533 t1 CREATE TABLE `t1` (
534 `c1` int(11) NOT NULL,
535 `c2` int(11) DEFAULT NULL
536 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
537 ALTER TABLE t1 RENAME TO t2;
538 SHOW TABLES;
539 Tables_in_test
540 t2
541 DROP TABLE t1;
542 ERROR 42S02: Unknown table 'test.t1'
543 SHOW CREATE TABLE t2;
544 Table Create Table
545 t2 CREATE TABLE `t2` (
546 `c1` int(11) NOT NULL,
547 `c2` int(11) DEFAULT NULL
548 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
549 DROP TABLE t2;
550 SHOW TABLES;
551 Tables_in_test
552 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 BIGINT);
553 SHOW TABLES;
554 Tables_in_test
555 t1
556 SHOW CREATE TABLE t1;
557 Table Create Table
558 t1 CREATE TABLE `t1` (
559 `c1` bigint(20) NOT NULL,
560 `c2` bigint(20) DEFAULT NULL
561 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
562 ALTER TABLE t1 RENAME TO t2;
563 SHOW TABLES;
564 Tables_in_test
565 t2
566 DROP TABLE t1;
567 ERROR 42S02: Unknown table 'test.t1'
568 SHOW CREATE TABLE t2;
569 Table Create Table
570 t2 CREATE TABLE `t2` (
571 `c1` bigint(20) NOT NULL,
572 `c2` bigint(20) DEFAULT NULL
573 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
574 DROP TABLE t2;
575 SHOW TABLES;
576 Tables_in_test
577 CREATE TABLE t1(c1 REAL NOT NULL, c2 REAL);
578 SHOW TABLES;
579 Tables_in_test
580 t1
581 SHOW CREATE TABLE t1;
582 Table Create Table
583 t1 CREATE TABLE `t1` (
584 `c1` double NOT NULL,
585 `c2` double DEFAULT NULL
586 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
587 ALTER TABLE t1 RENAME TO t2;
588 SHOW TABLES;
589 Tables_in_test
590 t2
591 DROP TABLE t1;
592 ERROR 42S02: Unknown table 'test.t1'
593 SHOW CREATE TABLE t2;
594 Table Create Table
595 t2 CREATE TABLE `t2` (
596 `c1` double NOT NULL,
597 `c2` double DEFAULT NULL
598 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
599 DROP TABLE t2;
600 SHOW TABLES;
601 Tables_in_test
602 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DOUBLE);
603 SHOW TABLES;
604 Tables_in_test
605 t1
606 SHOW CREATE TABLE t1;
607 Table Create Table
608 t1 CREATE TABLE `t1` (
609 `c1` double NOT NULL,
610 `c2` double DEFAULT NULL
611 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
612 ALTER TABLE t1 RENAME TO t2;
613 SHOW TABLES;
614 Tables_in_test
615 t2
616 DROP TABLE t1;
617 ERROR 42S02: Unknown table 'test.t1'
618 SHOW CREATE TABLE t2;
619 Table Create Table
620 t2 CREATE TABLE `t2` (
621 `c1` double NOT NULL,
622 `c2` double DEFAULT NULL
623 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
624 DROP TABLE t2;
625 SHOW TABLES;
626 Tables_in_test
627 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 FLOAT);
628 SHOW TABLES;
629 Tables_in_test
630 t1
631 SHOW CREATE TABLE t1;
632 Table Create Table
633 t1 CREATE TABLE `t1` (
634 `c1` float NOT NULL,
635 `c2` float DEFAULT NULL
636 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
637 ALTER TABLE t1 RENAME TO t2;
638 SHOW TABLES;
639 Tables_in_test
640 t2
641 DROP TABLE t1;
642 ERROR 42S02: Unknown table 'test.t1'
643 SHOW CREATE TABLE t2;
644 Table Create Table
645 t2 CREATE TABLE `t2` (
646 `c1` float NOT NULL,
647 `c2` float DEFAULT NULL
648 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
649 DROP TABLE t2;
650 SHOW TABLES;
651 Tables_in_test
652 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DECIMAL);
653 SHOW TABLES;
654 Tables_in_test
655 t1
656 SHOW CREATE TABLE t1;
657 Table Create Table
658 t1 CREATE TABLE `t1` (
659 `c1` decimal(10,0) NOT NULL,
660 `c2` decimal(10,0) DEFAULT NULL
661 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
662 ALTER TABLE t1 RENAME TO t2;
663 SHOW TABLES;
664 Tables_in_test
665 t2
666 DROP TABLE t1;
667 ERROR 42S02: Unknown table 'test.t1'
668 SHOW CREATE TABLE t2;
669 Table Create Table
670 t2 CREATE TABLE `t2` (
671 `c1` decimal(10,0) NOT NULL,
672 `c2` decimal(10,0) DEFAULT NULL
673 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
674 DROP TABLE t2;
675 SHOW TABLES;
676 Tables_in_test
677 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 NUMERIC);
678 SHOW TABLES;
679 Tables_in_test
680 t1
681 SHOW CREATE TABLE t1;
682 Table Create Table
683 t1 CREATE TABLE `t1` (
684 `c1` decimal(10,0) NOT NULL,
685 `c2` decimal(10,0) DEFAULT NULL
686 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
687 ALTER TABLE t1 RENAME TO t2;
688 SHOW TABLES;
689 Tables_in_test
690 t2
691 DROP TABLE t1;
692 ERROR 42S02: Unknown table 'test.t1'
693 SHOW CREATE TABLE t2;
694 Table Create Table
695 t2 CREATE TABLE `t2` (
696 `c1` decimal(10,0) NOT NULL,
697 `c2` decimal(10,0) DEFAULT NULL
698 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
699 DROP TABLE t2;
700 SHOW TABLES;
701 Tables_in_test
702 CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE);
703 SHOW TABLES;
704 Tables_in_test
705 t1
706 SHOW CREATE TABLE t1;
707 Table Create Table
708 t1 CREATE TABLE `t1` (
709 `c1` date NOT NULL,
710 `c2` date DEFAULT NULL
711 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
712 ALTER TABLE t1 RENAME TO t2;
713 SHOW TABLES;
714 Tables_in_test
715 t2
716 DROP TABLE t1;
717 ERROR 42S02: Unknown table 'test.t1'
718 SHOW CREATE TABLE t2;
719 Table Create Table
720 t2 CREATE TABLE `t2` (
721 `c1` date NOT NULL,
722 `c2` date DEFAULT NULL
723 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
724 DROP TABLE t2;
725 SHOW TABLES;
726 Tables_in_test
727 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME);
728 SHOW TABLES;
729 Tables_in_test
730 t1
731 SHOW CREATE TABLE t1;
732 Table Create Table
733 t1 CREATE TABLE `t1` (
734 `c1` time NOT NULL,
735 `c2` time DEFAULT NULL
736 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
737 ALTER TABLE t1 RENAME TO t2;
738 SHOW TABLES;
739 Tables_in_test
740 t2
741 DROP TABLE t1;
742 ERROR 42S02: Unknown table 'test.t1'
743 SHOW CREATE TABLE t2;
744 Table Create Table
745 t2 CREATE TABLE `t2` (
746 `c1` time NOT NULL,
747 `c2` time DEFAULT NULL
748 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
749 DROP TABLE t2;
750 SHOW TABLES;
751 Tables_in_test
752 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP);
753 SHOW TABLES;
754 Tables_in_test
755 t1
756 SHOW CREATE TABLE t1;
757 Table Create Table
758 t1 CREATE TABLE `t1` (
759 `c1` timestamp NOT NULL,
760 `c2` timestamp NULL DEFAULT NULL
761 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
762 ALTER TABLE t1 RENAME TO t2;
763 SHOW TABLES;
764 Tables_in_test
765 t2
766 DROP TABLE t1;
767 ERROR 42S02: Unknown table 'test.t1'
768 SHOW CREATE TABLE t2;
769 Table Create Table
770 t2 CREATE TABLE `t2` (
771 `c1` timestamp NOT NULL,
772 `c2` timestamp NULL DEFAULT NULL
773 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
774 DROP TABLE t2;
775 SHOW TABLES;
776 Tables_in_test
777 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR);
778 SHOW TABLES;
779 Tables_in_test
780 t1
781 SHOW CREATE TABLE t1;
782 Table Create Table
783 t1 CREATE TABLE `t1` (
784 `c1` year(4) NOT NULL,
785 `c2` year(4) DEFAULT NULL
786 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
787 ALTER TABLE t1 RENAME TO t2;
788 SHOW TABLES;
789 Tables_in_test
790 t2
791 DROP TABLE t1;
792 ERROR 42S02: Unknown table 'test.t1'
793 SHOW CREATE TABLE t2;
794 Table Create Table
795 t2 CREATE TABLE `t2` (
796 `c1` year(4) NOT NULL,
797 `c2` year(4) DEFAULT NULL
798 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
799 DROP TABLE t2;
800 SHOW TABLES;
801 Tables_in_test