EVOLUTION-MANAGER

Edit File: ta_drop_pk_number.result

DROP TABLE IF EXISTS t9; CREATE TABLE t9(c1 BIT NOT NULL PRIMARY KEY); SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` bit(1) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t9 DROP PRIMARY KEY; SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` bit(1) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t9; SHOW TABLES; Tables_in_test CREATE TABLE t9(c1 TINYINT NOT NULL PRIMARY KEY); SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` tinyint(4) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t9 DROP PRIMARY KEY; SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` tinyint(4) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t9; SHOW TABLES; Tables_in_test CREATE TABLE t9(c1 SMALLINT NOT NULL PRIMARY KEY); SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` smallint(6) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t9 DROP PRIMARY KEY; SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` smallint(6) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t9; SHOW TABLES; Tables_in_test CREATE TABLE t9(c1 MEDIUMINT NOT NULL PRIMARY KEY); SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` mediumint(9) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t9 DROP PRIMARY KEY; SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` mediumint(9) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t9; SHOW TABLES; Tables_in_test CREATE TABLE t9(c1 INT NOT NULL PRIMARY KEY); SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t9 DROP PRIMARY KEY; SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` int(11) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t9; SHOW TABLES; Tables_in_test CREATE TABLE t9(c1 INTEGER NOT NULL PRIMARY KEY); SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t9 DROP PRIMARY KEY; SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` int(11) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t9; SHOW TABLES; Tables_in_test CREATE TABLE t9(c1 BIGINT NOT NULL PRIMARY KEY); SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` bigint(20) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t9 DROP PRIMARY KEY; SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` bigint(20) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t9; SHOW TABLES; Tables_in_test CREATE TABLE t9(c1 REAL NOT NULL PRIMARY KEY); SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` double NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t9 DROP PRIMARY KEY; SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` double NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t9; SHOW TABLES; Tables_in_test CREATE TABLE t9(c1 DOUBLE NOT NULL PRIMARY KEY); SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` double NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t9 DROP PRIMARY KEY; SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` double NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t9; SHOW TABLES; Tables_in_test CREATE TABLE t9(c1 FLOAT NOT NULL PRIMARY KEY); SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` float NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t9 DROP PRIMARY KEY; SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` float NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t9; SHOW TABLES; Tables_in_test CREATE TABLE t9(c1 DECIMAL NOT NULL PRIMARY KEY); SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` decimal(10,0) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t9 DROP PRIMARY KEY; SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` decimal(10,0) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t9; SHOW TABLES; Tables_in_test CREATE TABLE t9(c1 NUMERIC NOT NULL PRIMARY KEY); SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` decimal(10,0) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t9 DROP PRIMARY KEY; SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` decimal(10,0) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t9; SHOW TABLES; Tables_in_test CREATE TABLE t9(c1 DATE NOT NULL PRIMARY KEY); SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` date NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t9 DROP PRIMARY KEY; SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` date NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t9; SHOW TABLES; Tables_in_test CREATE TABLE t9(c1 TIME NOT NULL PRIMARY KEY); SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` time NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t9 DROP PRIMARY KEY; SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` time NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t9; SHOW TABLES; Tables_in_test CREATE TABLE t9(c1 TIMESTAMP NOT NULL PRIMARY KEY); SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`c1`) ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t9 DROP PRIMARY KEY; SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t9; SHOW TABLES; Tables_in_test CREATE TABLE t9(c1 YEAR NOT NULL PRIMARY KEY); SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` year(4) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t9 DROP PRIMARY KEY; SHOW TABLES; Tables_in_test t9 SHOW CREATE TABLE t9; Table Create Table t9 CREATE TABLE `t9` ( `c1` year(4) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t9; SHOW TABLES; Tables_in_test