1
create table t1 (a int primary key, b varchar(111), unique index b_idx (b(5)));
2
insert into t1 values (1, "foobar"),(2,"barbarbar");
3
--error ER_DUP_ENTRY, ER_DUP_KEY
4
insert into t1 values (3, "barbarpub");
7
create table t2 (a int primary key, b varbinary(111), unique index b_idx (b(5)));
8
insert into t2 values (1, "foobar"),(2,"barbarbar");
9
--error ER_DUP_ENTRY, ER_DUP_KEY
10
insert into t2 values (3, "barbarpub");