← Back to team overview

maria-developers team mailing list archive

MATCH returns -1

 

  Hello Sergei,


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?

Is this a bug?


Thanks!


Follow ups