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