babelfish-for-postgresql / babelfish_extensions / 9518647799

76%

BABEL_5_X_DEV: 77%

push

github

Support EXECUTE/CREATE...WITH RECOMPILE for stored procedures (#2563)

T-SQL supports EXECUTE WITH RECOMPILE and CREATE PROCEDURE ... WITH RECOMPILE.
For EXECUTE WITH RECOMPILE, an ad-hoc plan is generated for that particular execution.
For CREATE PROCEDURE WITH RECOMPILE, an ad-hoc plan is generated for every execution of the procedure, also when the EXECUTE statement does not specify WITH RECOMPILE.
In both cases, the ad-hoc generated plan is discarded immediately afterwards.

In Babelfish, forcing ad-hoc plan generation is implemented by setting the GUC "plan_cache_mode" to "force_custom_plan" for the particular procedure execution.
For CREATE PROCEDURE WITH RECOMPILE, and additional status bit is used in the babelfish_function_ext.flag_values catalog field.
Currently, recompilation will not apply to non-parametrized queries since PG will not generate a custom plan for such queries.

Task: BABEL-346
Signed-off-by: Rob Verschoor rcv@amazon.com

43 of 45 new or added lines in 6 files covered. (95.56%)

42314 of 57908 relevant lines covered (73.07%)

108134.56 hits per line