Kouhei Sutou
null+****@clear*****
Sun Feb 15 13:54:33 JST 2015
Kouhei Sutou 2015-02-15 13:54:33 +0900 (Sun, 15 Feb 2015) New Revision: e9b72011649ded6b5e80a211235142b8ae5df762 https://github.com/pgroonga/pgroonga/commit/e9b72011649ded6b5e80a211235142b8ae5df762 Message: Use compare mode for varchar by default Use text for full-text search. Modified files: expected/compare/varchar/single/equal/bitmapscan.out expected/compare/varchar/single/equal/indexscan.out expected/compare/varchar/single/equal/seqscan.out pgroonga.sql sql/compare/varchar/single/equal/bitmapscan.sql sql/compare/varchar/single/equal/indexscan.sql sql/compare/varchar/single/equal/seqscan.sql Modified: expected/compare/varchar/single/equal/bitmapscan.out (+1 -1) =================================================================== --- expected/compare/varchar/single/equal/bitmapscan.out 2015-02-15 13:50:39 +0900 (5e72ae5) +++ expected/compare/varchar/single/equal/bitmapscan.out 2015-02-15 13:54:33 +0900 (2f6abce) @@ -5,7 +5,7 @@ CREATE TABLE memos ( INSERT INTO memos VALUES (1, 'PostgreSQL'); INSERT INTO memos VALUES (2, 'Groonga'); INSERT INTO memos VALUES (3, 'PGroonga'); -CREATE INDEX grnindex ON memos USING pgroonga (title pgroonga.varchar_ops); +CREATE INDEX grnindex ON memos USING pgroonga (title); SET enable_seqscan = off; SET enable_indexscan = off; SET enable_bitmapscan = on; Modified: expected/compare/varchar/single/equal/indexscan.out (+1 -1) =================================================================== --- expected/compare/varchar/single/equal/indexscan.out 2015-02-15 13:50:39 +0900 (5438752) +++ expected/compare/varchar/single/equal/indexscan.out 2015-02-15 13:54:33 +0900 (cd79713) @@ -5,7 +5,7 @@ CREATE TABLE memos ( INSERT INTO memos VALUES (1, 'PostgreSQL'); INSERT INTO memos VALUES (2, 'Groonga'); INSERT INTO memos VALUES (3, 'PGroonga'); -CREATE INDEX grnindex ON memos USING pgroonga (title pgroonga.varchar_ops); +CREATE INDEX grnindex ON memos USING pgroonga (title); SET enable_seqscan = off; SET enable_indexscan = on; SET enable_bitmapscan = off; Modified: expected/compare/varchar/single/equal/seqscan.out (+1 -1) =================================================================== --- expected/compare/varchar/single/equal/seqscan.out 2015-02-15 13:50:39 +0900 (703b743) +++ expected/compare/varchar/single/equal/seqscan.out 2015-02-15 13:54:33 +0900 (151326c) @@ -5,7 +5,7 @@ CREATE TABLE memos ( INSERT INTO memos VALUES (1, 'PostgreSQL'); INSERT INTO memos VALUES (2, 'Groonga'); INSERT INTO memos VALUES (3, 'PGroonga'); -CREATE INDEX grnindex ON memos USING pgroonga (title pgroonga.varchar_ops); +CREATE INDEX grnindex ON memos USING pgroonga (title); SET enable_seqscan = on; SET enable_indexscan = off; SET enable_bitmapscan = off; Modified: pgroonga.sql (+2 -2) =================================================================== --- pgroonga.sql 2015-02-15 13:50:39 +0900 (3bec7d1) +++ pgroonga.sql 2015-02-15 13:54:33 +0900 (bba89e5) @@ -265,14 +265,14 @@ CREATE OPERATOR CLASS pgroonga.full_text_search_text_array_ops FUNCTION 1 pgroonga.get_text_array(internal, internal, text[]), FUNCTION 2 pgroonga.get_text(internal, internal, text); -CREATE OPERATOR CLASS pgroonga.full_text_search_varchar_ops DEFAULT FOR TYPE varchar +CREATE OPERATOR CLASS pgroonga.full_text_search_varchar_ops FOR TYPE varchar USING pgroonga AS OPERATOR 7 %%, OPERATOR 8 @@, FUNCTION 1 pgroonga.get_varchar(internal, internal, varchar), FUNCTION 2 pgroonga.get_varchar(internal, internal, varchar); -CREATE OPERATOR CLASS pgroonga.varchar_ops FOR TYPE varchar +CREATE OPERATOR CLASS pgroonga.varchar_ops DEFAULT FOR TYPE varchar USING pgroonga AS OPERATOR 1 < (text, text), OPERATOR 2 <= (text, text), Modified: sql/compare/varchar/single/equal/bitmapscan.sql (+1 -1) =================================================================== --- sql/compare/varchar/single/equal/bitmapscan.sql 2015-02-15 13:50:39 +0900 (ea2f81e) +++ sql/compare/varchar/single/equal/bitmapscan.sql 2015-02-15 13:54:33 +0900 (8fd5a0e) @@ -7,7 +7,7 @@ INSERT INTO memos VALUES (1, 'PostgreSQL'); INSERT INTO memos VALUES (2, 'Groonga'); INSERT INTO memos VALUES (3, 'PGroonga'); -CREATE INDEX grnindex ON memos USING pgroonga (title pgroonga.varchar_ops); +CREATE INDEX grnindex ON memos USING pgroonga (title); SET enable_seqscan = off; SET enable_indexscan = off; Modified: sql/compare/varchar/single/equal/indexscan.sql (+1 -1) =================================================================== --- sql/compare/varchar/single/equal/indexscan.sql 2015-02-15 13:50:39 +0900 (8088bd3) +++ sql/compare/varchar/single/equal/indexscan.sql 2015-02-15 13:54:33 +0900 (b960dec) @@ -7,7 +7,7 @@ INSERT INTO memos VALUES (1, 'PostgreSQL'); INSERT INTO memos VALUES (2, 'Groonga'); INSERT INTO memos VALUES (3, 'PGroonga'); -CREATE INDEX grnindex ON memos USING pgroonga (title pgroonga.varchar_ops); +CREATE INDEX grnindex ON memos USING pgroonga (title); SET enable_seqscan = off; SET enable_indexscan = on; Modified: sql/compare/varchar/single/equal/seqscan.sql (+1 -1) =================================================================== --- sql/compare/varchar/single/equal/seqscan.sql 2015-02-15 13:50:39 +0900 (ebe1d9f) +++ sql/compare/varchar/single/equal/seqscan.sql 2015-02-15 13:54:33 +0900 (6984451) @@ -7,7 +7,7 @@ INSERT INTO memos VALUES (1, 'PostgreSQL'); INSERT INTO memos VALUES (2, 'Groonga'); INSERT INTO memos VALUES (3, 'PGroonga'); -CREATE INDEX grnindex ON memos USING pgroonga (title pgroonga.varchar_ops); +CREATE INDEX grnindex ON memos USING pgroonga (title); SET enable_seqscan = on; SET enable_indexscan = off; -------------- next part -------------- HTML����������������������������...Download