Re: [Maria-developers] MATCH returns -1

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