summaryrefslogtreecommitdiff
path: root/mysql-test/r/fulltext.result
diff options
context:
space:
mode:
authorunknown <serg@serg.mysql.com>2001-11-08 00:06:07 +0100
committerunknown <serg@serg.mysql.com>2001-11-08 00:06:07 +0100
commit7e6161287ef4f8d112af04d60723fa410e2b9fa6 (patch)
tree57e47c348efe428aa84238f656e05060bae45a6b /mysql-test/r/fulltext.result
parent74e044c0db38bb09e168ad1ece001051fd4ef567 (diff)
downloadmariadb-git-7e6161287ef4f8d112af04d60723fa410e2b9fa6.tar.gz
bug in relevance calculation fixed
Diffstat (limited to 'mysql-test/r/fulltext.result')
-rw-r--r--mysql-test/r/fulltext.result7
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/fulltext.result b/mysql-test/r/fulltext.result
index c2b4de5f439..dbc0ac09f31 100644
--- a/mysql-test/r/fulltext.result
+++ b/mysql-test/r/fulltext.result
@@ -48,6 +48,13 @@ 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;
+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
delete from t1 where a like "MySQL%";
drop table t1;
CREATE TABLE t1 (