1# This test may run out of memory in some environments. 2--source include/big_test.inc 3 4set @allowed_packet= @@max_allowed_packet; 5SET GLOBAL max_allowed_packet=67108864; 6 7connect (con1, localhost, root,,); 8create table t1(a longblob unique, b longblob , c longblob , unique(b,c)); 9desc t1; 10show create table t1; 11show keys from t1; 12insert into t1 values(concat(repeat('sachin',10000000),'1'),concat(repeat('sachin',10000000),'1'), 13concat(repeat('sachin',10000000),'1')); 14insert into t1 values(concat(repeat('sachin',10000000),'2'),concat(repeat('sachin',10000000),'2'), 15concat(repeat('sachin',10000000),'1')); 16--error ER_DUP_ENTRY 17insert into t1 values(concat(repeat('sachin',10000000),'2'),concat(repeat('sachin',10000000),'2'), 18concat(repeat('sachin',10000000),'4')); 19--error ER_DUP_ENTRY 20insert into t1 values(concat(repeat('sachin',10000000),'3'),concat(repeat('sachin',10000000),'1'), 21concat(repeat('sachin',10000000),'1')); 22drop table t1; 23disconnect con1; 24connection default; 25set @@GLOBAL.max_allowed_packet= @allowed_packet; 26--echo # End of 10.4 tests 27