• R/O
  • HTTP
  • SSH
  • HTTPS

pg_hint_plan: Commit

firtst release


Commit MetaInfo

Revisionc3634a95607561a536fb3a9566ebaee1290430ed (tree)
Time2020-10-29 21:19:38
AuthorKyotaro Horiguchi <horikyoga.ntt@gmai...>
CommiterKyotaro Horiguchi

Log Message

Follow a behavioral change in core.

Commit e22e29c258 has changed the core's behavior of naming indexes.
Follow the changes. This is regression-result changes only.

Change Summary

Incremental Difference

--- a/expected/pg_hint_plan.out
+++ b/expected/pg_hint_plan.out
@@ -7081,14 +7081,14 @@ error hint:
70817081 /*+IndexScan(p2 p2_val_idx6)*/
70827082 EXPLAIN (COSTS false) SELECT val FROM p2 WHERE val >= '50' AND val <= '51' AND p2.ctid = '(1,1)';
70837083 LOG: available indexes for IndexScan(p2): p2_val_idx6
7084-LOG: available indexes for IndexScan(p2_c1): p2_c1_val_idx6
7085-LOG: available indexes for IndexScan(p2_c2): p2_c2_val_idx6
7086-LOG: available indexes for IndexScan(p2_c3): p2_c3_val_idx6
7087-LOG: available indexes for IndexScan(p2_c4): p2_c4_val_idx6
7088-LOG: available indexes for IndexScan(p2_c1_c1): p2_c1_c1_val_idx6
7089-LOG: available indexes for IndexScan(p2_c1_c2): p2_c1_c2_val_idx6
7090-LOG: available indexes for IndexScan(p2_c3_c1): p2_c3_c1_val_idx6
7091-LOG: available indexes for IndexScan(p2_c3_c2): p2_c3_c2_val_idx6
7084+LOG: available indexes for IndexScan(p2_c1): p2_c1_val_idx7
7085+LOG: available indexes for IndexScan(p2_c2): p2_c2_val_idx7
7086+LOG: available indexes for IndexScan(p2_c3): p2_c3_val_idx7
7087+LOG: available indexes for IndexScan(p2_c4): p2_c4_val_idx7
7088+LOG: available indexes for IndexScan(p2_c1_c1): p2_c1_c1_val_idx7
7089+LOG: available indexes for IndexScan(p2_c1_c2): p2_c1_c2_val_idx7
7090+LOG: available indexes for IndexScan(p2_c3_c1): p2_c3_c1_val_idx7
7091+LOG: available indexes for IndexScan(p2_c3_c2): p2_c3_c2_val_idx7
70927092 LOG: pg_hint_plan:
70937093 used hint:
70947094 IndexScan(p2 p2_val_idx6)
@@ -7122,14 +7122,14 @@ error hint:
71227122 /*+IndexScan(p2 p2_val_idx p2_val_idx6)*/
71237123 EXPLAIN (COSTS false) SELECT val FROM p2 WHERE val >= '50' AND val <= '51' AND p2.ctid = '(1,1)';
71247124 LOG: available indexes for IndexScan(p2): p2_val_idx6 p2_val_idx
7125-LOG: available indexes for IndexScan(p2_c1): p2_c1_val_idx6 p2_c1_val_idx
7126-LOG: available indexes for IndexScan(p2_c2): p2_c2_val_idx6 p2_c2_val_idx
7127-LOG: available indexes for IndexScan(p2_c3): p2_c3_val_idx6 p2_c3_val_idx
7128-LOG: available indexes for IndexScan(p2_c4): p2_c4_val_idx6 p2_c4_val_idx
7129-LOG: available indexes for IndexScan(p2_c1_c1): p2_c1_c1_val_idx6 p2_c1_c1_val_idx
7130-LOG: available indexes for IndexScan(p2_c1_c2): p2_c1_c2_val_idx6 p2_c1_c2_val_idx
7131-LOG: available indexes for IndexScan(p2_c3_c1): p2_c3_c1_val_idx6 p2_c3_c1_val_idx
7132-LOG: available indexes for IndexScan(p2_c3_c2): p2_c3_c2_val_idx6 p2_c3_c2_val_idx
7125+LOG: available indexes for IndexScan(p2_c1): p2_c1_val_idx7 p2_c1_val_idx
7126+LOG: available indexes for IndexScan(p2_c2): p2_c2_val_idx7 p2_c2_val_idx
7127+LOG: available indexes for IndexScan(p2_c3): p2_c3_val_idx7 p2_c3_val_idx
7128+LOG: available indexes for IndexScan(p2_c4): p2_c4_val_idx7 p2_c4_val_idx
7129+LOG: available indexes for IndexScan(p2_c1_c1): p2_c1_c1_val_idx7 p2_c1_c1_val_idx
7130+LOG: available indexes for IndexScan(p2_c1_c2): p2_c1_c2_val_idx7 p2_c1_c2_val_idx
7131+LOG: available indexes for IndexScan(p2_c3_c1): p2_c3_c1_val_idx7 p2_c3_c1_val_idx
7132+LOG: available indexes for IndexScan(p2_c3_c2): p2_c3_c2_val_idx7 p2_c3_c2_val_idx
71337133 LOG: pg_hint_plan:
71347134 used hint:
71357135 IndexScan(p2 p2_val_idx p2_val_idx6)
--- a/expected/ut-J.out
+++ b/expected/ut-J.out
@@ -561,11 +561,11 @@ not used hint:
561561 duplication hint:
562562 error hint:
563563
564- QUERY PLAN
565--------------------------------------------
564+ QUERY PLAN
565+---------------------------------------------
566566 Nested Loop
567567 -> Seq Scan on tm1 t1
568- -> Index Scan using tm1_pkey on tm1 t2
568+ -> Index Scan using tm1_c1_idx on tm1 t2
569569 Index Cond: (c1 = t1.c1)
570570 (4 rows)
571571
--- a/expected/ut-S.out
+++ b/expected/ut-S.out
@@ -430,9 +430,9 @@ error hint:
430430 -- No. S-1-5-4
431431 CREATE TEMP TABLE tm1 (LIKE s1.t1 INCLUDING ALL);
432432 EXPLAIN (COSTS false) SELECT * FROM tm1 WHERE tm1.c1 = 1;
433- QUERY PLAN
434-----------------------------------
435- Index Scan using tm1_pkey on tm1
433+ QUERY PLAN
434+------------------------------------
435+ Index Scan using tm1_c1_idx on tm1
436436 Index Cond: (c1 = 1)
437437 (2 rows)
438438
Show on old repository browser