Kouhei Sutou
null+****@clear*****
Sun Jan 18 22:51:10 JST 2015
Kouhei Sutou 2015-01-18 22:51:10 +0900 (Sun, 18 Jan 2015) New Revision: 2c8b67f05f2786c67767793544adefa7ae32af4f https://github.com/pgroonga/pgroonga/commit/2c8b67f05f2786c67767793544adefa7ae32af4f Message: Add a test for seqscan match Added files: expected/text/seqscan.out sql/text/seqscan.sql Removed files: expected/install.out sql/install.sql Modified files: Makefile Modified: Makefile (+6 -1) =================================================================== --- Makefile 2015-01-18 22:40:57 +0900 (ecef3fc) +++ Makefile 2015-01-18 22:51:10 +0900 (0c38483) @@ -6,7 +6,7 @@ DATA = pgroonga--0.2.0.sql PG_CPPFLAGS = $(shell pkg-config --cflags groonga) SHLIB_LINK = $(shell pkg-config --libs groonga) # REGRESS = pgroonga update bench -REGRESS = install +REGRESS = $(shell find sql -name '*.sql' | sed -e 's,\(^sql/\|\.sql$$\),,g') ifdef DEBUG COPT += -O0 -g3 -DPGROONGA_DEBUG=1 @@ -16,3 +16,8 @@ endif PG_CONFIG = pg_config PGXS := $(shell $(PG_CONFIG) --pgxs) include $(PGXS) + +installcheck: results/text + +results/text: + @mkdir -p results/text Deleted: expected/install.out (+0 -1) 100644 =================================================================== --- expected/install.out 2015-01-18 22:40:57 +0900 (11418be) +++ /dev/null @@ -1 +0,0 @@ -CREATE EXTENSION pgroonga; Added: expected/text/seqscan.out (+21 -0) 100644 =================================================================== --- /dev/null +++ expected/text/seqscan.out 2015-01-18 22:51:10 +0900 (5be289f) @@ -0,0 +1,21 @@ +CREATE EXTENSION pgroonga; +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) + Deleted: sql/install.sql (+0 -1) 100644 =================================================================== --- sql/install.sql 2015-01-18 22:40:57 +0900 (11418be) +++ /dev/null @@ -1 +0,0 @@ -CREATE EXTENSION pgroonga; Added: sql/text/seqscan.sql (+20 -0) 100644 =================================================================== --- /dev/null +++ sql/text/seqscan.sql 2015-01-18 22:51:10 +0900 (67a7cc9) @@ -0,0 +1,20 @@ +CREATE EXTENSION pgroonga; + +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'; -------------- next part -------------- HTML����������������������������...ダウンロード
