Kouhei Sutou
null+****@clear*****
Sat Apr 23 21:35:46 JST 2016
Kouhei Sutou 2016-04-23 21:35:46 +0900 (Sat, 23 Apr 2016) New Revision: d8b63e2cff4bb0ac9d5d4f12c2c5d0dd115be54d https://github.com/pgroonga/pgroonga/commit/d8b63e2cff4bb0ac9d5d4f12c2c5d0dd115be54d Message: test: use "function" instead of "groonga" Removed files: expected/groonga/command/after-truncate.out expected/groonga/command/select.out expected/groonga/snippet-html/keywords/multiple.out expected/groonga/snippet-html/keywords/one.out sql/groonga/command/after-truncate.sql sql/groonga/command/select.sql sql/groonga/snippet-html/keywords/multiple.sql sql/groonga/snippet-html/keywords/one.sql Deleted: expected/groonga/command/after-truncate.out (+0 -18) 100644 =================================================================== --- expected/groonga/command/after-truncate.out 2016-04-23 15:41:07 +0900 (a7166f4) +++ /dev/null @@ -1,18 +0,0 @@ -CREATE TABLE memos ( - content text -); -CREATE INDEX pgroonga_index ON memos USING pgroonga (content); -TRUNCATE memos; -INSERT INTO memos VALUES ('PostgreSQL is a RDBMS.'); -INSERT INTO memos VALUES ('Groonga is fast full text search engine.'); -INSERT INTO memos VALUES ('PGroonga is a PostgreSQL extension that uses Groonga.'); -SELECT pgroonga.command('select ' || - pgroonga.table_name('pgroonga_index') || - ' --output_columns content')::json->>1 - AS body; - body --------------------------------------------------------------------------------------------------------------------------------------------------------------------- - [[[3],[["content","LongText"]],["PostgreSQL is a RDBMS."],["Groonga is fast full text search engine."],["PGroonga is a PostgreSQL extension that uses Groonga."]]] -(1 row) - -DROP TABLE memos; Deleted: expected/groonga/command/select.out (+0 -17) 100644 =================================================================== --- expected/groonga/command/select.out 2016-04-23 15:41:07 +0900 (cbffc30) +++ /dev/null @@ -1,17 +0,0 @@ -CREATE TABLE memos ( - content text -); -INSERT INTO memos VALUES ('PostgreSQL is a RDBMS.'); -INSERT INTO memos VALUES ('Groonga is fast full text search engine.'); -INSERT INTO memos VALUES ('PGroonga is a PostgreSQL extension that uses Groonga.'); -CREATE INDEX pgroonga_index ON memos USING pgroonga (content); -SELECT pgroonga.command('select ' || - pgroonga.table_name('pgroonga_index') || - ' --output_columns content')::json->>1 - AS body; - body --------------------------------------------------------------------------------------------------------------------------------------------------------------------- - [[[3],[["content","LongText"]],["PostgreSQL is a RDBMS."],["Groonga is fast full text search engine."],["PGroonga is a PostgreSQL extension that uses Groonga."]]] -(1 row) - -DROP TABLE memos; Deleted: expected/groonga/snippet-html/keywords/multiple.out (+0 -20) 100644 =================================================================== --- expected/groonga/snippet-html/keywords/multiple.out 2016-04-23 15:41:07 +0900 (7e36d5f) +++ /dev/null @@ -1,20 +0,0 @@ -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. ' || - 'Also, Groonga allows updates without read locks. These characteristics ' || - 'result in superior performance on real-time applications.' || - '\n' || - '\n' || - 'Groonga is also a column-oriented database management system (DBMS). ' || - 'Compared with well-known row-oriented systems, such as MySQL and ' || - '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'])); - 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) - Deleted: expected/groonga/snippet-html/keywords/one.out (+0 -21) 100644 =================================================================== --- expected/groonga/snippet-html/keywords/one.out 2016-04-23 15:41:07 +0900 (63e3320) +++ /dev/null @@ -1,21 +0,0 @@ -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. ' || - 'Also, Groonga allows updates without read locks. These characteristics ' || - 'result in superior performance on real-time applications.' || - '\n' || - '\n' || - 'Groonga is also a column-oriented database management system (DBMS). ' || - 'Compared with well-known row-oriented systems, such as MySQL and ' || - 'PostgreSQL, column-oriented systems are more suited for aggregate ' || - 'queries. Due to this advantage, Groonga can cover weakness of ' || - 'row-oriented systems.', - 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) - Deleted: sql/groonga/command/after-truncate.sql (+0 -18) 100644 =================================================================== --- sql/groonga/command/after-truncate.sql 2016-04-23 15:41:07 +0900 (eba0d6f) +++ /dev/null @@ -1,18 +0,0 @@ -CREATE TABLE memos ( - content text -); - -CREATE INDEX pgroonga_index ON memos USING pgroonga (content); - -TRUNCATE memos; - -INSERT INTO memos VALUES ('PostgreSQL is a RDBMS.'); -INSERT INTO memos VALUES ('Groonga is fast full text search engine.'); -INSERT INTO memos VALUES ('PGroonga is a PostgreSQL extension that uses Groonga.'); - -SELECT pgroonga.command('select ' || - pgroonga.table_name('pgroonga_index') || - ' --output_columns content')::json->>1 - AS body; - -DROP TABLE memos; Deleted: sql/groonga/command/select.sql (+0 -16) 100644 =================================================================== --- sql/groonga/command/select.sql 2016-04-23 15:41:07 +0900 (742202a) +++ /dev/null @@ -1,16 +0,0 @@ -CREATE TABLE memos ( - content text -); - -INSERT INTO memos VALUES ('PostgreSQL is a RDBMS.'); -INSERT INTO memos VALUES ('Groonga is fast full text search engine.'); -INSERT INTO memos VALUES ('PGroonga is a PostgreSQL extension that uses Groonga.'); - -CREATE INDEX pgroonga_index ON memos USING pgroonga (content); - -SELECT pgroonga.command('select ' || - pgroonga.table_name('pgroonga_index') || - ' --output_columns content')::json->>1 - AS body; - -DROP TABLE memos; Deleted: sql/groonga/snippet-html/keywords/multiple.sql (+0 -14) 100644 =================================================================== --- sql/groonga/snippet-html/keywords/multiple.sql 2016-04-23 15:41:07 +0900 (e6a7c57) +++ /dev/null @@ -1,14 +0,0 @@ -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. ' || - 'Also, Groonga allows updates without read locks. These characteristics ' || - 'result in superior performance on real-time applications.' || - '\n' || - '\n' || - 'Groonga is also a column-oriented database management system (DBMS). ' || - 'Compared with well-known row-oriented systems, such as MySQL and ' || - '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'])); Deleted: sql/groonga/snippet-html/keywords/one.sql (+0 -14) 100644 =================================================================== --- sql/groonga/snippet-html/keywords/one.sql 2016-04-23 15:41:07 +0900 (e3a30df) +++ /dev/null @@ -1,14 +0,0 @@ -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. ' || - 'Also, Groonga allows updates without read locks. These characteristics ' || - 'result in superior performance on real-time applications.' || - '\n' || - '\n' || - 'Groonga is also a column-oriented database management system (DBMS). ' || - 'Compared with well-known row-oriented systems, such as MySQL and ' || - 'PostgreSQL, column-oriented systems are more suited for aggregate ' || - 'queries. Due to this advantage, Groonga can cover weakness of ' || - 'row-oriented systems.', - ARRAY['Groonga'])); -------------- next part -------------- HTML����������������������������...다운로드
