Kouhei Sutou
null+****@clear*****
Thu Feb 5 00:06:29 JST 2015
Kouhei Sutou 2015-02-05 00:06:29 +0900 (Thu, 05 Feb 2015) New Revision: 720955787d997d819425d3bbd8d6d543e01074ce https://github.com/pgroonga/pgroonga/commit/720955787d997d819425d3bbd8d6d543e01074ce Message: Add tests for integer <= XXX Added files: expected/compare/integer/single/less-than-equal/bitmapscan.out expected/compare/integer/single/less-than-equal/indexscan.out expected/compare/integer/single/less-than-equal/seqscan.out sql/compare/integer/single/less-than-equal/bitmapscan.sql sql/compare/integer/single/less-than-equal/indexscan.sql sql/compare/integer/single/less-than-equal/seqscan.sql Modified files: Makefile Modified: Makefile (+3 -0) =================================================================== --- Makefile 2015-02-04 23:19:45 +0900 (cd09e15) +++ Makefile 2015-02-05 00:06:29 +0900 (8e1fbe2) @@ -32,6 +32,7 @@ installcheck: results/full-text-search/text/multiple/contain installcheck: results/full-text-search/text/options/tokenizer installcheck: results/full-text-search/text/options/normalizer installcheck: results/compare/text/single/equal +installcheck: results/compare/integer/single/less-than-equal results/full-text-search/text/single/contain: @mkdir -p $@ @@ -47,3 +48,5 @@ results/full-text-search/text/options/normalizer: @mkdir -p $@ results/compare/text/single/equal: @mkdir -p $@ +results/compare/integer/single/less-than-equal: + @mkdir -p $@ Added: expected/compare/integer/single/less-than-equal/bitmapscan.out (+20 -0) 100644 =================================================================== --- /dev/null +++ expected/compare/integer/single/less-than-equal/bitmapscan.out 2015-02-05 00:06:29 +0900 (9c9cd96) @@ -0,0 +1,20 @@ +CREATE TABLE ids ( + id integer +); +INSERT INTO ids VALUES (1); +INSERT INTO ids VALUES (2); +INSERT INTO ids VALUES (3); +CREATE INDEX grnindex ON ids USING pgroonga (id); +SET enable_seqscan = off; +SET enable_indexscan = off; +SET enable_bitmapscan = on; +SELECT id + FROM ids + WHERE id <= 2; + id +---- + 1 + 2 +(2 rows) + +DROP TABLE ids; Added: expected/compare/integer/single/less-than-equal/indexscan.out (+20 -0) 100644 =================================================================== --- /dev/null +++ expected/compare/integer/single/less-than-equal/indexscan.out 2015-02-05 00:06:29 +0900 (906877f) @@ -0,0 +1,20 @@ +CREATE TABLE ids ( + id integer +); +INSERT INTO ids VALUES (1); +INSERT INTO ids VALUES (2); +INSERT INTO ids VALUES (3); +CREATE INDEX grnindex ON ids USING pgroonga (id); +SET enable_seqscan = off; +SET enable_indexscan = on; +SET enable_bitmapscan = off; +SELECT id + FROM ids + WHERE id <= 2; + id +---- + 1 + 2 +(2 rows) + +DROP TABLE ids; Added: expected/compare/integer/single/less-than-equal/seqscan.out (+20 -0) 100644 =================================================================== --- /dev/null +++ expected/compare/integer/single/less-than-equal/seqscan.out 2015-02-05 00:06:29 +0900 (0cc8641) @@ -0,0 +1,20 @@ +CREATE TABLE ids ( + id integer +); +INSERT INTO ids VALUES (1); +INSERT INTO ids VALUES (2); +INSERT INTO ids VALUES (3); +CREATE INDEX grnindex ON ids USING pgroonga (id); +SET enable_seqscan = on; +SET enable_indexscan = off; +SET enable_bitmapscan = off; +SELECT id + FROM ids + WHERE id <= 2; + id +---- + 1 + 2 +(2 rows) + +DROP TABLE ids; Added: sql/compare/integer/single/less-than-equal/bitmapscan.sql (+19 -0) 100644 =================================================================== --- /dev/null +++ sql/compare/integer/single/less-than-equal/bitmapscan.sql 2015-02-05 00:06:29 +0900 (f785fbf) @@ -0,0 +1,19 @@ +CREATE TABLE ids ( + id integer +); + +INSERT INTO ids VALUES (1); +INSERT INTO ids VALUES (2); +INSERT INTO ids VALUES (3); + +CREATE INDEX grnindex ON ids USING pgroonga (id); + +SET enable_seqscan = off; +SET enable_indexscan = off; +SET enable_bitmapscan = on; + +SELECT id + FROM ids + WHERE id <= 2; + +DROP TABLE ids; Added: sql/compare/integer/single/less-than-equal/indexscan.sql (+19 -0) 100644 =================================================================== --- /dev/null +++ sql/compare/integer/single/less-than-equal/indexscan.sql 2015-02-05 00:06:29 +0900 (2696748) @@ -0,0 +1,19 @@ +CREATE TABLE ids ( + id integer +); + +INSERT INTO ids VALUES (1); +INSERT INTO ids VALUES (2); +INSERT INTO ids VALUES (3); + +CREATE INDEX grnindex ON ids USING pgroonga (id); + +SET enable_seqscan = off; +SET enable_indexscan = on; +SET enable_bitmapscan = off; + +SELECT id + FROM ids + WHERE id <= 2; + +DROP TABLE ids; Added: sql/compare/integer/single/less-than-equal/seqscan.sql (+19 -0) 100644 =================================================================== --- /dev/null +++ sql/compare/integer/single/less-than-equal/seqscan.sql 2015-02-05 00:06:29 +0900 (bc957db) @@ -0,0 +1,19 @@ +CREATE TABLE ids ( + id integer +); + +INSERT INTO ids VALUES (1); +INSERT INTO ids VALUES (2); +INSERT INTO ids VALUES (3); + +CREATE INDEX grnindex ON ids USING pgroonga (id); + +SET enable_seqscan = on; +SET enable_indexscan = off; +SET enable_bitmapscan = off; + +SELECT id + FROM ids + WHERE id <= 2; + +DROP TABLE ids; -------------- next part -------------- HTML����������������������������... Download