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