babelfish-for-postgresql / babelfish_extensions / 26159457624

77%

push

github

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

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%)

53890 of 69972 relevant lines covered (77.02%)

615600.88 hits per line