From e8b45861e981f4084c4bb6697f173a8f3990194b Mon Sep 17 00:00:00 2001
From: "serg@serg.mysql.com" <>
Date: Wed, 21 Nov 2001 18:25:44 +0100
Subject: (UPDATE|DELETE) ...WHERE MATCH bugfix

---
 mysql-test/r/fulltext.result | 4 ++++
 mysql-test/t/fulltext.test   | 3 +++
 2 files changed, 7 insertions(+)

(limited to 'mysql-test')

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;
 
 #
-- 
cgit v1.2.1