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