diff options
| author | serg@serg.mysql.com <> | 2001-11-21 18:25:44 +0100 |
|---|---|---|
| committer | serg@serg.mysql.com <> | 2001-11-21 18:25:44 +0100 |
| commit | e8b45861e981f4084c4bb6697f173a8f3990194b (patch) | |
| tree | 212d0be141fe682b30e2759024cb421a2eaf9d1c /mysql-test | |
| parent | f6cf7618be1db2d5f0f1ccf67acb1a4fa6f9877a (diff) | |
| download | mariadb-git-e8b45861e981f4084c4bb6697f173a8f3990194b.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; # |