1#
2# Bug #3928 regexp [[:>:]] and UTF-8
3#
4SELECT @@character_set_client, @@collation_connection;
5
6# This should return TRUE
7select  'вася'  rlike '\\bвася\\b';
8select  'вася ' rlike '\\bвася\\b';
9select ' вася'  rlike '\\bвася\\b';
10select ' вася ' rlike '\\bвася\\b';
11
12select  'вася'  rlike '[[:<:]]вася[[:>:]]';
13select  'вася ' rlike '[[:<:]]вася[[:>:]]';
14select ' вася'  rlike '[[:<:]]вася[[:>:]]';
15select ' вася ' rlike '[[:<:]]вася[[:>:]]';
16
17# This should return FALSE
18select  'васяz' rlike '\\bвася\\b';
19select 'zвася'  rlike '\\bвася\\b';
20select 'zвасяz' rlike '\\bвася\\b';
21
22select  'васяz' rlike '[[:<:]]вася[[:>:]]';
23select 'zвася'  rlike '[[:<:]]вася[[:>:]]';
24select 'zвасяz' rlike '[[:<:]]вася[[:>:]]';
25