EVOLUTION-MANAGER
Edit File: ai_part.result
SET DEFAULT_STORAGE_ENGINE='TokuDB'; DROP TABLE IF EXISTS foo; SET SESSION tokudb_disable_slow_alter=1; CREATE TABLE foo (a INT, b INT, PRIMARY KEY (a)) PARTITION BY HASH(a) PARTITIONS 2; INSERT INTO foo VALUES (1,0),(2,0); SHOW CREATE TABLE foo; Table Create Table foo CREATE TABLE `foo` ( `a` int(11) NOT NULL, `b` int(11) DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 PARTITION BY HASH (`a`) PARTITIONS 2 ALTER TABLE foo ADD KEY(b); SHOW CREATE TABLE foo; Table Create Table foo CREATE TABLE `foo` ( `a` int(11) NOT NULL, `b` int(11) DEFAULT NULL, PRIMARY KEY (`a`), KEY `b` (`b`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 PARTITION BY HASH (`a`) PARTITIONS 2 DROP TABLE foo;