Debian Codegraph @

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

raw
1 --echo ---- Partitioning and char data type
2
3 eval create table t1 (a char(255) not null, primary key(a)) engine=$engine
4 partition by key (a) (
5 partition pa1 max_rows=20 min_rows=2,
6 partition pa2 max_rows=30 min_rows=3,
7 partition pa3 max_rows=30 min_rows=4,
8 partition pa4 max_rows=40 min_rows=2);
9 show create table t1;
10 insert into t1 values (repeat('a',255)), ('b'), (repeat('a',128)), (repeat('b',64));
11 --sorted_result
12 select * from t1;
13 select * from t1 where a='b';
14 update t1 set a='bb' where a='b';
15 delete from t1 where a='bb';
16 --sorted_result
17 select * from t1;
18 drop table t1;
19
20 eval create table t2 (a char(255) not null, primary key(a)) engine=$engine
21 partition by key (a) partitions 27;
22 show create table t2;
23 let $count=26;
24 let $letter=0;
25 --echo $count inserts;
26 --disable_query_log
27 begin;
28 while ($count)
29 {
30 eval insert into t2 values (repeat(char(ascii('a')+$letter),$count+54));
31 dec $count;
32 inc $letter;
33 }
34 commit;
35 --enable_query_log
36 select count(*) from t2;
37 --sorted_result
38 select * from t2;
39 drop table t2;
40
41 # mleich: Several partitioning functions are no more allowed.
42 if (0)
43 {
44 eval create table t3 (a char(255) not null, primary key(a)) engine=$engine
45 partition by range (ascii(a)) subpartition by key (a) subpartitions 4 (
46 partition pa16 values less than (16),
47 partition pa32 values less than (32),
48 partition pa64 values less than (64),
49 partition pa128 values less than (128),
50 partition pa256 values less than (256)
51 );
52 show create table t3;
53 let $count=26;
54 let $letter=0;
55 --echo $count inserts;
56 --disable_query_log
57 begin;
58 while ($count)
59 {
60 eval insert into t3 values (repeat(char(ascii('a')+$letter),$count+54));
61 dec $count;
62 inc $letter;
63 }
64 commit;
65 --enable_query_log
66 select count(*) from t3;
67 select a from t3;
68 drop table t3;
69
70 eval create table t4 (a char(255) not null, primary key(a)) engine=$engine
71 partition by list (ascii(a)) subpartition by key (a) subpartitions 4 (
72 partition pa16 values in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16),
73 partition pa32 values in (17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32),
74 partition pa64 values in (33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64),
75 partition pa128 values in (65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128),
76 partition pa256 values in (129,130,131,132,133,134,135,136,137,138,139,140
77 ,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256)
78 );
79 show create table t4;
80 let $count=26;
81 let $letter=0;
82 --echo $count inserts;
83 --disable_query_log
84 begin;
85 while ($count)
86 {
87 eval insert into t4 values (repeat(char(ascii('a')+$letter),$count+54));
88 dec $count;
89 inc $letter;
90 }
91 commit;
92 --enable_query_log
93 select count(*) from t4;
94 select a from t4;
95 drop table t4;
96 }
97 # End of tests with disallowed partitioning functions.