Groonga - fulltext search engine.

[Groonga-commit] pgroonga/pgroonga at b0e6879 [master] test: improve test data

Kouhei Sutou null+****@clear*****
Wed Oct 28 22:21:53 JST 2015

• Previous message: [Groonga-commit] pgroonga/pgroonga at cea7a23 [master] Fix function name
• Next message: [Groonga-commit] pgroonga/pgroonga at 9ece27b [master] Support ILIKE with index
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Kouhei Sutou	2015-10-28 22:21:53 +0900 (Wed, 28 Oct 2015)

  New Revision: b0e68794de2ab453247dd7c9766e74e0a9847193
  https://github.com/pgroonga/pgroonga/commit/b0e68794de2ab453247dd7c9766e74e0a9847193

  Message:
    test: improve test data

  Modified files:
    expected/full-text-search/text/single/like/end/bitmapscan.out
    expected/full-text-search/text/single/like/end/indexscan.out
    expected/full-text-search/text/single/like/end/seqscan.out
    sql/full-text-search/text/single/like/end/bitmapscan.sql
    sql/full-text-search/text/single/like/end/indexscan.sql
    sql/full-text-search/text/single/like/end/seqscan.sql

  Modified: expected/full-text-search/text/single/like/end/bitmapscan.out (+8 -8)
===================================================================
--- expected/full-text-search/text/single/like/end/bitmapscan.out    2015-10-28 22:12:53 +0900 (23a5dd1)
+++ expected/full-text-search/text/single/like/end/bitmapscan.out    2015-10-28 22:21:53 +0900 (7099ace)
@@ -2,20 +2,20 @@ CREATE TABLE memos (
   id integer,
   content text
 );
-INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.');
-INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.');
-INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.');
-INSERT INTO memos VALUES (4, 'groonga command is provided.');
+INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS');
+INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine');
+INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga');
+INSERT INTO memos VALUES (4, 'groonga command is provided');
 CREATE INDEX grnindex ON memos USING pgroonga (content);
 SET enable_seqscan = off;
 SET enable_indexscan = off;
 SET enable_bitmapscan = on;
 SELECT id, content
   FROM memos
- WHERE content LIKE '%Groonga.';
- id |                        content                        
-----+-------------------------------------------------------
-  3 | PGroonga is a PostgreSQL extension that uses Groonga.
+ WHERE content LIKE '%Groonga';
+ id |                        content                       
+----+------------------------------------------------------
+  3 | PGroonga is a PostgreSQL extension that uses Groonga
 (1 row)
 
 DROP TABLE memos;

  Modified: expected/full-text-search/text/single/like/end/indexscan.out (+8 -8)
===================================================================
--- expected/full-text-search/text/single/like/end/indexscan.out    2015-10-28 22:12:53 +0900 (77d3f69)
+++ expected/full-text-search/text/single/like/end/indexscan.out    2015-10-28 22:21:53 +0900 (c1775a9)
@@ -2,20 +2,20 @@ CREATE TABLE memos (
   id integer,
   content text
 );
-INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.');
-INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.');
-INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.');
-INSERT INTO memos VALUES (4, 'groonga command is provided.');
+INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS');
+INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine');
+INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga');
+INSERT INTO memos VALUES (4, 'groonga command is provided');
 CREATE INDEX grnindex ON memos USING pgroonga (content);
 SET enable_seqscan = off;
 SET enable_indexscan = on;
 SET enable_bitmapscan = off;
 SELECT id, content
   FROM memos
- WHERE content LIKE '%Groonga.';
- id |                        content                        
-----+-------------------------------------------------------
-  3 | PGroonga is a PostgreSQL extension that uses Groonga.
+ WHERE content LIKE '%Groonga';
+ id |                        content                       
+----+------------------------------------------------------
+  3 | PGroonga is a PostgreSQL extension that uses Groonga
 (1 row)
 
 DROP TABLE memos;

  Modified: expected/full-text-search/text/single/like/end/seqscan.out (+8 -8)
===================================================================
--- expected/full-text-search/text/single/like/end/seqscan.out    2015-10-28 22:12:53 +0900 (8de1aef)
+++ expected/full-text-search/text/single/like/end/seqscan.out    2015-10-28 22:21:53 +0900 (7ee1d35)
@@ -2,20 +2,20 @@ CREATE TABLE memos (
   id integer,
   content text
 );
-INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.');
-INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.');
-INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.');
-INSERT INTO memos VALUES (4, 'groonga command is provided.');
+INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS');
+INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine');
+INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga');
+INSERT INTO memos VALUES (4, 'groonga command is provided');
 CREATE INDEX grnindex ON memos USING pgroonga (content);
 SET enable_seqscan = on;
 SET enable_indexscan = off;
 SET enable_bitmapscan = off;
 SELECT id, content
   FROM memos
- WHERE content LIKE '%Groonga.';
- id |                        content                        
-----+-------------------------------------------------------
-  3 | PGroonga is a PostgreSQL extension that uses Groonga.
+ WHERE content LIKE '%Groonga';
+ id |                        content                       
+----+------------------------------------------------------
+  3 | PGroonga is a PostgreSQL extension that uses Groonga
 (1 row)
 
 DROP TABLE memos;

  Modified: sql/full-text-search/text/single/like/end/bitmapscan.sql (+5 -5)
===================================================================
--- sql/full-text-search/text/single/like/end/bitmapscan.sql    2015-10-28 22:12:53 +0900 (6c87e6f)
+++ sql/full-text-search/text/single/like/end/bitmapscan.sql    2015-10-28 22:21:53 +0900 (8a8bb6a)
@@ -3,10 +3,10 @@ CREATE TABLE memos (
   content text
 );
 
-INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.');
-INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.');
-INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.');
-INSERT INTO memos VALUES (4, 'groonga command is provided.');
+INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS');
+INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine');
+INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga');
+INSERT INTO memos VALUES (4, 'groonga command is provided');
 
 CREATE INDEX grnindex ON memos USING pgroonga (content);
 
@@ -16,6 +16,6 @@ SET enable_bitmapscan = on;
 
 SELECT id, content
   FROM memos
- WHERE content LIKE '%Groonga.';
+ WHERE content LIKE '%Groonga';
 
 DROP TABLE memos;

  Modified: sql/full-text-search/text/single/like/end/indexscan.sql (+5 -5)
===================================================================
--- sql/full-text-search/text/single/like/end/indexscan.sql    2015-10-28 22:12:53 +0900 (5bb096a)
+++ sql/full-text-search/text/single/like/end/indexscan.sql    2015-10-28 22:21:53 +0900 (9ca52f9)
@@ -3,10 +3,10 @@ CREATE TABLE memos (
   content text
 );
 
-INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.');
-INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.');
-INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.');
-INSERT INTO memos VALUES (4, 'groonga command is provided.');
+INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS');
+INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine');
+INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga');
+INSERT INTO memos VALUES (4, 'groonga command is provided');
 
 CREATE INDEX grnindex ON memos USING pgroonga (content);
 
@@ -16,6 +16,6 @@ SET enable_bitmapscan = off;
 
 SELECT id, content
   FROM memos
- WHERE content LIKE '%Groonga.';
+ WHERE content LIKE '%Groonga';
 
 DROP TABLE memos;

  Modified: sql/full-text-search/text/single/like/end/seqscan.sql (+4 -4)
===================================================================
--- sql/full-text-search/text/single/like/end/seqscan.sql    2015-10-28 22:12:53 +0900 (9ec27a4)
+++ sql/full-text-search/text/single/like/end/seqscan.sql    2015-10-28 22:21:53 +0900 (63fa5fe)
@@ -3,10 +3,10 @@ CREATE TABLE memos (
   content text
 );
 
-INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.');
-INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.');
+INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS');
+INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine');
 INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.');
-INSERT INTO memos VALUES (4, 'groonga command is provided.');
+INSERT INTO memos VALUES (4, 'groonga command is provided');
 
 CREATE INDEX grnindex ON memos USING pgroonga (content);
 
@@ -16,6 +16,6 @@ SET enable_bitmapscan = off;
 
 SELECT id, content
   FROM memos
- WHERE content LIKE '%Groonga.';
+ WHERE content LIKE '%Groonga';
 
 DROP TABLE memos;
-------------- next part --------------
HTML����������������������������...
Download 

• Previous message: [Groonga-commit] pgroonga/pgroonga at cea7a23 [master] Fix function name
• Next message: [Groonga-commit] pgroonga/pgroonga at 9ece27b [master] Support ILIKE with index
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]