[pgpool-committers: 8713] pgpool: Fix query cache to not cache timestamptz and timetz cast.
Tatsuo Ishii
ishii at sraoss.co.jp
Tue Jul 5 14:19:48 JST 2022
Fix query cache to not cache timestamptz and timetz cast.
Even if query is constant + cast (like '2022-07-05
14:07:00'::timestamptz), the result can be changed by SET TIME ZONE
command etc. and the result should not be cached.
Also regression test data added.
Discussion: https://www.pgpool.net/pipermail/pgpool-general/2022-July/008353.html
Branch
------
V4_1_STABLE
Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=516d2ed2d8069b1bfae9b0fc34cfc58b994f63bc
Modified Files
--------------
src/rewrite/pool_timestamp.c | 4 +++-
src/test/regression/tests/006.memqcache/test.sh | 16 ++++++++++++++++
src/utils/pool_select_walker.c | 13 ++++---------
3 files changed, 23 insertions(+), 10 deletions(-)
More information about the pgpool-committers
mailing list