babelfish-for-postgresql / babelfish_extensions / 26742848189

77%

BABEL_6_X_DEV: 77%

push

github

Drop TVP temp tables at RPC end to fix stale plan reads (#4806) (#4830)

When the same prepared SP taking a TVP is re-executed on the same
connection (sp_prepexec / sp_execute), only the first batch's rows
land in the target. Subsequent sp_execute calls silently read from
the first batch's temp table because the cached plan never gets
invalidated.

As a fix cleanup tvp temp tables at the end of every successful
RPC. The DROP fires PlanCacheRelCallback, marking dependent cached
plans invalid.

Task: BABEL-6658

Authored-by: yuchi <yuchichang@tutorabc.com>

34 of 42 new or added lines in 1 file covered. (80.95%)

54247 of 70298 relevant lines covered (77.17%)

397266.04 hits per line