Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Hint not working for Prepare Statement #6

Closed
ZaidGolwalaFAST opened this issue Nov 24, 2017 · 1 comment
Closed

Hint not working for Prepare Statement #6

ZaidGolwalaFAST opened this issue Nov 24, 2017 · 1 comment

Comments

@ZaidGolwalaFAST
Copy link

I am trying to use pg_hint_plan to get hint for my dynamic queries prepared using Prepare statements , but hint does not work.

I have attached the test case for ECPG for which pg_hint_plan fails to provide hint.
From the log it seems the sequence in which it parses the query and execute the query gets jumbled up.

I have attached the log and Source code with my logging for same , for debugging purpose I had added logging in functions "pg_hint_plan_post_parse_analyze" and "pg_hint_plan_planner".

It seems that while executing pg_hint_plan_planner the hint gets overwritten with next statement's hint string.

test_douteki_01.pgc.txt

hint_plan.log

pg_hint_plan.c.txt

@horiguti
Copy link
Contributor

horiguti commented Feb 17, 2020

I think this is introduced at PG10 version and fixed by the commit 0576a94 for master, PG12, 4e3c987
for PG11 , eb2d8f3
for PG10.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants