"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)
mysql Ver 11.16 Distrib 3.23.49, for Win95/Win98 (i32)
Windows 98 SE
--
./ premax
./ [EMAIL PROTECTED]
---------------------------------------------------------------------
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
