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/r/fulltext.result | |
| 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/r/fulltext.result')
| -rw-r--r-- | mysql-test/r/fulltext.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/fulltext.result b/mysql-test/r/fulltext.result index 5ecab7278db..f5e65c5103b 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -192,3 +192,12 @@ a b 2 fullaaa fullzzz 1 I wonder why the fulltext index doesnt work? 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; +8 +8 +8 +8 +8 +drop table t1; |