Kouhei Sutou
null+****@clear*****
Thu Oct 4 10:30:01 JST 2012
Kouhei Sutou 2011-09-25 20:39:49 +0900 (Sun, 25 Sep 2011) New Revision: fad07e5ae2b6cc3337c8bc4fba7d4566c165f29d https://github.com/mroonga/mroonga/commit/fad07e5ae2b6cc3337c8bc4fba7d4566c165f29d Log: [wrapper][test] use multi match against conditions as selected columns. Modified files: test/sql/groonga_wrapper/r/fulltext_multiple_index.result test/sql/groonga_wrapper/t/fulltext_multiple_index.test Modified: test/sql/groonga_wrapper/r/fulltext_multiple_index.result (+4 -3) =================================================================== --- test/sql/groonga_wrapper/r/fulltext_multiple_index.result 2011-09-25 20:37:40 +0900 (f762b7e) +++ test/sql/groonga_wrapper/r/fulltext_multiple_index.result 2011-09-25 20:39:49 +0900 (993ab87) @@ -19,9 +19,10 @@ diaries CREATE TABLE `diaries` ( insert into diaries (title, body) values ("survey", "will start groonga!"); insert into diaries (title, body) values ("groonga (1)", "starting groonga..."); insert into diaries (title, body) values ("groonga (2)", "started groonga."); -select * from diaries +select *, match(title) against("survey"), match(body) against("groonga") +from diaries where match(title) against("survey") and match(body) against("groonga"); -id title body -1 survey will start groonga! +id title body match(title) against("survey") match(body) against("groonga") +1 survey will start groonga! 1 1 drop table diaries; Modified: test/sql/groonga_wrapper/t/fulltext_multiple_index.test (+2 -1) =================================================================== --- test/sql/groonga_wrapper/t/fulltext_multiple_index.test 2011-09-25 20:37:40 +0900 (6b8bb02) +++ test/sql/groonga_wrapper/t/fulltext_multiple_index.test 2011-09-25 20:39:49 +0900 (cc88083) @@ -33,7 +33,8 @@ insert into diaries (title, body) values ("survey", "will start groonga!"); insert into diaries (title, body) values ("groonga (1)", "starting groonga..."); insert into diaries (title, body) values ("groonga (2)", "started groonga."); -select * from diaries +select *, match(title) against("survey"), match(body) against("groonga") + from diaries where match(title) against("survey") and match(body) against("groonga"); -------------- next part -------------- HTML����������������������������...Download