Debian Codegraph @

mysql-test/suite/parts/inc/partition_double.inc

raw
1 eval create table t1 (a double not null, primary key(a)) engine=$engine
2 partition by key (a) (
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);
7 show create table t1;
8 insert into t1 values (-2.2250738585072014E+208), (-2.2250738585072014E-208), (-1.5), (-1), (0), (1.5), (1234.567), (2.2250738585072014E+208);
9 --sorted_result
10 select * from t1;
11 select * from t1 where a=1.5;
12 delete from t1 where a=1.5;
13 --sorted_result
14 select * from t1;
15 drop table t1;
16
17 eval create table t2 (a double not null, primary key(a)) engine=$engine
18 partition by key (a) partitions 10;
19 show create table t2;
20 insert into t2 values (-2.2250738585072014E+208), (-2.2250738585072014E-208), (-1.5), (-1), (0), (1.5), (1234.567), (2.2250738585072014E+208);
21 --sorted_result
22 select * from t2;
23 select * from t2 where a=1234.567;
24 delete from t2 where a=1234.567;
25 --sorted_result
26 select * from t2;
27 delete from t2;
28 let $count=$maxrows;
29 --echo $maxrows*3 inserts;
30 --disable_query_log
31 begin;
32 while ($count)
33 {
34 eval insert into t2 values ($count);
35 eval insert into t2 values ($count+0.33);
36 eval insert into t2 values ($count+0.75);
37 dec $count;
38 }
39 commit;
40 --enable_query_log
41 select count(*) from t2;
42 drop table t2;
43