OSDN Git Service

Allow hints to be placed anywhere in query
authorDaniil Anisimov <anisimow.d@gmail.com>
Tue, 18 Jan 2022 08:40:35 +0000 (17:40 +0900)
committerKyotaro Horiguchi <horikyota.ntt@gmail.com>
Tue, 18 Jan 2022 08:40:35 +0000 (17:40 +0900)
commit9e2f8b6127c0f0cf9204529b2e83d967876f0ae1
tree4aa36629b85be344254a5ce5404b416f21cc1911
parente5e2b19a6696a7716809186c5f24823513bca003
Allow hints to be placed anywhere in query

Hints description is restriected to be placed before certain
characters. That is effectively at the beginning of a query, or after
EXPLAIN or PREPARE.  This commit adds a new setting parameter
pg_hint_plan.hints_anywhere, which gets rid of that restriction.  When
it is on, pg_hint_plan ignores SQL syntax at all while reading hints
so there's no restricion on where hint string is placed in a query
string. On the other hand it may lead to false reads from a non-hint
strings.
Makefile
doc/pg_hint_plan-ja.html
doc/pg_hint_plan.html
pg_hint_plan.c