From 8286b67632d538219d9f0c0a7fef0b404f307792 Mon Sep 17 00:00:00 2001 From: Kyotaro Horiguchi Date: Wed, 28 Oct 2020 18:03:05 +0900 Subject: [PATCH] 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. --- expected/pg_hint_plan.out | 32 ++++++++++++++++---------------- expected/ut-J.out | 6 +++--- expected/ut-S.out | 6 +++--- 3 files changed, 22 insertions(+), 22 deletions(-) diff --git a/expected/pg_hint_plan.out b/expected/pg_hint_plan.out index dbcee84..1a19066 100644 --- 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 --- 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 --- 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) -- 2.11.0