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

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