Re: Bug or feature fulltext search?

Hi,

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

How-to-repeat :

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"
To: "Jocelyn Fournier"
Cc:
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
> / /|_/ / // /\ \/ /_/ / /__ 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
> To unsubscribe, e-mail

> 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 bugs-thread12265@lists.mysql.com
To unsubscribe, e-mail