Kouhei Sutou
null+****@clear*****
Fri Jun 30 11:24:56 JST 2017
Kouhei Sutou 2017-06-30 11:24:56 +0900 (Fri, 30 Jun 2017) New Revision: 6b7f043126a32bd99df61e6d628af1484948c45f https://github.com/pgroonga/pgroonga/commit/6b7f043126a32bd99df61e6d628af1484948c45f Message: pgroonga_escape test: add existent and nonexistent mix case Added files: expected/function/query-expand/mix.out sql/function/query-expand/mix.sql Added: expected/function/query-expand/mix.out (+13 -0) 100644 =================================================================== --- /dev/null +++ expected/function/query-expand/mix.out 2017-06-30 11:24:56 +0900 (120944a) @@ -0,0 +1,13 @@ +CREATE TABLE synonyms ( + term text PRIMARY KEY, + synonyms text[] +); +INSERT INTO synonyms VALUES ('Mroonga', ARRAY['Mroonga', 'Groonga MySQL']); +INSERT INTO synonyms VALUES ('PGroonga', ARRAY['PGroonga', 'Groonga PostgreSQL']); +SELECT pgroonga.query_expand('synonyms', 'term', 'synonyms', + 'Ruby (Mroonga OR PGroonga)'); + query_expand +------------------------------------------------------------------------------- + Ruby (((Mroonga) OR (Groonga MySQL)) OR ((PGroonga) OR (Groonga PostgreSQL))) +(1 row) + Added: sql/function/query-expand/mix.sql (+10 -0) 100644 =================================================================== --- /dev/null +++ sql/function/query-expand/mix.sql 2017-06-30 11:24:56 +0900 (6c2aa0d) @@ -0,0 +1,10 @@ +CREATE TABLE synonyms ( + term text PRIMARY KEY, + synonyms text[] +); + +INSERT INTO synonyms VALUES ('Mroonga', ARRAY['Mroonga', 'Groonga MySQL']); +INSERT INTO synonyms VALUES ('PGroonga', ARRAY['PGroonga', 'Groonga PostgreSQL']); + +SELECT pgroonga.query_expand('synonyms', 'term', 'synonyms', + 'Ruby (Mroonga OR PGroonga)'); -------------- next part -------------- HTML����������������������������...Download