Fix query hint retrieval with utilities

ossc-db / pg_hint_plan

Extension adding support for optimizer hints in PostgreSQL

Other

696 stars 103 forks source link

Fix query hint retrieval with utilities #130

Closed michaelpq closed 1 year ago

michaelpq commented 1 year ago

Query jumbling is possible in PostgreSQL 16 for utilities, generating a JumbleState that could involve a query normalization. This does not really matter for query hints, so this commit patches the post parse-analyze hook to ignore entirely utility queries.

michaelpq commented 1 year ago

@rjuju @yamatattsu @horiguti @MasahikoSawada If there are no objections from any of you, do you mind if I apply this patch and fix the regression tests? I have other patches brewing on top of that that would need more careful review.

michaelpq commented 1 year ago

This one has been applied as well. Now the master branch has stable regression tests.