diff options
| author | unknown <serg@sergbook.mylan> | 2003-11-08 15:41:24 +0100 |
|---|---|---|
| committer | unknown <serg@sergbook.mylan> | 2003-11-08 15:41:24 +0100 |
| commit | 21b624f046c4efbb0fd1f25135cc6663ab3ded4e (patch) | |
| tree | b9e0bafcc3ea5b9b3723b3e19379dff712f481b0 /mysql-test/t/fulltext.test | |
| parent | 06fd12c5aef1643519500d0f14bd7f1785e4caf6 (diff) | |
| download | mariadb-git-21b624f046c4efbb0fd1f25135cc6663ab3ded4e.tar.gz | |
fulltext.test, fulltext.result, ft_nlq_search.c:
a bug in latin1_german2 FT fixed
myisam/ft_nlq_search.c:
a bug in latin1_german2 FT fixed
mysql-test/r/fulltext.result:
a bug in latin1_german2 FT fixed
mysql-test/t/fulltext.test:
a bug in latin1_german2 FT fixed
Diffstat (limited to 'mysql-test/t/fulltext.test')
| -rw-r--r-- | mysql-test/t/fulltext.test | 13 |
1 files changed, 9 insertions, 4 deletions
diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test index 37913d2d747..422ca23de90 100644 --- a/mysql-test/t/fulltext.test +++ b/mysql-test/t/fulltext.test @@ -237,11 +237,16 @@ INSERT t1 VALUES ('Mit freundlichem Grüß'), ('aus Osnabrück'); SET NAMES koi8r; INSERT t1 VALUES ("üÔÏ ÍÙ - ÏÐÉÌËÉ"),("ïÔÌÅÚØ, ÇÎÉÄÁ!"), ("îÅ ×ÌÅÚÁÊ, ÕÂØÅÔ!"),("É ÂÕÄÅÔ ÐÒÁ×!"); -SELECT t, charset(t) FROM t1 WHERE MATCH t AGAINST ('ïðéìëé'); -SELECT t, charset(t) FROM t1 WHERE MATCH t AGAINST ('ðÒá*' IN BOOLEAN MODE); +SELECT t, collation(t) FROM t1 WHERE MATCH t AGAINST ('ïðéìëé'); +SELECT t, collation(t) FROM t1 WHERE MATCH t AGAINST ('ðÒá*' IN BOOLEAN MODE); SELECT * FROM t1 WHERE MATCH t AGAINST ('ÜÔÏ' IN BOOLEAN MODE); -SELECT t, charset(t) FROM t1 WHERE MATCH t AGAINST ('Osnabrück'); +SELECT t, collation(t) FROM t1 WHERE MATCH t AGAINST ('Osnabrück'); SET NAMES latin1; -SELECT t, charset(t) FROM t1 WHERE MATCH t AGAINST ('Osnabrück'); +SELECT t, collation(t) FROM t1 WHERE MATCH t AGAINST ('Osnabrück'); +SELECT t, collation(t) FROM t1 WHERE MATCH t AGAINST ('Osnabrueck'); +#alter table t1 modify t text character set latin1 collate latin1_german2_ci not null; +alter table t1 modify t varchar(200) collate latin1_german2_ci not null; +SELECT t, collation(t) FROM t1 WHERE MATCH t AGAINST ('Osnabrück'); +SELECT t, collation(t) FROM t1 WHERE MATCH t AGAINST ('Osnabrueck'); DROP TABLE t1; |