[pgpool-committers: 6861] 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
------
master

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

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(-)