diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/ta_rename.result')
| -rw-r--r-- | mysql-test/suite/engines/funcs/r/ta_rename.result | 128 |
1 files changed, 64 insertions, 64 deletions
diff --git a/mysql-test/suite/engines/funcs/r/ta_rename.result b/mysql-test/suite/engines/funcs/r/ta_rename.result index f3d2a4aa514..7a1490e4f79 100644 --- a/mysql-test/suite/engines/funcs/r/ta_rename.result +++ b/mysql-test/suite/engines/funcs/r/ta_rename.result @@ -8,7 +8,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` bit(1) NOT NULL, `c2` bit(1) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME t2; SHOW TABLES; Tables_in_test @@ -20,7 +20,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` bit(1) NOT NULL, `c2` bit(1) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -33,7 +33,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` tinyint(4) NOT NULL, `c2` tinyint(4) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME t2; SHOW TABLES; Tables_in_test @@ -45,7 +45,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` tinyint(4) NOT NULL, `c2` tinyint(4) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -58,7 +58,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` smallint(6) NOT NULL, `c2` smallint(6) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME t2; SHOW TABLES; Tables_in_test @@ -70,7 +70,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` smallint(6) NOT NULL, `c2` smallint(6) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -83,7 +83,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` mediumint(9) NOT NULL, `c2` mediumint(9) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME t2; SHOW TABLES; Tables_in_test @@ -95,7 +95,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` mediumint(9) NOT NULL, `c2` mediumint(9) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -108,7 +108,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, `c2` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME t2; SHOW TABLES; Tables_in_test @@ -120,7 +120,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` int(11) NOT NULL, `c2` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -133,7 +133,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, `c2` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME t2; SHOW TABLES; Tables_in_test @@ -145,7 +145,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` int(11) NOT NULL, `c2` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -158,7 +158,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` bigint(20) NOT NULL, `c2` bigint(20) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME t2; SHOW TABLES; Tables_in_test @@ -170,7 +170,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` bigint(20) NOT NULL, `c2` bigint(20) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -183,7 +183,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` double NOT NULL, `c2` double DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME t2; SHOW TABLES; Tables_in_test @@ -195,7 +195,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` double NOT NULL, `c2` double DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -208,7 +208,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` double NOT NULL, `c2` double DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME t2; SHOW TABLES; Tables_in_test @@ -220,7 +220,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` double NOT NULL, `c2` double DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -233,7 +233,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` float NOT NULL, `c2` float DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME t2; SHOW TABLES; Tables_in_test @@ -245,7 +245,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` float NOT NULL, `c2` float DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -258,7 +258,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` decimal(10,0) NOT NULL, `c2` decimal(10,0) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME t2; SHOW TABLES; Tables_in_test @@ -270,7 +270,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` decimal(10,0) NOT NULL, `c2` decimal(10,0) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -283,7 +283,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` decimal(10,0) NOT NULL, `c2` decimal(10,0) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME t2; SHOW TABLES; Tables_in_test @@ -295,7 +295,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` decimal(10,0) NOT NULL, `c2` decimal(10,0) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -308,7 +308,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` date NOT NULL, `c2` date DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME t2; SHOW TABLES; Tables_in_test @@ -320,7 +320,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` date NOT NULL, `c2` date DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -333,7 +333,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` time NOT NULL, `c2` time DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME t2; SHOW TABLES; Tables_in_test @@ -345,7 +345,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` time NOT NULL, `c2` time DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -358,7 +358,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `c2` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME t2; SHOW TABLES; Tables_in_test @@ -370,7 +370,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `c2` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -383,7 +383,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` year(4) NOT NULL, `c2` year(4) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME t2; SHOW TABLES; Tables_in_test @@ -395,7 +395,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` year(4) NOT NULL, `c2` year(4) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -408,7 +408,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` bit(1) NOT NULL, `c2` bit(1) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME TO t2; SHOW TABLES; Tables_in_test @@ -420,7 +420,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` bit(1) NOT NULL, `c2` bit(1) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -433,7 +433,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` tinyint(4) NOT NULL, `c2` tinyint(4) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME TO t2; SHOW TABLES; Tables_in_test @@ -445,7 +445,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` tinyint(4) NOT NULL, `c2` tinyint(4) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -458,7 +458,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` smallint(6) NOT NULL, `c2` smallint(6) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME TO t2; SHOW TABLES; Tables_in_test @@ -470,7 +470,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` smallint(6) NOT NULL, `c2` smallint(6) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -483,7 +483,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` mediumint(9) NOT NULL, `c2` mediumint(9) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME TO t2; SHOW TABLES; Tables_in_test @@ -495,7 +495,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` mediumint(9) NOT NULL, `c2` mediumint(9) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -508,7 +508,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, `c2` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME TO t2; SHOW TABLES; Tables_in_test @@ -520,7 +520,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` int(11) NOT NULL, `c2` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -533,7 +533,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, `c2` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME TO t2; SHOW TABLES; Tables_in_test @@ -545,7 +545,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` int(11) NOT NULL, `c2` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -558,7 +558,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` bigint(20) NOT NULL, `c2` bigint(20) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME TO t2; SHOW TABLES; Tables_in_test @@ -570,7 +570,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` bigint(20) NOT NULL, `c2` bigint(20) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -583,7 +583,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` double NOT NULL, `c2` double DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME TO t2; SHOW TABLES; Tables_in_test @@ -595,7 +595,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` double NOT NULL, `c2` double DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -608,7 +608,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` double NOT NULL, `c2` double DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME TO t2; SHOW TABLES; Tables_in_test @@ -620,7 +620,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` double NOT NULL, `c2` double DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -633,7 +633,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` float NOT NULL, `c2` float DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME TO t2; SHOW TABLES; Tables_in_test @@ -645,7 +645,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` float NOT NULL, `c2` float DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -658,7 +658,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` decimal(10,0) NOT NULL, `c2` decimal(10,0) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME TO t2; SHOW TABLES; Tables_in_test @@ -670,7 +670,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` decimal(10,0) NOT NULL, `c2` decimal(10,0) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -683,7 +683,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` decimal(10,0) NOT NULL, `c2` decimal(10,0) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME TO t2; SHOW TABLES; Tables_in_test @@ -695,7 +695,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` decimal(10,0) NOT NULL, `c2` decimal(10,0) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -708,7 +708,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` date NOT NULL, `c2` date DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME TO t2; SHOW TABLES; Tables_in_test @@ -720,7 +720,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` date NOT NULL, `c2` date DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -733,7 +733,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` time NOT NULL, `c2` time DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME TO t2; SHOW TABLES; Tables_in_test @@ -745,7 +745,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` time NOT NULL, `c2` time DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -758,7 +758,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `c2` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME TO t2; SHOW TABLES; Tables_in_test @@ -770,7 +770,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `c2` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test @@ -783,7 +783,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` year(4) NOT NULL, `c2` year(4) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 RENAME TO t2; SHOW TABLES; Tables_in_test @@ -795,7 +795,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` year(4) NOT NULL, `c2` year(4) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SHOW TABLES; Tables_in_test |