"MySQL" full-text index match multi-column error

The table structure is as follows:

CREATE TABLE ' T ' (   ..... KEY ' Title_fc ' (' Titleindex '),   KEY ' Shortname_fc ' (' Shortnameindex ')) ENGINE=InnoDB auto_increment=50962041DEFAULT CHARSET= 

Two full-text indexes were created, but the following error occurred while searching.

Mysql> SELECT Count(1) as Count  fromT AWHERE 1 = 1   andMATCH (A.titleindex) against ('"5YeM 5Yqo"' inchBOOLEAN MODE);+-------+| Count |+-------+|     - |+-------+1Rowinch Set(0.01sec) MySQL> SELECT Count(1) as Count  fromT AWHERE 1 = 1   andMATCH (A.shortnameindex) against ('"5YeM 5Yqo"' inchBOOLEAN MODE);+-------+| Count |+-------+|     6 |+-------+1Rowinch Set(0.00sec) MySQL> SELECT Count(1) as Count  fromT AWHERE 1 = 1   andMATCH (A.shortnameindex, A.titleindex) against ('"5YeM 5Yqo"' inchBOOLEAN MODE); ERROR1191(HY000): Can't find fulltext index matching the column list

Single match a column can be queried normally, but match multiple columns will be an error.

It was later found on the MySQL document: the match () column list must match exactly the column list in some Fulltext index definition for the table , unless this MATCH () was in BOOLEAN MODE on a MyISAM table.

"MySQL" full-text index match multiple columns error