From 7bc2ffa68e065249c7bbbd7486b94e392f461895 Mon Sep 17 00:00:00 2001
From: MasaoFujii <masao.fujii@gmail.com>
Date: Tue, 24 Sep 2013 22:51:54 +0900
Subject: [PATCH] Add the regression test of enable_recheck parameter.

Beena Emerson, modified by me.
---
 expected/pg_bigm.out | 31 +++++++++++++++++++++++++++++++
 sql/pg_bigm.sql      | 12 ++++++++++++
 2 files changed, 43 insertions(+)

diff --git a/expected/pg_bigm.out b/expected/pg_bigm.out
index 6515631..4cc3a07 100644
--- a/expected/pg_bigm.out
+++ b/expected/pg_bigm.out
@@ -10,6 +10,8 @@ SET pg_bigm.last_update = '2013.09.18';
 ERROR:  parameter "pg_bigm.last_update" cannot be changed
 SET standard_conforming_strings = on;
 SET escape_string_warning = off;
+SET pg_bigm.enable_recheck = on;
+SET pg_bigm.gin_key_limit = 0;
 -- tests for likequery
 SELECT likequery (NULL);
  likequery 
@@ -456,6 +458,35 @@ SELECT doc FROM test_bigm WHERE doc LIKE 'pg\___gm%';
  pg_bigmは検索性能を200%向上させました。
 (6 rows)
 
+-- tests for pg_bigm.enable_recheck
+SELECT doc FROM test_bigm WHERE doc LIKE likequery('trial');
+         doc          
+----------------------
+ He is awaiting trial
+(1 row)
+
+SELECT doc FROM test_bigm WHERE doc LIKE likequery('東京都');
+     doc      
+--------------
+ ここは東京都
+(1 row)
+
+SET pg_bigm.enable_recheck = off;
+SELECT doc FROM test_bigm WHERE doc LIKE likequery('trial');
+           doc            
+--------------------------
+ He is awaiting trial
+ It was a trivial mistake
+(2 rows)
+
+SELECT doc FROM test_bigm WHERE doc LIKE likequery('東京都');
+       doc        
+------------------
+ ここは東京都
+ 東京と京都に行く
+(2 rows)
+
+SET pg_bigm.enable_recheck = on;
 -- tests with standard_conforming_strings disabled
 SET standard_conforming_strings = off;
 SELECT likequery('\\_%');
diff --git a/sql/pg_bigm.sql b/sql/pg_bigm.sql
index 88cc28c..e77ab5b 100644
--- a/sql/pg_bigm.sql
+++ b/sql/pg_bigm.sql
@@ -7,6 +7,8 @@ SET pg_bigm.last_update = '2013.09.18';
 
 SET standard_conforming_strings = on;
 SET escape_string_warning = off;
+SET pg_bigm.enable_recheck = on;
+SET pg_bigm.gin_key_limit = 0;
 
 -- tests for likequery
 SELECT likequery (NULL);
@@ -114,6 +116,16 @@ SELECT doc FROM test_bigm WHERE doc LIKE '%\%';
 EXPLAIN (COSTS off) SELECT doc FROM test_bigm WHERE doc LIKE 'pg\___gm%';
 SELECT doc FROM test_bigm WHERE doc LIKE 'pg\___gm%';
 
+-- tests for pg_bigm.enable_recheck
+SELECT doc FROM test_bigm WHERE doc LIKE likequery('trial');
+SELECT doc FROM test_bigm WHERE doc LIKE likequery('東京都');
+
+SET pg_bigm.enable_recheck = off;
+SELECT doc FROM test_bigm WHERE doc LIKE likequery('trial');
+SELECT doc FROM test_bigm WHERE doc LIKE likequery('東京都');
+
+SET pg_bigm.enable_recheck = on;
+
 -- tests with standard_conforming_strings disabled
 SET standard_conforming_strings = off;
 SELECT likequery('\\_%');
-- 
2.11.0