Hello Sergei,
Tuesday, July 23, 2002, 10:17:06 PM, you wrote:
SG> Hi!
SG> 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)
SG> Obviously, it's a bug.
SG> Could you provide a test case ?
I tried to use 'REPAIR TABLE Txt_index USE_FRM', this query work _very_ slow:
+------------------+--------+----------+----------------------------------------+
| Table | Op | Msg_type | Msg_text |
+------------------+--------+----------+----------------------------------------+
| NewWeb.Txt_index | repair | warning | Number of rows changed from 0 to 43390 |
| NewWeb.Txt_index | repair | status | OK |
+------------------+--------+----------+----------------------------------------+
2 rows in set (2 days 11 hours 21 min 7.35 se2 rows in set (2
But noting change:
mysql> select left(ftText,17) from Txt_index where match(ftText)
against('+(wùd200206*) +wù12p' in boolean mode);
3 rows in set (0.35 sec)
mysql> select left(ftText,17) from Txt_index where match(ftText) against('+wùd200206*
+wù12p' in boolean mode);
42 rows in set (4.52 sec)
mysql>
SG> Regards,
SG> Sergei
--
Best regards,
Artem mailto:[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
