diff options
Diffstat (limited to 'storage/mroonga/mysql-test/mroonga/wrapper/r/fulltext_boolean_mode_pragma_default_operator_plus_with_or.result')
-rw-r--r-- | storage/mroonga/mysql-test/mroonga/wrapper/r/fulltext_boolean_mode_pragma_default_operator_plus_with_or.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/storage/mroonga/mysql-test/mroonga/wrapper/r/fulltext_boolean_mode_pragma_default_operator_plus_with_or.result b/storage/mroonga/mysql-test/mroonga/wrapper/r/fulltext_boolean_mode_pragma_default_operator_plus_with_or.result new file mode 100644 index 00000000000..b61f0637bb9 --- /dev/null +++ b/storage/mroonga/mysql-test/mroonga/wrapper/r/fulltext_boolean_mode_pragma_default_operator_plus_with_or.result @@ -0,0 +1,16 @@ +DROP TABLE IF EXISTS memos; +SET NAMES utf8; +CREATE TABLE memos ( +id INT PRIMARY KEY AUTO_INCREMENT, +content TEXT, +FULLTEXT INDEX (content) +) DEFAULT CHARSET=utf8 COMMENT='engine "InnODB"'; +INSERT INTO memos VALUES (NULL, "Today is good day."); +INSERT INTO memos VALUES (NULL, "Tomorrow will be good day."); +INSERT INTO memos VALUES (NULL, "Today is fine."); +SELECT * FROM memos +WHERE MATCH (content) AGAINST ("*D+ today OR tomorrow day" IN BOOLEAN MODE); +id content +1 Today is good day. +2 Tomorrow will be good day. +DROP TABLE memos; |