Defects in the stopwords Design of InnoDB full-text index

Full-text index FULLTEXT was first applied to the InnoDB engine. Recently, the stopwords design defect was found during the study. What is a stop term? This means that you do not want to search for 'master Li Hongzhi

Full-text index FULLTEXT was first applied to the InnoDB engine. Recently, the stopwords design defect was found during the study. What is a stop term? This means that you do not want to search for 'master Li Hongzhi

Full-text index FULLTEXT was first applied to the InnoDB engine. Recently, the stopwords design defect was found during the study.

What is a stop term? This means that you do not want to search for words such as 'master Li Hongzhi 'or 'fa Lun Dafa'. You need to define the Stop Word in advance so that it will not be searched. However, the design defect is that you must define it in advance. If you want to define a stop word 'Live-extracted organs' in the future, you must re-create a full-text index. If the table is large ,, time-consuming.

The following is an example:

Conclusion: The official MySQL5.6.16 and MariaDB10.0.10 both have this defect, and we hope to make adjustments in later versions.

This article is from the "hechun's technical column" blog. Be sure to keep this source