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