Kouhei Sutou
null+****@clear*****
Tue Aug 11 22:23:57 JST 2015
Kouhei Sutou 2015-08-11 22:23:57 +0900 (Tue, 11 Aug 2015) New Revision: 4658a7b26eb2db17f655c4c805902a94c12651d2 https://github.com/pgroonga/pgroonga/commit/4658a7b26eb2db17f655c4c805902a94c12651d2 Message: test: use unnset() for readability Modified files: expected/groonga/snippet-html/keywords/multiple.out expected/groonga/snippet-html/keywords/one.out sql/groonga/snippet-html/keywords/multiple.sql sql/groonga/snippet-html/keywords/one.sql Modified: expected/groonga/snippet-html/keywords/multiple.out (+7 -6) =================================================================== --- expected/groonga/snippet-html/keywords/multiple.out 2015-08-11 22:16:32 +0900 (d988ab2) +++ expected/groonga/snippet-html/keywords/multiple.out 2015-08-11 22:23:57 +0900 (7e36d5f) @@ -1,4 +1,4 @@ -SELECT pgroonga.snippet_html( +SELECT unnest(pgroonga.snippet_html( 'Groonga is a fast and accurate full text search engine based on ' || 'inverted index. One of the characteristics of Groonga is that a ' || 'newly registered document instantly appears in search results. ' || @@ -11,9 +11,10 @@ SELECT pgroonga.snippet_html( 'PostgreSQL, column-oriented systems are more suited for aggregate ' || 'queries. Due to this advantage, Groonga can cover weakness of ' || 'row-oriented systems.', - ARRAY['fast', 'PostgreSQL']); - snippet_html ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- - {"Groonga is a <span class=\"keyword\">fast</span> and accurate full text search engine based on inverted index. One of the characteristics of Groonga is that a newly registered document instantly appears in search results. Also, Gro","ase management system (DBMS). Compared with well-known row-oriented systems, such as MySQL and <span class=\"keyword\">PostgreSQL</span>, column-oriented systems are more suited for aggregate queries. Due to this advantage, Groonga"} -(1 row) + ARRAY['fast', 'PostgreSQL'])); + unnest +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- + Groonga is a <span class="keyword">fast</span> and accurate full text search engine based on inverted index. One of the characteristics of Groonga is that a newly registered document instantly appears in search results. Also, Gro + ase management system (DBMS). Compared with well-known row-oriented systems, such as MySQL and <span class="keyword">PostgreSQL</span>, column-oriented systems are more suited for aggregate queries. Due to this advantage, Groonga +(2 rows) Modified: expected/groonga/snippet-html/keywords/one.out (+8 -6) =================================================================== --- expected/groonga/snippet-html/keywords/one.out 2015-08-11 22:16:32 +0900 (2ef52ac) +++ expected/groonga/snippet-html/keywords/one.out 2015-08-11 22:23:57 +0900 (63e3320) @@ -1,4 +1,4 @@ -SELECT pgroonga.snippet_html( +SELECT unnest(pgroonga.snippet_html( 'Groonga is a fast and accurate full text search engine based on ' || 'inverted index. One of the characteristics of Groonga is that a ' || 'newly registered document instantly appears in search results. ' || @@ -11,9 +11,11 @@ SELECT pgroonga.snippet_html( 'PostgreSQL, column-oriented systems are more suited for aggregate ' || 'queries. Due to this advantage, Groonga can cover weakness of ' || 'row-oriented systems.', - ARRAY['Groonga']); - snippet_html ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- - {"<span class=\"keyword\">Groonga</span> is a fast and accurate full text search engine based on inverted index. One of the characteristics of <span class=\"keyword\">Groonga</span> is that a newly registered document instantly appears in search results. Also, Gro","t read locks. These characteristics result in superior performance on real-time applications.\\n\\n<span class=\"keyword\">Groonga</span> is also a column-oriented database management system (DBMS). Compared with well-known row-orien","ted systems, such as MySQL and PostgreSQL, column-oriented systems are more suited for aggregate queries. Due to this advantage, <span class=\"keyword\">Groonga</span> can cover weakness of row-oriented systems."} -(1 row) + ARRAY['Groonga'])); + unnest +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- + <span class="keyword">Groonga</span> is a fast and accurate full text search engine based on inverted index. One of the characteristics of <span class="keyword">Groonga</span> is that a newly registered document instantly appears in search results. Also, Gro + t read locks. These characteristics result in superior performance on real-time applications.\n\n<span class="keyword">Groonga</span> is also a column-oriented database management system (DBMS). Compared with well-known row-orien + ted systems, such as MySQL and PostgreSQL, column-oriented systems are more suited for aggregate queries. Due to this advantage, <span class="keyword">Groonga</span> can cover weakness of row-oriented systems. +(3 rows) Modified: sql/groonga/snippet-html/keywords/multiple.sql (+2 -2) =================================================================== --- sql/groonga/snippet-html/keywords/multiple.sql 2015-08-11 22:16:32 +0900 (596847c) +++ sql/groonga/snippet-html/keywords/multiple.sql 2015-08-11 22:23:57 +0900 (e6a7c57) @@ -1,4 +1,4 @@ -SELECT pgroonga.snippet_html( +SELECT unnest(pgroonga.snippet_html( 'Groonga is a fast and accurate full text search engine based on ' || 'inverted index. One of the characteristics of Groonga is that a ' || 'newly registered document instantly appears in search results. ' || @@ -11,4 +11,4 @@ SELECT pgroonga.snippet_html( 'PostgreSQL, column-oriented systems are more suited for aggregate ' || 'queries. Due to this advantage, Groonga can cover weakness of ' || 'row-oriented systems.', - ARRAY['fast', 'PostgreSQL']); + ARRAY['fast', 'PostgreSQL'])); Modified: sql/groonga/snippet-html/keywords/one.sql (+2 -2) =================================================================== --- sql/groonga/snippet-html/keywords/one.sql 2015-08-11 22:16:32 +0900 (b8fde85) +++ sql/groonga/snippet-html/keywords/one.sql 2015-08-11 22:23:57 +0900 (e3a30df) @@ -1,4 +1,4 @@ -SELECT pgroonga.snippet_html( +SELECT unnest(pgroonga.snippet_html( 'Groonga is a fast and accurate full text search engine based on ' || 'inverted index. One of the characteristics of Groonga is that a ' || 'newly registered document instantly appears in search results. ' || @@ -11,4 +11,4 @@ SELECT pgroonga.snippet_html( 'PostgreSQL, column-oriented systems are more suited for aggregate ' || 'queries. Due to this advantage, Groonga can cover weakness of ' || 'row-oriented systems.', - ARRAY['Groonga']); + ARRAY['Groonga'])); -------------- next part -------------- HTML����������������������������... Download