Hi!
On Feb 06, Tibor Simko wrote:
> 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
Thanks for your bugreport.
The bug will be fixed in the next MySQL release.
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
---------------------------------------------------------------------
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
