1#
2# Bug#11650: LIKE pattern matching using prefix index
3# doesn't return correct result
4#
5--disable_query_log
6set @ctype_save_sql_mode=@@sql_mode;
7set sql_mode="";
8--enable_query_log
9--disable_warnings
10#
11# This query creates a column using
12# character_set_connection and
13# collation_connection.
14#
15create table t1 engine=innodb select repeat('a',50) as c1;
16--enable_warnings
17--disable_query_log
18set sql_mode=@ctype_save_sql_mode;
19--enable_query_log
20alter table t1 add index(c1(5));
21
22insert into t1 values ('abcdefg'),('abcde100'),('abcde110'),('abcde111');
23select collation(c1) from t1 limit 1;
24select c1 from t1 where c1 like 'abcdef%' order by c1;
25select c1 from t1 where c1 like 'abcde1%' order by c1;
26select c1 from t1 where c1 like 'abcde11%' order by c1;
27select c1 from t1 where c1 like 'abcde111%' order by c1;
28drop table t1;
29