← Back to team overview

maria-developers team mailing list archive

Re: MATCH returns -1

 

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



Follow ups

References