From 43a1ef6ce23e8751236c3948030e6e7b57bd5c45 Mon Sep 17 00:00:00 2001 From: unknown Date: Fri, 1 Mar 2002 16:57:08 +0000 Subject: fulltext+const_table bug fixed mysql-test/r/fulltext.result: test added mysql-test/t/fulltext.test: test added sql/item_func.cc: fulltext+const_table problem fixed once and forever sql/item_func.h: fulltext+const_table problem fixed once and forever sql/sql_select.cc: fulltext+const_table problem fixed once and forever sql/table.h: fulltext+const_table problem fixed once and forever --- mysql-test/r/fulltext.result | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'mysql-test/r/fulltext.result') diff --git a/mysql-test/r/fulltext.result b/mysql-test/r/fulltext.result index 1d03dffa76a..775ec29917f 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -150,3 +150,9 @@ select * from t1; id title 1 this test once revealed a bug update t1 set title=NULL where id=1; +drop table t1; +CREATE TABLE t1 (a int(11), b text, FULLTEXT KEY (b)) TYPE=MyISAM; +insert into t1 values (1,"I wonder why the fulltext index doesnt work?"); +SELECT * from t1 where MATCH (b) AGAINST ('apples'); +a b +drop table t1; -- cgit v1.2.1