EVOLUTION-MANAGER

Edit File: alter_table_enable_keys_fulltext.result

DROP TABLE IF EXISTS diaries; SET NAMES utf8; CREATE TABLE diaries ( id int PRIMARY KEY, title varchar(255), FULLTEXT KEY title_index (title) ) COMMENT='ENGINE "InnoDB"' DEFAULT CHARSET=utf8; ALTER TABLE diaries DISABLE KEYS; INSERT INTO diaries VALUES (1, "Hello"); INSERT INTO diaries VALUES (2, "天気"); INSERT INTO diaries VALUES (3, "富士山"); SELECT * FROM diaries FORCE INDEX (title_index) WHERE MATCH (title) AGAINST ("富士山"); ERROR HY000: Can't find FULLTEXT index matching the column list ALTER TABLE diaries ENABLE KEYS; SELECT * FROM diaries FORCE INDEX (title_index) WHERE MATCH (title) AGAINST ("富士山"); id title 3 富士山 DROP TABLE diaries;