diff options
| author | bar@bar.mysql.r18.ru <> | 2003-09-24 13:57:26 +0500 |
|---|---|---|
| committer | bar@bar.mysql.r18.ru <> | 2003-09-24 13:57:26 +0500 |
| commit | 52bb4efcddc9365e380417d654d28aeb7afc1e6c (patch) | |
| tree | 448ed92b80853b37f5da3790377626724f67208d /mysql-test/r | |
| parent | efd94f5ba972bb10d2d10fe46fc9153536941e92 (diff) | |
| download | mariadb-git-52bb4efcddc9365e380417d654d28aeb7afc1e6c.tar.gz | |
regexp worked only with the default character set.
Now it can work with any character set.
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/func_regexp.result | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/r/func_regexp.result b/mysql-test/r/func_regexp.result index 8d22994ef2b..35742136ee6 100644 --- a/mysql-test/r/func_regexp.result +++ b/mysql-test/r/func_regexp.result @@ -52,3 +52,27 @@ select * from t1 where xxx REGEXP '^this is some text: to test - out\\.reg exp [ xxx this is some text: to test - out.reg exp (22/45) drop table t1; +select _latin1 0xFF regexp _latin1 '[[:lower:]]' COLLATE latin1_bin; +_latin1 0xFF regexp _latin1 '[[:lower:]]' COLLATE latin1_bin +1 +select _koi8r 0xFF regexp _koi8r '[[:lower:]]' COLLATE koi8r_bin; +_koi8r 0xFF regexp _koi8r '[[:lower:]]' COLLATE koi8r_bin +0 +select _latin1 0xFF regexp _latin1 '[[:upper:]]' COLLATE latin1_bin; +_latin1 0xFF regexp _latin1 '[[:upper:]]' COLLATE latin1_bin +0 +select _koi8r 0xFF regexp _koi8r '[[:upper:]]' COLLATE koi8r_bin; +_koi8r 0xFF regexp _koi8r '[[:upper:]]' COLLATE koi8r_bin +1 +select _latin1 0xF7 regexp _latin1 '[[:alpha:]]'; +_latin1 0xF7 regexp _latin1 '[[:alpha:]]' +0 +select _koi8r 0xF7 regexp _koi8r '[[:alpha:]]'; +_koi8r 0xF7 regexp _koi8r '[[:alpha:]]' +1 +select _latin1'a' regexp _latin1'A' collate latin1_general_ci; +_latin1'a' regexp _latin1'A' collate latin1_general_ci +1 +select _latin1'a' regexp _latin1'A' collate latin1_bin; +_latin1'a' regexp _latin1'A' collate latin1_bin +0 |