[Groonga-mysql-commit] mroonga/mroonga [master] [wrapper][test] use multi match against conditions as selected columns.

Back to archive index

null+****@clear***** null+****@clear*****
2011年 9月 25日 (日) 20:39:49 JST


Kouhei Sutou	2011-09-25 11:39:49 +0000 (Sun, 25 Sep 2011)

  New Revision: 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 11:37:40 +0000 (f762b7e)
+++ test/sql/groonga_wrapper/r/fulltext_multiple_index.result    2011-09-25 11:39:49 +0000 (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 11:37:40 +0000 (6b8bb02)
+++ test/sql/groonga_wrapper/t/fulltext_multiple_index.test    2011-09-25 11:39:49 +0000 (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");
 




Groonga-mysql-commit メーリングリストの案内
Back to archive index