From: Takashi Suzuki <suzuki.takashi@metrosystems.co.jp>
Date: Thu, 9 Jan 2014 04:58:37 +0000 (+0900)
Subject: 機能試験表との試験番号のずれをなおした。
X-Git-Tag: REL93_1_1_1~30
X-Git-Url: http://git.osdn.net/view?p=pghintplan%2Fpg_hint_plan.git;a=commitdiff_plain;h=3f674b75327b8608e0107d76a3a0984cb06a05c5

機能試験表との試験番号のずれをなおした。
---

diff --git a/expected/ut-S.out b/expected/ut-S.out
index 7b5bc1a..0a5cf59 100644
--- a/expected/ut-S.out
+++ b/expected/ut-S.out
@@ -4168,7 +4168,7 @@ error hint:
          Index Cond: (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery)
 (5 rows)
 
--- No. S-3-4-10
+-- No. S-3-4-21
 /*+BitmapScan(ti1 ti1_pkey)*/
 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
 LOG:  available indexes for BitmapScan(ti1): ti1_pkey
@@ -4188,7 +4188,7 @@ error hint:
          Index Cond: (c1 < 100)
 (5 rows)
 
--- No. S-3-4-11
+-- No. S-3-4-22
 /*+BitmapScan(ti1 ti1_c2_key)*/
 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
 LOG:  available indexes for BitmapScan(ti1): ti1_c2_key
diff --git a/sql/ut-S.sql b/sql/ut-S.sql
index 97a1355..1c6475a 100644
--- a/sql/ut-S.sql
+++ b/sql/ut-S.sql
@@ -732,11 +732,11 @@ EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c
 /*+BitmapScan(ti1 ti1_ts)*/
 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
 
--- No. S-3-4-10
+-- No. S-3-4-21
 /*+BitmapScan(ti1 ti1_pkey)*/
 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
 
--- No. S-3-4-11
+-- No. S-3-4-22
 /*+BitmapScan(ti1 ti1_c2_key)*/
 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';