Kouhei Sutou
null+****@clear*****
Sun Jan 18 23:48:04 JST 2015
Kouhei Sutou 2015-01-18 23:48:04 +0900 (Sun, 18 Jan 2015) New Revision: 25a18ed3a6b08a40021ae209e49bd8801f16604d https://github.com/pgroonga/pgroonga/commit/25a18ed3a6b08a40021ae209e49bd8801f16604d Message: Don't use OR Modified files: expected/text/multiple/update.out sql/text/multiple/update.sql Modified: expected/text/multiple/update.out (+11 -4) =================================================================== --- expected/text/multiple/update.out 2015-01-18 23:25:10 +0900 (165ad21) +++ expected/text/multiple/update.out 2015-01-18 23:48:04 +0900 (f2b40e6) @@ -19,16 +19,23 @@ SET enable_indexscan = on; SET enable_bitmapscan = off; SELECT id, title, content FROM memos - WHERE title %% 'Groonga' OR content %% 'Groonga'; + WHERE content %% 'Groonga'; id | title | content ----+---------+-------------------------------------- - 2 | Groonga | is fast full text search engine. 3 | Mroonga | is a MySQL plugin that uses Groonga. -(2 rows) +(1 row) + +SELECT id, title, content + FROM memos + WHERE title %% 'Mroonga'; + id | title | content +----+---------+-------------------------------------- + 3 | Mroonga | is a MySQL plugin that uses Groonga. +(1 row) SELECT id, title, content FROM memos - WHERE title %% 'Mroonga' AND content %% 'MySQL'; + WHERE content %% 'MySQL'; id | title | content ----+---------+-------------------------------------- 3 | Mroonga | is a MySQL plugin that uses Groonga. Modified: sql/text/multiple/update.sql (+6 -2) =================================================================== --- sql/text/multiple/update.sql 2015-01-18 23:25:10 +0900 (f4f5163) +++ sql/text/multiple/update.sql 2015-01-18 23:48:04 +0900 (f5e50fc) @@ -24,10 +24,14 @@ SET enable_bitmapscan = off; SELECT id, title, content FROM memos - WHERE title %% 'Groonga' OR content %% 'Groonga'; + WHERE content %% 'Groonga'; SELECT id, title, content FROM memos - WHERE title %% 'Mroonga' AND content %% 'MySQL'; + WHERE title %% 'Mroonga'; + +SELECT id, title, content + FROM memos + WHERE content %% 'MySQL'; DROP TABLE memos; -------------- next part -------------- HTML����������������������������...ダウンロード
