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

Tatsuo Ishii ishii at sraoss.co.jp
Tue Jul 5 14:20:02 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
------
master

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

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