EVOLUTION-MANAGER

Edit File: create_table_index_normalizer_none.result

DROP TABLE IF EXISTS diaries; SET NAMES utf8; CREATE TABLE diaries ( day DATE PRIMARY KEY, content VARCHAR(64) NOT NULL, FULLTEXT INDEX (content) COMMENT 'normalizer "none"' ) DEFAULT CHARSET=utf8; INSERT INTO diaries VALUES ("2013-04-23", "Mroonga"); SELECT * FROM diaries WHERE MATCH (content) AGAINST ("+Mroonga" IN BOOLEAN MODE); day content 2013-04-23 Mroonga SELECT * FROM diaries WHERE MATCH (content) AGAINST ("+mroonga" IN BOOLEAN MODE); day content DROP TABLE diaries;