diff options
Diffstat (limited to 'storage/mroonga/mysql-test/mroonga/storage/r/fulltext_boolean_mode_pragma_default_operator_or_with_minus.result')
| -rw-r--r-- | storage/mroonga/mysql-test/mroonga/storage/r/fulltext_boolean_mode_pragma_default_operator_or_with_minus.result | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/fulltext_boolean_mode_pragma_default_operator_or_with_minus.result b/storage/mroonga/mysql-test/mroonga/storage/r/fulltext_boolean_mode_pragma_default_operator_or_with_minus.result index 103866902c2..dfeb71f0d14 100644 --- a/storage/mroonga/mysql-test/mroonga/storage/r/fulltext_boolean_mode_pragma_default_operator_or_with_minus.result +++ b/storage/mroonga/mysql-test/mroonga/storage/r/fulltext_boolean_mode_pragma_default_operator_or_with_minus.result @@ -10,9 +10,10 @@ INSERT INTO memos VALUES ("Today is fine."); INSERT INTO memos VALUES ("Tomorrow will be fine."); INSERT INTO memos VALUES ("Yesterday was fine."); SELECT * FROM memos -WHERE MATCH (content) AGAINST ("*DOR today -good tomorrow" IN BOOLEAN MODE); +WHERE MATCH (content) AGAINST ("*DOR today -good tomorrow" IN BOOLEAN MODE) +ORDER BY content; content -Tomorrow will be good day. Today is fine. Tomorrow will be fine. +Tomorrow will be good day. DROP TABLE memos; |