• R/O
  • HTTP
  • SSH
  • HTTPS

pg_hint_plan: List of commits

firtst release


RSS
Rev. Time Author
53c74fb 2020-02-13 14:51:51 Kyotaro Horiguchi

Do null-check of error_context_stack before use

The variable is accessed without null checking when planner is called
in the context of pl/pgsql. Fix it. Back-patched up to pg_hint_plan94.

Reporter: egashira-yusuke
Issue: https://github.com/ossc-db/pg_hint_plan/issues/42
Original-Author: sun-wei <30999182+Dagouhan@users.noreply.github.com>
Original-patch: https://github.com/ossc-db/pg_hint_plan/pull/45/commits/8fe092ef73a9af6cfb41e20717d7cb35aa74fce2

3112422 2020-02-13 14:50:53 Kyotaro Horiguchi

Do null-check of error_context_stack before use

The variable is accessed without null checking when planner is called
in the context of pl/pgsql. Fix it. Back-patched up to pg_hint_plan94.

Reporter: egashira-yusuke
Issue: https://github.com/ossc-db/pg_hint_plan/issues/42
Original-Author: sun-wei <30999182+Dagouhan@users.noreply.github.com>
Original-patch: https://github.com/ossc-db/pg_hint_plan/pull/45/commits/8fe092ef73a9af6cfb41e20717d7cb35aa74fce2

22a770c 2019-10-29 18:49:22 Kyotaro Horiguchi

Fix regression tests.

Fix regression tests to work for PG12.

96588f8 2019-10-29 18:47:17 Kyotaro Horiguchi

Follow the change in PG12.

Commit 428b260f87 breaks the prior assumptions by adding one more
planning cycle for updates on partitioned tables. Follow the change.

08e5c94 2019-10-29 18:24:38 Kyotaro Horiguchi

Update core.c based on PG12.0

The following commits changes the original functions in core.c as of
REL_12_0. Took in the changes.

7ad6498fd5a654de6e743814c36cf619a3b5ddb6
45f8eaa8e3031c9cb12deb1b5e294bc052b378f2
f49842d1ee31b976c681322f76025d7732e860f3
7ad6498fd5a654de6e743814c36cf619a3b5ddb6

dba2113 2019-08-29 17:33:54 Jignesh Shah

Fix definition of is_dummy_rel based on changes to community PostgreSQL 11.3

This breaks compatibility with older minor versions, but don't bother
keeping it. Binary built using newer PG minor versions works for older
minor versions.

c945c7b 2019-08-29 17:27:30 Jignesh Shah

Fix definition of is_dummy_rel based on changes in community

64fe767 2019-08-29 17:23:26 Jignesh Shah

Fix is_dummy_rel based on changes in PostgreSQL 10.8

This breaks compatibility with older minor versions, but don't bother
keeping it. Binary built using newer PG minor versions works for older
minor versions.

cf22a23 2019-08-29 16:57:23 LittleWuCoding

fix spelling mistakes in file pg_hint_plan.html

737bcdf 2019-08-29 16:57:16 LittleWuCoding

fix spelling mistakes in file pg_hint_plan.html

31d93fe 2019-08-29 16:57:12 LittleWuCoding

fix spelling mistakes in file pg_hint_plan.html

a912bba 2019-08-29 16:57:04 LittleWuCoding

fix spelling mistakes in file pg_hint_plan.html

7f82a1c 2019-08-29 16:57:00 LittleWuCoding

fix spelling mistakes in file pg_hint_plan.html

36bd012 2019-08-29 16:56:44 LittleWuCoding

fix spelling mistakes in file pg_hint_plan.html

f1837d3 2019-08-29 16:12:58 Arthur Zakirov

Use ParallelHint in ParallelHintCreate()

0dc01fb 2019-08-29 16:12:52 Arthur Zakirov

Use ParallelHint in ParallelHintCreate()

d9bc761 2019-08-29 16:12:39 Arthur Zakirov

Use ParallelHint in ParallelHintCreate()

