[pgpool-committers: 8715] pgpool: Fix query cache to not cache timestamptz and timetz cast.

Tatsuo Ishii ishii at sraoss.co.jp
Tue Jul 5 14:19:57 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_3_STABLE

Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=7c5485c913f29e04ee836cc2294ba8c9ce086b7a

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