1#
2# To test a desired collation, set session.collation_connection to
3# this collation before including this file
4#
5
6--disable_warnings
7drop table if exists t1;
8--enable_warnings
9
10#
11# Create a table with two varchar(64) null-able column,
12# using current values of
13# @@character_set_connection and  @@collation_connection.
14#
15
16create table t1 as
17select repeat(' ', 64) as s1, repeat(' ',64) as s2
18union
19select null, null;
20show create table t1;
21delete from t1;
22
23insert into t1 values('aaa','aaa');
24insert into t1 values('aaa|qqq','qqq');
25insert into t1 values('gheis','^[^a-dXYZ]+$');
26insert into t1 values('aab','^aa?b');
27insert into t1 values('Baaan','^Ba*n');
28insert into t1 values('aaa','qqq|aaa');
29insert into t1 values('qqq','qqq|aaa');
30
31insert into t1 values('bbb','qqq|aaa');
32insert into t1 values('bbb','qqq');
33insert into t1 values('aaa','aba');
34
35insert into t1 values(null,'abc');
36insert into t1 values('def',null);
37insert into t1 values(null,null);
38insert into t1 values('ghi','ghi[');
39
40--sorted_result
41select HIGH_PRIORITY s1 regexp s2 from t1;
42
43drop table t1;
44