diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/ta_string_to_not_null.result')
-rw-r--r-- | mysql-test/suite/engines/funcs/r/ta_string_to_not_null.result | 32 |
1 files changed, 16 insertions, 16 deletions
diff --git a/mysql-test/suite/engines/funcs/r/ta_string_to_not_null.result b/mysql-test/suite/engines/funcs/r/ta_string_to_not_null.result index af165597820..6236206409f 100644 --- a/mysql-test/suite/engines/funcs/r/ta_string_to_not_null.result +++ b/mysql-test/suite/engines/funcs/r/ta_string_to_not_null.result @@ -7,7 +7,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` char(100) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 MODIFY c1 CHAR(100) NOT NULL; SHOW TABLES; Tables_in_test @@ -16,7 +16,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` char(100) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -28,7 +28,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` varchar(100) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 MODIFY c1 VARCHAR(100) NOT NULL; SHOW TABLES; Tables_in_test @@ -37,7 +37,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` varchar(100) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -49,7 +49,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` binary(100) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 MODIFY c1 BINARY(100) NOT NULL; SHOW TABLES; Tables_in_test @@ -58,7 +58,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` binary(100) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -70,7 +70,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` varbinary(100) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 MODIFY c1 VARBINARY(100) NOT NULL; SHOW TABLES; Tables_in_test @@ -79,7 +79,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` varbinary(100) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -91,7 +91,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` char(100) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 CHANGE c1 c1 CHAR(100) NOT NULL; SHOW TABLES; Tables_in_test @@ -100,7 +100,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` char(100) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -112,7 +112,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` varchar(100) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 CHANGE c1 c1 VARCHAR(100) NOT NULL; SHOW TABLES; Tables_in_test @@ -121,7 +121,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` varchar(100) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -133,7 +133,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` binary(100) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 CHANGE c1 c1 BINARY(100) NOT NULL; SHOW TABLES; Tables_in_test @@ -142,7 +142,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` binary(100) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -154,7 +154,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` varbinary(100) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ALTER TABLE t1 CHANGE c1 c1 VARBINARY(100) NOT NULL; SHOW TABLES; Tables_in_test @@ -163,7 +163,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` varbinary(100) NOT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; SHOW TABLES; Tables_in_test |