diff options
Diffstat (limited to 'storage/mroonga/mysql-test/mroonga/wrapper/r/create_table_normalizer_fulltext_index.result')
-rw-r--r-- | storage/mroonga/mysql-test/mroonga/wrapper/r/create_table_normalizer_fulltext_index.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/storage/mroonga/mysql-test/mroonga/wrapper/r/create_table_normalizer_fulltext_index.result b/storage/mroonga/mysql-test/mroonga/wrapper/r/create_table_normalizer_fulltext_index.result new file mode 100644 index 00000000000..ea992f827ca --- /dev/null +++ b/storage/mroonga/mysql-test/mroonga/wrapper/r/create_table_normalizer_fulltext_index.result @@ -0,0 +1,16 @@ +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 "NormalizerAuto"' +) COMMENT='engine "InnoDB"' DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; +INSERT INTO diaries VALUES ("2013-04-23", "ブラックコーヒーを飲んだ。"); +SELECT * FROM diaries +WHERE MATCH (content) AGAINST ("+ふらつく" IN BOOLEAN MODE); +day content +SELECT * FROM diaries +WHERE MATCH (content) AGAINST ("+ブラック" IN BOOLEAN MODE); +day content +2013-04-23 ブラックコーヒーを飲んだ。 +DROP TABLE diaries; |