diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2002-06-14 15:06:01 +0300 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2002-06-14 15:06:01 +0300 |
| commit | 4a1b497899c01fd3df7deaa94ee9171fead111f5 (patch) | |
| tree | 63763801fe20c7f851a8661ae6d3b1c393aa144a /mysql-test/t/fulltext.test | |
| parent | 0ea0993cfb64feab7b603479fc1f2a1342381bb8 (diff) | |
| download | mariadb-git-4a1b497899c01fd3df7deaa94ee9171fead111f5.tar.gz | |
Fixed a rare bug when fulltext index is present and no tables are used.
A better fix would be to have a map of tables that are not used at all,
and to annul just fledls in that TABLE.
Diffstat (limited to 'mysql-test/t/fulltext.test')
| -rw-r--r-- | mysql-test/t/fulltext.test | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test index 238705c8e3e..4093f06d627 100644 --- a/mysql-test/t/fulltext.test +++ b/mysql-test/t/fulltext.test @@ -154,4 +154,8 @@ insert into t1 values (2,"fullaaa fullzzz"); select * from t1 where match b against ('full*' in boolean mode); drop table t1; +CREATE TABLE t1 ( id int(11) NOT NULL auto_increment primary key, mytext text NOT NULL, FULLTEXT KEY mytext (mytext)) TYPE=MyISAM; +INSERT INTO t1 VALUES (1,'my small mouse'),(2,'la-la-la'),(3,'It is so funny'),(4,'MySQL Tutorial'); +select 8 from t1; +drop table t1; |