Hi!
On Jul 23, Artem V. Ryabov wrote:
> Hello mysql,
>
> see this 2 queries:
> why they not equal?
> why first skip many records?
>
> mysql> select left(ftText,20) from Txt_index where match(ftText)
>against('+(wщd200206*) +wщ12p' in boolean mode);
> 3 rows in set (0.36 sec)
>
> mysql> select left(ftText,20) from Txt_index where match(ftText)
>against('+wщd200206* +wщ12p' in boolean mode);
> 42 rows in set (8.00 sec)
>
>
> mysql> show variables like 'version';
> +---------------+-----------------+
> | Variable_name | Value |
> +---------------+-----------------+
> | version | 4.0.2-alpha-log |
> +---------------+-----------------+
> 1 row in set (0.00 sec)
Obviously, it's a bug.
Could you provide a test case ?
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
