Kouhei Sutou
null+****@clear*****
Tue May 2 09:21:39 JST 2017
Kouhei Sutou 2017-05-02 09:21:39 +0900 (Tue, 02 May 2017) New Revision: 91cb566838bd3a081027774cc309380ca5b26a81 https://github.com/pgroonga/pgroonga/commit/91cb566838bd3a081027774cc309380ca5b26a81 Message: test: remove copied files Removed files: expected/array/text/single/match/bitmapscan.out expected/array/text/single/match/indexscan.out expected/array/text/single/match/seqscan.out expected/array/text/single/query/bitmapscan.out expected/array/text/single/query/indexscan.out expected/array/text/single/query/seqscan.out expected/array/varchar/single/match/bitmapscan.out expected/array/varchar/single/match/indexscan.out expected/array/varchar/single/match/seqscan.out sql/array/text/single/match/bitmapscan.sql sql/array/text/single/match/indexscan.sql sql/array/text/single/match/seqscan.sql sql/array/text/single/query/bitmapscan.sql sql/array/text/single/query/indexscan.sql sql/array/text/single/query/seqscan.sql sql/array/varchar/single/match/bitmapscan.sql sql/array/varchar/single/match/indexscan.sql sql/array/varchar/single/match/seqscan.sql Deleted: expected/array/text/single/match/bitmapscan.out (+0 -29) 100644 =================================================================== --- expected/array/text/single/match/bitmapscan.out 2017-05-02 09:17:05 +0900 (f5fd603) +++ /dev/null @@ -1,29 +0,0 @@ -CREATE TABLE memos ( - title text, - contents text[] -); -INSERT INTO memos - VALUES ('PostgreSQL', - ARRAY['PostgreSQL is an OSS RDBMS', - 'PostgreSQL has partial full-text search support']); -INSERT INTO memos - VALUES ('Groonga', ARRAY['Groonga is an OSS full-text search engine', - 'Groonga has full full-text search support']); -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); -SET enable_seqscan = off; -SET enable_indexscan = off; -SET enable_bitmapscan = on; -SELECT title, contents - FROM memos - WHERE contents %% 'Groonga'; - title | contents -----------+-------------------------------------------------------------------------------------------------------------------------- - Groonga | {"Groonga is an OSS full-text search engine","Groonga has full full-text search support"} - PGroonga | {"PGroonga is an OSS PostgreSQL extension","PGroonga adds full full-text search support based on Groonga to PostgreSQL"} -(2 rows) - -DROP TABLE memos; Deleted: expected/array/text/single/match/indexscan.out (+0 -29) 100644 =================================================================== --- expected/array/text/single/match/indexscan.out 2017-05-02 09:17:05 +0900 (e23faa2) +++ /dev/null @@ -1,29 +0,0 @@ -CREATE TABLE memos ( - title text, - contents text[] -); -INSERT INTO memos - VALUES ('PostgreSQL', - ARRAY['PostgreSQL is an OSS RDBMS', - 'PostgreSQL has partial full-text search support']); -INSERT INTO memos - VALUES ('Groonga', ARRAY['Groonga is an OSS full-text search engine', - 'Groonga has full full-text search support']); -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); -SET enable_seqscan = off; -SET enable_indexscan = on; -SET enable_bitmapscan = off; -SELECT title, contents - FROM memos - WHERE contents %% 'Groonga'; - title | contents -----------+-------------------------------------------------------------------------------------------------------------------------- - Groonga | {"Groonga is an OSS full-text search engine","Groonga has full full-text search support"} - PGroonga | {"PGroonga is an OSS PostgreSQL extension","PGroonga adds full full-text search support based on Groonga to PostgreSQL"} -(2 rows) - -DROP TABLE memos; Deleted: expected/array/text/single/match/seqscan.out (+0 -29) 100644 =================================================================== --- expected/array/text/single/match/seqscan.out 2017-05-02 09:17:05 +0900 (1c0d0a0) +++ /dev/null @@ -1,29 +0,0 @@ -CREATE TABLE memos ( - title text, - contents text[] -); -INSERT INTO memos - VALUES ('PostgreSQL', - ARRAY['PostgreSQL is an OSS RDBMS', - 'PostgreSQL has partial full-text search support']); -INSERT INTO memos - VALUES ('Groonga', ARRAY['Groonga is an OSS full-text search engine', - 'Groonga has full full-text search support']); -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); -SET enable_seqscan = on; -SET enable_indexscan = off; -SET enable_bitmapscan = off; -SELECT title, contents - FROM memos - WHERE contents %% 'Groonga'; - title | contents -----------+-------------------------------------------------------------------------------------------------------------------------- - Groonga | {"Groonga is an OSS full-text search engine","Groonga has full full-text search support"} - PGroonga | {"PGroonga is an OSS PostgreSQL extension","PGroonga adds full full-text search support based on Groonga to PostgreSQL"} -(2 rows) - -DROP TABLE memos; Deleted: expected/array/text/single/query/bitmapscan.out (+0 -29) 100644 =================================================================== --- expected/array/text/single/query/bitmapscan.out 2017-05-02 09:17:05 +0900 (f7353bf) +++ /dev/null @@ -1,29 +0,0 @@ -CREATE TABLE memos ( - title text, - contents text[] -); -INSERT INTO memos - VALUES ('PostgreSQL', - ARRAY['PostgreSQL is an OSS RDBMS', - 'PostgreSQL has partial full-text search support']); -INSERT INTO memos - VALUES ('Groonga', ARRAY['Groonga is an OSS full-text search engine', - 'Groonga has full full-text search support']); -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); -SET enable_seqscan = off; -SET enable_indexscan = off; -SET enable_bitmapscan = on; -SELECT title, contents - FROM memos - WHERE contents @@ 'rdbms OR engine'; - title | contents -------------+------------------------------------------------------------------------------------------- - PostgreSQL | {"PostgreSQL is an OSS RDBMS","PostgreSQL has partial full-text search support"} - Groonga | {"Groonga is an OSS full-text search engine","Groonga has full full-text search support"} -(2 rows) - -DROP TABLE memos; Deleted: expected/array/text/single/query/indexscan.out (+0 -29) 100644 =================================================================== --- expected/array/text/single/query/indexscan.out 2017-05-02 09:17:05 +0900 (ab54ab7) +++ /dev/null @@ -1,29 +0,0 @@ -CREATE TABLE memos ( - title text, - contents text[] -); -INSERT INTO memos - VALUES ('PostgreSQL', - ARRAY['PostgreSQL is an OSS RDBMS', - 'PostgreSQL has partial full-text search support']); -INSERT INTO memos - VALUES ('Groonga', ARRAY['Groonga is an OSS full-text search engine', - 'Groonga has full full-text search support']); -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); -SET enable_seqscan = off; -SET enable_indexscan = on; -SET enable_bitmapscan = off; -SELECT title, contents - FROM memos - WHERE contents @@ 'rdbms OR engine'; - title | contents -------------+------------------------------------------------------------------------------------------- - PostgreSQL | {"PostgreSQL is an OSS RDBMS","PostgreSQL has partial full-text search support"} - Groonga | {"Groonga is an OSS full-text search engine","Groonga has full full-text search support"} -(2 rows) - -DROP TABLE memos; Deleted: expected/array/text/single/query/seqscan.out (+0 -29) 100644 =================================================================== --- expected/array/text/single/query/seqscan.out 2017-05-02 09:17:05 +0900 (dcab8f5) +++ /dev/null @@ -1,29 +0,0 @@ -CREATE TABLE memos ( - title text, - contents text[] -); -INSERT INTO memos - VALUES ('PostgreSQL', - ARRAY['PostgreSQL is an OSS RDBMS', - 'PostgreSQL has partial full-text search support']); -INSERT INTO memos - VALUES ('Groonga', ARRAY['Groonga is an OSS full-text search engine', - 'Groonga has full full-text search support']); -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); -SET enable_seqscan = on; -SET enable_indexscan = off; -SET enable_bitmapscan = off; -SELECT title, contents - FROM memos - WHERE contents @@ 'rdbms OR engine'; - title | contents -------------+------------------------------------------------------------------------------------------- - PostgreSQL | {"PostgreSQL is an OSS RDBMS","PostgreSQL has partial full-text search support"} - Groonga | {"Groonga is an OSS full-text search engine","Groonga has full full-text search support"} -(2 rows) - -DROP TABLE memos; Deleted: expected/array/varchar/single/match/bitmapscan.out (+0 -21) 100644 =================================================================== --- expected/array/varchar/single/match/bitmapscan.out 2017-05-02 09:17:05 +0900 (52c5847) +++ /dev/null @@ -1,21 +0,0 @@ -CREATE TABLE memos ( - title text, - tags varchar(1023)[] -); -INSERT INTO memos VALUES ('PostgreSQL', ARRAY['PostgreSQL']); -INSERT INTO memos VALUES ('Groonga', ARRAY['Groonga']); -INSERT INTO memos VALUES ('PGroonga', ARRAY['PostgreSQL', 'Groonga']); -CREATE INDEX pgroonga_memos_index ON memos USING pgroonga (tags); -SET enable_seqscan = off; -SET enable_indexscan = off; -SET enable_bitmapscan = on; -SELECT title, tags - FROM memos - WHERE tags %% 'Groonga'; - title | tags -----------+---------------------- - Groonga | {Groonga} - PGroonga | {PostgreSQL,Groonga} -(2 rows) - -DROP TABLE memos; Deleted: expected/array/varchar/single/match/indexscan.out (+0 -21) 100644 =================================================================== --- expected/array/varchar/single/match/indexscan.out 2017-05-02 09:17:05 +0900 (b17f753) +++ /dev/null @@ -1,21 +0,0 @@ -CREATE TABLE memos ( - title text, - tags varchar(1023)[] -); -INSERT INTO memos VALUES ('PostgreSQL', ARRAY['PostgreSQL']); -INSERT INTO memos VALUES ('Groonga', ARRAY['Groonga']); -INSERT INTO memos VALUES ('PGroonga', ARRAY['PostgreSQL', 'Groonga']); -CREATE INDEX pgroonga_memos_index ON memos USING pgroonga (tags); -SET enable_seqscan = off; -SET enable_indexscan = on; -SET enable_bitmapscan = off; -SELECT title, tags - FROM memos - WHERE tags %% 'Groonga'; - title | tags -----------+---------------------- - Groonga | {Groonga} - PGroonga | {PostgreSQL,Groonga} -(2 rows) - -DROP TABLE memos; Deleted: expected/array/varchar/single/match/seqscan.out (+0 -21) 100644 =================================================================== --- expected/array/varchar/single/match/seqscan.out 2017-05-02 09:17:05 +0900 (517a48f) +++ /dev/null @@ -1,21 +0,0 @@ -CREATE TABLE memos ( - title text, - tags varchar(1023)[] -); -INSERT INTO memos VALUES ('PostgreSQL', ARRAY['PostgreSQL']); -INSERT INTO memos VALUES ('Groonga', ARRAY['Groonga']); -INSERT INTO memos VALUES ('PGroonga', ARRAY['PostgreSQL', 'Groonga']); -CREATE INDEX pgroonga_memos_index ON memos USING pgroonga (tags); -SET enable_seqscan = on; -SET enable_indexscan = off; -SET enable_bitmapscan = off; -SELECT title, tags - FROM memos - WHERE tags %% 'Groonga'; - title | tags -----------+---------------------- - Groonga | {Groonga} - PGroonga | {PostgreSQL,Groonga} -(2 rows) - -DROP TABLE memos; Deleted: sql/array/text/single/match/bitmapscan.sql (+0 -28) 100644 =================================================================== --- sql/array/text/single/match/bitmapscan.sql 2017-05-02 09:17:05 +0900 (5a906ab) +++ /dev/null @@ -1,28 +0,0 @@ -CREATE TABLE memos ( - title text, - contents text[] -); - -INSERT INTO memos - VALUES ('PostgreSQL', - ARRAY['PostgreSQL is an OSS RDBMS', - 'PostgreSQL has partial full-text search support']); -INSERT INTO memos - VALUES ('Groonga', ARRAY['Groonga is an OSS full-text search engine', - 'Groonga has full full-text search support']); -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); - -SET enable_seqscan = off; -SET enable_indexscan = off; -SET enable_bitmapscan = on; - -SELECT title, contents - FROM memos - WHERE contents %% 'Groonga'; - -DROP TABLE memos; Deleted: sql/array/text/single/match/indexscan.sql (+0 -28) 100644 =================================================================== --- sql/array/text/single/match/indexscan.sql 2017-05-02 09:17:05 +0900 (942818c) +++ /dev/null @@ -1,28 +0,0 @@ -CREATE TABLE memos ( - title text, - contents text[] -); - -INSERT INTO memos - VALUES ('PostgreSQL', - ARRAY['PostgreSQL is an OSS RDBMS', - 'PostgreSQL has partial full-text search support']); -INSERT INTO memos - VALUES ('Groonga', ARRAY['Groonga is an OSS full-text search engine', - 'Groonga has full full-text search support']); -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); - -SET enable_seqscan = off; -SET enable_indexscan = on; -SET enable_bitmapscan = off; - -SELECT title, contents - FROM memos - WHERE contents %% 'Groonga'; - -DROP TABLE memos; Deleted: sql/array/text/single/match/seqscan.sql (+0 -28) 100644 =================================================================== --- sql/array/text/single/match/seqscan.sql 2017-05-02 09:17:05 +0900 (5c6e656) +++ /dev/null @@ -1,28 +0,0 @@ -CREATE TABLE memos ( - title text, - contents text[] -); - -INSERT INTO memos - VALUES ('PostgreSQL', - ARRAY['PostgreSQL is an OSS RDBMS', - 'PostgreSQL has partial full-text search support']); -INSERT INTO memos - VALUES ('Groonga', ARRAY['Groonga is an OSS full-text search engine', - 'Groonga has full full-text search support']); -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); - -SET enable_seqscan = on; -SET enable_indexscan = off; -SET enable_bitmapscan = off; - -SELECT title, contents - FROM memos - WHERE contents %% 'Groonga'; - -DROP TABLE memos; Deleted: sql/array/text/single/query/bitmapscan.sql (+0 -28) 100644 =================================================================== --- sql/array/text/single/query/bitmapscan.sql 2017-05-02 09:17:05 +0900 (864d135) +++ /dev/null @@ -1,28 +0,0 @@ -CREATE TABLE memos ( - title text, - contents text[] -); - -INSERT INTO memos - VALUES ('PostgreSQL', - ARRAY['PostgreSQL is an OSS RDBMS', - 'PostgreSQL has partial full-text search support']); -INSERT INTO memos - VALUES ('Groonga', ARRAY['Groonga is an OSS full-text search engine', - 'Groonga has full full-text search support']); -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); - -SET enable_seqscan = off; -SET enable_indexscan = off; -SET enable_bitmapscan = on; - -SELECT title, contents - FROM memos - WHERE contents @@ 'rdbms OR engine'; - -DROP TABLE memos; Deleted: sql/array/text/single/query/indexscan.sql (+0 -28) 100644 =================================================================== --- sql/array/text/single/query/indexscan.sql 2017-05-02 09:17:05 +0900 (2fcbd11) +++ /dev/null @@ -1,28 +0,0 @@ -CREATE TABLE memos ( - title text, - contents text[] -); - -INSERT INTO memos - VALUES ('PostgreSQL', - ARRAY['PostgreSQL is an OSS RDBMS', - 'PostgreSQL has partial full-text search support']); -INSERT INTO memos - VALUES ('Groonga', ARRAY['Groonga is an OSS full-text search engine', - 'Groonga has full full-text search support']); -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); - -SET enable_seqscan = off; -SET enable_indexscan = on; -SET enable_bitmapscan = off; - -SELECT title, contents - FROM memos - WHERE contents @@ 'rdbms OR engine'; - -DROP TABLE memos; Deleted: sql/array/text/single/query/seqscan.sql (+0 -28) 100644 =================================================================== --- sql/array/text/single/query/seqscan.sql 2017-05-02 09:17:05 +0900 (bbc0ab6) +++ /dev/null @@ -1,28 +0,0 @@ -CREATE TABLE memos ( - title text, - contents text[] -); - -INSERT INTO memos - VALUES ('PostgreSQL', - ARRAY['PostgreSQL is an OSS RDBMS', - 'PostgreSQL has partial full-text search support']); -INSERT INTO memos - VALUES ('Groonga', ARRAY['Groonga is an OSS full-text search engine', - 'Groonga has full full-text search support']); -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); - -SET enable_seqscan = on; -SET enable_indexscan = off; -SET enable_bitmapscan = off; - -SELECT title, contents - FROM memos - WHERE contents @@ 'rdbms OR engine'; - -DROP TABLE memos; Deleted: sql/array/varchar/single/match/bitmapscan.sql (+0 -20) 100644 =================================================================== --- sql/array/varchar/single/match/bitmapscan.sql 2017-05-02 09:17:05 +0900 (d4568f1) +++ /dev/null @@ -1,20 +0,0 @@ -CREATE TABLE memos ( - title text, - tags varchar(1023)[] -); - -INSERT INTO memos VALUES ('PostgreSQL', ARRAY['PostgreSQL']); -INSERT INTO memos VALUES ('Groonga', ARRAY['Groonga']); -INSERT INTO memos VALUES ('PGroonga', ARRAY['PostgreSQL', 'Groonga']); - -CREATE INDEX pgroonga_memos_index ON memos USING pgroonga (tags); - -SET enable_seqscan = off; -SET enable_indexscan = off; -SET enable_bitmapscan = on; - -SELECT title, tags - FROM memos - WHERE tags %% 'Groonga'; - -DROP TABLE memos; Deleted: sql/array/varchar/single/match/indexscan.sql (+0 -20) 100644 =================================================================== --- sql/array/varchar/single/match/indexscan.sql 2017-05-02 09:17:05 +0900 (8805b2a) +++ /dev/null @@ -1,20 +0,0 @@ -CREATE TABLE memos ( - title text, - tags varchar(1023)[] -); - -INSERT INTO memos VALUES ('PostgreSQL', ARRAY['PostgreSQL']); -INSERT INTO memos VALUES ('Groonga', ARRAY['Groonga']); -INSERT INTO memos VALUES ('PGroonga', ARRAY['PostgreSQL', 'Groonga']); - -CREATE INDEX pgroonga_memos_index ON memos USING pgroonga (tags); - -SET enable_seqscan = off; -SET enable_indexscan = on; -SET enable_bitmapscan = off; - -SELECT title, tags - FROM memos - WHERE tags %% 'Groonga'; - -DROP TABLE memos; Deleted: sql/array/varchar/single/match/seqscan.sql (+0 -20) 100644 =================================================================== --- sql/array/varchar/single/match/seqscan.sql 2017-05-02 09:17:05 +0900 (0fb15dc) +++ /dev/null @@ -1,20 +0,0 @@ -CREATE TABLE memos ( - title text, - tags varchar(1023)[] -); - -INSERT INTO memos VALUES ('PostgreSQL', ARRAY['PostgreSQL']); -INSERT INTO memos VALUES ('Groonga', ARRAY['Groonga']); -INSERT INTO memos VALUES ('PGroonga', ARRAY['PostgreSQL', 'Groonga']); - -CREATE INDEX pgroonga_memos_index ON memos USING pgroonga (tags); - -SET enable_seqscan = on; -SET enable_indexscan = off; -SET enable_bitmapscan = off; - -SELECT title, tags - FROM memos - WHERE tags %% 'Groonga'; - -DROP TABLE memos; -------------- next part -------------- HTML����������������������������...Download
