Kouhei Sutou
null+****@clear*****
Sat Aug 12 11:49:06 JST 2017
Kouhei Sutou 2017-08-12 11:49:06 +0900 (Sat, 12 Aug 2017) New Revision: a0c653450f8424d5e32ce171fadff733ac8e626c https://github.com/pgroonga/pgroonga/commit/a0c653450f8424d5e32ce171fadff733ac8e626c Message: test: make stable Modified files: expected/compatibility/schema/term-search/text/combined/bitmapscan.out expected/compatibility/schema/term-search/text/combined/indexscan.out expected/term-search/text/combined/bitmapscan.out expected/term-search/text/combined/indexscan.out expected/term-search/text/combined/seqscan.out sql/compatibility/schema/term-search/text/combined/bitmapscan.sql sql/compatibility/schema/term-search/text/combined/indexscan.sql sql/term-search/text/combined/bitmapscan.sql sql/term-search/text/combined/indexscan.sql sql/term-search/text/combined/seqscan.sql Modified: expected/compatibility/schema/term-search/text/combined/bitmapscan.out (+8 -5) =================================================================== --- expected/compatibility/schema/term-search/text/combined/bitmapscan.out 2017-08-12 11:31:32 +0900 (c543fb6) +++ expected/compatibility/schema/term-search/text/combined/bitmapscan.out 2017-08-12 11:49:06 +0900 (0042213) @@ -23,17 +23,20 @@ CREATE INDEX pgrn_tag_readings_index ON tag_readings SET enable_seqscan = off; SET enable_indexscan = off; SET enable_bitmapscan = on; -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 ------------+------- - PostgreSQL | 1 Groonga | 1 + PostgreSQL | 1 (2 rows) DROP TABLE tag_readings; Modified: expected/compatibility/schema/term-search/text/combined/indexscan.out (+1 -1) =================================================================== --- expected/compatibility/schema/term-search/text/combined/indexscan.out 2017-08-12 11:31:32 +0900 (4661b2f) +++ expected/compatibility/schema/term-search/text/combined/indexscan.out 2017-08-12 11:49:06 +0900 (853143d) @@ -32,8 +32,8 @@ SELECT tag_name, pgroonga.score(tag_readings) WHERE katakana &^~ 'posu'; name | score ------------+------- - PostgreSQL | 1 Groonga | 1 + PostgreSQL | 1 (2 rows) DROP TABLE tag_readings; Modified: expected/term-search/text/combined/bitmapscan.out (+11 -8) =================================================================== --- expected/term-search/text/combined/bitmapscan.out 2017-08-12 11:31:32 +0900 (e4e050e) +++ expected/term-search/text/combined/bitmapscan.out 2017-08-12 11:49:06 +0900 (38e9969) @@ -23,17 +23,20 @@ CREATE INDEX pgrn_tag_readings_index ON tag_readings SET enable_seqscan = off; SET enable_indexscan = off; SET enable_bitmapscan = on; -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'; - name | pgroonga_score -------------+---------------- - PostgreSQL | 1 - Groonga | 1 + WHERE katakana &^~ 'posu' +) AS candidates +ORDER BY name; + name | score +------------+------- + Groonga | 1 + PostgreSQL | 1 (2 rows) DROP TABLE tag_readings; Modified: expected/term-search/text/combined/indexscan.out (+11 -8) =================================================================== --- expected/term-search/text/combined/indexscan.out 2017-08-12 11:31:32 +0900 (0939c8f) +++ expected/term-search/text/combined/indexscan.out 2017-08-12 11:49:06 +0900 (e9af174) @@ -23,17 +23,20 @@ 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'; - name | pgroonga_score -------------+---------------- - PostgreSQL | 1 - Groonga | 1 + WHERE katakana &^~ 'posu' +) AS candidates +ORDER BY name; + name | score +------------+------- + Groonga | 1 + PostgreSQL | 1 (2 rows) DROP TABLE tag_readings; Modified: expected/term-search/text/combined/seqscan.out (+11 -8) =================================================================== --- expected/term-search/text/combined/seqscan.out 2017-08-12 11:31:32 +0900 (9954063) +++ expected/term-search/text/combined/seqscan.out 2017-08-12 11:49:06 +0900 (29a54ed) @@ -19,17 +19,20 @@ INSERT INTO tag_readings VALUES ('pglogical', 'ピージーロジカル'); SET enable_seqscan = on; SET enable_indexscan = off; 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'; - name | pgroonga_score -------------+---------------- - Groonga | 0 - PostgreSQL | 0 + WHERE katakana &^~ 'posu' +) AS candidates +ORDER BY name; + name | score +------------+------- + Groonga | 0 + PostgreSQL | 0 (2 rows) DROP TABLE tag_readings; Modified: sql/compatibility/schema/term-search/text/combined/bitmapscan.sql (+7 -4) =================================================================== --- sql/compatibility/schema/term-search/text/combined/bitmapscan.sql 2017-08-12 11:31:32 +0900 (9293214) +++ sql/compatibility/schema/term-search/text/combined/bitmapscan.sql 2017-08-12 11:49:06 +0900 (9d6c374) @@ -29,13 +29,16 @@ SET enable_seqscan = off; SET enable_indexscan = off; SET enable_bitmapscan = on; -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; DROP TABLE tag_readings; DROP TABLE tags; Modified: sql/compatibility/schema/term-search/text/combined/indexscan.sql (+7 -4) =================================================================== --- sql/compatibility/schema/term-search/text/combined/indexscan.sql 2017-08-12 11:31:32 +0900 (e11d092) +++ sql/compatibility/schema/term-search/text/combined/indexscan.sql 2017-08-12 11:49:06 +0900 (9aa93a7) @@ -29,13 +29,16 @@ 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; DROP TABLE tag_readings; DROP TABLE tags; Modified: sql/term-search/text/combined/bitmapscan.sql (+7 -4) =================================================================== --- sql/term-search/text/combined/bitmapscan.sql 2017-08-12 11:31:32 +0900 (0dcb5d7) +++ sql/term-search/text/combined/bitmapscan.sql 2017-08-12 11:49:06 +0900 (17dfafb) @@ -29,13 +29,16 @@ SET enable_seqscan = off; SET enable_indexscan = off; SET enable_bitmapscan = on; -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; DROP TABLE tag_readings; DROP TABLE tags; Modified: sql/term-search/text/combined/indexscan.sql (+7 -4) =================================================================== --- sql/term-search/text/combined/indexscan.sql 2017-08-12 11:31:32 +0900 (5326342) +++ sql/term-search/text/combined/indexscan.sql 2017-08-12 11:49:06 +0900 (888b153) @@ -29,13 +29,16 @@ 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; DROP TABLE tag_readings; DROP TABLE tags; Modified: sql/term-search/text/combined/seqscan.sql (+7 -4) =================================================================== --- sql/term-search/text/combined/seqscan.sql 2017-08-12 11:31:32 +0900 (a111235) +++ sql/term-search/text/combined/seqscan.sql 2017-08-12 11:49:06 +0900 (cb9b8e5) @@ -24,13 +24,16 @@ SET enable_seqscan = on; SET enable_indexscan = off; 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; DROP TABLE tag_readings; DROP TABLE tags; -------------- next part -------------- HTML����������������������������...Download
