maria-discuss team mailing list archive

[Ian Gilfillan <ian@xxxxxxxxxxx>]

For InnoDB, you need to change innodb_ft_min_token_size, as 
ft_min_word_len is for MyISAM only:

https://mariadb.com/kb/en/library/innodb-system-variables/#innodb_ft_min_token_size
https://mariadb.com/kb/en/library/server-system-variables/#ft_min_word_len


On 2019/01/09 13:39, Andrew Wood wrote:
> Im trying to run a full text query on a two letter keyword 'K7'. I 
> have set ft_min_word_len=2 and restarted the server and if I view the 
> system vars in Mysql Workbench it shows it is set correctly.
>
> I have then dropped and re-created the index on the descrip column. It 
> is an InnoDB table so I cannot do repair table.
>
> Im running the following query which I expect to match the following 
> record but it doesnt. Full text searches for other words match OK.
>
> select * from asset where type ='DOCUMENTS' and (match(descrip) 
> against ('K7' in boolean mode)) ;
>
>
> +-----+--------------------+----------------------------------------------------------------------------------------------+-----------+-------------------+--------------+-------------+ 
>
> | id  | type                   | descrip           | subtype | 
> intendeduse  | location    | assetfileid |
> +-----+--------------------+---------------------------------------------------------------------------------------------+------------+-------------------+--------------+-------------+ 
>
> | 153 | DOCUMENTS | Telephone Kiosk No. 7 K7 Interior promo photo from 
> field trial.              | PHOTO   | DISPLAY         | STORAGE  
> |         152 |
> +-----+--------------------+----------------------------------------------------------------------------------------------+------------+------------------+--------------+-------------+ 
>
>
>
> Any ideas why this is not working?
>
> Thanks
>
> Andrew