1select @@collation_connection; 2 3# 4# Create a table with a nullable varchar(10) column 5# using currect character_set_connection. 6create table t1 as select repeat(' ',10) as a union select null; 7alter table t1 add key(a); 8show create table t1; 9insert into t1 values ("a"),("abc"),("abcd"),("hello"),("test"); 10explain select * from t1 where a like 'abc%'; 11explain select * from t1 where a like concat('abc','%'); 12select * from t1 where a like "abc%"; 13select * from t1 where a like concat("abc","%"); 14select * from t1 where a like "ABC%"; 15select * from t1 where a like "test%"; 16select * from t1 where a like "te_t"; 17select * from t1 where a like "%a%"; 18select * from t1 where a like "%abcd%"; 19select * from t1 where a like "%abc\d%"; 20drop table t1; 21 22# 23# Bug #2619 ucs2 LIKE comparison fails in some cases 24# 25 26select 'AA' like 'AA'; 27select 'AA' like 'A%A'; 28select 'AA' like 'A%%A'; 29select 'AA' like 'AA%'; 30select 'AA' like '%AA%'; 31select 'AA' like '%A'; 32select 'AA' like '%AA'; 33select 'AA' like 'A%A%'; 34select 'AA' like '_%_%'; 35select 'AA' like '%A%A'; 36select 'AAA'like 'A%A%A'; 37 38select 'AZ' like 'AZ'; 39select 'AZ' like 'A%Z'; 40select 'AZ' like 'A%%Z'; 41select 'AZ' like 'AZ%'; 42select 'AZ' like '%AZ%'; 43select 'AZ' like '%Z'; 44select 'AZ' like '%AZ'; 45select 'AZ' like 'A%Z%'; 46select 'AZ' like '_%_%'; 47select 'AZ' like '%A%Z'; 48select 'AZ' like 'A_'; 49select 'AZ' like '_Z'; 50select 'AMZ'like 'A%M%Z'; 51