Kouhei Sutou
null+****@clear*****
Wed Oct 28 22:44:00 JST 2015
Kouhei Sutou 2015-10-28 22:44:00 +0900 (Wed, 28 Oct 2015) New Revision: 58c75417f01fbbfecad121563dc4af410c128922 https://github.com/pgroonga/pgroonga/commit/58c75417f01fbbfecad121563dc4af410c128922 Message: test: add tests for ILIKE with regular expression Copied files: expected/regexp/text/ilike/begin-of-text/bitmapscan.out (from expected/regexp/text/like/begin-of-text/bitmapscan.out) expected/regexp/text/ilike/begin-of-text/indexscan.out (from expected/regexp/text/like/begin-of-text/indexscan.out) expected/regexp/text/ilike/begin-of-text/seqscan.out (from expected/regexp/text/like/begin-of-text/seqscan.out) expected/regexp/text/ilike/end-of-text/bitmapscan.out (from expected/regexp/text/like/end-of-text/bitmapscan.out) expected/regexp/text/ilike/end-of-text/indexscan.out (from expected/regexp/text/like/end-of-text/indexscan.out) expected/regexp/text/ilike/end-of-text/seqscan.out (from expected/regexp/text/like/end-of-text/seqscan.out) expected/regexp/text/ilike/exact/bitmapscan.out (from expected/regexp/text/like/exact/bitmapscan.out) expected/regexp/text/ilike/exact/indexscan.out (from expected/regexp/text/like/exact/indexscan.out) expected/regexp/text/ilike/exact/seqscan.out (from expected/regexp/text/like/exact/seqscan.out) expected/regexp/text/ilike/partial/bitmapscan.out (from expected/regexp/text/like/partial/bitmapscan.out) expected/regexp/text/ilike/partial/indexscan.out (from expected/regexp/text/like/partial/indexscan.out) expected/regexp/text/ilike/partial/seqscan.out (from expected/regexp/text/like/partial/seqscan.out) sql/regexp/text/ilike/begin-of-text/bitmapscan.sql (from sql/regexp/text/like/partial/bitmapscan.sql) sql/regexp/text/ilike/begin-of-text/indexscan.sql (from sql/regexp/text/like/begin-of-text/indexscan.sql) sql/regexp/text/ilike/begin-of-text/seqscan.sql (from sql/regexp/text/like/begin-of-text/seqscan.sql) sql/regexp/text/ilike/end-of-text/bitmapscan.sql (from sql/regexp/text/like/end-of-text/bitmapscan.sql) sql/regexp/text/ilike/end-of-text/indexscan.sql (from sql/regexp/text/like/end-of-text/indexscan.sql) sql/regexp/text/ilike/end-of-text/seqscan.sql (from sql/regexp/text/like/end-of-text/seqscan.sql) sql/regexp/text/ilike/exact/bitmapscan.sql (from sql/regexp/text/like/exact/bitmapscan.sql) sql/regexp/text/ilike/exact/indexscan.sql (from sql/regexp/text/like/exact/indexscan.sql) sql/regexp/text/ilike/exact/seqscan.sql (from sql/regexp/text/like/exact/seqscan.sql) sql/regexp/text/ilike/partial/bitmapscan.sql (from sql/regexp/text/like/partial/bitmapscan.sql) sql/regexp/text/ilike/partial/indexscan.sql (from sql/regexp/text/like/begin-of-text/indexscan.sql) sql/regexp/text/ilike/partial/seqscan.sql (from sql/regexp/text/like/begin-of-text/seqscan.sql) Modified files: expected/regexp/text/like/begin-of-text/bitmapscan.out expected/regexp/text/like/begin-of-text/indexscan.out expected/regexp/text/like/begin-of-text/seqscan.out expected/regexp/text/like/end-of-text/bitmapscan.out expected/regexp/text/like/end-of-text/indexscan.out expected/regexp/text/like/end-of-text/seqscan.out expected/regexp/text/like/exact/bitmapscan.out expected/regexp/text/like/exact/indexscan.out expected/regexp/text/like/exact/seqscan.out expected/regexp/text/like/partial/bitmapscan.out expected/regexp/text/like/partial/indexscan.out expected/regexp/text/like/partial/seqscan.out sql/regexp/text/like/begin-of-text/bitmapscan.sql sql/regexp/text/like/begin-of-text/indexscan.sql sql/regexp/text/like/begin-of-text/seqscan.sql sql/regexp/text/like/end-of-text/bitmapscan.sql sql/regexp/text/like/end-of-text/indexscan.sql sql/regexp/text/like/end-of-text/seqscan.sql sql/regexp/text/like/exact/bitmapscan.sql sql/regexp/text/like/exact/indexscan.sql sql/regexp/text/like/exact/seqscan.sql sql/regexp/text/like/partial/bitmapscan.sql sql/regexp/text/like/partial/indexscan.sql sql/regexp/text/like/partial/seqscan.sql Copied: expected/regexp/text/ilike/begin-of-text/bitmapscan.out (+4 -2) 81% =================================================================== --- expected/regexp/text/like/begin-of-text/bitmapscan.out 2015-10-28 22:38:02 +0900 (9d24832) +++ expected/regexp/text/ilike/begin-of-text/bitmapscan.out 2015-10-28 22:44:00 +0900 (c751250) @@ -5,16 +5,18 @@ CREATE TABLE memos ( 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.'); +INSERT INTO memos VALUES (4, 'groonga command is provided.'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); SET enable_seqscan = off; SET enable_indexscan = off; SET enable_bitmapscan = on; SELECT id, content FROM memos - WHERE content LIKE 'Groonga%'; + WHERE content ILIKE 'GROONGA%'; id | content ----+------------------------------------------ 2 | Groonga is fast full text search engine. -(1 row) + 4 | groonga command is provided. +(2 rows) DROP TABLE memos; Copied: expected/regexp/text/ilike/begin-of-text/indexscan.out (+4 -2) 81% =================================================================== --- expected/regexp/text/like/begin-of-text/indexscan.out 2015-10-28 22:38:02 +0900 (5f2b916) +++ expected/regexp/text/ilike/begin-of-text/indexscan.out 2015-10-28 22:44:00 +0900 (f6d31b1) @@ -5,16 +5,18 @@ CREATE TABLE memos ( 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.'); +INSERT INTO memos VALUES (4, 'groonga command is provided.'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); SET enable_seqscan = off; SET enable_indexscan = on; SET enable_bitmapscan = off; SELECT id, content FROM memos - WHERE content LIKE 'Groonga%'; + WHERE content ILIKE 'GROONGA%'; id | content ----+------------------------------------------ 2 | Groonga is fast full text search engine. -(1 row) + 4 | groonga command is provided. +(2 rows) DROP TABLE memos; Copied: expected/regexp/text/ilike/begin-of-text/seqscan.out (+4 -2) 81% =================================================================== --- expected/regexp/text/like/begin-of-text/seqscan.out 2015-10-28 22:38:02 +0900 (760328e) +++ expected/regexp/text/ilike/begin-of-text/seqscan.out 2015-10-28 22:44:00 +0900 (0108a17) @@ -5,16 +5,18 @@ CREATE TABLE memos ( 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.'); +INSERT INTO memos VALUES (4, 'groonga command is provided.'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); SET enable_seqscan = on; SET enable_indexscan = off; SET enable_bitmapscan = off; SELECT id, content FROM memos - WHERE content LIKE 'Groonga%'; + WHERE content ILIKE 'GROONGA%'; id | content ----+------------------------------------------ 2 | Groonga is fast full text search engine. -(1 row) + 4 | groonga command is provided. +(2 rows) DROP TABLE memos; Copied: expected/regexp/text/ilike/end-of-text/bitmapscan.out (+2 -1) 87% =================================================================== --- expected/regexp/text/like/end-of-text/bitmapscan.out 2015-10-28 22:38:02 +0900 (beb001d) +++ expected/regexp/text/ilike/end-of-text/bitmapscan.out 2015-10-28 22:44:00 +0900 (141eee4) @@ -5,13 +5,14 @@ CREATE TABLE memos ( 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'); +INSERT INTO memos VALUES (4, 'groonga command is provided'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); SET enable_seqscan = off; SET enable_indexscan = off; SET enable_bitmapscan = on; SELECT id, content FROM memos - WHERE content LIKE '%Groonga'; + WHERE content ILIKE '%GROONGA'; id | content ----+------------------------------------------------------ 3 | PGroonga is a PostgreSQL extension that uses Groonga Copied: expected/regexp/text/ilike/end-of-text/indexscan.out (+2 -1) 87% =================================================================== --- expected/regexp/text/like/end-of-text/indexscan.out 2015-10-28 22:38:02 +0900 (297fe20) +++ expected/regexp/text/ilike/end-of-text/indexscan.out 2015-10-28 22:44:00 +0900 (b930583) @@ -5,13 +5,14 @@ CREATE TABLE memos ( 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'); +INSERT INTO memos VALUES (4, 'groonga command is provided'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); SET enable_seqscan = off; SET enable_indexscan = on; SET enable_bitmapscan = off; SELECT id, content FROM memos - WHERE content LIKE '%Groonga'; + WHERE content ILIKE '%GROONGA'; id | content ----+------------------------------------------------------ 3 | PGroonga is a PostgreSQL extension that uses Groonga Copied: expected/regexp/text/ilike/end-of-text/seqscan.out (+2 -1) 87% =================================================================== --- expected/regexp/text/like/end-of-text/seqscan.out 2015-10-28 22:38:02 +0900 (8c7550c) +++ expected/regexp/text/ilike/end-of-text/seqscan.out 2015-10-28 22:44:00 +0900 (92ba844) @@ -5,13 +5,14 @@ CREATE TABLE memos ( 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'); +INSERT INTO memos VALUES (4, 'groonga command is provided'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); SET enable_seqscan = on; SET enable_indexscan = off; SET enable_bitmapscan = off; SELECT id, content FROM memos - WHERE content LIKE '%Groonga'; + WHERE content ILIKE '%GROONGA'; id | content ----+------------------------------------------------------ 3 | PGroonga is a PostgreSQL extension that uses Groonga Copied: expected/regexp/text/ilike/exact/bitmapscan.out (+4 -2) 82% =================================================================== --- expected/regexp/text/like/exact/bitmapscan.out 2015-10-28 22:38:02 +0900 (b17401e) +++ expected/regexp/text/ilike/exact/bitmapscan.out 2015-10-28 22:44:00 +0900 (80d4e42) @@ -5,16 +5,18 @@ CREATE TABLE memos ( INSERT INTO memos VALUES (1, 'PostgreSQL'); INSERT INTO memos VALUES (2, 'Groonga'); INSERT INTO memos VALUES (3, 'PGroonga'); +INSERT INTO memos VALUES (4, 'groonga'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); SET enable_seqscan = off; SET enable_indexscan = off; SET enable_bitmapscan = on; SELECT id, content FROM memos - WHERE content LIKE 'Groonga'; + WHERE content ILIKE 'GROONGA'; id | content ----+--------- 2 | Groonga -(1 row) + 4 | groonga +(2 rows) DROP TABLE memos; Copied: expected/regexp/text/ilike/exact/indexscan.out (+4 -2) 82% =================================================================== --- expected/regexp/text/like/exact/indexscan.out 2015-10-28 22:38:02 +0900 (f5f3676) +++ expected/regexp/text/ilike/exact/indexscan.out 2015-10-28 22:44:00 +0900 (9a834c3) @@ -5,16 +5,18 @@ CREATE TABLE memos ( INSERT INTO memos VALUES (1, 'PostgreSQL'); INSERT INTO memos VALUES (2, 'Groonga'); INSERT INTO memos VALUES (3, 'PGroonga'); +INSERT INTO memos VALUES (4, 'groonga'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); SET enable_seqscan = off; SET enable_indexscan = on; SET enable_bitmapscan = off; SELECT id, content FROM memos - WHERE content LIKE 'Groonga'; + WHERE content ILIKE 'GROONGA'; id | content ----+--------- 2 | Groonga -(1 row) + 4 | groonga +(2 rows) DROP TABLE memos; Copied: expected/regexp/text/ilike/exact/seqscan.out (+4 -2) 82% =================================================================== --- expected/regexp/text/like/exact/seqscan.out 2015-10-28 22:38:02 +0900 (1c83e66) +++ expected/regexp/text/ilike/exact/seqscan.out 2015-10-28 22:44:00 +0900 (b15aa8c) @@ -5,16 +5,18 @@ CREATE TABLE memos ( INSERT INTO memos VALUES (1, 'PostgreSQL'); INSERT INTO memos VALUES (2, 'Groonga'); INSERT INTO memos VALUES (3, 'PGroonga'); +INSERT INTO memos VALUES (4, 'groonga'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); SET enable_seqscan = on; SET enable_indexscan = off; SET enable_bitmapscan = off; SELECT id, content FROM memos - WHERE content LIKE 'Groonga'; + WHERE content ILIKE 'GROONGA'; id | content ----+--------- 2 | Groonga -(1 row) + 4 | groonga +(2 rows) DROP TABLE memos; Copied: expected/regexp/text/ilike/partial/bitmapscan.out (+4 -2) 83% =================================================================== --- expected/regexp/text/like/partial/bitmapscan.out 2015-10-28 22:38:02 +0900 (66f9750) +++ expected/regexp/text/ilike/partial/bitmapscan.out 2015-10-28 22:44:00 +0900 (d122fa7) @@ -5,17 +5,19 @@ CREATE TABLE memos ( 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.'); +INSERT INTO memos VALUES (4, 'groonga command is provided.'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); SET enable_seqscan = off; SET enable_indexscan = off; SET enable_bitmapscan = on; SELECT id, content FROM memos - WHERE content LIKE '%Groonga%'; + WHERE content ILIKE '%GROONGA%'; id | content ----+------------------------------------------------------- 2 | Groonga is fast full text search engine. 3 | PGroonga is a PostgreSQL extension that uses Groonga. -(2 rows) + 4 | groonga command is provided. +(3 rows) DROP TABLE memos; Copied: expected/regexp/text/ilike/partial/indexscan.out (+4 -2) 83% =================================================================== --- expected/regexp/text/like/partial/indexscan.out 2015-10-28 22:38:02 +0900 (9bfb42f) +++ expected/regexp/text/ilike/partial/indexscan.out 2015-10-28 22:44:00 +0900 (07f11f0) @@ -5,17 +5,19 @@ CREATE TABLE memos ( 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.'); +INSERT INTO memos VALUES (4, 'groonga command is provided.'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); SET enable_seqscan = off; SET enable_indexscan = on; SET enable_bitmapscan = off; SELECT id, content FROM memos - WHERE content LIKE '%Groonga%'; + WHERE content ILIKE '%GROONGA%'; id | content ----+------------------------------------------------------- 2 | Groonga is fast full text search engine. 3 | PGroonga is a PostgreSQL extension that uses Groonga. -(2 rows) + 4 | groonga command is provided. +(3 rows) DROP TABLE memos; Copied: expected/regexp/text/ilike/partial/seqscan.out (+4 -2) 83% =================================================================== --- expected/regexp/text/like/partial/seqscan.out 2015-10-28 22:38:02 +0900 (13a3efd) +++ expected/regexp/text/ilike/partial/seqscan.out 2015-10-28 22:44:00 +0900 (063f68c) @@ -5,17 +5,19 @@ CREATE TABLE memos ( 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.'); +INSERT INTO memos VALUES (4, 'groonga command is provided.'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); SET enable_seqscan = on; SET enable_indexscan = off; SET enable_bitmapscan = off; SELECT id, content FROM memos - WHERE content LIKE '%Groonga%'; + WHERE content ILIKE '%GROONGA%'; id | content ----+------------------------------------------------------- 2 | Groonga is fast full text search engine. 3 | PGroonga is a PostgreSQL extension that uses Groonga. -(2 rows) + 4 | groonga command is provided. +(3 rows) DROP TABLE memos; Modified: expected/regexp/text/like/begin-of-text/bitmapscan.out (+1 -0) =================================================================== --- expected/regexp/text/like/begin-of-text/bitmapscan.out 2015-10-28 22:38:02 +0900 (9d24832) +++ expected/regexp/text/like/begin-of-text/bitmapscan.out 2015-10-28 22:44:00 +0900 (4c3f7de) @@ -5,6 +5,7 @@ CREATE TABLE memos ( 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.'); +INSERT INTO memos VALUES (4, 'groonga command is provided.'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); SET enable_seqscan = off; SET enable_indexscan = off; Modified: expected/regexp/text/like/begin-of-text/indexscan.out (+1 -0) =================================================================== --- expected/regexp/text/like/begin-of-text/indexscan.out 2015-10-28 22:38:02 +0900 (5f2b916) +++ expected/regexp/text/like/begin-of-text/indexscan.out 2015-10-28 22:44:00 +0900 (6dd6ded) @@ -5,6 +5,7 @@ CREATE TABLE memos ( 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.'); +INSERT INTO memos VALUES (4, 'groonga command is provided.'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); SET enable_seqscan = off; SET enable_indexscan = on; Modified: expected/regexp/text/like/begin-of-text/seqscan.out (+1 -0) =================================================================== --- expected/regexp/text/like/begin-of-text/seqscan.out 2015-10-28 22:38:02 +0900 (760328e) +++ expected/regexp/text/like/begin-of-text/seqscan.out 2015-10-28 22:44:00 +0900 (870697f) @@ -5,6 +5,7 @@ CREATE TABLE memos ( 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.'); +INSERT INTO memos VALUES (4, 'groonga command is provided.'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); SET enable_seqscan = on; SET enable_indexscan = off; Modified: expected/regexp/text/like/end-of-text/bitmapscan.out (+1 -0) =================================================================== --- expected/regexp/text/like/end-of-text/bitmapscan.out 2015-10-28 22:38:02 +0900 (beb001d) +++ expected/regexp/text/like/end-of-text/bitmapscan.out 2015-10-28 22:44:00 +0900 (2e3ffc0) @@ -5,6 +5,7 @@ CREATE TABLE memos ( 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'); +INSERT INTO memos VALUES (4, 'groonga command is provided'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); SET enable_seqscan = off; SET enable_indexscan = off; Modified: expected/regexp/text/like/end-of-text/indexscan.out (+1 -0) =================================================================== --- expected/regexp/text/like/end-of-text/indexscan.out 2015-10-28 22:38:02 +0900 (297fe20) +++ expected/regexp/text/like/end-of-text/indexscan.out 2015-10-28 22:44:00 +0900 (a025f0f) @@ -5,6 +5,7 @@ CREATE TABLE memos ( 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'); +INSERT INTO memos VALUES (4, 'groonga command is provided'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); SET enable_seqscan = off; SET enable_indexscan = on; Modified: expected/regexp/text/like/end-of-text/seqscan.out (+1 -0) =================================================================== --- expected/regexp/text/like/end-of-text/seqscan.out 2015-10-28 22:38:02 +0900 (8c7550c) +++ expected/regexp/text/like/end-of-text/seqscan.out 2015-10-28 22:44:00 +0900 (1b696b6) @@ -5,6 +5,7 @@ CREATE TABLE memos ( 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'); +INSERT INTO memos VALUES (4, 'groonga command is provided'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); SET enable_seqscan = on; SET enable_indexscan = off; Modified: expected/regexp/text/like/exact/bitmapscan.out (+1 -0) =================================================================== --- expected/regexp/text/like/exact/bitmapscan.out 2015-10-28 22:38:02 +0900 (b17401e) +++ expected/regexp/text/like/exact/bitmapscan.out 2015-10-28 22:44:00 +0900 (12e23c2) @@ -5,6 +5,7 @@ CREATE TABLE memos ( INSERT INTO memos VALUES (1, 'PostgreSQL'); INSERT INTO memos VALUES (2, 'Groonga'); INSERT INTO memos VALUES (3, 'PGroonga'); +INSERT INTO memos VALUES (4, 'groonga'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); SET enable_seqscan = off; SET enable_indexscan = off; Modified: expected/regexp/text/like/exact/indexscan.out (+1 -0) =================================================================== --- expected/regexp/text/like/exact/indexscan.out 2015-10-28 22:38:02 +0900 (f5f3676) +++ expected/regexp/text/like/exact/indexscan.out 2015-10-28 22:44:00 +0900 (55ff57f) @@ -5,6 +5,7 @@ CREATE TABLE memos ( INSERT INTO memos VALUES (1, 'PostgreSQL'); INSERT INTO memos VALUES (2, 'Groonga'); INSERT INTO memos VALUES (3, 'PGroonga'); +INSERT INTO memos VALUES (4, 'groonga'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); SET enable_seqscan = off; SET enable_indexscan = on; Modified: expected/regexp/text/like/exact/seqscan.out (+1 -0) =================================================================== --- expected/regexp/text/like/exact/seqscan.out 2015-10-28 22:38:02 +0900 (1c83e66) +++ expected/regexp/text/like/exact/seqscan.out 2015-10-28 22:44:00 +0900 (c214e6b) @@ -5,6 +5,7 @@ CREATE TABLE memos ( INSERT INTO memos VALUES (1, 'PostgreSQL'); INSERT INTO memos VALUES (2, 'Groonga'); INSERT INTO memos VALUES (3, 'PGroonga'); +INSERT INTO memos VALUES (4, 'groonga'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); SET enable_seqscan = on; SET enable_indexscan = off; Modified: expected/regexp/text/like/partial/bitmapscan.out (+1 -0) =================================================================== --- expected/regexp/text/like/partial/bitmapscan.out 2015-10-28 22:38:02 +0900 (66f9750) +++ expected/regexp/text/like/partial/bitmapscan.out 2015-10-28 22:44:00 +0900 (19befa7) @@ -5,6 +5,7 @@ CREATE TABLE memos ( 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.'); +INSERT INTO memos VALUES (4, 'groonga command is provided.'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); SET enable_seqscan = off; SET enable_indexscan = off; Modified: expected/regexp/text/like/partial/indexscan.out (+1 -0) =================================================================== --- expected/regexp/text/like/partial/indexscan.out 2015-10-28 22:38:02 +0900 (9bfb42f) +++ expected/regexp/text/like/partial/indexscan.out 2015-10-28 22:44:00 +0900 (1fe5149) @@ -5,6 +5,7 @@ CREATE TABLE memos ( 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.'); +INSERT INTO memos VALUES (4, 'groonga command is provided.'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); SET enable_seqscan = off; SET enable_indexscan = on; Modified: expected/regexp/text/like/partial/seqscan.out (+1 -0) =================================================================== --- expected/regexp/text/like/partial/seqscan.out 2015-10-28 22:38:02 +0900 (13a3efd) +++ expected/regexp/text/like/partial/seqscan.out 2015-10-28 22:44:00 +0900 (ede37a0) @@ -5,6 +5,7 @@ CREATE TABLE memos ( 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.'); +INSERT INTO memos VALUES (4, 'groonga command is provided.'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); SET enable_seqscan = on; SET enable_indexscan = off; Copied: sql/regexp/text/ilike/begin-of-text/bitmapscan.sql (+2 -1) 83% =================================================================== --- sql/regexp/text/like/partial/bitmapscan.sql 2015-10-28 22:38:02 +0900 (2982dce) +++ sql/regexp/text/ilike/begin-of-text/bitmapscan.sql 2015-10-28 22:44:00 +0900 (27f13d6) @@ -6,6 +6,7 @@ CREATE TABLE memos ( 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.'); +INSERT INTO memos VALUES (4, 'groonga command is provided.'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); @@ -15,6 +16,6 @@ SET enable_bitmapscan = on; SELECT id, content FROM memos - WHERE content LIKE '%Groonga%'; + WHERE content ILIKE 'GROONGA%'; DROP TABLE memos; Copied: sql/regexp/text/ilike/begin-of-text/indexscan.sql (+2 -1) 83% =================================================================== --- sql/regexp/text/like/begin-of-text/indexscan.sql 2015-10-28 22:38:02 +0900 (0f660d8) +++ sql/regexp/text/ilike/begin-of-text/indexscan.sql 2015-10-28 22:44:00 +0900 (66083d0) @@ -6,6 +6,7 @@ CREATE TABLE memos ( 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.'); +INSERT INTO memos VALUES (4, 'groonga command is provided.'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); @@ -15,6 +16,6 @@ SET enable_bitmapscan = off; SELECT id, content FROM memos - WHERE content LIKE 'Groonga%'; + WHERE content ILIKE 'GROONGA%'; DROP TABLE memos; Copied: sql/regexp/text/ilike/begin-of-text/seqscan.sql (+2 -1) 83% =================================================================== --- sql/regexp/text/like/begin-of-text/seqscan.sql 2015-10-28 22:38:02 +0900 (0727588) +++ sql/regexp/text/ilike/begin-of-text/seqscan.sql 2015-10-28 22:44:00 +0900 (458ee35) @@ -6,6 +6,7 @@ CREATE TABLE memos ( 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.'); +INSERT INTO memos VALUES (4, 'groonga command is provided.'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); @@ -15,6 +16,6 @@ SET enable_bitmapscan = off; SELECT id, content FROM memos - WHERE content LIKE 'Groonga%'; + WHERE content ILIKE 'GROONGA%'; DROP TABLE memos; Copied: sql/regexp/text/ilike/end-of-text/bitmapscan.sql (+2 -1) 83% =================================================================== --- sql/regexp/text/like/end-of-text/bitmapscan.sql 2015-10-28 22:38:02 +0900 (43a94d7) +++ sql/regexp/text/ilike/end-of-text/bitmapscan.sql 2015-10-28 22:44:00 +0900 (60af052) @@ -6,6 +6,7 @@ CREATE TABLE memos ( 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'); +INSERT INTO memos VALUES (4, 'groonga command is provided'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); @@ -15,6 +16,6 @@ SET enable_bitmapscan = on; SELECT id, content FROM memos - WHERE content LIKE '%Groonga'; + WHERE content ILIKE '%GROONGA'; DROP TABLE memos; Copied: sql/regexp/text/ilike/end-of-text/indexscan.sql (+2 -1) 83% =================================================================== --- sql/regexp/text/like/end-of-text/indexscan.sql 2015-10-28 22:38:02 +0900 (5b94877) +++ sql/regexp/text/ilike/end-of-text/indexscan.sql 2015-10-28 22:44:00 +0900 (81876f6) @@ -6,6 +6,7 @@ CREATE TABLE memos ( 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'); +INSERT INTO memos VALUES (4, 'groonga command is provided'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); @@ -15,6 +16,6 @@ SET enable_bitmapscan = off; SELECT id, content FROM memos - WHERE content LIKE '%Groonga'; + WHERE content ILIKE '%GROONGA'; DROP TABLE memos; Copied: sql/regexp/text/ilike/end-of-text/seqscan.sql (+2 -1) 83% =================================================================== --- sql/regexp/text/like/end-of-text/seqscan.sql 2015-10-28 22:38:02 +0900 (516fab3) +++ sql/regexp/text/ilike/end-of-text/seqscan.sql 2015-10-28 22:44:00 +0900 (c8b660d) @@ -6,6 +6,7 @@ CREATE TABLE memos ( 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'); +INSERT INTO memos VALUES (4, 'groonga command is provided'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); @@ -15,6 +16,6 @@ SET enable_bitmapscan = off; SELECT id, content FROM memos - WHERE content LIKE '%Groonga'; + WHERE content ILIKE '%GROONGA'; DROP TABLE memos; Copied: sql/regexp/text/ilike/exact/bitmapscan.sql (+2 -1) 84% =================================================================== --- sql/regexp/text/like/exact/bitmapscan.sql 2015-10-28 22:38:02 +0900 (aa1f891) +++ sql/regexp/text/ilike/exact/bitmapscan.sql 2015-10-28 22:44:00 +0900 (92572fc) @@ -6,6 +6,7 @@ CREATE TABLE memos ( INSERT INTO memos VALUES (1, 'PostgreSQL'); INSERT INTO memos VALUES (2, 'Groonga'); INSERT INTO memos VALUES (3, 'PGroonga'); +INSERT INTO memos VALUES (4, 'groonga'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); @@ -15,6 +16,6 @@ SET enable_bitmapscan = on; SELECT id, content FROM memos - WHERE content LIKE 'Groonga'; + WHERE content ILIKE 'GROONGA'; DROP TABLE memos; Copied: sql/regexp/text/ilike/exact/indexscan.sql (+2 -1) 84% =================================================================== --- sql/regexp/text/like/exact/indexscan.sql 2015-10-28 22:38:02 +0900 (b7cd1e6) +++ sql/regexp/text/ilike/exact/indexscan.sql 2015-10-28 22:44:00 +0900 (41f14ed) @@ -6,6 +6,7 @@ CREATE TABLE memos ( INSERT INTO memos VALUES (1, 'PostgreSQL'); INSERT INTO memos VALUES (2, 'Groonga'); INSERT INTO memos VALUES (3, 'PGroonga'); +INSERT INTO memos VALUES (4, 'groonga'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); @@ -15,6 +16,6 @@ SET enable_bitmapscan = off; SELECT id, content FROM memos - WHERE content LIKE 'Groonga'; + WHERE content ILIKE 'GROONGA'; DROP TABLE memos; Copied: sql/regexp/text/ilike/exact/seqscan.sql (+2 -1) 84% =================================================================== --- sql/regexp/text/like/exact/seqscan.sql 2015-10-28 22:38:02 +0900 (e64e398) +++ sql/regexp/text/ilike/exact/seqscan.sql 2015-10-28 22:44:00 +0900 (6144e9c) @@ -6,6 +6,7 @@ CREATE TABLE memos ( INSERT INTO memos VALUES (1, 'PostgreSQL'); INSERT INTO memos VALUES (2, 'Groonga'); INSERT INTO memos VALUES (3, 'PGroonga'); +INSERT INTO memos VALUES (4, 'groonga'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); @@ -15,6 +16,6 @@ SET enable_bitmapscan = off; SELECT id, content FROM memos - WHERE content LIKE 'Groonga'; + WHERE content ILIKE 'GROONGA'; DROP TABLE memos; Copied: sql/regexp/text/ilike/partial/bitmapscan.sql (+2 -1) 83% =================================================================== --- sql/regexp/text/like/partial/bitmapscan.sql 2015-10-28 22:38:02 +0900 (2982dce) +++ sql/regexp/text/ilike/partial/bitmapscan.sql 2015-10-28 22:44:00 +0900 (673c731) @@ -6,6 +6,7 @@ CREATE TABLE memos ( 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.'); +INSERT INTO memos VALUES (4, 'groonga command is provided.'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); @@ -15,6 +16,6 @@ SET enable_bitmapscan = on; SELECT id, content FROM memos - WHERE content LIKE '%Groonga%'; + WHERE content ILIKE '%GROONGA%'; DROP TABLE memos; Copied: sql/regexp/text/ilike/partial/indexscan.sql (+2 -1) 83% =================================================================== --- sql/regexp/text/like/begin-of-text/indexscan.sql 2015-10-28 22:38:02 +0900 (0f660d8) +++ sql/regexp/text/ilike/partial/indexscan.sql 2015-10-28 22:44:00 +0900 (8094d41) @@ -6,6 +6,7 @@ CREATE TABLE memos ( 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.'); +INSERT INTO memos VALUES (4, 'groonga command is provided.'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); @@ -15,6 +16,6 @@ SET enable_bitmapscan = off; SELECT id, content FROM memos - WHERE content LIKE 'Groonga%'; + WHERE content ILIKE '%GROONGA%'; DROP TABLE memos; Copied: sql/regexp/text/ilike/partial/seqscan.sql (+2 -1) 83% =================================================================== --- sql/regexp/text/like/begin-of-text/seqscan.sql 2015-10-28 22:38:02 +0900 (0727588) +++ sql/regexp/text/ilike/partial/seqscan.sql 2015-10-28 22:44:00 +0900 (6e1e66b) @@ -6,6 +6,7 @@ CREATE TABLE memos ( 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.'); +INSERT INTO memos VALUES (4, 'groonga command is provided.'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); @@ -15,6 +16,6 @@ SET enable_bitmapscan = off; SELECT id, content FROM memos - WHERE content LIKE 'Groonga%'; + WHERE content ILIKE '%GROONGA%'; DROP TABLE memos; Modified: sql/regexp/text/like/begin-of-text/bitmapscan.sql (+1 -0) =================================================================== --- sql/regexp/text/like/begin-of-text/bitmapscan.sql 2015-10-28 22:38:02 +0900 (5d841ff) +++ sql/regexp/text/like/begin-of-text/bitmapscan.sql 2015-10-28 22:44:00 +0900 (0d67874) @@ -6,6 +6,7 @@ CREATE TABLE memos ( 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.'); +INSERT INTO memos VALUES (4, 'groonga command is provided.'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); Modified: sql/regexp/text/like/begin-of-text/indexscan.sql (+1 -0) =================================================================== --- sql/regexp/text/like/begin-of-text/indexscan.sql 2015-10-28 22:38:02 +0900 (0f660d8) +++ sql/regexp/text/like/begin-of-text/indexscan.sql 2015-10-28 22:44:00 +0900 (378f3cc) @@ -6,6 +6,7 @@ CREATE TABLE memos ( 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.'); +INSERT INTO memos VALUES (4, 'groonga command is provided.'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); Modified: sql/regexp/text/like/begin-of-text/seqscan.sql (+1 -0) =================================================================== --- sql/regexp/text/like/begin-of-text/seqscan.sql 2015-10-28 22:38:02 +0900 (0727588) +++ sql/regexp/text/like/begin-of-text/seqscan.sql 2015-10-28 22:44:00 +0900 (65eb601) @@ -6,6 +6,7 @@ CREATE TABLE memos ( 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.'); +INSERT INTO memos VALUES (4, 'groonga command is provided.'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); Modified: sql/regexp/text/like/end-of-text/bitmapscan.sql (+1 -0) =================================================================== --- sql/regexp/text/like/end-of-text/bitmapscan.sql 2015-10-28 22:38:02 +0900 (43a94d7) +++ sql/regexp/text/like/end-of-text/bitmapscan.sql 2015-10-28 22:44:00 +0900 (2950834) @@ -6,6 +6,7 @@ CREATE TABLE memos ( 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'); +INSERT INTO memos VALUES (4, 'groonga command is provided'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); Modified: sql/regexp/text/like/end-of-text/indexscan.sql (+1 -0) =================================================================== --- sql/regexp/text/like/end-of-text/indexscan.sql 2015-10-28 22:38:02 +0900 (5b94877) +++ sql/regexp/text/like/end-of-text/indexscan.sql 2015-10-28 22:44:00 +0900 (40b49e5) @@ -6,6 +6,7 @@ CREATE TABLE memos ( 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'); +INSERT INTO memos VALUES (4, 'groonga command is provided'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); Modified: sql/regexp/text/like/end-of-text/seqscan.sql (+1 -0) =================================================================== --- sql/regexp/text/like/end-of-text/seqscan.sql 2015-10-28 22:38:02 +0900 (516fab3) +++ sql/regexp/text/like/end-of-text/seqscan.sql 2015-10-28 22:44:00 +0900 (f2a1148) @@ -6,6 +6,7 @@ CREATE TABLE memos ( 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'); +INSERT INTO memos VALUES (4, 'groonga command is provided'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); Modified: sql/regexp/text/like/exact/bitmapscan.sql (+1 -0) =================================================================== --- sql/regexp/text/like/exact/bitmapscan.sql 2015-10-28 22:38:02 +0900 (aa1f891) +++ sql/regexp/text/like/exact/bitmapscan.sql 2015-10-28 22:44:00 +0900 (f2adb85) @@ -6,6 +6,7 @@ CREATE TABLE memos ( INSERT INTO memos VALUES (1, 'PostgreSQL'); INSERT INTO memos VALUES (2, 'Groonga'); INSERT INTO memos VALUES (3, 'PGroonga'); +INSERT INTO memos VALUES (4, 'groonga'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); Modified: sql/regexp/text/like/exact/indexscan.sql (+1 -0) =================================================================== --- sql/regexp/text/like/exact/indexscan.sql 2015-10-28 22:38:02 +0900 (b7cd1e6) +++ sql/regexp/text/like/exact/indexscan.sql 2015-10-28 22:44:00 +0900 (02b39f4) @@ -6,6 +6,7 @@ CREATE TABLE memos ( INSERT INTO memos VALUES (1, 'PostgreSQL'); INSERT INTO memos VALUES (2, 'Groonga'); INSERT INTO memos VALUES (3, 'PGroonga'); +INSERT INTO memos VALUES (4, 'groonga'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); Modified: sql/regexp/text/like/exact/seqscan.sql (+1 -0) =================================================================== --- sql/regexp/text/like/exact/seqscan.sql 2015-10-28 22:38:02 +0900 (e64e398) +++ sql/regexp/text/like/exact/seqscan.sql 2015-10-28 22:44:00 +0900 (88b47f3) @@ -6,6 +6,7 @@ CREATE TABLE memos ( INSERT INTO memos VALUES (1, 'PostgreSQL'); INSERT INTO memos VALUES (2, 'Groonga'); INSERT INTO memos VALUES (3, 'PGroonga'); +INSERT INTO memos VALUES (4, 'groonga'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); Modified: sql/regexp/text/like/partial/bitmapscan.sql (+1 -0) =================================================================== --- sql/regexp/text/like/partial/bitmapscan.sql 2015-10-28 22:38:02 +0900 (2982dce) +++ sql/regexp/text/like/partial/bitmapscan.sql 2015-10-28 22:44:00 +0900 (957a01a) @@ -6,6 +6,7 @@ CREATE TABLE memos ( 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.'); +INSERT INTO memos VALUES (4, 'groonga command is provided.'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); Modified: sql/regexp/text/like/partial/indexscan.sql (+1 -0) =================================================================== --- sql/regexp/text/like/partial/indexscan.sql 2015-10-28 22:38:02 +0900 (077ba8b) +++ sql/regexp/text/like/partial/indexscan.sql 2015-10-28 22:44:00 +0900 (7586ec5) @@ -6,6 +6,7 @@ CREATE TABLE memos ( 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.'); +INSERT INTO memos VALUES (4, 'groonga command is provided.'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); Modified: sql/regexp/text/like/partial/seqscan.sql (+1 -0) =================================================================== --- sql/regexp/text/like/partial/seqscan.sql 2015-10-28 22:38:02 +0900 (7f21162) +++ sql/regexp/text/like/partial/seqscan.sql 2015-10-28 22:44:00 +0900 (605701d) @@ -6,6 +6,7 @@ CREATE TABLE memos ( 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.'); +INSERT INTO memos VALUES (4, 'groonga command is provided.'); CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); -------------- next part -------------- HTML����������������������������...Download