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

[Tatsuo Ishii]

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
------
V4_1_STABLE

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

Modified Files
--------------
src/include/query_cache/pool_memqcache.h        |    1 +
src/parser/gram_minimal.c                       | 3047 ++++++++++++-----------
src/parser/gram_minimal.y                       |    1 +
src/protocol/pool_proto_modules.c               |    2 +-
src/query_cache/pool_memqcache.c                |  127 +-
src/test/regression/tests/006.memqcache/test.sh |    6 +
src/utils/pool_select_walker.c                  |    6 +
7 files changed, 1665 insertions(+), 1525 deletions(-)