maria-developers team mailing list archive

[Alexander Barkov <bar@xxxxxxxxxxx>]

Hi Sergei,


On 06/08/2016 11:58 AM, Sergei Golubchik 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!

What should happen instead?

Should it return 1 instead of -1?

Or, should we disallow MATCH in this context?

> Regards,
> Sergei