1SET DEFAULT_STORAGE_ENGINE='tokudb'; 2call mtr.add_suppression("TokuDB.*"); 3call mtr.add_suppression(".*returned handler error 22"); 4drop table if exists t; 5create table t (id int not null primary key, v0 longblob not null,v1 longblob not null); 6select @@max_allowed_packet into @my_max_allowed_packet; 7set global max_allowed_packet=100000000; 8connect conn1,localhost,root,,; 9insert into t values (1,repeat('a',16*1024*1024),repeat('b',16*1024*1024)); 10ERROR HY000: Got error 22 "Invalid argument" from storage engine TokuDB 11insert into t values (1,repeat('a',16*1024*1024),repeat('b',16*1024*1024-1)); 12ERROR HY000: Got error 22 "Invalid argument" from storage engine TokuDB 13insert into t values (1,repeat('a',16*1024*1024),repeat('b',16*1024*1024-2)); 14ERROR HY000: Got error 22 "Invalid argument" from storage engine TokuDB 15insert into t values (1,repeat('a',16*1024*1024),repeat('b',16*1024*1024-3)); 16ERROR HY000: Got error 22 "Invalid argument" from storage engine TokuDB 17insert into t values (1,repeat('a',16*1024*1024),repeat('b',16*1024*1024-4)); 18ERROR HY000: Got error 22 "Invalid argument" from storage engine TokuDB 19insert into t values (1,repeat('a',16*1024*1024),repeat('b',16*1024*1024-5)); 20ERROR HY000: Got error 22 "Invalid argument" from storage engine TokuDB 21insert into t values (1,repeat('a',16*1024*1024),repeat('b',16*1024*1024-6)); 22ERROR HY000: Got error 22 "Invalid argument" from storage engine TokuDB 23insert into t values (1,repeat('a',16*1024*1024),repeat('b',16*1024*1024-7)); 24ERROR HY000: Got error 22 "Invalid argument" from storage engine TokuDB 25insert into t values (1,repeat('a',16*1024*1024),repeat('b',16*1024*1024-8)); 26select id,length(v0),length(v1) from t; 27id length(v0) length(v1) 281 16777216 16777208 29truncate table t; 30insert into t values (1,'a','a'),(2,'b','b'),(3,'c','c'),(4,'d','d'),(5,repeat('e',16*1024*1024),repeat('f',16*1024*1024)); 31ERROR HY000: Got error 22 "Invalid argument" from storage engine TokuDB 32select id,length(v0),length(v1) from t; 33id length(v0) length(v1) 34truncate table t; 35insert into t values (1,'a','a'),(2,'b','b'),(3,'c','c'),(4,'d','d'); 36insert into t values (5,repeat('e',16*1024*1024),repeat('f',16*1024*1024)); 37ERROR HY000: Got error 22 "Invalid argument" from storage engine TokuDB 38select id,length(v0),length(v1) from t; 39id length(v0) length(v1) 401 1 1 412 1 1 423 1 1 434 1 1 44connection default; 45disconnect conn1; 46set global max_allowed_packet=@my_max_allowed_packet; 47drop table t; 48