Kouhei Sutou
null+****@clear*****
Sat Sep 26 19:30:30 JST 2015
Kouhei Sutou 2015-09-26 19:30:30 +0900 (Sat, 26 Sep 2015) New Revision: b189d5c27ce8a107fa052e85451ca21ecc743eb1 https://github.com/pgroonga/pgroonga/commit/b189d5c27ce8a107fa052e85451ca21ecc743eb1 Message: test: add missing expected files Added files: expected/jsonb/full-text-search/default.out expected/jsonb/full-text-search/disable.out Added: expected/jsonb/full-text-search/default.out (+22 -0) 100644 =================================================================== --- /dev/null +++ expected/jsonb/full-text-search/default.out 2015-09-26 19:30:30 +0900 (298b86b) @@ -0,0 +1,22 @@ +CREATE TABLE logs ( + id int, + record jsonb +); +INSERT INTO logs VALUES (1, '{"message": "Hello World"}'); +INSERT INTO logs VALUES (2, '{"message": "This is a pen"}'); +INSERT INTO logs VALUES (3, '{"message": "Good-by World"}'); +CREATE INDEX pgroonga_index ON logs USING pgroonga (record); +SET enable_seqscan = off; +SET enable_indexscan = on; +SET enable_bitmapscan = off; +SELECT id, record + FROM logs + WHERE record @@ 'string @ "world"' + ORDER BY id; + id | record +----+------------------------------ + 1 | {"message": "Hello World"} + 3 | {"message": "Good-by World"} +(2 rows) + +DROP TABLE logs; Added: expected/jsonb/full-text-search/disable.out (+31 -0) 100644 =================================================================== --- /dev/null +++ expected/jsonb/full-text-search/disable.out 2015-09-26 19:30:30 +0900 (87aa555) @@ -0,0 +1,31 @@ +CREATE TABLE logs ( + id int, + record jsonb +); +INSERT INTO logs VALUES (1, '{"message": "Hello World"}'); +INSERT INTO logs VALUES (2, '{"message": "This is a pen"}'); +INSERT INTO logs VALUES (3, '{"message": "Good-by World"}'); +CREATE INDEX pgroonga_index ON logs + USING pgroonga (record) + WITH (tokenizer = ''); +SET enable_seqscan = off; +SET enable_indexscan = on; +SET enable_bitmapscan = off; +SELECT id, record + FROM logs + WHERE record @@ 'string @ "world"' + ORDER BY id; + id | record +----+-------- +(0 rows) + +SELECT id, record + FROM logs + WHERE record @@ 'string == "Hello World"' + ORDER BY id; + id | record +----+---------------------------- + 1 | {"message": "Hello World"} +(1 row) + +DROP TABLE logs; -------------- next part -------------- HTML����������������������������...ダウンロード
