No.S-3-5-7の試験のPG9.2用予測結果を更新した。

diff --git a/expected/ut-S-9.2.out b/expected/ut-S-9.2.out
index 24a861c..2042ce7 100644 (file)
--- a/expected/ut-S-9.2.out
+++ b/expected/ut-S-9.2.out
@@ -4567,6 +4567,27 @@ error hint:
 (2 rows)
 
 -- No. S-3-5-7
+EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
+          QUERY PLAN          
+------------------------------
+ Index Scan using t1_i1 on t1
+   Index Cond: (c1 = 1)
+(2 rows)
+
+/*+TidScan(t1)*/
+EXPLAIN (COSTS true) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
+LOG:  pg_hint_plan:
+used hint:
+TidScan(t1)
+not used hint:
+duplication hint:
+error hint:
+
+                              QUERY PLAN                               
+-----------------------------------------------------------------------
+ Seq Scan on t1  (cost=10000000000.00..10000000018.50 rows=1 width=15)
+   Filter: (c1 = 1)
+(2 rows)
 
 ----
 ---- No. S-3-6 query structure