Debian Codegraph @

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

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