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/t/fulltext.test | |
| 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/t/fulltext.test')
| -rw-r--r-- | mysql-test/t/fulltext.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test index ace51217bba..3d203bc61f5 100644 --- a/mysql-test/t/fulltext.test +++ b/mysql-test/t/fulltext.test @@ -129,3 +129,13 @@ check table t1; update t1 set title='this test once revealed a bug' where id=1; select * from t1; update t1 set title=NULL where id=1; + +drop table t1; + +# one more bug - const_table related + +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'); + +drop table t1; |