Kouhei Sutou
null+****@clear*****
Fri Jun 30 11:39:50 JST 2017
Kouhei Sutou 2017-06-30 11:39:50 +0900 (Fri, 30 Jun 2017) New Revision: cd3f9cee39b46d828382daf4ea0ef00ead4685ff https://github.com/pgroonga/pgroonga/commit/cd3f9cee39b46d828382daf4ea0ef00ead4685ff Message: pgroonga_escape test: add normal index case Added files: expected/function/query-expand/normal-index.out sql/function/query-expand/normal-index.sql Added: expected/function/query-expand/normal-index.out (+13 -0) 100644 =================================================================== --- /dev/null +++ expected/function/query-expand/normal-index.out 2017-06-30 11:39:50 +0900 (7411537) @@ -0,0 +1,13 @@ +CREATE TABLE synonyms ( + term text, + synonyms text[] +); +CREATE INDEX synonyms_term_index ON synonyms (term); +INSERT INTO synonyms VALUES ('Groonga', ARRAY['Groonga', 'Senna']); +SELECT pgroonga.query_expand('synonyms', 'term', 'synonyms', 'Groonga'); + query_expand +------------------------ + ((Groonga) OR (Senna)) +(1 row) + +DROP TABLE synonyms; Added: sql/function/query-expand/normal-index.sql (+12 -0) 100644 =================================================================== --- /dev/null +++ sql/function/query-expand/normal-index.sql 2017-06-30 11:39:50 +0900 (0d62d8a) @@ -0,0 +1,12 @@ +CREATE TABLE synonyms ( + term text, + synonyms text[] +); + +CREATE INDEX synonyms_term_index ON synonyms (term); + +INSERT INTO synonyms VALUES ('Groonga', ARRAY['Groonga', 'Senna']); + +SELECT pgroonga.query_expand('synonyms', 'term', 'synonyms', 'Groonga'); + +DROP TABLE synonyms; -------------- next part -------------- HTML����������������������������...Download