[Groonga-commit] pgroonga/pgroonga at 5569b52 [master] test: make stable

Back to archive index

Kouhei Sutou null+****@clear*****
Sat Aug 12 11:49:44 JST 2017


Kouhei Sutou	2017-08-12 11:49:44 +0900 (Sat, 12 Aug 2017)

  New Revision: 5569b52ecf32367c22a63dcf635ae4a2f08f58bd
  https://github.com/pgroonga/pgroonga/commit/5569b52ecf32367c22a63dcf635ae4a2f08f58bd

  Message:
    test: make stable

  Modified files:
    expected/compatibility/schema/term-search/text/combined/indexscan.out

  Modified: expected/compatibility/schema/term-search/text/combined/indexscan.out (+7 -4)
===================================================================
--- expected/compatibility/schema/term-search/text/combined/indexscan.out    2017-08-12 11:49:06 +0900 (853143d)
+++ expected/compatibility/schema/term-search/text/combined/indexscan.out    2017-08-12 11:49:44 +0900 (de51512)
@@ -23,13 +23,16 @@ CREATE INDEX pgrn_tag_readings_index ON tag_readings
 SET enable_seqscan = off;
 SET enable_indexscan = on;
 SET enable_bitmapscan = off;
-SELECT name, pgroonga.score(tags)
+SELECT * FROM (
+  SELECT name, pgroonga.score(tags) AS score
   FROM tags
   WHERE name &^ 'Groon'
-UNION
-SELECT tag_name, pgroonga.score(tag_readings)
+  UNION
+  SELECT tag_name AS name, pgroonga.score(tag_readings) AS score
   FROM tag_readings
-  WHERE katakana &^~ 'posu';
+  WHERE katakana &^~ 'posu'
+) AS candidates
+ORDER BY name;
     name    | score 
 ------------+-------
  Groonga    |     1
-------------- next part --------------
HTML����������������������������...
Download 



More information about the Groonga-commit mailing list
Back to archive index