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

Reply via email to