[pgpool-committers: 6858] pgpool: Prevent data modifying CTE to be cached.

Tatsuo Ishii ishii at sraoss.co.jp
Tue Jul 14 22:15:15 JST 2020


Prevent data modifying CTE to be cached.

Data modifying CTE was mistakenly treated as normal read only CTE and
result query was created.  As a result subsequent CTE was not
executed.

Problem reported and patch created by Hou, Zhijie.
Subtle changes to the regression test by me.
Discussion: https://www.pgpool.net/pipermail/pgpool-hackers/2020-July/003705.html

Branch
------
V3_7_STABLE

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

Modified Files
--------------
src/include/query_cache/pool_memqcache.h        |   3 +-
src/protocol/pool_proto_modules.c               |   7 +-
src/query_cache/pool_memqcache.c                | 136 +++++++++++++++++++++++-
src/test/regression/tests/006.memqcache/test.sh |   6 ++
src/utils/pool_select_walker.c                  |   6 ++
5 files changed, 151 insertions(+), 7 deletions(-)



More information about the pgpool-committers mailing list