diff options
| author | unknown <bar@bar.intranet.mysql.r18.ru> | 2004-02-03 18:14:23 +0400 |
|---|---|---|
| committer | unknown <bar@bar.intranet.mysql.r18.ru> | 2004-02-03 18:14:23 +0400 |
| commit | 786a5b6bc3a5de8dcd44b1d10b64c8799ceebbca (patch) | |
| tree | 002634aaf11d4ae989c004140dedacccf4c24d2e /mysql-test | |
| parent | 453a32e92720f4b3bb504d88c70433333190f174 (diff) | |
| download | mariadb-git-786a5b6bc3a5de8dcd44b1d10b64c8799ceebbca.tar.gz | |
Bug #2619 ucs2 LIKE comparison fails in some cases
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/func_like.result | 30 | ||||
| -rw-r--r-- | mysql-test/t/func_like.test | 19 |
2 files changed, 49 insertions, 0 deletions
diff --git a/mysql-test/r/func_like.result b/mysql-test/r/func_like.result index cf07ba88477..085e2f2f37e 100644 --- a/mysql-test/r/func_like.result +++ b/mysql-test/r/func_like.result @@ -104,3 +104,33 @@ a ÆÙ×ÁÐÒÏÌÄö æù÷áðòïìäö DROP TABLE t1; +SET NAMES cp1250; +CREATE TABLE t1 (a varchar(250) NOT NULL) DEFAULT CHARACTER SET=cp1250; +INSERT INTO t1 VALUES +('Techni Tapes Sp. z o.o.'), +('Pojazdy Szynowe PESA Bydgoszcz SA Holding'), +('AKAPESTER 1 P.P.H.U.'), +('Pojazdy Szynowe PESA Bydgoszcz S A Holding'), +('PPUH PESKA-I Maria Struniarska'); +select * from t1 where a like '%PESA%'; +a +Pojazdy Szynowe PESA Bydgoszcz SA Holding +Pojazdy Szynowe PESA Bydgoszcz S A Holding +select * from t1 where a like '%PESA %'; +a +Pojazdy Szynowe PESA Bydgoszcz SA Holding +Pojazdy Szynowe PESA Bydgoszcz S A Holding +select * from t1 where a like '%PES%'; +a +Techni Tapes Sp. z o.o. +Pojazdy Szynowe PESA Bydgoszcz SA Holding +AKAPESTER 1 P.P.H.U. +Pojazdy Szynowe PESA Bydgoszcz S A Holding +PPUH PESKA-I Maria Struniarska +select * from t1 where a like '%PESKA%'; +a +PPUH PESKA-I Maria Struniarska +select * from t1 where a like '%ESKA%'; +a +PPUH PESKA-I Maria Struniarska +DROP TABLE t1; diff --git a/mysql-test/t/func_like.test b/mysql-test/t/func_like.test index 0cd85385df4..a05a2a3bdaa 100644 --- a/mysql-test/t/func_like.test +++ b/mysql-test/t/func_like.test @@ -44,3 +44,22 @@ SELECT * FROM t1 WHERE a LIKE '%Æù×%'; SELECT * FROM t1 WHERE a LIKE 'Æù×Á%'; DROP TABLE t1; + +# Bug #2547 Strange "like" behaviour in tables with default charset=cp1250 +# Test like with non-default character set using TurboBM +# +SET NAMES cp1250; +CREATE TABLE t1 (a varchar(250) NOT NULL) DEFAULT CHARACTER SET=cp1250; +INSERT INTO t1 VALUES +('Techni Tapes Sp. z o.o.'), +('Pojazdy Szynowe PESA Bydgoszcz SA Holding'), +('AKAPESTER 1 P.P.H.U.'), +('Pojazdy Szynowe PESA Bydgoszcz S A Holding'), +('PPUH PESKA-I Maria Struniarska'); + +select * from t1 where a like '%PESA%'; +select * from t1 where a like '%PESA %'; +select * from t1 where a like '%PES%'; +select * from t1 where a like '%PESKA%'; +select * from t1 where a like '%ESKA%'; +DROP TABLE t1; |