Kouhei Sutou
null+****@clear*****
Wed Jul 19 09:38:23 JST 2017
Kouhei Sutou 2017-07-19 09:38:23 +0900 (Wed, 19 Jul 2017) New Revision: fe819a54477d3d3be46cd13897df6df9b66d774e https://github.com/pgroonga/pgroonga/commit/fe819a54477d3d3be46cd13897df6df9b66d774e Message: test: make similar search tests stable Modified files: expected/full-text-search/text-array/compatibility/v2/similar-v2/bitmapscan.out expected/full-text-search/text-array/compatibility/v2/similar-v2/indexscan.out expected/full-text-search/text-array/compatibility/v2/similar-v2/seqscan.out expected/full-text-search/text-array/similar-v2/bitmapscan.out expected/full-text-search/text-array/similar-v2/indexscan.out expected/full-text-search/text-array/similar-v2/seqscan.out sql/full-text-search/text-array/compatibility/v2/similar-v2/bitmapscan.sql sql/full-text-search/text-array/compatibility/v2/similar-v2/indexscan.sql sql/full-text-search/text-array/compatibility/v2/similar-v2/seqscan.sql sql/full-text-search/text-array/similar-v2/bitmapscan.sql sql/full-text-search/text-array/similar-v2/indexscan.sql sql/full-text-search/text-array/similar-v2/seqscan.sql Modified: expected/full-text-search/text-array/compatibility/v2/similar-v2/bitmapscan.out (+6 -6) =================================================================== --- expected/full-text-search/text-array/compatibility/v2/similar-v2/bitmapscan.out 2017-07-19 08:34:42 +0900 (258fdf2) +++ expected/full-text-search/text-array/compatibility/v2/similar-v2/bitmapscan.out 2017-07-19 09:38:23 +0900 (fb4c2d8) @@ -21,18 +21,18 @@ SET enable_bitmapscan = on; EXPLAIN (COSTS OFF) SELECT title, contents FROM memos - WHERE contents &~? 'Mroonga is a MySQL plugin that uses Groonga.'; - QUERY PLAN ------------------------------------------------------------------------------------------ + WHERE contents &~? 'Mroonga: A MySQL plugin that uses Groonga'; + QUERY PLAN +-------------------------------------------------------------------------------------- Bitmap Heap Scan on memos - Recheck Cond: (contents &~? 'Mroonga is a MySQL plugin that uses Groonga.'::text) + Recheck Cond: (contents &~? 'Mroonga: A MySQL plugin that uses Groonga'::text) -> Bitmap Index Scan on pgroonga_memos_index - Index Cond: (contents &~? 'Mroonga is a MySQL plugin that uses Groonga.'::text) + Index Cond: (contents &~? 'Mroonga: A MySQL plugin that uses Groonga'::text) (4 rows) SELECT title, contents FROM memos - WHERE contents &~? 'Mroonga is a MySQL plugin that uses Groonga.'; + WHERE contents &~? 'Mroonga: A MySQL plugin that uses Groonga'; title | contents ----------+-------------------------------------------------------------------------------------------------------------------------- Groonga | {"Groonga is an OSS full-text search engine","Groonga has full full-text search support"} Modified: expected/full-text-search/text-array/compatibility/v2/similar-v2/indexscan.out (+5 -5) =================================================================== --- expected/full-text-search/text-array/compatibility/v2/similar-v2/indexscan.out 2017-07-19 08:34:42 +0900 (a53a6c9) +++ expected/full-text-search/text-array/compatibility/v2/similar-v2/indexscan.out 2017-07-19 09:38:23 +0900 (1c17544) @@ -21,16 +21,16 @@ SET enable_bitmapscan = off; EXPLAIN (COSTS OFF) SELECT title, contents FROM memos - WHERE contents &~? 'Mroonga is a MySQL plugin that uses Groonga.'; - QUERY PLAN ------------------------------------------------------------------------------------ + WHERE contents &~? 'Mroonga: A MySQL plugin that uses Groonga'; + QUERY PLAN +-------------------------------------------------------------------------------- Index Scan using pgroonga_memos_index on memos - Index Cond: (contents &~? 'Mroonga is a MySQL plugin that uses Groonga.'::text) + Index Cond: (contents &~? 'Mroonga: A MySQL plugin that uses Groonga'::text) (2 rows) SELECT title, contents FROM memos - WHERE contents &~? 'Mroonga is a MySQL plugin that uses Groonga.'; + WHERE contents &~? 'Mroonga: A MySQL plugin that uses Groonga'; title | contents ----------+-------------------------------------------------------------------------------------------------------------------------- Groonga | {"Groonga is an OSS full-text search engine","Groonga has full full-text search support"} Modified: expected/full-text-search/text-array/compatibility/v2/similar-v2/seqscan.out (+1 -3) =================================================================== --- expected/full-text-search/text-array/compatibility/v2/similar-v2/seqscan.out 2017-07-19 08:34:42 +0900 (aea9a97) +++ expected/full-text-search/text-array/compatibility/v2/similar-v2/seqscan.out 2017-07-19 09:38:23 +0900 (0f1b9a6) @@ -13,13 +13,11 @@ INSERT INTO memos VALUES ('PGroonga', ARRAY['PGroonga is an OSS PostgreSQL extension', 'PGroonga adds full full-text search support based on Groonga to PostgreSQL']); -CREATE INDEX pgroonga_memos_index ON memos - USING pgroonga (contents pgroonga.text_array_full_text_search_ops_v2); SET enable_seqscan = on; SET enable_indexscan = off; SET enable_bitmapscan = off; SELECT title, contents FROM memos - WHERE contents &~? 'Mroonga is a MySQL plugin that uses Groonga.'; + WHERE contents &~? 'Mroonga: A MySQL plugin that uses Groonga'; ERROR: pgroonga: similar search is available only in index scan DROP TABLE memos; Modified: expected/full-text-search/text-array/similar-v2/bitmapscan.out (+6 -6) =================================================================== --- expected/full-text-search/text-array/similar-v2/bitmapscan.out 2017-07-19 08:34:42 +0900 (445e1ad) +++ expected/full-text-search/text-array/similar-v2/bitmapscan.out 2017-07-19 09:38:23 +0900 (ae76c33) @@ -21,18 +21,18 @@ SET enable_bitmapscan = on; EXPLAIN (COSTS OFF) SELECT title, contents FROM memos - WHERE contents &@* 'Mroonga is a MySQL plugin that uses Groonga.'; - QUERY PLAN ------------------------------------------------------------------------------------------ + WHERE contents &@* 'Mroonga: A MySQL plugin that uses Groonga'; + QUERY PLAN +-------------------------------------------------------------------------------------- Bitmap Heap Scan on memos - Recheck Cond: (contents &@* 'Mroonga is a MySQL plugin that uses Groonga.'::text) + Recheck Cond: (contents &@* 'Mroonga: A MySQL plugin that uses Groonga'::text) -> Bitmap Index Scan on pgroonga_memos_index - Index Cond: (contents &@* 'Mroonga is a MySQL plugin that uses Groonga.'::text) + Index Cond: (contents &@* 'Mroonga: A MySQL plugin that uses Groonga'::text) (4 rows) SELECT title, contents FROM memos - WHERE contents &@* 'Mroonga is a MySQL plugin that uses Groonga.'; + WHERE contents &@* 'Mroonga: A MySQL plugin that uses Groonga'; title | contents ----------+-------------------------------------------------------------------------------------------------------------------------- Groonga | {"Groonga is an OSS full-text search engine","Groonga has full full-text search support"} Modified: expected/full-text-search/text-array/similar-v2/indexscan.out (+5 -5) =================================================================== --- expected/full-text-search/text-array/similar-v2/indexscan.out 2017-07-19 08:34:42 +0900 (22e7f60) +++ expected/full-text-search/text-array/similar-v2/indexscan.out 2017-07-19 09:38:23 +0900 (1632a15) @@ -21,16 +21,16 @@ SET enable_bitmapscan = off; EXPLAIN (COSTS OFF) SELECT title, contents FROM memos - WHERE contents &@* 'Mroonga is a MySQL plugin that uses Groonga.'; - QUERY PLAN ------------------------------------------------------------------------------------ + WHERE contents &@* 'Mroonga: A MySQL plugin that uses Groonga'; + QUERY PLAN +-------------------------------------------------------------------------------- Index Scan using pgroonga_memos_index on memos - Index Cond: (contents &@* 'Mroonga is a MySQL plugin that uses Groonga.'::text) + Index Cond: (contents &@* 'Mroonga: A MySQL plugin that uses Groonga'::text) (2 rows) SELECT title, contents FROM memos - WHERE contents &@* 'Mroonga is a MySQL plugin that uses Groonga.'; + WHERE contents &@* 'Mroonga: A MySQL plugin that uses Groonga'; title | contents ----------+-------------------------------------------------------------------------------------------------------------------------- Groonga | {"Groonga is an OSS full-text search engine","Groonga has full full-text search support"} Modified: expected/full-text-search/text-array/similar-v2/seqscan.out (+1 -3) =================================================================== --- expected/full-text-search/text-array/similar-v2/seqscan.out 2017-07-19 08:34:42 +0900 (fd01674) +++ expected/full-text-search/text-array/similar-v2/seqscan.out 2017-07-19 09:38:23 +0900 (7ee3b85) @@ -13,13 +13,11 @@ INSERT INTO memos VALUES ('PGroonga', ARRAY['PGroonga is an OSS PostgreSQL extension', 'PGroonga adds full full-text search support based on Groonga to PostgreSQL']); -CREATE INDEX pgroonga_memos_index ON memos - USING pgroonga (contents pgroonga.text_array_full_text_search_ops_v2); SET enable_seqscan = on; SET enable_indexscan = off; SET enable_bitmapscan = off; SELECT title, contents FROM memos - WHERE contents &@* 'Mroonga is a MySQL plugin that uses Groonga.'; + WHERE contents &@* 'Mroonga: A MySQL plugin that uses Groonga'; ERROR: pgroonga: similar search is available only in index scan DROP TABLE memos; Modified: sql/full-text-search/text-array/compatibility/v2/similar-v2/bitmapscan.sql (+2 -2) =================================================================== --- sql/full-text-search/text-array/compatibility/v2/similar-v2/bitmapscan.sql 2017-07-19 08:34:42 +0900 (efcdace) +++ sql/full-text-search/text-array/compatibility/v2/similar-v2/bitmapscan.sql 2017-07-19 09:38:23 +0900 (0dff562) @@ -25,10 +25,10 @@ SET enable_bitmapscan = on; EXPLAIN (COSTS OFF) SELECT title, contents FROM memos - WHERE contents &~? 'Mroonga is a MySQL plugin that uses Groonga.'; + WHERE contents &~? 'Mroonga: A MySQL plugin that uses Groonga'; SELECT title, contents FROM memos - WHERE contents &~? 'Mroonga is a MySQL plugin that uses Groonga.'; + WHERE contents &~? 'Mroonga: A MySQL plugin that uses Groonga'; DROP TABLE memos; Modified: sql/full-text-search/text-array/compatibility/v2/similar-v2/indexscan.sql (+2 -2) =================================================================== --- sql/full-text-search/text-array/compatibility/v2/similar-v2/indexscan.sql 2017-07-19 08:34:42 +0900 (0e9f22a) +++ sql/full-text-search/text-array/compatibility/v2/similar-v2/indexscan.sql 2017-07-19 09:38:23 +0900 (d28931f) @@ -25,10 +25,10 @@ SET enable_bitmapscan = off; EXPLAIN (COSTS OFF) SELECT title, contents FROM memos - WHERE contents &~? 'Mroonga is a MySQL plugin that uses Groonga.'; + WHERE contents &~? 'Mroonga: A MySQL plugin that uses Groonga'; SELECT title, contents FROM memos - WHERE contents &~? 'Mroonga is a MySQL plugin that uses Groonga.'; + WHERE contents &~? 'Mroonga: A MySQL plugin that uses Groonga'; DROP TABLE memos; Modified: sql/full-text-search/text-array/compatibility/v2/similar-v2/seqscan.sql (+1 -4) =================================================================== --- sql/full-text-search/text-array/compatibility/v2/similar-v2/seqscan.sql 2017-07-19 08:34:42 +0900 (be79ea4) +++ sql/full-text-search/text-array/compatibility/v2/similar-v2/seqscan.sql 2017-07-19 09:38:23 +0900 (3a1012e) @@ -15,15 +15,12 @@ INSERT INTO memos ARRAY['PGroonga is an OSS PostgreSQL extension', 'PGroonga adds full full-text search support based on Groonga to PostgreSQL']); -CREATE INDEX pgroonga_memos_index ON memos - USING pgroonga (contents pgroonga.text_array_full_text_search_ops_v2); - SET enable_seqscan = on; SET enable_indexscan = off; SET enable_bitmapscan = off; SELECT title, contents FROM memos - WHERE contents &~? 'Mroonga is a MySQL plugin that uses Groonga.'; + WHERE contents &~? 'Mroonga: A MySQL plugin that uses Groonga'; DROP TABLE memos; Modified: sql/full-text-search/text-array/similar-v2/bitmapscan.sql (+2 -2) =================================================================== --- sql/full-text-search/text-array/similar-v2/bitmapscan.sql 2017-07-19 08:34:42 +0900 (ae49c2e) +++ sql/full-text-search/text-array/similar-v2/bitmapscan.sql 2017-07-19 09:38:23 +0900 (9818e44) @@ -25,10 +25,10 @@ SET enable_bitmapscan = on; EXPLAIN (COSTS OFF) SELECT title, contents FROM memos - WHERE contents &@* 'Mroonga is a MySQL plugin that uses Groonga.'; + WHERE contents &@* 'Mroonga: A MySQL plugin that uses Groonga'; SELECT title, contents FROM memos - WHERE contents &@* 'Mroonga is a MySQL plugin that uses Groonga.'; + WHERE contents &@* 'Mroonga: A MySQL plugin that uses Groonga'; DROP TABLE memos; Modified: sql/full-text-search/text-array/similar-v2/indexscan.sql (+2 -2) =================================================================== --- sql/full-text-search/text-array/similar-v2/indexscan.sql 2017-07-19 08:34:42 +0900 (e6a66d7) +++ sql/full-text-search/text-array/similar-v2/indexscan.sql 2017-07-19 09:38:23 +0900 (4a60f0e) @@ -25,10 +25,10 @@ SET enable_bitmapscan = off; EXPLAIN (COSTS OFF) SELECT title, contents FROM memos - WHERE contents &@* 'Mroonga is a MySQL plugin that uses Groonga.'; + WHERE contents &@* 'Mroonga: A MySQL plugin that uses Groonga'; SELECT title, contents FROM memos - WHERE contents &@* 'Mroonga is a MySQL plugin that uses Groonga.'; + WHERE contents &@* 'Mroonga: A MySQL plugin that uses Groonga'; DROP TABLE memos; Modified: sql/full-text-search/text-array/similar-v2/seqscan.sql (+1 -4) =================================================================== --- sql/full-text-search/text-array/similar-v2/seqscan.sql 2017-07-19 08:34:42 +0900 (739a9cb) +++ sql/full-text-search/text-array/similar-v2/seqscan.sql 2017-07-19 09:38:23 +0900 (63e5bc4) @@ -15,15 +15,12 @@ INSERT INTO memos ARRAY['PGroonga is an OSS PostgreSQL extension', 'PGroonga adds full full-text search support based on Groonga to PostgreSQL']); -CREATE INDEX pgroonga_memos_index ON memos - USING pgroonga (contents pgroonga.text_array_full_text_search_ops_v2); - SET enable_seqscan = on; SET enable_indexscan = off; SET enable_bitmapscan = off; SELECT title, contents FROM memos - WHERE contents &@* 'Mroonga is a MySQL plugin that uses Groonga.'; + WHERE contents &@* 'Mroonga: A MySQL plugin that uses Groonga'; DROP TABLE memos; -------------- next part -------------- HTML����������������������������... ダウンロード