mysql> DROP TABLE IF EXISTS test.t_col_fts

mysql> CREATE TABLE test.t_col_fts (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
pad VARCHAR(20)
) ENGINE=InnoDB

mysql> INSERT INTO test.t_col_fts(pad) VALUES ('a'), ('b')

mysql> ALTER TABLE test.t_col_fts ADD COLUMN col_test VARCHAR(100)

mysql> INSERT INTO test.t_col_fts(pad, col_test) VALUES ('c', 'preindexvalue'), ('d', 'preindexhello')

mysql> ALTER TABLE test.t_col_fts ADD FULLTEXT INDEX idx_add (col_test) WITH PARSER STANDARD

mysql> INSERT INTO test.t_col_fts(pad, col_test) VALUES ('e', 'plugincasevalue'), ('f', 'hello')

wait> shard_progress table=test.t_col_fts index=idx_add

mysql> SELECT id FROM test.t_col_fts WHERE MATCH(col_test) AGAINST('preindexhello' IN BOOLEAN MODE)
+----+
| id |
+----+
|  4 |
+----+

mysql> SELECT id FROM test.t_col_fts WHERE MATCH(col_test) AGAINST('hello' IN BOOLEAN MODE)
+----+
| id |
+----+
|  6 |
+----+

mysql> SELECT id FROM test.t_col_fts WHERE MATCH(col_test) AGAINST('plugincasevalue' IN BOOLEAN MODE)
+----+
| id |
+----+
|  5 |
+----+

mysql> SELECT count(*) FROM test.t_col_fts WHERE fts_match_word("hello", col_test) or not fts_match_word("hello", col_test)
+----------+
| count(*) |
+----------+
|        6 |
+----------+