[pgpool-committers: 8711] pgpool: Fix query cache to not cache timestamptz and timetz cast.
Tatsuo Ishii
ishii at sraoss.co.jp
Tue Jul 5 14:19:39 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
------
V3_7_STABLE
Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=2a6a721888454550ad9071b501cc77d4df3474cf
Modified Files
--------------
src/rewrite/pool_timestamp.c | 4 +++-
src/test/regression/tests/006.memqcache/test.sh | 16 ++++++++++++++++
src/utils/pool_select_walker.c | 17 ++++++-----------
3 files changed, 25 insertions(+), 12 deletions(-)
More information about the pgpool-committers
mailing list