create table t1 (a float not null, primary key(a)) engine='MYISAM' partition by key (a) ( partition pa1 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' max_rows=20 min_rows=2, partition pa2 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' max_rows=30 min_rows=3, partition pa3 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' max_rows=30 min_rows=4, partition pa4 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' max_rows=40 min_rows=2); show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` float NOT NULL, PRIMARY KEY (`a`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 DATA DIRECTORY='/tmp/' INDEX DIRECTORY='/tmp/' /*!50100 PARTITION BY KEY (a) (PARTITION pa1 MAX_ROWS = 20 MIN_ROWS = 2 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = MyISAM, PARTITION pa2 MAX_ROWS = 30 MIN_ROWS = 3 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = MyISAM, PARTITION pa3 MAX_ROWS = 30 MIN_ROWS = 4 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = MyISAM, PARTITION pa4 MAX_ROWS = 40 MIN_ROWS = 2 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = MyISAM) */ insert into t1 values (-3.402823466E+38), (3.402823466E+38), (-1.5), (-1), (0), (1), (1.5); select * from t1; a -3.40282e+38 -1.5 -1 0 1 1.5 3.40282e+38 select * from t1 where a=1.5; a 1.5 delete from t1 where a=1.5; select * from t1; a -3.40282e+38 -1.5 -1 0 1 3.40282e+38 drop table t1; create table t2 (a float not null, primary key(a)) engine='MYISAM' partition by key (a) partitions 10; show create table t2; Table Create Table t2 CREATE TABLE `t2` ( `a` float NOT NULL, PRIMARY KEY (`a`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) PARTITIONS 10 */ insert into t2 values (-3.402823466E+38), (-3.402823466E+37), (-123.456), (0), (1234546.789), (123.456), (1.5); select * from t2; a -3.40282e+38 -3.40282e+37 -123.456 0 1.5 123.456 1.23455e+06 select * from t2 where a=123.456; a delete from t2 where a=123.456; select * from t2; a -3.40282e+38 -3.40282e+37 -123.456 0 1.5 123.456 1.23455e+06 select * from t2 where a=1.5; a 1.5 delete from t2 where a=1.5; select * from t2; a -3.40282e+38 -3.40282e+37 -123.456 0 123.456 1.23455e+06 delete from t2; 16384*3 inserts; select count(*) from t2; count(*) 49152 drop table t2; create table t3 (a float not null, primary key(a)) engine='MYISAM' partition by range (cast(floor(a) as signed)) subpartition by key (a) subpartitions 3 ( partition pa1 values less than (3), partition pa3 values less than (6), partition pa10 values less than (10) ); show create table t3; Table Create Table t3 CREATE TABLE `t3` ( `a` float NOT NULL, PRIMARY KEY (`a`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (cast(floor(a) as signed)) SUBPARTITION BY KEY (a) SUBPARTITIONS 3 (PARTITION pa1 VALUES LESS THAN (3) ENGINE = MyISAM, PARTITION pa3 VALUES LESS THAN (6) ENGINE = MyISAM, PARTITION pa10 VALUES LESS THAN (10) ENGINE = MyISAM) */ 9*3 inserts; insert into t3 values (9); insert into t3 values (9+0.33); insert into t3 values (9+0.75); insert into t3 values (8); insert into t3 values (8+0.33); insert into t3 values (8+0.75); insert into t3 values (7); insert into t3 values (7+0.33); insert into t3 values (7+0.75); insert into t3 values (6); insert into t3 values (6+0.33); insert into t3 values (6+0.75); insert into t3 values (5); insert into t3 values (5+0.33); insert into t3 values (5+0.75); insert into t3 values (4); insert into t3 values (4+0.33); insert into t3 values (4+0.75); insert into t3 values (3); insert into t3 values (3+0.33); insert into t3 values (3+0.75); insert into t3 values (2); insert into t3 values (2+0.33); insert into t3 values (2+0.75); insert into t3 values (1); insert into t3 values (1+0.33); insert into t3 values (1+0.75); select count(*) from t3; count(*) 27 select * from t3; a 1 1.33 1.75 2 2.33 2.75 3 3.33 3.75 4 4.33 4.75 5 5.33 5.75 6 6.33 6.75 7 7.33 7.75 8 8.33 8.75 9 9.33 9.75 drop table t3; create table t4 (a float not null, primary key(a)) engine='MYISAM' partition by list (cast(floor(a) as signed)) subpartition by key (a) subpartitions 3 ( partition pa1 values in (1,2,3), partition pa3 values in (4,5,6), partition pa10 values in (7,8,9,10) ); show create table t4; Table Create Table t4 CREATE TABLE `t4` ( `a` float NOT NULL, PRIMARY KEY (`a`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (cast(floor(a) as signed)) SUBPARTITION BY KEY (a) SUBPARTITIONS 3 (PARTITION pa1 VALUES IN (1,2,3) ENGINE = MyISAM, PARTITION pa3 VALUES IN (4,5,6) ENGINE = MyISAM, PARTITION pa10 VALUES IN (7,8,9,10) ENGINE = MyISAM) */ 9*3 inserts; insert into t4 values (9); insert into t4 values (9+0.33); insert into t4 values (9+0.75); insert into t4 values (8); insert into t4 values (8+0.33); insert into t4 values (8+0.75); insert into t4 values (7); insert into t4 values (7+0.33); insert into t4 values (7+0.75); insert into t4 values (6); insert into t4 values (6+0.33); insert into t4 values (6+0.75); insert into t4 values (5); insert into t4 values (5+0.33); insert into t4 values (5+0.75); insert into t4 values (4); insert into t4 values (4+0.33); insert into t4 values (4+0.75); insert into t4 values (3); insert into t4 values (3+0.33); insert into t4 values (3+0.75); insert into t4 values (2); insert into t4 values (2+0.33); insert into t4 values (2+0.75); insert into t4 values (1); insert into t4 values (1+0.33); insert into t4 values (1+0.75); select count(*) from t4; count(*) 27 select * from t4; a 1 1.33 1.75 2 2.33 2.75 3 3.33 3.75 4 4.33 4.75 5 5.33 5.75 6 6.33 6.75 7 7.33 7.75 8 8.33 8.75 9 9.33 9.75 drop table t4; create table t1 (a double not null, primary key(a)) engine='MYISAM' partition by key (a) ( partition pa1 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' max_rows=20 min_rows=2, partition pa2 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' max_rows=30 min_rows=3, partition pa3 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' max_rows=30 min_rows=4, partition pa4 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' max_rows=40 min_rows=2); show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` double NOT NULL, PRIMARY KEY (`a`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 DATA DIRECTORY='/tmp/' INDEX DIRECTORY='/tmp/' /*!50100 PARTITION BY KEY (a) (PARTITION pa1 MAX_ROWS = 20 MIN_ROWS = 2 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = MyISAM, PARTITION pa2 MAX_ROWS = 30 MIN_ROWS = 3 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = MyISAM, PARTITION pa3 MAX_ROWS = 30 MIN_ROWS = 4 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = MyISAM, PARTITION pa4 MAX_ROWS = 40 MIN_ROWS = 2 DATA DIRECTORY = '/tmp' INDEX DIRECTORY = '/tmp' ENGINE = MyISAM) */ insert into t1 values (-2.2250738585072014E+208), (-2.2250738585072014E-208), (-1.5), (-1), (0), (1.5), (1234.567), (2.2250738585072014E+208); select * from t1; a -2.2250738585072e+208 -1.5 -1 -2.2250738585072e-208 0 1.5 1234.567 2.2250738585072e+208 select * from t1 where a=1.5; a 1.5 delete from t1 where a=1.5; select * from t1; a -2.2250738585072e+208 -1.5 -1 -2.2250738585072e-208 0 1234.567 2.2250738585072e+208 drop table t1; create table t2 (a double not null, primary key(a)) engine='MYISAM' partition by key (a) partitions 10; show create table t2; Table Create Table t2 CREATE TABLE `t2` ( `a` double NOT NULL, PRIMARY KEY (`a`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) PARTITIONS 10 */ insert into t2 values (-2.2250738585072014E+208), (-2.2250738585072014E-208), (-1.5), (-1), (0), (1.5), (1234.567), (2.2250738585072014E+208); select * from t2; a -2.2250738585072e+208 -1.5 -1 -2.2250738585072e-208 0 1.5 1234.567 2.2250738585072e+208 select * from t2 where a=1234.567; a 1234.567 delete from t2 where a=1234.567; select * from t2; a -2.2250738585072e+208 -1.5 -1 -2.2250738585072e-208 0 1.5 2.2250738585072e+208 delete from t2; 16384*3 inserts; select count(*) from t2; count(*) 49152 drop table t2; create table t3 (a double not null, primary key(a)) engine='MYISAM' partition by range (cast(floor(a) as signed)) subpartition by key (a) subpartitions 3 ( partition pa1 values less than (3), partition pa3 values less than (6), partition pa10 values less than (10) ); show create table t3; Table Create Table t3 CREATE TABLE `t3` ( `a` double NOT NULL, PRIMARY KEY (`a`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (cast(floor(a) as signed)) SUBPARTITION BY KEY (a) SUBPARTITIONS 3 (PARTITION pa1 VALUES LESS THAN (3) ENGINE = MyISAM, PARTITION pa3 VALUES LESS THAN (6) ENGINE = MyISAM, PARTITION pa10 VALUES LESS THAN (10) ENGINE = MyISAM) */ 9*3 inserts; insert into t3 values (9); insert into t3 values (9+0.33); insert into t3 values (9+0.75); insert into t3 values (8); insert into t3 values (8+0.33); insert into t3 values (8+0.75); insert into t3 values (7); insert into t3 values (7+0.33); insert into t3 values (7+0.75); insert into t3 values (6); insert into t3 values (6+0.33); insert into t3 values (6+0.75); insert into t3 values (5); insert into t3 values (5+0.33); insert into t3 values (5+0.75); insert into t3 values (4); insert into t3 values (4+0.33); insert into t3 values (4+0.75); insert into t3 values (3); insert into t3 values (3+0.33); insert into t3 values (3+0.75); insert into t3 values (2); insert into t3 values (2+0.33); insert into t3 values (2+0.75); insert into t3 values (1); insert into t3 values (1+0.33); insert into t3 values (1+0.75); select count(*) from t3; count(*) 27 select * from t3; a 1 1.33 1.75 2 2.33 2.75 3 3.33 3.75 4 4.33 4.75 5 5.33 5.75 6 6.33 6.75 7 7.33 7.75 8 8.33 8.75 9 9.33 9.75 drop table t3; create table t4 (a double not null, primary key(a)) engine='MYISAM' partition by list (cast(floor(a) as signed)) subpartition by key (a) subpartitions 3 ( partition pa1 values in (1,2,3), partition pa3 values in (4,5,6), partition pa10 values in (7,8,9,10) ); show create table t4; Table Create Table t4 CREATE TABLE `t4` ( `a` double NOT NULL, PRIMARY KEY (`a`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (cast(floor(a) as signed)) SUBPARTITION BY KEY (a) SUBPARTITIONS 3 (PARTITION pa1 VALUES IN (1,2,3) ENGINE = MyISAM, PARTITION pa3 VALUES IN (4,5,6) ENGINE = MyISAM, PARTITION pa10 VALUES IN (7,8,9,10) ENGINE = MyISAM) */ 9*3 inserts; insert into t4 values (9); insert into t4 values (9+0.33); insert into t4 values (9+0.75); insert into t4 values (8); insert into t4 values (8+0.33); insert into t4 values (8+0.75); insert into t4 values (7); insert into t4 values (7+0.33); insert into t4 values (7+0.75); insert into t4 values (6); insert into t4 values (6+0.33); insert into t4 values (6+0.75); insert into t4 values (5); insert into t4 values (5+0.33); insert into t4 values (5+0.75); insert into t4 values (4); insert into t4 values (4+0.33); insert into t4 values (4+0.75); insert into t4 values (3); insert into t4 values (3+0.33); insert into t4 values (3+0.75); insert into t4 values (2); insert into t4 values (2+0.33); insert into t4 values (2+0.75); insert into t4 values (1); insert into t4 values (1+0.33); insert into t4 values (1+0.75); select count(*) from t4; count(*) 27 select * from t4; a 1 1.33 1.75 2 2.33 2.75 3 3.33 3.75 4 4.33 4.75 5 5.33 5.75 6 6.33 6.75 7 7.33 7.75 8 8.33 8.75 9 9.33 9.75 drop table t4;