Question 22082 in Mysql Question posted in
The official MySQL documentation can be found here.

MySQL's comment /*!50100 */ didn't work in Version 5.7

I have try to create full text index.

I use the " FULLTEXT KEY book_name (book_name) WITH PARSER ngram ".

After created the table , the "show create table " shows that the upper line turned to be " FULLTEXT KEY book_name (book_name) /*!50100 WITH PARSER ngram */"

But It didn’t work really. I can’t use the full text search.

I put the source code here : db fiddle

You can see the difference. I don’t know why.

Tags:

2

Answers


  1. 0

    Why are You using MYISAM as engine , use INNODB

    CREATE TABLE tmp1 (
  book_name char(32) NOT NULL,
  FULLTEXT KEY book_name (book_name) /*!50100 WITH PARSER `ngram` */
) ENGINE=INNODB DEFAULT CHARSET=utf8mb4;

    So at least the FULL TEXT works fine with english text, but if it works with asian text i don’t know

    Login or Signup to reply.
  2. 0

    Is this relevant?

    —- 2018-07-27 8.0.12 General Availability & 2018-07-27 5.7.23 General Availability — — InnoDB —–

    The ngram full-text search parser permitted comma and period characters to be tokenized as words, which caused an inconsistency between boolean and natural language mode search results. Comma and period characters are no longer tokenized. (Bug #27847697)

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search