I´m trying to use fulltextsearch this is the result of the query
the column M shows how the result of match shows 0 in the rows who contains that value, i try without “” and have the same result
i try with the command OPTIMIZE TABLE books FLUSH;
but the result not change, what i´m doing wrong?
this is the table
CREATE TABLE Pendings (id BIGINT UNSIGNED AUTO_INCREMENT ,ProcessId BIGINT, PendingId BIGINT,Path TEXT,Name TEXT, TaskName TEXT,TagsValues TEXT,KEY (id) USING CLUSTERED COLUMNSTORE, FULLTEXT(TagsValues))
Your column M is the relevance score. It appears that it may be rounding or truncating that for some reason. Try casting that to a float or some other decimal data type representation. It is likely that the other values really are say ‘0.98888’. Generally, you will want to include your relevance score in the where clause.
the strange behavior was due by the simbol “-” in the date saved on the column, I change the format from “-” to “_” and little change on the search and works without problem
2 Likes
Nice find! ( post must be at least 20 characters :-))
1 Like
