1
create table t1 (a decimal(10,4) not null, primary key(a)) engine='InnoDB'
3
partition pa1 max_rows=20 min_rows=2,
4
partition pa2 max_rows=30 min_rows=3,
5
partition pa3 max_rows=30 min_rows=4,
6
partition pa4 max_rows=40 min_rows=2);
10
`a` decimal(10,4) NOT NULL,
12
) ENGINE=InnoDB DEFAULT CHARSET=latin1
13
/*!50100 PARTITION BY KEY (a)
14
(PARTITION pa1 MAX_ROWS = 20 MIN_ROWS = 2 ENGINE = InnoDB,
15
PARTITION pa2 MAX_ROWS = 30 MIN_ROWS = 3 ENGINE = InnoDB,
16
PARTITION pa3 MAX_ROWS = 30 MIN_ROWS = 4 ENGINE = InnoDB,
17
PARTITION pa4 MAX_ROWS = 40 MIN_ROWS = 2 ENGINE = InnoDB) */
18
insert into t1 values (999999.9999), (-999999.9999), (123456.7899), (-123456.7899), (-1.5), (1), (0), (-1), (1.5), (1234.567), (-1234.567);
32
select * from t1 where a=1234.567;
35
delete from t1 where a=1234.567;
49
create table t2 (a decimal(18,9) not null, primary key(a)) engine='InnoDB'
50
partition by key (a) partitions 10;
53
t2 CREATE TABLE `t2` (
54
`a` decimal(18,9) NOT NULL,
56
) ENGINE=InnoDB DEFAULT CHARSET=latin1
57
/*!50100 PARTITION BY KEY (a)
59
insert into t2 values (999999999.999999999), (-999999999.999999999), (-1.5), (-1), (0), (1.5), (1234.567), (-1234.567);
70
select * from t2 where a=1234.567;
73
delete from t2 where a=1234.567;
85
select count(*) from t2;