My apologies if this is a known bug, I could not find a list of known
bugs. The detailed description is below, but basically,
works: match() against () AND match() against()
nope: match() against () OR match() against()
works: match() against ()>0 AND match() against()
nope: match() against ()>0 AND match() against()>0
where "works" means it uses the fulltext index, "nope" means it doesn't.
I'm using mysql v3.23.49 on Linux/x86.
Was this fixed already?
Thanks,
Matt
(and now the detailed description:)
I have a table 'entries', with columns 'author' and 'title', and a
fulltext index on each (individually).
If I issue the queries:
SELECT * from entries where match(author) against ('somebody') and
match(title) against ('something')
SELECT * from entries where match(author) against ('somebody') and
match(author) against ('somebodyelse')
Then it uses the index as expected. But if I issue
SELECT * from entries where match(author) against ('somebody') or
match(title) against ('something')
SELECT * from entries where match(author) against ('somebody') or
match(author) against ('somebodyelse')
(or instead of and)
Then it doesn't. EXPLAIN says:
+------------+------+---------------+------+---------+------+--------+--
----------+
| table | type | possible_keys | key | key_len | ref | rows |
Extra |
+------------+------+---------------+------+---------+------+--------+--
----------+
| entries | ALL | NULL | NULL | NULL | NULL | 483226 |
where used |
+------------+------+---------------+------+---------+------+--------+--
----------+
1 row in set (0.00 sec)
for the latter of the two.
Thinking it might be a problem with not saying ">0" (and here's where it
gets odd), I found that
SELECT * from entries where match(author) against ('somebody')>0 and
match(author) against('somebody2');
does use the index, while
SELECT * from entries where match(author) against ('somebody')>0 and
match(author) against('somebody2')>0;
does not!
---------------------------------------------------------------------
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
