Hi,
I've encountered a similar bug on my own table.
If you want, I can upload a tar.gz of my table (5 MB), with the associated
query needed to reproduce the problem ?
Regards,
Jocelyn
----- Original Message -----
From: "Artem V. Ryabov" <[EMAIL PROTECTED]>
To: "Sergei Golubchik" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, July 24, 2002 10:43 AM
Subject: Re[2]: Bug or feature fulltext search?
> 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.
> yes. next query prove it:
>
> mysql> select left(ftText,17),match(ftText) against('+(w�d200206*) +w�12p'
in boolean mode) as m from Txt_index where match(ftText)
against('+w�d200206* +w�12p' in boolean mode);
> +-------------------+------+
> | left(ftText,17) | m |
> +-------------------+------+
> | w�d20020601 w�12p | 1 |
> | w�d20020601 w�nw | 1 |
> | w�d20020604 w�12p | 1 |
> | w�d20020604 w�12p | 1 |
> | w�d20020609 w�12p | 1 |
> | w�d20020609 w�12p | 1 |
> | w�d20020609 w�12p | 1 |
> | w�d20020609 w�12p | 1 |
> | w�d20020609 w�12p | 1 |
> | w�d20020609 w�12p | 1 |
> | w�d20020609 w�12p | 1 |
> | w�d20020609 w�12p | 1 |
> | w�d20020609 w�12p | 1 |
> | w�d20020609 w�12p | 1 |
> | w�d20020611 w�12p | 1 |
> | w�d20020611 w�12p | 1 |
> | w�d20020611 w�12p | 1 |
> | w�d20020611 w�12p | 1 |
> | w�d20020611 w�12p | 1 |
> | w�d20020614 w�12p | 1 |
> | w�d20020614 w�12p | 1 |
> | w�d20020619 w�12p | 1 |
> | w�d20020619 w�12p | 1 |
> | w�d20020619 w�12p | 1 |
> | w�d20020619 w�12p | 1 |
> | w�d20020619 w�12p | 1 |
> | w�d20020625 w�12p | 1 |
> | w�d20020625 w�12p | 1 |
> | w�d20020625 w�12p | 1 |
> | w�d20020625 w�12p | 1 |
> | w�d20020627 w�12p | 1 |
> | w�d20020627 w�12p | 1 |
> | w�d20020627 w�12p | 1 |
> | w�d20020627 w�12p | 1 |
> | w�d20020627 w�12p | 1 |
> | w�d20020627 w�12p | 1 |
> | w�d20020627 w�12p | 1 |
> | w�d20020627 w�12p | 1 |
> | w�d20020627 w�12p | 1 |
> | w�d20020627 w�12p | 1 |
> | w�d20020627 w�12p | 1 |
> | w�d20020627 w�12p | 1 |
> +-------------------+------+
> 42 rows in set (3.46 sec)
> mysql>
>
>
> SG> Could you provide a test case ?
> but how?
> Table very big:
>
> mysql> SHOW TABLE STATUS like 'Txt_index';
>
+-----------+--------+------------+-------+----------------+-------------+--
---------------+--------------+-----------+----------------+----------------
-----+---------------------+---------------------+----------------+---------
--------------+
> | Name | Type | Row_format | Rows | Avg_row_length | Data_length |
Max_data_length | Index_length | Data_free | Auto_increment | Create_time
| Update_time | Check_time | Create_options | Comment
|
>
+-----------+--------+------------+-------+----------------+-------------+--
---------------+--------------+-----------+----------------+----------------
-----+---------------------+---------------------+----------------+---------
--------------+
> | Txt_index | MyISAM | Dynamic | 42744 | 6032 | 257856408 |
4294967295 | 166645760 | 0 | 58071 | 2002-07-11 15:22:31
| 2002-07-11 15:30:56 | 2002-07-11 15:42:25 | |
�������������� ������ |
>
+-----------+--------+------------+-------+----------------+-------------+--
---------------+--------------+-----------+----------------+----------------
-----+---------------------+---------------------+----------------+---------
--------------+
> 1 row in set (0.03 sec)
> mysql> show create table Txt_index;
>
+-----------+---------------------------------------------------------------
----------------------------------------------------------------------------
-----------------------------------------------------------------+
> | Table | Create Table
|
>
+-----------+---------------------------------------------------------------
----------------------------------------------------------------------------
-----------------------------------------------------------------+
> | Txt_index | CREATE TABLE `Txt_index` ( `ID` int(11) NOT NULL
auto_increment, `ftText` mediumtext NOT NULL, PRIMARY KEY (`ID`),
FULLTEXT KEY `ftText` (`ftText`)) TYPE=MyISAM COMMENT='��������������
������' |
>
+-----------+---------------------------------------------------------------
----------------------------------------------------------------------------
-----------------------------------------------------------------+
> 1 row in set (0.02 sec)
> mysql>
>
> short table work without bug:
>
> mysql> create table tt(primary key(ID),fulltext(t)) select ID,ftText as t
from Txt_index where match(ftText) against('+w�d200206* +w�12p' in boolean
mode);
> Query OK, 42 rows affected (5.38 sec)
> Records: 42 Duplicates: 0 Warnings: 0
> mysql> select count(*) from tt where match(t) against ('+(w�d200206*)
+w�12p' in boolean mode);
> +----------+
> | count(*) |
> +----------+
> | 42 |
> +----------+
> 1 row in set (0.07 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
>
>
>
>
---------------------------------------------------------------------
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
