diff options
| author | unknown <serg@serg.mysql.com> | 2001-11-21 18:25:44 +0100 |
|---|---|---|
| committer | unknown <serg@serg.mysql.com> | 2001-11-21 18:25:44 +0100 |
| commit | dfbeb93550fedc416bec85191d57acd93ffdd007 (patch) | |
| tree | 212d0be141fe682b30e2759024cb421a2eaf9d1c /mysql-test | |
| parent | 680d02190773191b43de2ae5d4826d8eab8ad029 (diff) | |
| download | mariadb-git-dfbeb93550fedc416bec85191d57acd93ffdd007.tar.gz | |
(UPDATE|DELETE) ...WHERE MATCH bugfix
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/fulltext.result | 4 | ||||
| -rw-r--r-- | mysql-test/t/fulltext.test | 3 |
2 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/fulltext.result b/mysql-test/r/fulltext.result index e8a4d87f680..c39210107ae 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -6,6 +6,10 @@ Full-text indexes are called collections a b Full-text indexes are called collections Only MyISAM tables support collections +a b +Only MyISAM tables support collections +Function MATCH ... AGAINST() is used to do a search +some test foobar implements vector space model id id id diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test index eedee811f2b..83e328ca616 100644 --- a/mysql-test/t/fulltext.test +++ b/mysql-test/t/fulltext.test @@ -10,6 +10,9 @@ select * from t1 where MATCH(a,b) AGAINST ("collections"); select * from t1 where MATCH(a,b) AGAINST ("indexes"); select * from t1 where MATCH(a,b) AGAINST ("indexes collections"); delete from t1 where a like "MySQL%"; +update t1 set a='some test foobar' where MATCH a,b AGAINST ('model'); +delete from t1 where MATCH(a,b) AGAINST ("indexes"); +select * from t1; drop table t1; # |