Kouhei Sutou
null+****@clear*****
Mon May 29 16:01:36 JST 2017
Kouhei Sutou 2017-05-29 16:01:36 +0900 (Mon, 29 May 2017) New Revision: a59218427400fe1b43d0d37413a8c377429012c4 https://github.com/pgroonga/pgroonga/commit/a59218427400fe1b43d0d37413a8c377429012c4 Message: varchar_array_ops_v2 -> varchar_array_term_search_ops_v2 Modified files: data/pgroonga--1.2.0--1.2.1.sql data/pgroonga.sql Renamed files: expected/term-search/varchar-array/compatibility/v1/match-v2/bitmapscan.out (from expected/match/varchar-array/compatibility/v1/match-v2/bitmapscan.out) expected/term-search/varchar-array/compatibility/v1/match-v2/indexscan.out (from expected/match/varchar-array/compatibility/v1/match-v2/indexscan.out) expected/term-search/varchar-array/compatibility/v1/match-v2/seqscan.out (from expected/match/varchar-array/compatibility/v1/match-v2/seqscan.out) expected/term-search/varchar-array/compatibility/v2/match-v1/bitmapscan.out (from expected/match/varchar-array/compatibility/v2/match-v1/bitmapscan.out) expected/term-search/varchar-array/compatibility/v2/match-v1/indexscan.out (from expected/match/varchar-array/compatibility/v2/match-v1/indexscan.out) expected/term-search/varchar-array/compatibility/v2/match-v1/seqscan.out (from expected/match/varchar-array/compatibility/v2/match-v1/seqscan.out) expected/term-search/varchar-array/match-v2/bitmapscan.out (from expected/match/varchar-array/match-v2/bitmapscan.out) expected/term-search/varchar-array/match-v2/indexscan.out (from expected/match/varchar-array/match-v2/indexscan.out) expected/term-search/varchar-array/match-v2/seqscan.out (from expected/match/varchar-array/match-v2/seqscan.out) expected/term-search/varchar-array/match/bitmapscan.out (from expected/match/varchar-array/match/bitmapscan.out) expected/term-search/varchar-array/match/indexscan.out (from expected/match/varchar-array/match/indexscan.out) expected/term-search/varchar-array/match/seqscan.out (from expected/match/varchar-array/match/seqscan.out) sql/term-search/varchar-array/compatibility/v1/match-v2/bitmapscan.sql (from sql/match/varchar-array/compatibility/v1/match-v2/bitmapscan.sql) sql/term-search/varchar-array/compatibility/v1/match-v2/indexscan.sql (from sql/match/varchar-array/compatibility/v1/match-v2/indexscan.sql) sql/term-search/varchar-array/compatibility/v1/match-v2/seqscan.sql (from sql/match/varchar-array/compatibility/v1/match-v2/seqscan.sql) sql/term-search/varchar-array/compatibility/v2/match-v1/bitmapscan.sql (from sql/match/varchar-array/compatibility/v2/match-v1/bitmapscan.sql) sql/term-search/varchar-array/compatibility/v2/match-v1/indexscan.sql (from sql/match/varchar-array/compatibility/v2/match-v1/indexscan.sql) sql/term-search/varchar-array/compatibility/v2/match-v1/seqscan.sql (from sql/match/varchar-array/compatibility/v2/match-v1/seqscan.sql) sql/term-search/varchar-array/match-v2/bitmapscan.sql (from sql/match/varchar-array/match-v2/bitmapscan.sql) sql/term-search/varchar-array/match-v2/indexscan.sql (from sql/match/varchar-array/match-v2/indexscan.sql) sql/term-search/varchar-array/match-v2/seqscan.sql (from sql/match/varchar-array/match-v2/seqscan.sql) sql/term-search/varchar-array/match/bitmapscan.sql (from sql/match/varchar-array/match/bitmapscan.sql) sql/term-search/varchar-array/match/indexscan.sql (from sql/match/varchar-array/match/indexscan.sql) sql/term-search/varchar-array/match/seqscan.sql (from sql/match/varchar-array/match/seqscan.sql) Modified: data/pgroonga--1.2.0--1.2.1.sql (+3 -2) =================================================================== --- data/pgroonga--1.2.0--1.2.1.sql 2017-05-17 09:51:17 +0900 (07e6118) +++ data/pgroonga--1.2.0--1.2.1.sql 2017-05-29 16:01:36 +0900 (1c12a02) @@ -342,7 +342,7 @@ CREATE OPERATOR CLASS pgroonga.varchar_regexp_ops_v2 FOR TYPE varchar OPERATOR 10 @~, OPERATOR 22 &~; --- Add pgroonga.varchar_array_ops_v2. +-- Add pgroonga.varchar_array_term_search_ops_v2. CREATE FUNCTION pgroonga.match_varchar_array(varchar[], varchar) RETURNS bool AS 'MODULE_PATHNAME', 'pgroonga_match_varchar_array' @@ -356,7 +356,8 @@ CREATE OPERATOR &@ ( RIGHTARG = varchar ); -CREATE OPERATOR CLASS pgroonga.varchar_array_ops_v2 FOR TYPE varchar[] +CREATE OPERATOR CLASS pgroonga.varchar_array_term_search_ops_v2 + FOR TYPE varchar[] USING pgroonga AS OPERATOR 8 %% (varchar[], varchar), -- For backward compatibility OPERATOR 12 &@ (varchar[], varchar); Modified: data/pgroonga.sql (+2 -1) =================================================================== --- data/pgroonga.sql 2017-05-17 09:51:17 +0900 (6ed078d) +++ data/pgroonga.sql 2017-05-29 16:01:36 +0900 (2c22d8e) @@ -1034,7 +1034,8 @@ CREATE OPERATOR CLASS pgroonga.varchar_full_text_search_ops_v2 OPERATOR 18 &@> (varchar, varchar[]), OPERATOR 19 &?> (varchar, varchar[]); -CREATE OPERATOR CLASS pgroonga.varchar_array_ops_v2 FOR TYPE varchar[] +CREATE OPERATOR CLASS pgroonga.varchar_array_term_search_ops_v2 + FOR TYPE varchar[] USING pgroonga AS OPERATOR 8 %% (varchar[], varchar), -- For backward compatibility OPERATOR 12 &@ (varchar[], varchar); Renamed: expected/term-search/varchar-array/compatibility/v1/match-v2/bitmapscan.out (+0 -0) 100% =================================================================== Renamed: expected/term-search/varchar-array/compatibility/v1/match-v2/indexscan.out (+0 -0) 100% =================================================================== Renamed: expected/term-search/varchar-array/compatibility/v1/match-v2/seqscan.out (+0 -0) 100% =================================================================== Renamed: expected/term-search/varchar-array/compatibility/v2/match-v1/bitmapscan.out (+1 -1) 93% =================================================================== --- expected/match/varchar-array/compatibility/v2/match-v1/bitmapscan.out 2017-05-17 09:51:17 +0900 (c99f414) +++ expected/term-search/varchar-array/compatibility/v2/match-v1/bitmapscan.out 2017-05-29 16:01:36 +0900 (cbb0627) @@ -6,7 +6,7 @@ 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 pgroonga.varchar_array_ops_v2); + USING pgroonga (tags pgroonga.varchar_array_term_search_ops_v2); SET enable_seqscan = off; SET enable_indexscan = off; SET enable_bitmapscan = on; Renamed: expected/term-search/varchar-array/compatibility/v2/match-v1/indexscan.out (+1 -1) 92% =================================================================== --- expected/match/varchar-array/compatibility/v2/match-v1/indexscan.out 2017-05-17 09:51:17 +0900 (3a1a61c) +++ expected/term-search/varchar-array/compatibility/v2/match-v1/indexscan.out 2017-05-29 16:01:36 +0900 (d292527) @@ -6,7 +6,7 @@ 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 pgroonga.varchar_array_ops_v2); + USING pgroonga (tags pgroonga.varchar_array_term_search_ops_v2); SET enable_seqscan = off; SET enable_indexscan = on; SET enable_bitmapscan = off; Renamed: expected/term-search/varchar-array/compatibility/v2/match-v1/seqscan.out (+2 -1) 83% =================================================================== --- expected/match/varchar-array/compatibility/v2/match-v1/seqscan.out 2017-05-17 09:51:17 +0900 (517a48f) +++ expected/term-search/varchar-array/compatibility/v2/match-v1/seqscan.out 2017-05-29 16:01:36 +0900 (7e2d1e7) @@ -5,7 +5,8 @@ CREATE TABLE memos ( 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); +CREATE INDEX pgroonga_memos_index ON memos + USING pgroonga (tags pgroonga.varchar_array_term_search_ops_v2); SET enable_seqscan = on; SET enable_indexscan = off; SET enable_bitmapscan = off; Renamed: expected/term-search/varchar-array/match-v2/bitmapscan.out (+1 -1) 93% =================================================================== --- expected/match/varchar-array/match-v2/bitmapscan.out 2017-05-17 09:51:17 +0900 (6c80d0b) +++ expected/term-search/varchar-array/match-v2/bitmapscan.out 2017-05-29 16:01:36 +0900 (79d9827) @@ -6,7 +6,7 @@ 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 pgroonga.varchar_array_ops_v2); + USING pgroonga (tags pgroonga.varchar_array_term_search_ops_v2); SET enable_seqscan = off; SET enable_indexscan = off; SET enable_bitmapscan = on; Renamed: expected/term-search/varchar-array/match-v2/indexscan.out (+1 -1) 92% =================================================================== --- expected/match/varchar-array/match-v2/indexscan.out 2017-05-17 09:51:17 +0900 (968e6e0) +++ expected/term-search/varchar-array/match-v2/indexscan.out 2017-05-29 16:01:36 +0900 (1a6c246) @@ -6,7 +6,7 @@ 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 pgroonga.varchar_array_ops_v2); + USING pgroonga (tags pgroonga.varchar_array_term_search_ops_v2); SET enable_seqscan = off; SET enable_indexscan = on; SET enable_bitmapscan = off; Renamed: expected/term-search/varchar-array/match-v2/seqscan.out (+1 -1) 89% =================================================================== --- expected/match/varchar-array/match-v2/seqscan.out 2017-05-17 09:51:17 +0900 (9eb9234) +++ expected/term-search/varchar-array/match-v2/seqscan.out 2017-05-29 16:01:36 +0900 (5eba35d) @@ -6,7 +6,7 @@ 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 pgroonga.varchar_array_ops_v2); + USING pgroonga (tags pgroonga.varchar_array_term_search_ops_v2); SET enable_seqscan = on; SET enable_indexscan = off; SET enable_bitmapscan = off; Renamed: expected/term-search/varchar-array/match/bitmapscan.out (+0 -0) 100% =================================================================== Renamed: expected/term-search/varchar-array/match/indexscan.out (+0 -0) 100% =================================================================== Renamed: expected/term-search/varchar-array/match/seqscan.out (+0 -0) 100% =================================================================== Renamed: sql/term-search/varchar-array/compatibility/v1/match-v2/bitmapscan.sql (+0 -0) 100% =================================================================== Renamed: sql/term-search/varchar-array/compatibility/v1/match-v2/indexscan.sql (+0 -0) 100% =================================================================== Renamed: sql/term-search/varchar-array/compatibility/v1/match-v2/seqscan.sql (+0 -0) 100% =================================================================== Renamed: sql/term-search/varchar-array/compatibility/v2/match-v1/bitmapscan.sql (+1 -1) 88% =================================================================== --- sql/match/varchar-array/compatibility/v2/match-v1/bitmapscan.sql 2017-05-17 09:51:17 +0900 (e7f097b) +++ sql/term-search/varchar-array/compatibility/v2/match-v1/bitmapscan.sql 2017-05-29 16:01:36 +0900 (847f9ab) @@ -8,7 +8,7 @@ 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 pgroonga.varchar_array_ops_v2); + USING pgroonga (tags pgroonga.varchar_array_term_search_ops_v2); SET enable_seqscan = off; SET enable_indexscan = off; Renamed: sql/term-search/varchar-array/compatibility/v2/match-v1/indexscan.sql (+1 -1) 88% =================================================================== --- sql/match/varchar-array/compatibility/v2/match-v1/indexscan.sql 2017-05-17 09:51:17 +0900 (462b124) +++ sql/term-search/varchar-array/compatibility/v2/match-v1/indexscan.sql 2017-05-29 16:01:36 +0900 (939cd64) @@ -8,7 +8,7 @@ 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 pgroonga.varchar_array_ops_v2); + USING pgroonga (tags pgroonga.varchar_array_term_search_ops_v2); SET enable_seqscan = off; SET enable_indexscan = on; Renamed: sql/term-search/varchar-array/compatibility/v2/match-v1/seqscan.sql (+2 -1) 78% =================================================================== --- sql/match/varchar-array/compatibility/v2/match-v1/seqscan.sql 2017-05-17 09:51:17 +0900 (0fb15dc) +++ sql/term-search/varchar-array/compatibility/v2/match-v1/seqscan.sql 2017-05-29 16:01:36 +0900 (b5e6147) @@ -7,7 +7,8 @@ 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); +CREATE INDEX pgroonga_memos_index ON memos + USING pgroonga (tags pgroonga.varchar_array_term_search_ops_v2); SET enable_seqscan = on; SET enable_indexscan = off; Renamed: sql/term-search/varchar-array/match-v2/bitmapscan.sql (+1 -1) 88% =================================================================== --- sql/match/varchar-array/match-v2/bitmapscan.sql 2017-05-17 09:51:17 +0900 (d0af501) +++ sql/term-search/varchar-array/match-v2/bitmapscan.sql 2017-05-29 16:01:36 +0900 (0ee0d4a) @@ -8,7 +8,7 @@ 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 pgroonga.varchar_array_ops_v2); + USING pgroonga (tags pgroonga.varchar_array_term_search_ops_v2); SET enable_seqscan = off; SET enable_indexscan = off; Renamed: sql/term-search/varchar-array/match-v2/indexscan.sql (+1 -1) 88% =================================================================== --- sql/match/varchar-array/match-v2/indexscan.sql 2017-05-17 09:51:17 +0900 (ac5fa82) +++ sql/term-search/varchar-array/match-v2/indexscan.sql 2017-05-29 16:01:36 +0900 (4934c47) @@ -8,7 +8,7 @@ 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 pgroonga.varchar_array_ops_v2); + USING pgroonga (tags pgroonga.varchar_array_term_search_ops_v2); SET enable_seqscan = off; SET enable_indexscan = on; Renamed: sql/term-search/varchar-array/match-v2/seqscan.sql (+1 -1) 87% =================================================================== --- sql/match/varchar-array/match-v2/seqscan.sql 2017-05-17 09:51:17 +0900 (e21457a) +++ sql/term-search/varchar-array/match-v2/seqscan.sql 2017-05-29 16:01:36 +0900 (c6a0a83) @@ -8,7 +8,7 @@ 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 pgroonga.varchar_array_ops_v2); + USING pgroonga (tags pgroonga.varchar_array_term_search_ops_v2); SET enable_seqscan = on; SET enable_indexscan = off; Renamed: sql/term-search/varchar-array/match/bitmapscan.sql (+0 -0) 100% =================================================================== Renamed: sql/term-search/varchar-array/match/indexscan.sql (+0 -0) 100% =================================================================== Renamed: sql/term-search/varchar-array/match/seqscan.sql (+0 -0) 100% =================================================================== -------------- next part -------------- HTML����������������������������...Télécharger
