Debian Codegraph @

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

raw
1 eval create table t1 (a datetime 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 ('1975-01-01 21:21:21'), ('2020-12-31 12:10:30'), ('1980-10-14 03:03'), ('2000-06-15 23:59');
9 select * from t1;
10 select * from t1 where a=19801014030300;
11 delete from t1 where a=19801014030300;
12 select * from t1;
13 drop table t1;
14
15 eval create table t2 (a datetime not null, primary key(a)) engine=$engine
16 partition by key (a) partitions 12;
17 show create table t2;
18 insert into t2 values ('1975-01-01 0:1:1'), ('2020-12-31 10:11:12'), ('1980-10-14 13:14:15'), ('2000-06-15 14:15:16');
19 select * from t2;
20 select * from t2 where a='1980-10-14 13:14:15';
21 delete from t2 where a='1980-10-14 13:14:15';
22 select * from t2;
23 delete from t2;
24 let $count=59;
25 --echo $count inserts;
26 --disable_query_log
27 begin;
28 while ($count)
29 {
30 eval insert into t2 values (19700101000000+$count);
31 dec $count;
32 }
33 commit;
34 --enable_query_log
35 select count(*) from t2;
36 select * from t2;
37 drop table t2;
38
39 eval create table t3 (a datetime not null, primary key(a)) engine=$engine
40 partition by range (month(a)) subpartition by key (a)
41 subpartitions 3 (
42 partition quarter1 values less than (4),
43 partition quarter2 values less than (7),
44 partition quarter3 values less than (10),
45 partition quarter4 values less than (13)
46 );
47 show create table t3;
48 let $count=12;
49 --echo $count inserts;
50 --disable_query_log
51 begin;
52 while ($count)
53 {
54 eval insert into t3 values (adddate(19700101000000,interval $count-1 month));
55 dec $count;
56 }
57 commit;
58 --enable_query_log
59 select count(*) from t3;
60 select * from t3;
61 drop table t3;
62
63 eval create table t4 (a datetime not null, primary key(a)) engine=$engine
64 partition by list (month(a)) subpartition by key (a)
65 subpartitions 3 (
66 partition quarter1 values in (1,2,3),
67 partition quarter2 values in (4,5,6),
68 partition quarter3 values in (7,8,9),
69 partition quarter4 values in (10,11,12)
70 );
71 show create table t4;
72 let $count=12;
73 --echo $count inserts;
74 --disable_query_log
75 begin;
76 while ($count)
77 {
78 eval insert into t4 values (adddate(19700101000000,interval $count-1 month));
79 dec $count;
80 }
81 commit;
82 --enable_query_log
83 select count(*) from t4;
84 select * from t4;
85 drop table t4;