Hi!
On May 23, Przemyslaw Popielarski wrote:
> "Sergei Golubchik" <[EMAIL PROTECTED]> wrote:
> > It looks like a bug. Can you create a test case for this ?
>
> create table tBooks (
> isbn char(10) not null primary key,
> title varchar(60) not null,
> fulltext index (title)
> );
>
> insert into tBooks (isbn,title) values
> ('1876340436','2000 Lonely Planet Calendar');
>
> insert into tBooks (isbn,title) values
> ('0852297904','Britannica 2002 on CD-ROM Expanded ed');
>
> SELECT isbn,title FROM tBooks
> WHERE tBooks.isbn="1876340436"
> AND MATCH (tBooks.title) AGAINST ("britannica")
>
> +------------+-----------------------------+
> | isbn | title |
> +------------+-----------------------------+
> | 1876340436 | 2000 Lonely Planet Calendar |
> +------------+-----------------------------+
> 1 row in set (0.00 sec)
Works fine for me (that is "No rows" - and no bug).
Probably, it's one of numerous fulltext-related bugs that were fixed
since 4.0.1 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
