diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/ta_column_from_unsigned.result')
| -rw-r--r-- | mysql-test/suite/engines/funcs/r/ta_column_from_unsigned.result | 176 |
1 files changed, 88 insertions, 88 deletions
diff --git a/mysql-test/suite/engines/funcs/r/ta_column_from_unsigned.result b/mysql-test/suite/engines/funcs/r/ta_column_from_unsigned.result index 4690dbb73a7..614ee5469b8 100644 --- a/mysql-test/suite/engines/funcs/r/ta_column_from_unsigned.result +++ b/mysql-test/suite/engines/funcs/r/ta_column_from_unsigned.result @@ -7,7 +7,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` tinyint(3) unsigned DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 MODIFY c1 TINYINT NULL; SHOW TABLES; Tables_in_test @@ -16,7 +16,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` tinyint(4) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -28,7 +28,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` smallint(5) unsigned DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 MODIFY c1 SMALLINT NULL; SHOW TABLES; Tables_in_test @@ -37,7 +37,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` smallint(6) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -49,7 +49,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` mediumint(8) unsigned DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 MODIFY c1 MEDIUMINT NULL; SHOW TABLES; Tables_in_test @@ -58,7 +58,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` mediumint(9) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -70,7 +70,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` int(10) unsigned DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 MODIFY c1 INT NULL; SHOW TABLES; Tables_in_test @@ -79,7 +79,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -91,7 +91,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` int(10) unsigned DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 MODIFY c1 INTEGER NULL; SHOW TABLES; Tables_in_test @@ -100,7 +100,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -112,7 +112,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` bigint(20) unsigned DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 MODIFY c1 BIGINT NULL; SHOW TABLES; Tables_in_test @@ -121,7 +121,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` bigint(20) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -133,7 +133,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` double unsigned DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 MODIFY c1 REAL NULL; SHOW TABLES; Tables_in_test @@ -142,7 +142,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` double DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -154,7 +154,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` double unsigned DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 MODIFY c1 DOUBLE NULL; SHOW TABLES; Tables_in_test @@ -163,7 +163,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` double DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -175,7 +175,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` float unsigned DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 MODIFY c1 FLOAT NULL; SHOW TABLES; Tables_in_test @@ -184,7 +184,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` float DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -196,7 +196,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` decimal(10,0) unsigned DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 MODIFY c1 DECIMAL NULL; SHOW TABLES; Tables_in_test @@ -205,7 +205,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` decimal(10,0) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -217,7 +217,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` decimal(10,0) unsigned DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 MODIFY c1 NUMERIC NULL; SHOW TABLES; Tables_in_test @@ -226,7 +226,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` decimal(10,0) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -238,7 +238,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` tinyint(3) unsigned DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 CHANGE c1 c1 TINYINT NULL; SHOW TABLES; Tables_in_test @@ -247,7 +247,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` tinyint(4) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -259,7 +259,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` smallint(5) unsigned DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 CHANGE c1 c1 SMALLINT NULL; SHOW TABLES; Tables_in_test @@ -268,7 +268,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` smallint(6) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -280,7 +280,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` mediumint(8) unsigned DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 CHANGE c1 c1 MEDIUMINT NULL; SHOW TABLES; Tables_in_test @@ -289,7 +289,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` mediumint(9) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -301,7 +301,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` int(10) unsigned DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 CHANGE c1 c1 INT NULL; SHOW TABLES; Tables_in_test @@ -310,7 +310,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -322,7 +322,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` int(10) unsigned DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 CHANGE c1 c1 INTEGER NULL; SHOW TABLES; Tables_in_test @@ -331,7 +331,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -343,7 +343,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` bigint(20) unsigned DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 CHANGE c1 c1 BIGINT NULL; SHOW TABLES; Tables_in_test @@ -352,7 +352,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` bigint(20) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -364,7 +364,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` double unsigned DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 CHANGE c1 c1 REAL NULL; SHOW TABLES; Tables_in_test @@ -373,7 +373,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` double DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -385,7 +385,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` double unsigned DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 CHANGE c1 c1 DOUBLE NULL; SHOW TABLES; Tables_in_test @@ -394,7 +394,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` double DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -406,7 +406,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` float unsigned DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 CHANGE c1 c1 FLOAT NULL; SHOW TABLES; Tables_in_test @@ -415,7 +415,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` float DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -427,7 +427,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` decimal(10,0) unsigned DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 CHANGE c1 c1 DECIMAL NULL; SHOW TABLES; Tables_in_test @@ -436,7 +436,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` decimal(10,0) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -448,7 +448,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` decimal(10,0) unsigned DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 CHANGE c1 c1 NUMERIC NULL; SHOW TABLES; Tables_in_test @@ -457,7 +457,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` decimal(10,0) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -469,7 +469,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` tinyint(3) unsigned NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 MODIFY c1 TINYINT NOT NULL; SHOW TABLES; Tables_in_test @@ -478,7 +478,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` tinyint(4) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -490,7 +490,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` smallint(5) unsigned NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 MODIFY c1 SMALLINT NOT NULL; SHOW TABLES; Tables_in_test @@ -499,7 +499,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` smallint(6) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -511,7 +511,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` mediumint(8) unsigned NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 MODIFY c1 MEDIUMINT NOT NULL; SHOW TABLES; Tables_in_test @@ -520,7 +520,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` mediumint(9) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -532,7 +532,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` int(10) unsigned NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 MODIFY c1 INT NOT NULL; SHOW TABLES; Tables_in_test @@ -541,7 +541,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` int(11) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -553,7 +553,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` int(10) unsigned NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 MODIFY c1 INTEGER NOT NULL; SHOW TABLES; Tables_in_test @@ -562,7 +562,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` int(11) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -574,7 +574,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` bigint(20) unsigned NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 MODIFY c1 BIGINT NOT NULL; SHOW TABLES; Tables_in_test @@ -583,7 +583,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` bigint(20) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -595,7 +595,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` double unsigned NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 MODIFY c1 REAL NOT NULL; SHOW TABLES; Tables_in_test @@ -604,7 +604,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` double NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -616,7 +616,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` double unsigned NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 MODIFY c1 DOUBLE NOT NULL; SHOW TABLES; Tables_in_test @@ -625,7 +625,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` double NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -637,7 +637,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` float unsigned NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 MODIFY c1 FLOAT NOT NULL; SHOW TABLES; Tables_in_test @@ -646,7 +646,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` float NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -658,7 +658,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` decimal(10,0) unsigned NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 MODIFY c1 DECIMAL NOT NULL; SHOW TABLES; Tables_in_test @@ -667,7 +667,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` decimal(10,0) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -679,7 +679,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` decimal(10,0) unsigned NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 MODIFY c1 NUMERIC NOT NULL; SHOW TABLES; Tables_in_test @@ -688,7 +688,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` decimal(10,0) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -700,7 +700,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` tinyint(3) unsigned NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 CHANGE c1 c1 TINYINT NOT NULL; SHOW TABLES; Tables_in_test @@ -709,7 +709,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` tinyint(4) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -721,7 +721,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` smallint(5) unsigned NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 CHANGE c1 c1 SMALLINT NOT NULL; SHOW TABLES; Tables_in_test @@ -730,7 +730,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` smallint(6) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -742,7 +742,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` mediumint(8) unsigned NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 CHANGE c1 c1 MEDIUMINT NOT NULL; SHOW TABLES; Tables_in_test @@ -751,7 +751,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` mediumint(9) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -763,7 +763,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` int(10) unsigned NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 CHANGE c1 c1 INT NOT NULL; SHOW TABLES; Tables_in_test @@ -772,7 +772,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` int(11) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -784,7 +784,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` int(10) unsigned NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 CHANGE c1 c1 INTEGER NOT NULL; SHOW TABLES; Tables_in_test @@ -793,7 +793,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` int(11) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -805,7 +805,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` bigint(20) unsigned NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 CHANGE c1 c1 BIGINT NOT NULL; SHOW TABLES; Tables_in_test @@ -814,7 +814,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` bigint(20) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -826,7 +826,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` double unsigned NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 CHANGE c1 c1 REAL NOT NULL; SHOW TABLES; Tables_in_test @@ -835,7 +835,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` double NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -847,7 +847,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` double unsigned NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 CHANGE c1 c1 DOUBLE NOT NULL; SHOW TABLES; Tables_in_test @@ -856,7 +856,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` double NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -868,7 +868,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` float unsigned NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 CHANGE c1 c1 FLOAT NOT NULL; SHOW TABLES; Tables_in_test @@ -877,7 +877,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` float NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -889,7 +889,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` decimal(10,0) unsigned NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 CHANGE c1 c1 DECIMAL NOT NULL; SHOW TABLES; Tables_in_test @@ -898,7 +898,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` decimal(10,0) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test @@ -910,7 +910,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` decimal(10,0) unsigned NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t3 CHANGE c1 c1 NUMERIC NOT NULL; SHOW TABLES; Tables_in_test @@ -919,7 +919,7 @@ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` decimal(10,0) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t3; SHOW TABLES; Tables_in_test |