diff options
| author | unknown <bar@bar.intranet.mysql.r18.ru> | 2004-06-07 12:51:18 +0500 |
|---|---|---|
| committer | unknown <bar@bar.intranet.mysql.r18.ru> | 2004-06-07 12:51:18 +0500 |
| commit | 938fb67bd2bd139bb02d98d0b0298ab8d4bf901d (patch) | |
| tree | b95e6a3d5908a015cf9163612fd462eb0d498c8e /mysql-test | |
| parent | 5cc410bb70dca2fad9dd7452ef294e1020186dda (diff) | |
| download | mariadb-git-938fb67bd2bd139bb02d98d0b0298ab8d4bf901d.tar.gz | |
Bug #3928 regexp [[:>:]] and UTF-8
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/ctype_utf8.result | 22 | ||||
| -rw-r--r-- | mysql-test/t/ctype_utf8.test | 16 |
2 files changed, 38 insertions, 0 deletions
diff --git a/mysql-test/r/ctype_utf8.result b/mysql-test/r/ctype_utf8.result index 28af71b7681..6c11dd210aa 100644 --- a/mysql-test/r/ctype_utf8.result +++ b/mysql-test/r/ctype_utf8.result @@ -218,3 +218,25 @@ b select * from t1 where a = 'b' and a != 'b'; a drop table t1; +set names utf8; +select 'вася' rlike '[[:<:]]вася[[:>:]]'; +'вася' rlike '[[:<:]]вася[[:>:]]' +1 +select 'вася ' rlike '[[:<:]]вася[[:>:]]'; +'вася ' rlike '[[:<:]]вася[[:>:]]' +1 +select ' вася' rlike '[[:<:]]вася[[:>:]]'; +' вася' rlike '[[:<:]]вася[[:>:]]' +1 +select ' вася ' rlike '[[:<:]]вася[[:>:]]'; +' вася ' rlike '[[:<:]]вася[[:>:]]' +1 +select 'васяz' rlike '[[:<:]]вася[[:>:]]'; +'васяz' rlike '[[:<:]]вася[[:>:]]' +0 +select 'zвася' rlike '[[:<:]]вася[[:>:]]'; +'zвася' rlike '[[:<:]]вася[[:>:]]' +0 +select 'zвасяz' rlike '[[:<:]]вася[[:>:]]'; +'zвасяz' rlike '[[:<:]]вася[[:>:]]' +0 diff --git a/mysql-test/t/ctype_utf8.test b/mysql-test/t/ctype_utf8.test index 4e68efeffc3..6a504a8533a 100644 --- a/mysql-test/t/ctype_utf8.test +++ b/mysql-test/t/ctype_utf8.test @@ -141,3 +141,19 @@ select * from t1 where a = 'b'; select * from t1 where a = 'b' and a = 'b'; select * from t1 where a = 'b' and a != 'b'; drop table t1; + +# +# Bug #3928 regexp [[:>:]] and UTF-8 +# +set names utf8; + +# This should return TRUE +select 'вася' rlike '[[:<:]]вася[[:>:]]'; +select 'вася ' rlike '[[:<:]]вася[[:>:]]'; +select ' вася' rlike '[[:<:]]вася[[:>:]]'; +select ' вася ' rlike '[[:<:]]вася[[:>:]]'; + +# This should return FALSE +select 'васяz' rlike '[[:<:]]вася[[:>:]]'; +select 'zвася' rlike '[[:<:]]вася[[:>:]]'; +select 'zвасяz' rlike '[[:<:]]вася[[:>:]]'; |