diff options
| author | unknown <serg@serg.mysql.com> | 2002-03-01 16:57:08 +0000 |
|---|---|---|
| committer | unknown <serg@serg.mysql.com> | 2002-03-01 16:57:08 +0000 |
| commit | 43a1ef6ce23e8751236c3948030e6e7b57bd5c45 (patch) | |
| tree | 2b4289848a910e2a05a4d815949eaca3ecf90bb8 /mysql-test/r/fulltext.result | |
| parent | 6fdd6e8e4689342f8fa213a36465d2263a8ccab9 (diff) | |
| download | mariadb-git-43a1ef6ce23e8751236c3948030e6e7b57bd5c45.tar.gz | |
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
Diffstat (limited to 'mysql-test/r/fulltext.result')
| -rw-r--r-- | mysql-test/r/fulltext.result | 6 |
1 files changed, 6 insertions, 0 deletions
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; |