diff options
| author | serg@serg.mysql.com <> | 2002-03-01 16:57:08 +0000 |
|---|---|---|
| committer | serg@serg.mysql.com <> | 2002-03-01 16:57:08 +0000 |
| commit | 4e6150d4c78c2565edb3f3a0f999f380a75ebde5 (patch) | |
| tree | 2b4289848a910e2a05a4d815949eaca3ecf90bb8 /mysql-test/r/fulltext.result | |
| parent | 87a3c7f0f955097d180f5ebc112ae8d1ac93fb51 (diff) | |
| download | mariadb-git-4e6150d4c78c2565edb3f3a0f999f380a75ebde5.tar.gz | |
fulltext+const_table bug fixed
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; |