Kouhei Sutou
null+****@clear*****
Wed Oct 28 21:12:24 JST 2015
Kouhei Sutou 2015-10-28 21:12:24 +0900 (Wed, 28 Oct 2015) New Revision: 83d27ae3047d16aa9e621c124f83b9d366df5ca5 https://github.com/pgroonga/pgroonga/commit/83d27ae3047d16aa9e621c124f83b9d366df5ca5 Message: Use OR for @@ Modified files: expected/full-text-search/text/single/query/bitmapscan.out expected/full-text-search/text/single/query/indexscan.out expected/full-text-search/text/single/query/seqscan.out sql/full-text-search/text/single/query/bitmapscan.sql sql/full-text-search/text/single/query/indexscan.sql sql/full-text-search/text/single/query/seqscan.sql Modified: expected/full-text-search/text/single/query/bitmapscan.out (+6 -5) =================================================================== --- expected/full-text-search/text/single/query/bitmapscan.out 2015-10-28 21:07:44 +0900 (3236b26) +++ expected/full-text-search/text/single/query/bitmapscan.out 2015-10-28 21:12:24 +0900 (24e19f1) @@ -11,10 +11,11 @@ SET enable_indexscan = off; SET enable_bitmapscan = on; SELECT id, content FROM memos - WHERE content @@ 'groonga postgresql'; - id | content -----+------------------------------------------------------- - 3 | PGroonga is a PostgreSQL extension that uses Groonga. -(1 row) + WHERE content @@ 'rdbms OR engine'; + id | content +----+------------------------------------------ + 1 | PostgreSQL is a RDBMS. + 2 | Groonga is fast full text search engine. +(2 rows) DROP TABLE memos; Modified: expected/full-text-search/text/single/query/indexscan.out (+6 -5) =================================================================== --- expected/full-text-search/text/single/query/indexscan.out 2015-10-28 21:07:44 +0900 (86c7342) +++ expected/full-text-search/text/single/query/indexscan.out 2015-10-28 21:12:24 +0900 (3b70c68) @@ -11,10 +11,11 @@ SET enable_indexscan = on; SET enable_bitmapscan = off; SELECT id, content FROM memos - WHERE content @@ 'groonga postgresql'; - id | content -----+------------------------------------------------------- - 3 | PGroonga is a PostgreSQL extension that uses Groonga. -(1 row) + WHERE content @@ 'rdbms OR engine'; + id | content +----+------------------------------------------ + 1 | PostgreSQL is a RDBMS. + 2 | Groonga is fast full text search engine. +(2 rows) DROP TABLE memos; Modified: expected/full-text-search/text/single/query/seqscan.out (+6 -5) =================================================================== --- expected/full-text-search/text/single/query/seqscan.out 2015-10-28 21:07:44 +0900 (c8f22b2) +++ expected/full-text-search/text/single/query/seqscan.out 2015-10-28 21:12:24 +0900 (559018e) @@ -12,10 +12,11 @@ SET enable_indexscan = off; SET enable_bitmapscan = off; SELECT id, content FROM memos - WHERE content @@ 'groonga postgresql'; - id | content -----+------------------------------------------------------- - 3 | PGroonga is a PostgreSQL extension that uses Groonga. -(1 row) + WHERE content @@ 'rdbms OR engine'; + id | content +----+------------------------------------------ + 1 | PostgreSQL is a RDBMS. + 2 | Groonga is fast full text search engine. +(2 rows) DROP TABLE memos; Modified: sql/full-text-search/text/single/query/bitmapscan.sql (+1 -1) =================================================================== --- sql/full-text-search/text/single/query/bitmapscan.sql 2015-10-28 21:07:44 +0900 (87308d0) +++ sql/full-text-search/text/single/query/bitmapscan.sql 2015-10-28 21:12:24 +0900 (f952a91) @@ -15,6 +15,6 @@ SET enable_bitmapscan = on; SELECT id, content FROM memos - WHERE content @@ 'groonga postgresql'; + WHERE content @@ 'rdbms OR engine'; DROP TABLE memos; Modified: sql/full-text-search/text/single/query/indexscan.sql (+1 -1) =================================================================== --- sql/full-text-search/text/single/query/indexscan.sql 2015-10-28 21:07:44 +0900 (a04fdde) +++ sql/full-text-search/text/single/query/indexscan.sql 2015-10-28 21:12:24 +0900 (2eff8e8) @@ -15,6 +15,6 @@ SET enable_bitmapscan = off; SELECT id, content FROM memos - WHERE content @@ 'groonga postgresql'; + WHERE content @@ 'rdbms OR engine'; DROP TABLE memos; Modified: sql/full-text-search/text/single/query/seqscan.sql (+1 -1) =================================================================== --- sql/full-text-search/text/single/query/seqscan.sql 2015-10-28 21:07:44 +0900 (3346413) +++ sql/full-text-search/text/single/query/seqscan.sql 2015-10-28 21:12:24 +0900 (d10926d) @@ -17,6 +17,6 @@ SET enable_bitmapscan = off; SELECT id, content FROM memos - WHERE content @@ 'groonga postgresql'; + WHERE content @@ 'rdbms OR engine'; DROP TABLE memos; -------------- next part -------------- HTML����������������������������...Download