• R/O
  • HTTP
  • SSH
  • HTTPS

pg_hint_plan: コミット

firtst release


コミットメタ情報

リビジョンf5de55b77a29d8fb368d50a0b683eb6b1eb018ab (tree)
日時2018-11-13 17:39:33
作者Kyotaro Horiguchi <horiguchi.kyotaro@lab....>
コミッターKyotaro Horiguchi

ログメッセージ

Fix regression test following core's behavior

Some changes has been made on GUC default value and behavior. Follow
the change. No change was made on pg_hint_plan's behavior.

変更サマリ

差分

--- a/expected/pg_hint_plan.out
+++ b/expected/pg_hint_plan.out
@@ -2999,6 +2999,7 @@ error hint:
29992999 -> Index Scan using t2_pkey on t2
30003000 (4 rows)
30013001
3002+-- Cannot work
30023003 /*+NestLoop(t1 t2)*/
30033004 EXPLAIN (COSTS false) SELECT * FROM t1 FULL OUTER JOIN t2 ON (t1.id = t2.id);
30043005 LOG: pg_hint_plan:
@@ -3011,10 +3012,10 @@ error hint:
30113012 QUERY PLAN
30123013 ------------------------------
30133014 Hash Full Join
3014- Hash Cond: (t2.id = t1.id)
3015- -> Seq Scan on t2
3015+ Hash Cond: (t1.id = t2.id)
3016+ -> Seq Scan on t1
30163017 -> Hash
3017- -> Seq Scan on t1
3018+ -> Seq Scan on t2
30183019 (5 rows)
30193020
30203021 -- inheritance tables test
--- a/expected/ut-S.out
+++ b/expected/ut-S.out
@@ -4632,14 +4632,15 @@ error hint:
46324632 ---- No. S-3-6 query structure
46334633 ----
46344634 EXPLAIN (COSTS false) SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1 AND t1.ctid = '(1,1)';
4635- QUERY PLAN
4636------------------------------------------
4637- Nested Loop
4638- Join Filter: (t1.c1 = t2.c1)
4639- -> Tid Scan on t1
4640- TID Cond: (ctid = '(1,1)'::tid)
4635+ QUERY PLAN
4636+-----------------------------------------------
4637+ Hash Join
4638+ Hash Cond: (t2.c1 = t1.c1)
46414639 -> Seq Scan on t2
4642-(5 rows)
4640+ -> Hash
4641+ -> Tid Scan on t1
4642+ TID Cond: (ctid = '(1,1)'::tid)
4643+(6 rows)
46434644
46444645 -- No. S-3-6-1
46454646 /*+SeqScan(t1)*/
--- a/sql/pg_hint_plan.sql
+++ b/sql/pg_hint_plan.sql
@@ -336,6 +336,7 @@ EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1
336336 EXPLAIN (COSTS false) SELECT * FROM t1 FULL OUTER JOIN t2 ON (t1.id = t2.id);
337337 /*+MergeJoin(t1 t2)*/
338338 EXPLAIN (COSTS false) SELECT * FROM t1 FULL OUTER JOIN t2 ON (t1.id = t2.id);
339+-- Cannot work
339340 /*+NestLoop(t1 t2)*/
340341 EXPLAIN (COSTS false) SELECT * FROM t1 FULL OUTER JOIN t2 ON (t1.id = t2.id);
341342
旧リポジトリブラウザで表示