Fix to not cache SELECT having functions with return types are timestamptz or timetz.
authorTatsuo Ishii <ishii@sraoss.co.jp>
Wed, 6 Jul 2022 12:31:08 +0000 (21:31 +0900)
committerTatsuo Ishii <ishii@sraoss.co.jp>
Wed, 6 Jul 2022 12:31:08 +0000 (21:31 +0900)
commit47fd46cbcf31b46d93a8ade62fda43b82c39b4e6
tree06e1abf6e170a94828415be3ebcd41bf6aa9dd6d
parent859ca1734e0d8a0eb98c98d624fe5911b6e6d95f
Fix to not cache SELECT having functions with return types are timestamptz or timetz.

Functions with return type is timestamptz or timetz is affected by time zone setting.
Consider following scenario:

1) SELECT having such functions gets called and cache created.

2) time zone is changed.

3) same SELECT is called and the cache is used. The cache value is
correct any more because of the time zone change.

Discussion: https://www.pgpool.net/pipermail/pgpool-general/2022-July/008367.html
src/test/regression/tests/006.memqcache/test.sh
src/utils/pool_select_walker.c