subject:"Bug or feature fulltext search\?"

Re[2]: Bug or feature fulltext search?

2002-08-01 Thread Artem V. Ryabov


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,
 Artemmailto:[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

Re[2]: Bug or feature fulltext search?

2002-07-24 Thread Artem V. Ryabov


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

Re: Re[2]: Bug or feature fulltext search?

2002-07-24 Thread Jocelyn Fournier


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='Ïîëíîòåêñòîâûé
èíäåêñ

Re: Bug or feature fulltext search?

2002-07-24 Thread Sergei Golubchik


Hi!

On Jul 24, Jocelyn Fournier wrote:
 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

sure, thank you.

upload it to ftp://support.mysql.com/pub/mysql/secret/

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

Re: Bug or feature fulltext search?

2002-07-24 Thread Jocelyn Fournier


Hi,

I uploaded the table under
ftp://support.mysql.com/pub/mysql/secret/config.tar.gz

To reproduce the bug :

SELECT pseudo FROM config WHERE MATCH (config) AGAINST ('+(tes*) +test' IN
BOOLEAN MODE);
SELECT pseudo FROM config WHERE MATCH (config) AGAINST ('+tes* +test' IN
BOOLEAN MODE);

mysql SELECT pseudo FROM config WHERE MATCH (config) AGAINST ('+(tes*)
+test' IN BOOLEAN MODE);
++
| pseudo |
++
| bart70 |
| brioche|
| chupabouc  |
| Cobalt |
| Delio  |
| igor   |
| jojo61 |
| kalisto|
| lancelot75 |
| matthias   |
| napalm02   |
| picha  |
| The Mad|
| tuxinette  |
| utcddzeus  |
| vachefolle |
| WildGoose  |
| xeo|
++
18 rows in set (0.01 sec)

mysql SELECT pseudo FROM config WHERE MATCH (config) AGAINST ('+tes* +test'
IN BOOLEAN MODE);
++
| pseudo |
++
| bart70 |
| brioche|
| chupabouc  |
| Cobalt |
| Delio  |
| igor   |
| jojo61 |
| kalisto|
| lancelot75 |
| matthias   |
| napalm02   |
| picha  |
| The Mad|
| tuxinette  |
| utcddzeus  |
| vachefolle |
| WildGoose  |
| xeo|
| _jajax |
++
19 rows in set (0.01 sec)

Regards,
  Jocelyn


- Original Message -
From: Sergei Golubchik [EMAIL PROTECTED]
To: Jocelyn Fournier [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, July 24, 2002 4:45 PM
Subject: Re: Bug or feature fulltext search?


 Hi!

 On Jul 24, Jocelyn Fournier wrote:
  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

 sure, thank you.

 upload it to ftp://support.mysql.com/pub/mysql/secret/

 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






-
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

Bug or feature fulltext search?

2002-07-23 Thread Artem V. Ryabov


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);
+--+
| left(ftText,20)  |
+--+
| wÝd20020601   wÝ12p   wÝ |
| wÝd20020604   wÝ12p   wÝ |
| wÝd20020604   wÝ12p   wÝ |
+--+
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);
+--+
| left(ftText,20)  |
+--+
| wÝd20020601   wÝ12p   wÝ |
| wÝd20020601   wÝnwwÝ1 |
| wÝd20020604   wÝ12p   wÝ |
| wÝd20020604   wÝ12p   wÝ |
| wÝd20020609   wÝ12p   wÝ |
| wÝd20020609   wÝ12p   wÝ |
| wÝd20020609   wÝ12p   wÝ |
| wÝd20020609   wÝ12p   wÝ |
| wÝd20020609   wÝ12p   wÝ |
| wÝd20020609   wÝ12p   wÝ |
| wÝd20020609   wÝ12p   wÝ |
| wÝd20020609   wÝ12p   wÝ |
| wÝd20020609   wÝ12p   wÝ |
| wÝd20020609   wÝ12p   wÝ |
| wÝd20020611   wÝ12p   wÝ |
| wÝd20020611   wÝ12p   wÝ |
| wÝd20020611   wÝ12p   wÝ |
| wÝd20020611   wÝ12p   wÝ |
| wÝd20020611   wÝ12p   wÝ |
| wÝd20020614   wÝ12p   wÝ |
| wÝd20020614   wÝ12p   wÝ |
| wÝd20020619   wÝ12p   wÝ |
| wÝd20020619   wÝ12p   wÝ |
| wÝd20020619   wÝ12p   wÝ |
| wÝd20020619   wÝ12p   wÝ |
| wÝd20020619   wÝ12p   wÝ |
| wÝd20020625   wÝ12p   wÝ |
| wÝd20020625   wÝ12p   wÝ |
| wÝd20020625   wÝ12p   wÝ |
| wÝd20020625   wÝ12p   wÝ |
| wÝd20020627   wÝ12p   wÝ |
| wÝd20020627   wÝ12p   wÝ |
| wÝd20020627   wÝ12p   wÝ |
| wÝd20020627   wÝ12p   wÝ |
| wÝd20020627   wÝ12p   wÝ |
| wÝd20020627   wÝ12p   wÝ |
| wÝd20020627   wÝ12p   wÝ |
| wÝd20020627   wÝ12p   wÝ |
| wÝd20020627   wÝ12p   wÝ |
| wÝd20020627   wÝ12p   wÝ |
| wÝd20020627   wÝ12p   wÝ |
| wÝd20020627   wÝ12p   wÝ |
+--+
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)

-- 
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

Re: Bug or feature fulltext search?

2002-07-23 Thread Sergei Golubchik


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

Re[2]: Bug or feature fulltext search?

Re[2]: Bug or feature fulltext search?

Re: Re[2]: Bug or feature fulltext search?

Re: Bug or feature fulltext search?

Re: Bug or feature fulltext search?

Bug or feature fulltext search?

Re: Bug or feature fulltext search?

7 matches

Site Navigation

Mail list logo

Footer information