1
--echo ---- Partitioning and blob data type
3
--error ER_BLOB_FIELD_IN_PART_FUNC_ERROR
4
eval create table t1 (a blob not null, primary key(a(767))) engine=$engine
6
partition pa1 max_rows=20 min_rows=2,
7
partition pa2 max_rows=30 min_rows=3,
8
partition pa3 max_rows=30 min_rows=4,
9
partition pa4 max_rows=40 min_rows=2);
11
#show create table t1;
12
#insert into t1 values (repeat('a',1000)), ('b'), (repeat('a',500)), (repeat('b',64));
14
#select * from t1 where a='b';
15
#update t1 set a='bb' where a='b';
16
#delete from t1 where a='bb';
20
--error ER_BLOB_FIELD_IN_PART_FUNC_ERROR
21
eval create table t2 (a blob not null, primary key(a(767))) engine=$engine
22
partition by key (a) partitions 30;
24
--error ER_BLOB_FIELD_IN_PART_FUNC_ERROR
25
eval create table t2 (a tinyblob not null, primary key(a(767))) engine=$engine
26
partition by key (a) partitions 30;
28
--error ER_BLOB_FIELD_IN_PART_FUNC_ERROR
29
eval create table t2 (a mediumblob not null, primary key(a(767))) engine=$engine
30
partition by key (a) partitions 30;
32
--error ER_BLOB_FIELD_IN_PART_FUNC_ERROR
33
eval create table t2 (a longblob not null, primary key(a(767))) engine=$engine
34
partition by key (a) partitions 30;
36
#show create table t2;
39
#--echo $count inserts;
43
#eval insert into t2 values (repeat(char(ascii('a')+$letter),$count*$count));
47
#select count(*) from t2;