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