← Back to team overview

maria-developers team mailing list archive

Re: MATCH returns -1

 

Hello Sergei
How can we solve this bug?
Regards
sachin

On Wed, Jun 8, 2016 at 1:28 PM, Sergei Golubchik <serg@xxxxxxxxxxx> wrote:

> Hi, Alexander!
>
> On Jun 08, Alexander Barkov wrote:
> >
> > This script:
> >
> > DROP TABLE IF EXISTS t1;
> > CREATE TABLE t1 (a VARCHAR(30), b DOUBLE);
> > INSERT INTO t1 values('aaaa bbbb cccc dddd', MATCH (a) AGAINST('bbbb' IN
> BOOLEAN MODE));
> > SELECT * FROM t1;
> >
> > returns:
> >
> > +---------------------+------+
> > | a                   | b    |
> > +---------------------+------+
> > | aaaa bbbb cccc dddd |   -1 |
> > +---------------------+------+
> >
> > What does this -1 mean?
>
>   double Item_func_match::val_real()
>   {
>     DBUG_ENTER("Item_func_match::val");
>     if (ft_handler == NULL)
>       DBUG_RETURN(-1.0);
>
> > Is this a bug?
>
> I believe so!
>
> Regards,
> Sergei
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-developers
> Post to     : maria-developers@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-developers
> More help   : https://help.launchpad.net/ListHelp
>

References