diff options
Diffstat (limited to 'storage/mroonga/mysql-test/mroonga/wrapper/r/alter_table_disable_keys_create_fulltext.result')
-rw-r--r-- | storage/mroonga/mysql-test/mroonga/wrapper/r/alter_table_disable_keys_create_fulltext.result | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/storage/mroonga/mysql-test/mroonga/wrapper/r/alter_table_disable_keys_create_fulltext.result b/storage/mroonga/mysql-test/mroonga/wrapper/r/alter_table_disable_keys_create_fulltext.result new file mode 100644 index 00000000000..b185bf269f7 --- /dev/null +++ b/storage/mroonga/mysql-test/mroonga/wrapper/r/alter_table_disable_keys_create_fulltext.result @@ -0,0 +1,27 @@ +DROP TABLE IF EXISTS diaries; +SET NAMES utf8; +CREATE TABLE diaries ( +id int PRIMARY KEY, +title varchar(255) +) COMMENT='ENGINE "InnoDB"' DEFAULT CHARSET=utf8; +INSERT INTO diaries VALUES (1, "Hello"); +INSERT INTO diaries VALUES (2, "天気"); +INSERT INTO diaries VALUES (3, "富士山"); +SELECT * +FROM diaries +WHERE MATCH (title) AGAINST ("富士山"); +ERROR HY000: Can't find FULLTEXT index matching the column list +CREATE FULLTEXT INDEX title_index on diaries (title); +SELECT * +FROM diaries +FORCE INDEX (title_index) +WHERE MATCH (title) AGAINST ("富士山"); +id title +3 富士山 +ALTER TABLE diaries DISABLE KEYS; +SELECT * +FROM diaries +FORCE INDEX (title_index) +WHERE MATCH (title) AGAINST ("富士山"); +ERROR HY000: Can't find FULLTEXT index matching the column list +DROP TABLE diaries; |