cb78687 2019-03-08 14:05:51 Kyotaro Horiguchi

Silence some compilers

Some compilers seem to complain about the previous patch, that
prev_hint_str is used uninitialized. Actually it is not but move the
initialization code out of the PG_TRY() section so that such compilers
would be quiet.

b8f3e8a 2019-03-08 14:05:11 Kyotaro Horiguchi

Silence some compilers

Some compilers seem to complain about the previous patch, that
prev_hint_str is used uninitialized. Actually it is not but move the
initialization code out of the PG_TRY() section so that such compilers
would be quiet.

1d935d6 2019-03-08 14:04:33 Kyotaro Horiguchi

Silence some compilers

Some compilers seem to complain about the previous patch, that
prev_hint_str is used uninitialized. Actually it is not but move the
initialization code out of the PG_TRY() section so that such compilers
would be quiet.

6a58835 2019-03-08 13:58:52 Kyotaro Horiguchi

Silence some compilers

Some compilers seem to complain about the previous patch, that
prev_hint_str is used uninitialized. Actually it is not but move the
initialization code out of the PG_TRY() section so that such compilers
would be quiet.

000c325 2019-02-26 20:09:40 Kyotaro Horiguchi

Correctly handle planner nesting

pg_hint_plan assumed that plpgsql is the only source of nested planner
calls. Actually nested call can be made in any shapes. Most of the
cases doesn't harm but in a special case where pg_dbms_stats makes a
SPI call during query planning, that affects subsequent planner
work. Hints lose effect when pg_dbms_stats searches "locked
statistics" tables while planning the target query.

9.5 is not affected. Back patched back to 9.6.

8241ef0 2019-02-26 19:25:08 Kyotaro Horiguchi

Follow core's cobe/havor chages

Take in some changes took place in core code.

Commit 608b167f9f has largely changed the behavior around
CTE. Although I didn't confirmed that the all changes are valid as the
test for pg_hint_plan, just took in all plan differences.

9599067 2019-02-26 18:30:07 Kyotaro Horiguchi

Correctly handle planner nesting

pg_hint_plan assumed that plpgsql is the only source of nested planner
calls. Actually nested call can be made in any shapes. Most of the
cases doesn't harm but in a special case where pg_dbms_stats makes a
SPI call during query planning, that affects subsequent planner
work. Hints lose effect when pg_dbms_stats searches "locked
statistics" tables while planning the target query.

3b588bf 2019-02-26 18:27:46 Kyotaro Horiguchi

Follow the behavior change of PostgreSQL

Some behavioral changes of PostgreSQL breaks regression test. Follow
the changes.

647bad4 2019-02-26 17:49:50 Kyotaro Horiguchi

Correctly handle planner nesting

pg_hint_plan assumed that plpgsql is the only source of nested planner
calls. Actually nested call can be made in any shapes. Most of the
cases doesn't harm but in a special case where pg_dbms_stats makes a
SPI call during query planning, that affects subsequent planner
work. Hints lose effect when pg_dbms_stats searches "locked
statistics" tables while planning the target query.

8cc5d96 2019-02-26 17:48:41 Kyotaro Horiguchi

Follow the behavior change of PostgreSQL

Some behavioral changes of PostgreSQL breaks regression test. Follow
the changes.

009aa8b 2019-02-26 16:10:29 Kyotaro Horiguchi

Correctly handle planner nesting

pg_hint_plan assumed that plpgsql is the only source of nested planner
calls. Actually nested call can be made in any shapes. Most of the
cases doesn't harm but in a special case where pg_dbms_stats makes a
SPI call during query planning, that affects subsequent planner
work. Hints lose effect when pg_dbms_stats searches "locked
statistics" tables while planning the target query.

653f5ce 2019-02-26 15:36:44 Kyotaro Horiguchi

Follow the behavior change of PostgreSQL

Some behavioral changes of PostgreSQL breaks regression test. Follow
the changes.

d5c5bac 2019-02-26 14:56:07 Kyotaro Horiguchi

Stabilize test on paralle hints

Planner

Show on old repository browser