Commit: c8e2c79873d1832717ade54f93cff4fc4424fb7d - pg_hint_plan (git)

firtst release

Commit MetaInfo

• Revision: c8e2c79873d1832717ade54f93cff4fc4424fb7d (tree)
• Time: 2014-01-17 10:52:44
• Author: Takashi Suzuki <suzuki.takashi@metr...>
• Commiter: Takashi Suzuki

Log Message

Rowsヒント句のメッセージ出力(R-3-6-*)の試験を追加した。

Change Summary

• add: expected/R_3-6-1.out
• modified: expected/ut-R.out
• modified: sql/ut-R.sql

Incremental Difference

--- /dev/null
+++ b/expected/R_3-6-1.out
@@ -0,0 +1,20 @@
+                                QUERY PLAN                                 
+---------------------------------------------------------------------------
+ Merge Join  (cost=xxx rows=100 width=29)
+   Merge Cond: (t1.c1 = t2.c1)
+   ->  Index Scan using t1_i1 on t1  (cost=xxx rows=1000 width=15)
+   ->  Sort  (cost=xxx rows=100 width=14)
+         Sort Key: t2.c1
+         ->  Seq Scan on t2  (cost=xxx rows=100 width=14)
+(6 rows)
+
+                                QUERY PLAN                                 
+---------------------------------------------------------------------------
+ Merge Join  (cost=xxx rows=101 width=29)
+   Merge Cond: (t1.c1 = t2.c1)
+   ->  Index Scan using t1_i1 on t1  (cost=xxx rows=1000 width=15)
+   ->  Sort  (cost=xxx rows=100 width=14)
+         Sort Key: t2.c1
+         ->  Seq Scan on t2  (cost=xxx rows=100 width=14)
+(6 rows)
+

--- a/expected/ut-R.out
+++ b/expected/ut-R.out
@@ -2413,3 +2413,23 @@ error hint:
 \o
 \! sed 's/cost=[\.0-9]*/cost=xxx/' results/R_3-5-4.out.log > results/R_3-5-4.out
 \! diff expected/R_3-5-4.out results/R_3-5-4.out
+----
+---- No. R-3-6 hint state output
+----
+-- No. R-3-6-1
+SET client_min_messages TO DEBUG1;
+\o results/R_3-6-1.out.log
+EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
+/*+Rows(t1 t2 +1)*/
+EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
+DEBUG:  adjusted rows 100 to 101
+LOG:  pg_hint_plan:
+used hint:
+Rows(t1 t2 +1)
+not used hint:
+duplication hint:
+error hint:
+
+\o
+\! sed 's/cost=[\.0-9]*/cost=xxx/' results/R_3-6-1.out.log > results/R_3-6-1.out
+\! diff expected/R_3-6-1.out results/R_3-6-1.out

--- a/sql/ut-R.sql
+++ b/sql/ut-R.sql
@@ -1217,3 +1217,16 @@ EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
 \o
 \! sed 's/cost=[\.0-9]*/cost=xxx/' results/R_3-5-4.out.log > results/R_3-5-4.out
 \! diff expected/R_3-5-4.out results/R_3-5-4.out
+----
+---- No. R-3-6 hint state output
+----
+
+-- No. R-3-6-1
+SET client_min_messages TO DEBUG1;
+\o results/R_3-6-1.out.log
+EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
+/*+Rows(t1 t2 +1)*/
+EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
+\o
+\! sed 's/cost=[\.0-9]*/cost=xxx/' results/R_3-6-1.out.log > results/R_3-6-1.out
+\! diff expected/R_3-6-1.out results/R_3-6-1.out