Debian Codegraph @

mysql-test/suite/parts/r/partition_float_myisam.result

raw
1 create table t1 (a float not null, primary key(a)) engine='MYISAM'
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 Table Create Table
9 t1 CREATE TABLE `t1` (
10 `a` float NOT NULL,
11 PRIMARY KEY (`a`)
12 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
13 PARTITION BY KEY (`a`)
14 (PARTITION `pa1` MAX_ROWS = 20 MIN_ROWS = 2 ENGINE = MyISAM,
15 PARTITION `pa2` MAX_ROWS = 30 MIN_ROWS = 3 ENGINE = MyISAM,
16 PARTITION `pa3` MAX_ROWS = 30 MIN_ROWS = 4 ENGINE = MyISAM,
17 PARTITION `pa4` MAX_ROWS = 40 MIN_ROWS = 2 ENGINE = MyISAM)
18 insert into t1 values (-3.402823466E+38), (3.402823466E+38), (-1.5), (-1), (0), (1), (1.5);
19 select * from t1;
20 a
21 -3.40282e38
22 -1.5
23 -1
24 0
25 1
26 1.5
27 3.40282e38
28 select * from t1 where a=1.5;
29 a
30 1.5
31 delete from t1 where a=1.5;
32 select * from t1;
33 a
34 -3.40282e38
35 -1.5
36 -1
37 0
38 1
39 3.40282e38
40 drop table t1;
41 create table t2 (a float not null, primary key(a)) engine='MYISAM'
42 partition by key (a) partitions 10;
43 show create table t2;
44 Table Create Table
45 t2 CREATE TABLE `t2` (
46 `a` float NOT NULL,
47 PRIMARY KEY (`a`)
48 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
49 PARTITION BY KEY (`a`)
50 PARTITIONS 10
51 insert into t2 values (-3.402823466E+38), (-3.402823466E+37), (-123.456), (0), (1234546.789), (123.456), (1.5);
52 select * from t2;
53 a
54 -3.40282e38
55 -3.40282e37
56 -123.456
57 0
58 1.5
59 123.456
60 1234550
61 select * from t2 where a=123.456;
62 a
63 delete from t2 where a=123.456;
64 select * from t2;
65 a
66 -3.40282e38
67 -3.40282e37
68 -123.456
69 0
70 1.5
71 123.456
72 1234550
73 select * from t2 where a=1.5;
74 a
75 1.5
76 delete from t2 where a=1.5;
77 select * from t2;
78 a
79 -3.40282e38
80 -3.40282e37
81 -123.456
82 0
83 123.456
84 1234550
85 delete from t2;
86 16384*3 inserts;
87 select count(*) from t2;
88 count(*)
89 49152
90 drop table t2;