Hello
Another possibly related FULLTEXT problem: in 3.23.32, if the table
contains one row only, then a fulltext match occurs regardless of the
pattern you search for:
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (
id mediumint unsigned NOT NULL auto_increment,
tag char(6) NOT NULL default '',
value text NOT NULL default '',
PRIMARY KEY (id),
KEY kt(tag),
KEY kv(value(15)),
FULLTEXT KEY kvf(value)
) TYPE=MyISAM;
INSERT INTO t1 (tag,value) VALUES ('foo','foobar');
SELECT * FROM t1 WHERE MATCH (value) AGAINST ('nonexistent');
DROP TABLE t1;
If the table contains more than one row, then it works as expected
(i.e. no match is found for 'nonexistent').
cheers
--
TS
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php