Edit File: ta_string_to_null.result
DROP TABLE IF EXISTS t2; CREATE TABLE t2(c1 CHAR(200) NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` char(200) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t2 MODIFY c1 CHAR(200) NULL; SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` char(200) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 VARCHAR(200) NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` varchar(200) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t2 MODIFY c1 VARCHAR(200) NULL; SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` varchar(200) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 BINARY(200) NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` binary(200) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t2 MODIFY c1 BINARY(200) NULL; SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` binary(200) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 VARBINARY(200) NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` varbinary(200) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t2 MODIFY c1 VARBINARY(200) NULL; SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` varbinary(200) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 CHAR(200) NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` char(200) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t2 CHANGE c1 c1 CHAR(200) NULL; SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` char(200) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 VARCHAR(200) NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` varchar(200) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t2 CHANGE c1 c1 VARCHAR(200) NULL; SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` varchar(200) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 BINARY(200) NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` binary(200) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t2 CHANGE c1 c1 BINARY(200) NULL; SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` binary(200) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 VARBINARY(200) NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` varbinary(200) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t2 CHANGE c1 c1 VARBINARY(200) NULL; SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` varbinary(200) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test
Back to File Manager