Kouhei Sutou
null+****@clear*****
Wed Oct 28 21:07:44 JST 2015
Kouhei Sutou 2015-10-28 21:07:44 +0900 (Wed, 28 Oct 2015) New Revision: 71229947e1d0736a8285a72afebc9239d87f4869 https://github.com/pgroonga/pgroonga/commit/71229947e1d0736a8285a72afebc9239d87f4869 Message: Use "match" for "%%" and "query" for "@@" Copied files: expected/full-text-search/text/single/query/bitmapscan.out (from expected/full-text-search/text/single/match/bitmapscan.out) expected/full-text-search/text/single/query/indexscan.out (from expected/full-text-search/text/single/match/indexscan.out) expected/full-text-search/text/single/query/seqscan.out (from expected/full-text-search/text/single/match/seqscan.out) sql/full-text-search/text/single/query/bitmapscan.sql (from sql/full-text-search/text/single/match/bitmapscan.sql) sql/full-text-search/text/single/query/indexscan.sql (from sql/full-text-search/text/single/match/indexscan.sql) sql/full-text-search/text/single/query/seqscan.sql (from sql/full-text-search/text/single/match/seqscan.sql) Removed files: expected/full-text-search/text/single/contain/bitmapscan.out expected/full-text-search/text/single/contain/indexscan.out expected/full-text-search/text/single/contain/seqscan.out sql/full-text-search/text/single/contain/bitmapscan.sql sql/full-text-search/text/single/contain/indexscan.sql sql/full-text-search/text/single/contain/seqscan.sql Modified files: expected/full-text-search/text/single/match/bitmapscan.out expected/full-text-search/text/single/match/indexscan.out expected/full-text-search/text/single/match/seqscan.out sql/full-text-search/text/single/match/bitmapscan.sql sql/full-text-search/text/single/match/indexscan.sql sql/full-text-search/text/single/match/seqscan.sql Renamed files: expected/full-text-search/text/multiple/match/bitmapscan.out (from expected/full-text-search/text/multiple/contain/bitmapscan.out) expected/full-text-search/text/multiple/match/indexscan.out (from expected/full-text-search/text/multiple/contain/indexscan.out) expected/full-text-search/text/multiple/match/seqscan.out (from expected/full-text-search/text/multiple/contain/seqscan.out) sql/full-text-search/text/multiple/match/bitmapscan.sql (from sql/full-text-search/text/multiple/contain/bitmapscan.sql) sql/full-text-search/text/multiple/match/indexscan.sql (from sql/full-text-search/text/multiple/contain/indexscan.sql) sql/full-text-search/text/multiple/match/seqscan.sql (from sql/full-text-search/text/multiple/contain/seqscan.sql) Renamed: expected/full-text-search/text/multiple/match/bitmapscan.out (+0 -0) 100% =================================================================== Renamed: expected/full-text-search/text/multiple/match/indexscan.out (+0 -0) 100% =================================================================== Renamed: expected/full-text-search/text/multiple/match/seqscan.out (+0 -0) 100% =================================================================== Deleted: expected/full-text-search/text/single/contain/bitmapscan.out (+0 -21) 100644 =================================================================== --- expected/full-text-search/text/single/contain/bitmapscan.out 2015-10-28 21:06:06 +0900 (8ac6955) +++ /dev/null @@ -1,21 +0,0 @@ -CREATE TABLE memos ( - id integer, - content text -); -INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); -INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); -INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); -CREATE INDEX grnindex ON memos USING pgroonga (content); -SET enable_seqscan = off; -SET enable_indexscan = off; -SET enable_bitmapscan = on; -SELECT id, content - FROM memos - WHERE content %% 'Groonga'; - id | content -----+------------------------------------------------------- - 2 | Groonga is fast full text search engine. - 3 | PGroonga is a PostgreSQL extension that uses Groonga. -(2 rows) - -DROP TABLE memos; Deleted: expected/full-text-search/text/single/contain/indexscan.out (+0 -21) 100644 =================================================================== --- expected/full-text-search/text/single/contain/indexscan.out 2015-10-28 21:06:06 +0900 (0c5b028) +++ /dev/null @@ -1,21 +0,0 @@ -CREATE TABLE memos ( - id integer, - content text -); -INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); -INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); -INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); -CREATE INDEX grnindex ON memos USING pgroonga (content); -SET enable_seqscan = off; -SET enable_indexscan = on; -SET enable_bitmapscan = off; -SELECT id, content - FROM memos - WHERE content %% 'Groonga'; - id | content -----+------------------------------------------------------- - 2 | Groonga is fast full text search engine. - 3 | PGroonga is a PostgreSQL extension that uses Groonga. -(2 rows) - -DROP TABLE memos; Deleted: expected/full-text-search/text/single/contain/seqscan.out (+0 -21) 100644 =================================================================== --- expected/full-text-search/text/single/contain/seqscan.out 2015-10-28 21:06:06 +0900 (bcdef3b) +++ /dev/null @@ -1,21 +0,0 @@ -CREATE TABLE memos ( - id integer, - content text -); -INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); -INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); -INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); -CREATE INDEX grnindex ON memos USING pgroonga (content); -SET enable_seqscan = on; -SET enable_indexscan = off; -SET enable_bitmapscan = off; -SELECT id, content - FROM memos - WHERE content %% 'Groonga'; - id | content -----+------------------------------------------------------- - 2 | Groonga is fast full text search engine. - 3 | PGroonga is a PostgreSQL extension that uses Groonga. -(2 rows) - -DROP TABLE memos; Modified: expected/full-text-search/text/single/match/bitmapscan.out (+3 -2) =================================================================== --- expected/full-text-search/text/single/match/bitmapscan.out 2015-10-28 21:06:06 +0900 (3236b26) +++ expected/full-text-search/text/single/match/bitmapscan.out 2015-10-28 21:07:44 +0900 (8ac6955) @@ -11,10 +11,11 @@ SET enable_indexscan = off; SET enable_bitmapscan = on; SELECT id, content FROM memos - WHERE content @@ 'groonga postgresql'; + WHERE content %% 'Groonga'; id | content ----+------------------------------------------------------- + 2 | Groonga is fast full text search engine. 3 | PGroonga is a PostgreSQL extension that uses Groonga. -(1 row) +(2 rows) DROP TABLE memos; Modified: expected/full-text-search/text/single/match/indexscan.out (+3 -2) =================================================================== --- expected/full-text-search/text/single/match/indexscan.out 2015-10-28 21:06:06 +0900 (86c7342) +++ expected/full-text-search/text/single/match/indexscan.out 2015-10-28 21:07:44 +0900 (0c5b028) @@ -11,10 +11,11 @@ SET enable_indexscan = on; SET enable_bitmapscan = off; SELECT id, content FROM memos - WHERE content @@ 'groonga postgresql'; + WHERE content %% 'Groonga'; id | content ----+------------------------------------------------------- + 2 | Groonga is fast full text search engine. 3 | PGroonga is a PostgreSQL extension that uses Groonga. -(1 row) +(2 rows) DROP TABLE memos; Modified: expected/full-text-search/text/single/match/seqscan.out (+3 -3) =================================================================== --- expected/full-text-search/text/single/match/seqscan.out 2015-10-28 21:06:06 +0900 (c8f22b2) +++ expected/full-text-search/text/single/match/seqscan.out 2015-10-28 21:07:44 +0900 (bcdef3b) @@ -1,4 +1,3 @@ -SET search_path = "$user",public,pgroonga,pg_catalog; CREATE TABLE memos ( id integer, content text @@ -12,10 +11,11 @@ SET enable_indexscan = off; SET enable_bitmapscan = off; SELECT id, content FROM memos - WHERE content @@ 'groonga postgresql'; + WHERE content %% 'Groonga'; id | content ----+------------------------------------------------------- + 2 | Groonga is fast full text search engine. 3 | PGroonga is a PostgreSQL extension that uses Groonga. -(1 row) +(2 rows) DROP TABLE memos; Copied: expected/full-text-search/text/single/query/bitmapscan.out (+0 -0) 100% =================================================================== Copied: expected/full-text-search/text/single/query/indexscan.out (+0 -0) 100% =================================================================== Copied: expected/full-text-search/text/single/query/seqscan.out (+0 -0) 100% =================================================================== Renamed: sql/full-text-search/text/multiple/match/bitmapscan.sql (+0 -0) 100% =================================================================== Renamed: sql/full-text-search/text/multiple/match/indexscan.sql (+0 -0) 100% =================================================================== Renamed: sql/full-text-search/text/multiple/match/seqscan.sql (+0 -0) 100% =================================================================== Deleted: sql/full-text-search/text/single/contain/bitmapscan.sql (+0 -20) 100644 =================================================================== --- sql/full-text-search/text/single/contain/bitmapscan.sql 2015-10-28 21:06:06 +0900 (d459ec6) +++ /dev/null @@ -1,20 +0,0 @@ -CREATE TABLE memos ( - id integer, - content text -); - -INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); -INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); -INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); - -CREATE INDEX grnindex ON memos USING pgroonga (content); - -SET enable_seqscan = off; -SET enable_indexscan = off; -SET enable_bitmapscan = on; - -SELECT id, content - FROM memos - WHERE content %% 'Groonga'; - -DROP TABLE memos; Deleted: sql/full-text-search/text/single/contain/indexscan.sql (+0 -20) 100644 =================================================================== --- sql/full-text-search/text/single/contain/indexscan.sql 2015-10-28 21:06:06 +0900 (408d1db) +++ /dev/null @@ -1,20 +0,0 @@ -CREATE TABLE memos ( - id integer, - content text -); - -INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); -INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); -INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); - -CREATE INDEX grnindex ON memos USING pgroonga (content); - -SET enable_seqscan = off; -SET enable_indexscan = on; -SET enable_bitmapscan = off; - -SELECT id, content - FROM memos - WHERE content %% 'Groonga'; - -DROP TABLE memos; Deleted: sql/full-text-search/text/single/contain/seqscan.sql (+0 -20) 100644 =================================================================== --- sql/full-text-search/text/single/contain/seqscan.sql 2015-10-28 21:06:06 +0900 (71f638e) +++ /dev/null @@ -1,20 +0,0 @@ -CREATE TABLE memos ( - id integer, - content text -); - -INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); -INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); -INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); - -CREATE INDEX grnindex ON memos USING pgroonga (content); - -SET enable_seqscan = on; -SET enable_indexscan = off; -SET enable_bitmapscan = off; - -SELECT id, content - FROM memos - WHERE content %% 'Groonga'; - -DROP TABLE memos; Modified: sql/full-text-search/text/single/match/bitmapscan.sql (+1 -1) =================================================================== --- sql/full-text-search/text/single/match/bitmapscan.sql 2015-10-28 21:06:06 +0900 (87308d0) +++ sql/full-text-search/text/single/match/bitmapscan.sql 2015-10-28 21:07:44 +0900 (d459ec6) @@ -15,6 +15,6 @@ SET enable_bitmapscan = on; SELECT id, content FROM memos - WHERE content @@ 'groonga postgresql'; + WHERE content %% 'Groonga'; DROP TABLE memos; Modified: sql/full-text-search/text/single/match/indexscan.sql (+1 -1) =================================================================== --- sql/full-text-search/text/single/match/indexscan.sql 2015-10-28 21:06:06 +0900 (a04fdde) +++ sql/full-text-search/text/single/match/indexscan.sql 2015-10-28 21:07:44 +0900 (408d1db) @@ -15,6 +15,6 @@ SET enable_bitmapscan = off; SELECT id, content FROM memos - WHERE content @@ 'groonga postgresql'; + WHERE content %% 'Groonga'; DROP TABLE memos; Modified: sql/full-text-search/text/single/match/seqscan.sql (+1 -3) =================================================================== --- sql/full-text-search/text/single/match/seqscan.sql 2015-10-28 21:06:06 +0900 (3346413) +++ sql/full-text-search/text/single/match/seqscan.sql 2015-10-28 21:07:44 +0900 (71f638e) @@ -1,5 +1,3 @@ -SET search_path = "$user",public,pgroonga,pg_catalog; - CREATE TABLE memos ( id integer, content text @@ -17,6 +15,6 @@ SET enable_bitmapscan = off; SELECT id, content FROM memos - WHERE content @@ 'groonga postgresql'; + WHERE content %% 'Groonga'; DROP TABLE memos; Copied: sql/full-text-search/text/single/query/bitmapscan.sql (+0 -0) 100% =================================================================== Copied: sql/full-text-search/text/single/query/indexscan.sql (+0 -0) 100% =================================================================== Copied: sql/full-text-search/text/single/query/seqscan.sql (+0 -0) 100% =================================================================== -------------- next part -------------- HTML����������������������������...Télécharger
