Kouhei Sutou
null+****@clear*****
Fri Mar 27 21:40:51 JST 2015
Kouhei Sutou 2015-03-27 21:40:51 +0900 (Fri, 27 Mar 2015) New Revision: bd41da5232d93bfa1c40c533d7347f71e4ee5889 https://github.com/pgroonga/pgroonga/commit/bd41da5232d93bfa1c40c533d7347f71e4ee5889 Message: Add tests for timestamp with time zone Added files: expected/compare/timestamp_with_time_zone/single/between/bitmapscan.out expected/compare/timestamp_with_time_zone/single/between/indexscan.out expected/compare/timestamp_with_time_zone/single/between/seqscan.out sql/compare/timestamp_with_time_zone/single/between/bitmapscan.sql sql/compare/timestamp_with_time_zone/single/between/indexscan.sql sql/compare/timestamp_with_time_zone/single/between/seqscan.sql Modified files: Makefile Modified: Makefile (+3 -0) =================================================================== --- Makefile 2015-02-15 20:23:56 +0900 (7dc885a) +++ Makefile 2015-03-27 21:40:51 +0900 (fd672ac) @@ -40,6 +40,7 @@ installcheck: results/compare/integer/single/between installcheck: results/compare/integer/multiple/greater-than-equal installcheck: results/compare/integer/order_by_limit installcheck: results/compare/timestamp/single/between +installcheck: results/compare/timestamp_with_time_zone/single/between installcheck: results/array/text/single/contain installcheck: results/array/varchar/single/contain installcheck: results/groonga @@ -74,6 +75,8 @@ results/compare/integer/order_by_limit: @mkdir -p $@ results/compare/timestamp/single/between: @mkdir -p $@ +results/compare/timestamp_with_time_zone/single/between: + @mkdir -p $@ results/array/text/single/contain: @mkdir -p $@ results/array/varchar/single/contain: Added: expected/compare/timestamp_with_time_zone/single/between/bitmapscan.out (+33 -0) 100644 =================================================================== --- /dev/null +++ expected/compare/timestamp_with_time_zone/single/between/bitmapscan.out 2015-03-27 21:40:51 +0900 (295c822) @@ -0,0 +1,33 @@ +CREATE TABLE logs ( + created_at timestamp with time zone +); +INSERT INTO logs VALUES ('2015-02-14 10:44:10+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:09+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:02+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:04+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:01+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:05+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:07+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:06+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:03+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:08+09:00'); +CREATE INDEX pgroonga_index ON logs USING pgroonga (created_at); +SET enable_seqscan = off; +SET enable_indexscan = off; +SET enable_bitmapscan = on; +SELECT created_at + FROM logs + WHERE created_at BETWEEN '2015-02-14 10:44:03+09:00' AND '2015-02-14 10:44:09+09:00' + ORDER BY created_at ASC; + created_at +------------------------------ + Fri Feb 13 17:44:03 2015 PST + Fri Feb 13 17:44:04 2015 PST + Fri Feb 13 17:44:05 2015 PST + Fri Feb 13 17:44:06 2015 PST + Fri Feb 13 17:44:07 2015 PST + Fri Feb 13 17:44:08 2015 PST + Fri Feb 13 17:44:09 2015 PST +(7 rows) + +DROP TABLE logs; Added: expected/compare/timestamp_with_time_zone/single/between/indexscan.out (+33 -0) 100644 =================================================================== --- /dev/null +++ expected/compare/timestamp_with_time_zone/single/between/indexscan.out 2015-03-27 21:40:51 +0900 (38bba00) @@ -0,0 +1,33 @@ +CREATE TABLE logs ( + created_at timestamp with time zone +); +INSERT INTO logs VALUES ('2015-02-14 10:44:10+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:09+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:02+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:04+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:01+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:05+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:07+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:06+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:03+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:08+09:00'); +CREATE INDEX pgroonga_index ON logs USING pgroonga (created_at); +SET enable_seqscan = off; +SET enable_indexscan = on; +SET enable_bitmapscan = off; +SELECT created_at + FROM logs + WHERE created_at BETWEEN '2015-02-14 10:44:03+09:00' AND '2015-02-14 10:44:09+09:00' + ORDER BY created_at ASC; + created_at +------------------------------ + Fri Feb 13 17:44:03 2015 PST + Fri Feb 13 17:44:04 2015 PST + Fri Feb 13 17:44:05 2015 PST + Fri Feb 13 17:44:06 2015 PST + Fri Feb 13 17:44:07 2015 PST + Fri Feb 13 17:44:08 2015 PST + Fri Feb 13 17:44:09 2015 PST +(7 rows) + +DROP TABLE logs; Added: expected/compare/timestamp_with_time_zone/single/between/seqscan.out (+33 -0) 100644 =================================================================== --- /dev/null +++ expected/compare/timestamp_with_time_zone/single/between/seqscan.out 2015-03-27 21:40:51 +0900 (79a2903) @@ -0,0 +1,33 @@ +CREATE TABLE logs ( + created_at timestamp with time zone +); +INSERT INTO logs VALUES ('2015-02-14 10:44:10+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:09+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:02+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:04+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:01+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:05+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:07+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:06+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:03+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:08+09:00'); +CREATE INDEX pgroonga_index ON logs USING pgroonga (created_at); +SET enable_seqscan = on; +SET enable_indexscan = off; +SET enable_bitmapscan = off; +SELECT created_at + FROM logs + WHERE created_at BETWEEN '2015-02-14 10:44:03+09:00' AND '2015-02-14 10:44:09+09:00' + ORDER BY created_at ASC; + created_at +------------------------------ + Fri Feb 13 17:44:03 2015 PST + Fri Feb 13 17:44:04 2015 PST + Fri Feb 13 17:44:05 2015 PST + Fri Feb 13 17:44:06 2015 PST + Fri Feb 13 17:44:07 2015 PST + Fri Feb 13 17:44:08 2015 PST + Fri Feb 13 17:44:09 2015 PST +(7 rows) + +DROP TABLE logs; Added: sql/compare/timestamp_with_time_zone/single/between/bitmapscan.sql (+27 -0) 100644 =================================================================== --- /dev/null +++ sql/compare/timestamp_with_time_zone/single/between/bitmapscan.sql 2015-03-27 21:40:51 +0900 (c9ae5b8) @@ -0,0 +1,27 @@ +CREATE TABLE logs ( + created_at timestamp with time zone +); + +INSERT INTO logs VALUES ('2015-02-14 10:44:10+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:09+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:02+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:04+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:01+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:05+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:07+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:06+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:03+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:08+09:00'); + +CREATE INDEX pgroonga_index ON logs USING pgroonga (created_at); + +SET enable_seqscan = off; +SET enable_indexscan = off; +SET enable_bitmapscan = on; + +SELECT created_at + FROM logs + WHERE created_at BETWEEN '2015-02-14 10:44:03+09:00' AND '2015-02-14 10:44:09+09:00' + ORDER BY created_at ASC; + +DROP TABLE logs; Added: sql/compare/timestamp_with_time_zone/single/between/indexscan.sql (+27 -0) 100644 =================================================================== --- /dev/null +++ sql/compare/timestamp_with_time_zone/single/between/indexscan.sql 2015-03-27 21:40:51 +0900 (e226bda) @@ -0,0 +1,27 @@ +CREATE TABLE logs ( + created_at timestamp with time zone +); + +INSERT INTO logs VALUES ('2015-02-14 10:44:10+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:09+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:02+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:04+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:01+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:05+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:07+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:06+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:03+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:08+09:00'); + +CREATE INDEX pgroonga_index ON logs USING pgroonga (created_at); + +SET enable_seqscan = off; +SET enable_indexscan = on; +SET enable_bitmapscan = off; + +SELECT created_at + FROM logs + WHERE created_at BETWEEN '2015-02-14 10:44:03+09:00' AND '2015-02-14 10:44:09+09:00' + ORDER BY created_at ASC; + +DROP TABLE logs; Added: sql/compare/timestamp_with_time_zone/single/between/seqscan.sql (+27 -0) 100644 =================================================================== --- /dev/null +++ sql/compare/timestamp_with_time_zone/single/between/seqscan.sql 2015-03-27 21:40:51 +0900 (b718c2b) @@ -0,0 +1,27 @@ +CREATE TABLE logs ( + created_at timestamp with time zone +); + +INSERT INTO logs VALUES ('2015-02-14 10:44:10+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:09+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:02+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:04+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:01+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:05+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:07+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:06+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:03+09:00'); +INSERT INTO logs VALUES ('2015-02-14 10:44:08+09:00'); + +CREATE INDEX pgroonga_index ON logs USING pgroonga (created_at); + +SET enable_seqscan = on; +SET enable_indexscan = off; +SET enable_bitmapscan = off; + +SELECT created_at + FROM logs + WHERE created_at BETWEEN '2015-02-14 10:44:03+09:00' AND '2015-02-14 10:44:09+09:00' + ORDER BY created_at ASC; + +DROP TABLE logs; -------------- next part -------------- HTML����������������������������...Download