EVOLUTION-MANAGER

Edit File: tc_column_not_null.result

DROP TABLE IF EXISTS t2; CREATE TABLE t2(c1 BIT NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` bit(1) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 TINYINT NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` tinyint(4) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 SMALLINT NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` smallint(6) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 MEDIUMINT NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` mediumint(9) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 INT NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` int(11) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 INTEGER NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` int(11) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 BIGINT NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` bigint(20) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 DECIMAL NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` decimal(10,0) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 DEC NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` decimal(10,0) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 FIXED NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` decimal(10,0) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 NUMERIC NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` decimal(10,0) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 DOUBLE NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` double NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 REAL NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` double NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 DOUBLE PRECISION NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` double NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 FLOAT NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` float NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 DATE NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` date NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 TIME NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` time NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 TIMESTAMP NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 DATETIME NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` datetime NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 YEAR NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` year(4) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 TINYBLOB NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` tinyblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 BLOB NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` blob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 MEDIUMBLOB NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` mediumblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 LONGBLOB NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` longblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 TINYTEXT NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` tinytext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 TEXT NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` text NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 MEDIUMTEXT NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` mediumtext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test CREATE TABLE t2(c1 LONGTEXT NOT NULL); SHOW TABLES; Tables_in_test t2 SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` longtext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t2; SHOW TABLES; Tables_in_test