maria-developers team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

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