diff options
Diffstat (limited to 'storage/mroonga/mysql-test/mroonga/storage/r/fulltext_boolean_mode_leading_not.result')
-rw-r--r-- | storage/mroonga/mysql-test/mroonga/storage/r/fulltext_boolean_mode_leading_not.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/fulltext_boolean_mode_leading_not.result b/storage/mroonga/mysql-test/mroonga/storage/r/fulltext_boolean_mode_leading_not.result new file mode 100644 index 00000000..758f969f --- /dev/null +++ b/storage/mroonga/mysql-test/mroonga/storage/r/fulltext_boolean_mode_leading_not.result @@ -0,0 +1,15 @@ +DROP TABLE IF EXISTS diaries; +SET NAMES UTF8; +CREATE TABLE diaries ( +id INT PRIMARY KEY, +title VARCHAR(255), +content TEXT, +FULLTEXT INDEX (content) +) DEFAULT CHARSET UTF8; +INSERT INTO diaries VALUES(1, "Hello", "今日からはじめました。"); +INSERT INTO diaries VALUES(2, "天気", "明日の富士山の天気について"); +INSERT INTO diaries VALUES(3, "富士山", "今日も天気がよくてきれいに見える。"); +SELECT * FROM diaries WHERE MATCH(content) AGAINST("-明日 +天気" IN BOOLEAN MODE); +id title content +3 富士山 今日も天気がよくてきれいに見える。 +DROP TABLE diaries; |