3
# LIKE pattern matching using prefix index doesn't return correct result
5
select @@collation_connection;
6
create table t1 ROW_FORMAT=DYNAMIC select repeat('a',50) as c1 ;
7
insert into t1 values('abcdef');
8
insert into t1 values('_bcdef');
9
insert into t1 values('a_cdef');
10
insert into t1 values('ab_def');
11
insert into t1 values('abc_ef');
12
insert into t1 values('abcd_f');
13
insert into t1 values('abcde_');
14
# should return ab_def
15
select c1 as c1u from t1 where c1 like 'ab\_def';
16
# should return ab_def
17
select c1 as c2h from t1 where c1 like 'ab#_def' escape '#';