summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/innodb/r/create-index.result
blob: ad358a863298dc31caf71774232207a2295037e0 (plain)
1
2
3
4
5
6
7
8
9
#
# Bug #18010711	UNIQUE PREFIX INDEX ON BINARY COLUMN: FAILING
# ASSERTION: FLEN == LEN
#
create table t1 (f1 binary(5)) engine=innodb;
insert into t1 values ('w'), ('w');
create unique index index_t1 on t1(f1(4));
ERROR 23000: Duplicate entry 'w' for key 'index_t1'
drop table t1;