1# drop primary key should work. 5.5 alter table has a bug where drop pk returns invalid key prefix 2 3source include/have_tokudb.inc; 4set default_storage_engine=tokudb; 5 6disable_warnings; 7DROP TABLE IF EXISTS testtable; 8enable_warnings; 9 10CREATE TABLE `testtable` ( 11 `id` INT(11) NOT NULL, 12 `keyword` VARCHAR(299) DEFAULT NULL, 13 PRIMARY KEY (`id`), 14 KEY `keyword` (`keyword`(100)) 15) ENGINE=TokuDB DEFAULT CHARSET=utf8 COMPRESSION=TOKUDB_QUICKLZ; 16 17set tokudb_disable_hot_alter=ON; 18ALTER TABLE testtable DROP PRIMARY KEY; 19 20drop table testtable; 21 22CREATE TABLE `testtable` ( 23 `id` INT(11) NOT NULL, 24 `keyword` VARCHAR(299) DEFAULT NULL, 25 PRIMARY KEY (`id`), 26 KEY `keyword` (`keyword`(100)) 27) ENGINE=TokuDB DEFAULT CHARSET=utf8 COMPRESSION=TOKUDB_QUICKLZ; 28 29set tokudb_disable_hot_alter=OFF; 30ALTER TABLE testtable DROP PRIMARY KEY; 31 32drop table testtable; 33