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/r/fulltext.result | |
| 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/r/fulltext.result')
| -rw-r--r-- | mysql-test/r/fulltext.result | 33 |
1 files changed, 21 insertions, 12 deletions
diff --git a/mysql-test/r/fulltext.result b/mysql-test/r/fulltext.result index 31ed252b22d..3dacb9cc124 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -29,8 +29,8 @@ Full-text indexes are called collections Only MyISAM tables support collections select * from t1 where MATCH(a,b) AGAINST ("indexes collections" WITH QUERY EXPANSION); a b -Full-text indexes are called collections Only MyISAM tables support collections +Full-text indexes are called collections MySQL has now support for full-text search explain select * from t1 where MATCH(a,b) AGAINST ("collections"); id select_type table type possible_keys key key_len ref rows Extra @@ -294,18 +294,27 @@ 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 ('ïðéìëé'); -t charset(t) -üÔÏ ÍÙ - ÏÐÉÌËÉ utf8 -SELECT t, charset(t) FROM t1 WHERE MATCH t AGAINST ('ðÒá*' IN BOOLEAN MODE); -t charset(t) -É ÂÕÄÅÔ ÐÒÁ×! utf8 +SELECT t, collation(t) FROM t1 WHERE MATCH t AGAINST ('ïðéìëé'); +t collation(t) +üÔÏ ÍÙ - ÏÐÉÌËÉ utf8_general_ci +SELECT t, collation(t) FROM t1 WHERE MATCH t AGAINST ('ðÒá*' IN BOOLEAN MODE); +t collation(t) +É ÂÕÄÅÔ ÐÒÁ×! utf8_general_ci SELECT * FROM t1 WHERE MATCH t AGAINST ('ÜÔÏ' IN BOOLEAN MODE); t -SELECT t, charset(t) FROM t1 WHERE MATCH t AGAINST ('Osnabrück'); -t charset(t) +SELECT t, collation(t) FROM t1 WHERE MATCH t AGAINST ('Osnabrück'); +t collation(t) SET NAMES latin1; -SELECT t, charset(t) FROM t1 WHERE MATCH t AGAINST ('Osnabrück'); -t charset(t) -aus Osnabrück utf8 +SELECT t, collation(t) FROM t1 WHERE MATCH t AGAINST ('Osnabrück'); +t collation(t) +aus Osnabrück utf8_general_ci +SELECT t, collation(t) FROM t1 WHERE MATCH t AGAINST ('Osnabrueck'); +t collation(t) +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'); +t collation(t) +aus Osnabrück latin1_german2_ci +SELECT t, collation(t) FROM t1 WHERE MATCH t AGAINST ('Osnabrueck'); +t collation(t) +aus Osnabrück latin1_german2_ci DROP TABLE t1; |