diff options
| author | unknown <serg@serg.mysql.com> | 2002-03-04 13:17:49 +0000 |
|---|---|---|
| committer | unknown <serg@serg.mysql.com> | 2002-03-04 13:17:49 +0000 |
| commit | d9ff111a7c2d12df6a79e1d36e8fa0324dcd3ee2 (patch) | |
| tree | 07a598b90dfe3012dbed940305ebf74594dfd4e8 /mysql-test | |
| parent | 19d37eca52460dc4f94a1855d0aa78c3df968838 (diff) | |
| download | mariadb-git-d9ff111a7c2d12df6a79e1d36e8fa0324dcd3ee2.tar.gz | |
bug with indexless boolean fts fixed
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/fulltext.result | 9 | ||||
| -rw-r--r-- | mysql-test/t/fulltext.test | 3 |
2 files changed, 10 insertions, 2 deletions
diff --git a/mysql-test/r/fulltext.result b/mysql-test/r/fulltext.result index 775ec29917f..7f4f3444312 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -48,7 +48,14 @@ Full-text search in MySQL implements vector space model select * from t1 where MATCH(a,b) AGAINST("+search -(support vector)" IN BOOLEAN MODE); a b Function MATCH ... AGAINST() is used to do a search -select *, MATCH(a,b) AGAINST("support collections" IN BOOLEAN MODE) as x from t1; +select *, MATCH(a,b) AGAINST("support collections" IN BOOLEAN MODE) as x from t1; +a b x +MySQL has now support for full-text search 1 +Full-text indexes are called collections 1 +Only MyISAM tables support collections 2 +Function MATCH ... AGAINST() is used to do a search 0 +Full-text search in MySQL implements vector space model 0 +select *, MATCH(a,b) AGAINST("collections support" IN BOOLEAN MODE) as x from t1; a b x MySQL has now support for full-text search 1 Full-text indexes are called collections 1 diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test index 3d203bc61f5..da0c0a52d8a 100644 --- a/mysql-test/t/fulltext.test +++ b/mysql-test/t/fulltext.test @@ -27,7 +27,8 @@ select * from t1 where MATCH(a,b) AGAINST("+support +collections" IN BOOLEAN MOD select * from t1 where MATCH(a,b) AGAINST("+search" IN BOOLEAN MODE); select * from t1 where MATCH(a,b) AGAINST("+search +(support vector)" IN BOOLEAN MODE); select * from t1 where MATCH(a,b) AGAINST("+search -(support vector)" IN BOOLEAN MODE); -select *, MATCH(a,b) AGAINST("support collections" IN BOOLEAN MODE) as x from t1; +select *, MATCH(a,b) AGAINST("support collections" IN BOOLEAN MODE) as x from t1; +select *, MATCH(a,b) AGAINST("collections support" IN BOOLEAN MODE) as x from t1; # boolean w/o index: |