From: Takashi Suzuki <suzuki.takashi@metrosystems.co.jp>
Date: Mon, 5 Aug 2013 00:49:46 +0000 (+0900)
Subject: No.A-5-2の試験のSQLを更新した。
X-Git-Tag: REL91_1_1_1~84
X-Git-Url: http://git.osdn.net/view?p=pghintplan%2Fpg_hint_plan.git;a=commitdiff_plain;h=d01f916ed085abcff5a7ccb7d6793926e9b0e92e

No.A-5-2の試験のSQLを更新した。
---

diff --git a/sql/ut-A.sql b/sql/ut-A.sql
index a82c67c..36a49b0 100644
--- a/sql/ut-A.sql
+++ b/sql/ut-A.sql
@@ -65,16 +65,19 @@ EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
 ----
 
 -- No. A-5-2-1
+EXPLAIN (COSTS false) SELECT c1 FROM s1.t1 WHERE t1.c1 = 1;
 /*+SeqScan(t1)*/
-EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
+EXPLAIN (COSTS false) SELECT c1 FROM s1.t1 WHERE t1.c1 = 1;
 
 -- No. A-5-2-2
-/* normal comment */
-/*+SeqScan(t1)*/
-EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
+EXPLAIN (COSTS false) SELECT c1 /*+SeqScan(t1)*/ FROM s1.t1 WHERE t1.c1 = 1;
 
 -- No. A-5-2-3
-EXPLAIN (COSTS false) SELECT /*+SeqScan(t1)*/ * FROM s1.t1 WHERE t1.c1 = 1;
+EXPLAIN (COSTS false) SELECT c1 AS "c1"/*+SeqScan(t1)*/ FROM s1.t1 WHERE t1.c1 = 1;
+
+-- No. A-5-2-4
+EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
+EXPLAIN (COSTS false) SELECT * /*+SeqScan(t1)*/ FROM s1.t1 WHERE t1.c1 = 1;
 
 ----
 ---- No. A-6-1 hint's table definition