diff options
| author | bar@bar.intranet.mysql.r18.ru <> | 2004-02-03 18:14:23 +0400 |
|---|---|---|
| committer | bar@bar.intranet.mysql.r18.ru <> | 2004-02-03 18:14:23 +0400 |
| commit | 8f1b5b48cc94fe969830655b7ab993b182dc4840 (patch) | |
| tree | 002634aaf11d4ae989c004140dedacccf4c24d2e /mysql-test/t/func_like.test | |
| parent | c4728c276a88ef9d80f6cc9b129dda51ba9d347a (diff) | |
| download | mariadb-git-8f1b5b48cc94fe969830655b7ab993b182dc4840.tar.gz | |
Bug #2619 ucs2 LIKE comparison fails in some cases
Diffstat (limited to 'mysql-test/t/func_like.test')
| -rw-r--r-- | mysql-test/t/func_like.test | 19 |
1 files changed, 19 insertions, 0 deletions
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; |