2 # Test rows with length above > 16M
3 # Note that for this to work, you should start mysqld with
4 # -O max_allowed_packet=32M
7 drop table if exists t1;
8 create table t1 (a tinyint not null auto_increment, b longblob not null, primary key (a)) checksum=1;
10 insert into t1 (b) values(repeat(char(65),10));
11 insert into t1 (b) values(repeat(char(66),10));
12 insert into t1 (b) values(repeat(char(67),10));
13 update t1 set b=repeat(char(68),16777216) where a=1;
15 update t1 set b=repeat(char(69),16777000) where a=2;
16 update t1 set b=repeat(char(70),167) where a=3;
17 update t1 set b=repeat(char(71),16778000) where a=1;
18 update t1 set b=repeat(char(72),16778000) where a=3;
19 select a,length(b) from t1;
21 insert into t1 (b) values (repeat(char(73+@a),16777200+@a));
23 insert into t1 (b) values (repeat(char(73+@a),16777200+@a));
25 insert into t1 (b) values (repeat(char(73+@a),16777200+@a));
27 insert into t1 (b) values (repeat(char(73+@a),16777200+@a));
29 insert into t1 (b) values (repeat(char(73+@a),16777200+@a));
31 insert into t1 (b) values (repeat(char(73+@a),16777200+@a));
33 insert into t1 (b) values (repeat(char(73+@a),16777200+@a));
35 insert into t1 (b) values (repeat(char(73+@a),16777200+@a));
37 insert into t1 (b) values (repeat(char(73+@a),16777200+@a));
39 insert into t1 (b) values (repeat(char(73+@a),16777200+@a));
41 insert into t1 (b) values (repeat(char(73+@a),16777200+@a));
43 insert into t1 (b) values (repeat(char(73+@a),16777200+@a));
45 insert into t1 (b) values (repeat(char(73+@a),16777200+@a));
47 insert into t1 (b) values (repeat(char(73+@a),16777200+@a));
49 insert into t1 (b) values (repeat(char(73+@a),16777200+@a));
51 insert into t1 (b) values (repeat(char(73+@a),16777200+@a));
53 insert into t1 (b) values (repeat(char(73+@a),16777200+@a));
55 insert into t1 (b) values (repeat(char(73+@a),16777200+@a));
56 update t1 set b=('A') where a=5;
57 delete from t1 where a=7;
59 insert into t1 (b) values (repeat(char(73+@a),16777200+@a));
60 update t1 set b=repeat(char(73+@a+1),17000000+@a) where a=last_insert_id();
62 select a,mid(b,1,5),length(b) from t1;
66 select a from table where b<>repeat(mid(b,1,1),length(b));
67 delete from t1 where (a & 1);
68 select a from table where b<>repeat(mid(b,1,1),length(b));