Kouhei Sutou
null+****@clear*****
Thu Dec 21 16:40:27 JST 2017
Kouhei Sutou 2017-12-21 16:40:27 +0900 (Thu, 21 Dec 2017) New Revision: beea8e8622f922bea455fdd41e2bfed99d8cfecf https://github.com/mroonga/mroonga/commit/beea8e8622f922bea455fdd41e2bfed99d8cfecf Message: test: use more meaningful test data Modified files: mysql-test/mroonga/storage/optimization/condition_push_down/r/full_text_search_only.result mysql-test/mroonga/storage/optimization/condition_push_down/t/full_text_search_only.test Modified: mysql-test/mroonga/storage/optimization/condition_push_down/r/full_text_search_only.result (+5 -1) =================================================================== --- mysql-test/mroonga/storage/optimization/condition_push_down/r/full_text_search_only.result 2017-12-21 16:30:50 +0900 (879c0561) +++ mysql-test/mroonga/storage/optimization/condition_push_down/r/full_text_search_only.result 2017-12-21 16:40:27 +0900 (650c5f1c) @@ -3,14 +3,18 @@ FLUSH STATUS; SET NAMES UTF8; CREATE TABLE memos ( content TEXT, -FULLTEXT INDEX(content) +FULLTEXT INDEX (content) ) DEFAULT CHARSET UTF8; INSERT INTO memos VALUES ('Groonga is fast'); +INSERT INTO memos VALUES ('Fast embeddable full text search engine'); +INSERT INTO memos VALUES ('Mroonga is fast'); +INSERT INTO memos VALUES ('Groonga + MySQL'); SELECT * FROM memos WHERE MATCH(content) AGAINST('+Groonga' IN BOOLEAN MODE); content Groonga is fast +Groonga + MySQL SHOW STATUS LIKE 'mroonga_condition_push_down'; Variable_name Value Mroonga_condition_push_down 1 Modified: mysql-test/mroonga/storage/optimization/condition_push_down/t/full_text_search_only.test (+4 -1) =================================================================== --- mysql-test/mroonga/storage/optimization/condition_push_down/t/full_text_search_only.test 2017-12-21 16:30:50 +0900 (c303e6e1) +++ mysql-test/mroonga/storage/optimization/condition_push_down/t/full_text_search_only.test 2017-12-21 16:40:27 +0900 (9eaa8d32) @@ -25,10 +25,13 @@ FLUSH STATUS; SET NAMES UTF8; CREATE TABLE memos ( content TEXT, - FULLTEXT INDEX(content) + FULLTEXT INDEX (content) ) DEFAULT CHARSET UTF8; INSERT INTO memos VALUES ('Groonga is fast'); +INSERT INTO memos VALUES ('Fast embeddable full text search engine'); +INSERT INTO memos VALUES ('Mroonga is fast'); +INSERT INTO memos VALUES ('Groonga + MySQL'); SELECT * FROM memos -------------- next part -------------- HTML����������������������������... URL: https://lists.osdn.me/mailman/archives/groonga-mysql-commit/attachments/20171221/6f837b76/attachment-0001.htm