1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 BIT NOT NULL, c2 BIT);
10 `c2` bit(1) DEFAULT NULL
11 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
12 ALTER TABLE t1 RENAME t2;
17 ERROR 42S02: Unknown table 't1'
20 t2 CREATE TABLE `t2` (
22 `c2` bit(1) DEFAULT NULL
23 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
27 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TINYINT);
33 t1 CREATE TABLE `t1` (
34 `c1` tinyint(4) NOT NULL,
35 `c2` tinyint(4) DEFAULT NULL
36 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
37 ALTER TABLE t1 RENAME t2;
42 ERROR 42S02: Unknown table 't1'
45 t2 CREATE TABLE `t2` (
46 `c1` tinyint(4) NOT NULL,
47 `c2` tinyint(4) DEFAULT NULL
48 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
52 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 SMALLINT);
58 t1 CREATE TABLE `t1` (
59 `c1` smallint(6) NOT NULL,
60 `c2` smallint(6) DEFAULT NULL
61 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
62 ALTER TABLE t1 RENAME t2;
67 ERROR 42S02: Unknown table 't1'
70 t2 CREATE TABLE `t2` (
71 `c1` smallint(6) NOT NULL,
72 `c2` smallint(6) DEFAULT NULL
73 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
77 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 MEDIUMINT);
83 t1 CREATE TABLE `t1` (
84 `c1` mediumint(9) NOT NULL,
85 `c2` mediumint(9) DEFAULT NULL
86 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
87 ALTER TABLE t1 RENAME t2;
92 ERROR 42S02: Unknown table 't1'
95 t2 CREATE TABLE `t2` (
96 `c1` mediumint(9) NOT NULL,
97 `c2` mediumint(9) DEFAULT NULL
98 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
102 CREATE TABLE t1(c1 INT NOT NULL, c2 INT);
106 SHOW CREATE TABLE t1;
108 t1 CREATE TABLE `t1` (
109 `c1` int(11) NOT NULL,
110 `c2` int(11) DEFAULT NULL
111 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
112 ALTER TABLE t1 RENAME t2;
117 ERROR 42S02: Unknown table 't1'
118 SHOW CREATE TABLE t2;
120 t2 CREATE TABLE `t2` (
121 `c1` int(11) NOT NULL,
122 `c2` int(11) DEFAULT NULL
123 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
127 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INTEGER);
131 SHOW CREATE TABLE t1;
133 t1 CREATE TABLE `t1` (
134 `c1` int(11) NOT NULL,
135 `c2` int(11) DEFAULT NULL
136 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
137 ALTER TABLE t1 RENAME t2;
142 ERROR 42S02: Unknown table 't1'
143 SHOW CREATE TABLE t2;
145 t2 CREATE TABLE `t2` (
146 `c1` int(11) NOT NULL,
147 `c2` int(11) DEFAULT NULL
148 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
152 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 BIGINT);
156 SHOW CREATE TABLE t1;
158 t1 CREATE TABLE `t1` (
159 `c1` bigint(20) NOT NULL,
160 `c2` bigint(20) DEFAULT NULL
161 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
162 ALTER TABLE t1 RENAME t2;
167 ERROR 42S02: Unknown table 't1'
168 SHOW CREATE TABLE t2;
170 t2 CREATE TABLE `t2` (
171 `c1` bigint(20) NOT NULL,
172 `c2` bigint(20) DEFAULT NULL
173 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
177 CREATE TABLE t1(c1 REAL NOT NULL, c2 REAL);
181 SHOW CREATE TABLE t1;
183 t1 CREATE TABLE `t1` (
184 `c1` double NOT NULL,
185 `c2` double DEFAULT NULL
186 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
187 ALTER TABLE t1 RENAME t2;
192 ERROR 42S02: Unknown table 't1'
193 SHOW CREATE TABLE t2;
195 t2 CREATE TABLE `t2` (
196 `c1` double NOT NULL,
197 `c2` double DEFAULT NULL
198 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
202 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DOUBLE);
206 SHOW CREATE TABLE t1;
208 t1 CREATE TABLE `t1` (
209 `c1` double NOT NULL,
210 `c2` double DEFAULT NULL
211 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
212 ALTER TABLE t1 RENAME t2;
217 ERROR 42S02: Unknown table 't1'
218 SHOW CREATE TABLE t2;
220 t2 CREATE TABLE `t2` (
221 `c1` double NOT NULL,
222 `c2` double DEFAULT NULL
223 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
227 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 FLOAT);
231 SHOW CREATE TABLE t1;
233 t1 CREATE TABLE `t1` (
235 `c2` float DEFAULT NULL
236 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
237 ALTER TABLE t1 RENAME t2;
242 ERROR 42S02: Unknown table 't1'
243 SHOW CREATE TABLE t2;
245 t2 CREATE TABLE `t2` (
247 `c2` float DEFAULT NULL
248 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
252 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DECIMAL);
256 SHOW CREATE TABLE t1;
258 t1 CREATE TABLE `t1` (
259 `c1` decimal(10,0) NOT NULL,
260 `c2` decimal(10,0) DEFAULT NULL
261 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
262 ALTER TABLE t1 RENAME t2;
267 ERROR 42S02: Unknown table 't1'
268 SHOW CREATE TABLE t2;
270 t2 CREATE TABLE `t2` (
271 `c1` decimal(10,0) NOT NULL,
272 `c2` decimal(10,0) DEFAULT NULL
273 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
277 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 NUMERIC);
281 SHOW CREATE TABLE t1;
283 t1 CREATE TABLE `t1` (
284 `c1` decimal(10,0) NOT NULL,
285 `c2` decimal(10,0) DEFAULT NULL
286 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
287 ALTER TABLE t1 RENAME t2;
292 ERROR 42S02: Unknown table 't1'
293 SHOW CREATE TABLE t2;
295 t2 CREATE TABLE `t2` (
296 `c1` decimal(10,0) NOT NULL,
297 `c2` decimal(10,0) DEFAULT NULL
298 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
302 CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE);
306 SHOW CREATE TABLE t1;
308 t1 CREATE TABLE `t1` (
310 `c2` date DEFAULT NULL
311 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
312 ALTER TABLE t1 RENAME t2;
317 ERROR 42S02: Unknown table 't1'
318 SHOW CREATE TABLE t2;
320 t2 CREATE TABLE `t2` (
322 `c2` date DEFAULT NULL
323 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
327 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME);
331 SHOW CREATE TABLE t1;
333 t1 CREATE TABLE `t1` (
335 `c2` time DEFAULT NULL
336 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
337 ALTER TABLE t1 RENAME t2;
342 ERROR 42S02: Unknown table 't1'
343 SHOW CREATE TABLE t2;
345 t2 CREATE TABLE `t2` (
347 `c2` time DEFAULT NULL
348 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
352 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP);
356 SHOW CREATE TABLE t1;
358 t1 CREATE TABLE `t1` (
359 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
360 `c2` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
361 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
362 ALTER TABLE t1 RENAME t2;
367 ERROR 42S02: Unknown table 't1'
368 SHOW CREATE TABLE t2;
370 t2 CREATE TABLE `t2` (
371 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
372 `c2` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
373 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
377 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR);
381 SHOW CREATE TABLE t1;
383 t1 CREATE TABLE `t1` (
384 `c1` year(4) NOT NULL,
385 `c2` year(4) DEFAULT NULL
386 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
387 ALTER TABLE t1 RENAME t2;
392 ERROR 42S02: Unknown table 't1'
393 SHOW CREATE TABLE t2;
395 t2 CREATE TABLE `t2` (
396 `c1` year(4) NOT NULL,
397 `c2` year(4) DEFAULT NULL
398 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
402 CREATE TABLE t1(c1 BIT NOT NULL, c2 BIT);
406 SHOW CREATE TABLE t1;
408 t1 CREATE TABLE `t1` (
409 `c1` bit(1) NOT NULL,
410 `c2` bit(1) DEFAULT NULL
411 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
412 ALTER TABLE t1 RENAME TO t2;
417 ERROR 42S02: Unknown table 't1'
418 SHOW CREATE TABLE t2;
420 t2 CREATE TABLE `t2` (
421 `c1` bit(1) NOT NULL,
422 `c2` bit(1) DEFAULT NULL
423 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
427 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TINYINT);
431 SHOW CREATE TABLE t1;
433 t1 CREATE TABLE `t1` (
434 `c1` tinyint(4) NOT NULL,
435 `c2` tinyint(4) DEFAULT NULL
436 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
437 ALTER TABLE t1 RENAME TO t2;
442 ERROR 42S02: Unknown table 't1'
443 SHOW CREATE TABLE t2;
445 t2 CREATE TABLE `t2` (
446 `c1` tinyint(4) NOT NULL,
447 `c2` tinyint(4) DEFAULT NULL
448 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
452 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 SMALLINT);
456 SHOW CREATE TABLE t1;
458 t1 CREATE TABLE `t1` (
459 `c1` smallint(6) NOT NULL,
460 `c2` smallint(6) DEFAULT NULL
461 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
462 ALTER TABLE t1 RENAME TO t2;
467 ERROR 42S02: Unknown table 't1'
468 SHOW CREATE TABLE t2;
470 t2 CREATE TABLE `t2` (
471 `c1` smallint(6) NOT NULL,
472 `c2` smallint(6) DEFAULT NULL
473 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
477 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 MEDIUMINT);
481 SHOW CREATE TABLE t1;
483 t1 CREATE TABLE `t1` (
484 `c1` mediumint(9) NOT NULL,
485 `c2` mediumint(9) DEFAULT NULL
486 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
487 ALTER TABLE t1 RENAME TO t2;
492 ERROR 42S02: Unknown table 't1'
493 SHOW CREATE TABLE t2;
495 t2 CREATE TABLE `t2` (
496 `c1` mediumint(9) NOT NULL,
497 `c2` mediumint(9) DEFAULT NULL
498 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
502 CREATE TABLE t1(c1 INT NOT NULL, c2 INT);
506 SHOW CREATE TABLE t1;
508 t1 CREATE TABLE `t1` (
509 `c1` int(11) NOT NULL,
510 `c2` int(11) DEFAULT NULL
511 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
512 ALTER TABLE t1 RENAME TO t2;
517 ERROR 42S02: Unknown table 't1'
518 SHOW CREATE TABLE t2;
520 t2 CREATE TABLE `t2` (
521 `c1` int(11) NOT NULL,
522 `c2` int(11) DEFAULT NULL
523 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
527 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INTEGER);
531 SHOW CREATE TABLE t1;
533 t1 CREATE TABLE `t1` (
534 `c1` int(11) NOT NULL,
535 `c2` int(11) DEFAULT NULL
536 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
537 ALTER TABLE t1 RENAME TO t2;
542 ERROR 42S02: Unknown table 't1'
543 SHOW CREATE TABLE t2;
545 t2 CREATE TABLE `t2` (
546 `c1` int(11) NOT NULL,
547 `c2` int(11) DEFAULT NULL
548 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
552 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 BIGINT);
556 SHOW CREATE TABLE t1;
558 t1 CREATE TABLE `t1` (
559 `c1` bigint(20) NOT NULL,
560 `c2` bigint(20) DEFAULT NULL
561 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
562 ALTER TABLE t1 RENAME TO t2;
567 ERROR 42S02: Unknown table 't1'
568 SHOW CREATE TABLE t2;
570 t2 CREATE TABLE `t2` (
571 `c1` bigint(20) NOT NULL,
572 `c2` bigint(20) DEFAULT NULL
573 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
577 CREATE TABLE t1(c1 REAL NOT NULL, c2 REAL);
581 SHOW CREATE TABLE t1;
583 t1 CREATE TABLE `t1` (
584 `c1` double NOT NULL,
585 `c2` double DEFAULT NULL
586 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
587 ALTER TABLE t1 RENAME TO t2;
592 ERROR 42S02: Unknown table 't1'
593 SHOW CREATE TABLE t2;
595 t2 CREATE TABLE `t2` (
596 `c1` double NOT NULL,
597 `c2` double DEFAULT NULL
598 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
602 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DOUBLE);
606 SHOW CREATE TABLE t1;
608 t1 CREATE TABLE `t1` (
609 `c1` double NOT NULL,
610 `c2` double DEFAULT NULL
611 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
612 ALTER TABLE t1 RENAME TO t2;
617 ERROR 42S02: Unknown table 't1'
618 SHOW CREATE TABLE t2;
620 t2 CREATE TABLE `t2` (
621 `c1` double NOT NULL,
622 `c2` double DEFAULT NULL
623 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
627 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 FLOAT);
631 SHOW CREATE TABLE t1;
633 t1 CREATE TABLE `t1` (
635 `c2` float DEFAULT NULL
636 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
637 ALTER TABLE t1 RENAME TO t2;
642 ERROR 42S02: Unknown table 't1'
643 SHOW CREATE TABLE t2;
645 t2 CREATE TABLE `t2` (
647 `c2` float DEFAULT NULL
648 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
652 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DECIMAL);
656 SHOW CREATE TABLE t1;
658 t1 CREATE TABLE `t1` (
659 `c1` decimal(10,0) NOT NULL,
660 `c2` decimal(10,0) DEFAULT NULL
661 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
662 ALTER TABLE t1 RENAME TO t2;
667 ERROR 42S02: Unknown table 't1'
668 SHOW CREATE TABLE t2;
670 t2 CREATE TABLE `t2` (
671 `c1` decimal(10,0) NOT NULL,
672 `c2` decimal(10,0) DEFAULT NULL
673 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
677 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 NUMERIC);
681 SHOW CREATE TABLE t1;
683 t1 CREATE TABLE `t1` (
684 `c1` decimal(10,0) NOT NULL,
685 `c2` decimal(10,0) DEFAULT NULL
686 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
687 ALTER TABLE t1 RENAME TO t2;
692 ERROR 42S02: Unknown table 't1'
693 SHOW CREATE TABLE t2;
695 t2 CREATE TABLE `t2` (
696 `c1` decimal(10,0) NOT NULL,
697 `c2` decimal(10,0) DEFAULT NULL
698 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
702 CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE);
706 SHOW CREATE TABLE t1;
708 t1 CREATE TABLE `t1` (
710 `c2` date DEFAULT NULL
711 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
712 ALTER TABLE t1 RENAME TO t2;
717 ERROR 42S02: Unknown table 't1'
718 SHOW CREATE TABLE t2;
720 t2 CREATE TABLE `t2` (
722 `c2` date DEFAULT NULL
723 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
727 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME);
731 SHOW CREATE TABLE t1;
733 t1 CREATE TABLE `t1` (
735 `c2` time DEFAULT NULL
736 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
737 ALTER TABLE t1 RENAME TO t2;
742 ERROR 42S02: Unknown table 't1'
743 SHOW CREATE TABLE t2;
745 t2 CREATE TABLE `t2` (
747 `c2` time DEFAULT NULL
748 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
752 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP);
756 SHOW CREATE TABLE t1;
758 t1 CREATE TABLE `t1` (
759 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
760 `c2` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
761 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
762 ALTER TABLE t1 RENAME TO t2;
767 ERROR 42S02: Unknown table 't1'
768 SHOW CREATE TABLE t2;
770 t2 CREATE TABLE `t2` (
771 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
772 `c2` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
773 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
777 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR);
781 SHOW CREATE TABLE t1;
783 t1 CREATE TABLE `t1` (
784 `c1` year(4) NOT NULL,
785 `c2` year(4) DEFAULT NULL
786 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
787 ALTER TABLE t1 RENAME TO t2;
792 ERROR 42S02: Unknown table 't1'
793 SHOW CREATE TABLE t2;
795 t2 CREATE TABLE `t2` (
796 `c1` year(4) NOT NULL,
797 `c2` year(4) DEFAULT NULL
798 ) ENGINE=ENGINE DEFAULT CHARSET=latin1