Hi!
On Mar 06, Thomas Spahni wrote:
> Dear listmembers
>
> My problems are: jokers appear not to work as expected in boolean
> fulltext search and I can't figure out how to order results according to
> any relevance. I need someone to point me into the right direction.
>
> According to the Very Fine Manual I would expect that the following query
> would return at least 2 rows (remember: the word 'placidus' appears in two
> of the documents):
>
> mysql> SELECT doc FROM plaintext WHERE MATCH(bgetxt) AGAINST('placi*' IN
> BOOLEAN MODE);
> Empty set (0.00 sec)
It is a bug.
You can - either create a repeatable test case, to be sure,
the bug will be fixed in 4.0.2, or just wait till 4.0.2
and try it out, hoping that one of the boolean fulltext search
bugs that were fixed recently is yours.
> What happens? As it appears, the *asterisk* joker is not supported. And I
> can't see from the manual, how to obtain some relevance data when using
> the modifier 'IN BOOLEAN MODE'. I tried this:
>
> mysql> SELECT doc, MATCH(bgetxt) AGAINST('placidus' IN BOOLEAN MODE) AS
> score FROM plaintext WHERE MATCH(bgetxt) AGAINST('placidus' IN BOOLEAN
> MODE);
> +-------------+-------+
> | doc | score |
> +-------------+-------+
> | 122 III 150 | 1 |
> | 84 II 304 | 1 |
> +-------------+-------+
> 2 rows in set (0.00 sec)
>
>
> I need to sort rows returned by a boolean search in some order of
> relevance. Any enlightenment would be very helpful. TIA
Without seeing actual row data I cannot say whether 1 is correct
score or not. Boolean fulltext search uses VERY simple scoring,
so it is quite possible that both rows have the score of 1.
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
