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