• R/O
  • HTTP
  • SSH
  • HTTPS

pg_hint_plan: Commit

firtst release


Commit MetaInfo

Revision8286b67632d538219d9f0c0a7fef0b404f307792 (tree)
Time2020-10-29 20:31:47
AuthorKyotaro Horiguchi <horikyoga.ntt@gmai...>
CommiterKyotaro Horiguchi

Log Message

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.

Change Summary

Incremental Difference

--- a/expected/pg_hint_plan.out
+++ b/expected/pg_hint_plan.out
@@ -7061,14 +7061,14 @@ error hint:
70617061 /*+IndexScan(p2 p2_val_idx6)*/
70627062 EXPLAIN (COSTS false) SELECT val FROM p2 WHERE val >= '50' AND val <= '51' AND p2.ctid = '(1,1)';
70637063 LOG: available indexes for IndexScan(p2): p2_val_idx6
7064-LOG: available indexes for IndexScan(p2_c1): p2_c1_val_idx6
7065-LOG: available indexes for IndexScan(p2_c2): p2_c2_val_idx6
7066-LOG: available indexes for IndexScan(p2_c3): p2_c3_val_idx6
7067-LOG: available indexes for IndexScan(p2_c4): p2_c4_val_idx6
7068-LOG: available indexes for IndexScan(p2_c1_c1): p2_c1_c1_val_idx6
7069-LOG: available indexes for IndexScan(p2_c1_c2): p2_c1_c2_val_idx6
7070-LOG: available indexes for IndexScan(p2_c3_c1): p2_c3_c1_val_idx6
7071-LOG: available indexes for IndexScan(p2_c3_c2): p2_c3_c2_val_idx6
7064+LOG: available indexes for IndexScan(p2_c1): p2_c1_val_idx7
7065+LOG: available indexes for IndexScan(p2_c2): p2_c2_val_idx7
7066+LOG: available indexes for IndexScan(p2_c3): p2_c3_val_idx7
7067+LOG: available indexes for IndexScan(p2_c4): p2_c4_val_idx7
7068+LOG: available indexes for IndexScan(p2_c1_c1): p2_c1_c1_val_idx7
7069+LOG: available indexes for IndexScan(p2_c1_c2): p2_c1_c2_val_idx7
7070+LOG: available indexes for IndexScan(p2_c3_c1): p2_c3_c1_val_idx7
7071+LOG: available indexes for IndexScan(p2_c3_c2): p2_c3_c2_val_idx7
70727072 LOG: pg_hint_plan:
70737073 used hint:
70747074 IndexScan(p2 p2_val_idx6)
@@ -7102,14 +7102,14 @@ error hint:
71027102 /*+IndexScan(p2 p2_val_idx p2_val_idx6)*/
71037103 EXPLAIN (COSTS false) SELECT val FROM p2 WHERE val >= '50' AND val <= '51' AND p2.ctid = '(1,1)';
71047104 LOG: available indexes for IndexScan(p2): p2_val_idx6 p2_val_idx
7105-LOG: available indexes for IndexScan(p2_c1): p2_c1_val_idx6 p2_c1_val_idx
7106-LOG: available indexes for IndexScan(p2_c2): p2_c2_val_idx6 p2_c2_val_idx
7107-LOG: available indexes for IndexScan(p2_c3): p2_c3_val_idx6 p2_c3_val_idx
7108-LOG: available indexes for IndexScan(p2_c4): p2_c4_val_idx6 p2_c4_val_idx
7109-LOG: available indexes for IndexScan(p2_c1_c1): p2_c1_c1_val_idx6 p2_c1_c1_val_idx
7110-LOG: available indexes for IndexScan(p2_c1_c2): p2_c1_c2_val_idx6 p2_c1_c2_val_idx
7111-LOG: available indexes for IndexScan(p2_c3_c1): p2_c3_c1_val_idx6 p2_c3_c1_val_idx
7112-LOG: available indexes for IndexScan(p2_c3_c2): p2_c3_c2_val_idx6 p2_c3_c2_val_idx
7105+LOG: available indexes for IndexScan(p2_c1): p2_c1_val_idx7 p2_c1_val_idx
7106+LOG: available indexes for IndexScan(p2_c2): p2_c2_val_idx7 p2_c2_val_idx
7107+LOG: available indexes for IndexScan(p2_c3): p2_c3_val_idx7 p2_c3_val_idx
7108+LOG: available indexes for IndexScan(p2_c4): p2_c4_val_idx7 p2_c4_val_idx
7109+LOG: available indexes for IndexScan(p2_c1_c1): p2_c1_c1_val_idx7 p2_c1_c1_val_idx
7110+LOG: available indexes for IndexScan(p2_c1_c2): p2_c1_c2_val_idx7 p2_c1_c2_val_idx
7111+LOG: available indexes for IndexScan(p2_c3_c1): p2_c3_c1_val_idx7 p2_c3_c1_val_idx
7112+LOG: available indexes for IndexScan(p2_c3_c2): p2_c3_c2_val_idx7 p2_c3_c2_val_idx
71137113 LOG: pg_hint_plan:
71147114 used hint:
71157115 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