Follow a behavioral change in core.

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

diff --git a/expected/pg_hint_plan.out b/expected/pg_hint_plan.out
index dbcee84..1a19066 100644 (file)
--- a/expected/pg_hint_plan.out
+++ b/expected/pg_hint_plan.out
@@ -7061,14 +7061,14 @@ error hint:
 /*+IndexScan(p2 p2_val_idx6)*/
 EXPLAIN (COSTS false) SELECT val FROM p2 WHERE val >= '50' AND val <= '51' AND p2.ctid = '(1,1)';
 LOG:  available indexes for IndexScan(p2): p2_val_idx6
-LOG:  available indexes for IndexScan(p2_c1): p2_c1_val_idx6
-LOG:  available indexes for IndexScan(p2_c2): p2_c2_val_idx6
-LOG:  available indexes for IndexScan(p2_c3): p2_c3_val_idx6
-LOG:  available indexes for IndexScan(p2_c4): p2_c4_val_idx6
-LOG:  available indexes for IndexScan(p2_c1_c1): p2_c1_c1_val_idx6
-LOG:  available indexes for IndexScan(p2_c1_c2): p2_c1_c2_val_idx6
-LOG:  available indexes for IndexScan(p2_c3_c1): p2_c3_c1_val_idx6
-LOG:  available indexes for IndexScan(p2_c3_c2): p2_c3_c2_val_idx6
+LOG:  available indexes for IndexScan(p2_c1): p2_c1_val_idx7
+LOG:  available indexes for IndexScan(p2_c2): p2_c2_val_idx7
+LOG:  available indexes for IndexScan(p2_c3): p2_c3_val_idx7
+LOG:  available indexes for IndexScan(p2_c4): p2_c4_val_idx7
+LOG:  available indexes for IndexScan(p2_c1_c1): p2_c1_c1_val_idx7
+LOG:  available indexes for IndexScan(p2_c1_c2): p2_c1_c2_val_idx7
+LOG:  available indexes for IndexScan(p2_c3_c1): p2_c3_c1_val_idx7
+LOG:  available indexes for IndexScan(p2_c3_c2): p2_c3_c2_val_idx7
 LOG:  pg_hint_plan:
 used hint:
 IndexScan(p2 p2_val_idx6)
@@ -7102,14 +7102,14 @@ error hint:
 /*+IndexScan(p2 p2_val_idx p2_val_idx6)*/
 EXPLAIN (COSTS false) SELECT val FROM p2 WHERE val >= '50' AND val <= '51' AND p2.ctid = '(1,1)';
 LOG:  available indexes for IndexScan(p2): p2_val_idx6 p2_val_idx
-LOG:  available indexes for IndexScan(p2_c1): p2_c1_val_idx6 p2_c1_val_idx
-LOG:  available indexes for IndexScan(p2_c2): p2_c2_val_idx6 p2_c2_val_idx
-LOG:  available indexes for IndexScan(p2_c3): p2_c3_val_idx6 p2_c3_val_idx
-LOG:  available indexes for IndexScan(p2_c4): p2_c4_val_idx6 p2_c4_val_idx
-LOG:  available indexes for IndexScan(p2_c1_c1): p2_c1_c1_val_idx6 p2_c1_c1_val_idx
-LOG:  available indexes for IndexScan(p2_c1_c2): p2_c1_c2_val_idx6 p2_c1_c2_val_idx
-LOG:  available indexes for IndexScan(p2_c3_c1): p2_c3_c1_val_idx6 p2_c3_c1_val_idx
-LOG:  available indexes for IndexScan(p2_c3_c2): p2_c3_c2_val_idx6 p2_c3_c2_val_idx
+LOG:  available indexes for IndexScan(p2_c1): p2_c1_val_idx7 p2_c1_val_idx
+LOG:  available indexes for IndexScan(p2_c2): p2_c2_val_idx7 p2_c2_val_idx
+LOG:  available indexes for IndexScan(p2_c3): p2_c3_val_idx7 p2_c3_val_idx
+LOG:  available indexes for IndexScan(p2_c4): p2_c4_val_idx7 p2_c4_val_idx
+LOG:  available indexes for IndexScan(p2_c1_c1): p2_c1_c1_val_idx7 p2_c1_c1_val_idx
+LOG:  available indexes for IndexScan(p2_c1_c2): p2_c1_c2_val_idx7 p2_c1_c2_val_idx
+LOG:  available indexes for IndexScan(p2_c3_c1): p2_c3_c1_val_idx7 p2_c3_c1_val_idx
+LOG:  available indexes for IndexScan(p2_c3_c2): p2_c3_c2_val_idx7 p2_c3_c2_val_idx
 LOG:  pg_hint_plan:
 used hint:
 IndexScan(p2 p2_val_idx p2_val_idx6)

diff --git a/expected/ut-J.out b/expected/ut-J.out
index 9f45297..8506485 100644 (file)
--- a/expected/ut-J.out
+++ b/expected/ut-J.out
@@ -561,11 +561,11 @@ not used hint:
 duplication hint:
 error hint:
 
-                QUERY PLAN                 
--------------------------------------------
+                 QUERY PLAN                  
+---------------------------------------------
  Nested Loop
    ->  Seq Scan on tm1 t1
-   ->  Index Scan using tm1_pkey on tm1 t2
+   ->  Index Scan using tm1_c1_idx on tm1 t2
          Index Cond: (c1 = t1.c1)
 (4 rows)
 

diff --git a/expected/ut-S.out b/expected/ut-S.out
index 0d6f13c..919295f 100644 (file)
--- a/expected/ut-S.out
+++ b/expected/ut-S.out
@@ -430,9 +430,9 @@ error hint:
 -- No. S-1-5-4
 CREATE TEMP TABLE tm1 (LIKE s1.t1 INCLUDING ALL);
 EXPLAIN (COSTS false) SELECT * FROM tm1 WHERE tm1.c1 = 1;
-            QUERY PLAN            
-----------------------------------
- Index Scan using tm1_pkey on tm1
+             QUERY PLAN             
+------------------------------------
+ Index Scan using tm1_c1_idx on tm1
    Index Cond: (c1 = 1)
 (2 rows)