[pgpool-committers: 9213] pgpool: Allow to run certain multi-statement queries.

[Tatsuo Ishii]

Allow to run certain multi-statement queries.

Previously multi-statement queries including INSERT/UPDATE was not
recognized as a multi-statement because of optimization for lengthy
INSERT/UPDATE queries in streaming replication mode. This commit
temporarily turns off the optimization and adds regression test for
that.

Hopefully before releasing 4.5 we find a way to determine whether the
query is a multi-statement query or not in less expensive way. And if
it is not a multi-statement query, we can turn on the optimization.

Discussion: https://www.pgpool.net/pipermail/pgpool-hackers/2023-February/004291.html

Branch
------
master

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

Modified Files
--------------
src/protocol/pool_proto_modules.c                  |  2 +-
.../tests/001.load_balance/expected/expected7-r    | 39 ++++++++++++++++++++++
.../001.load_balance/expected/expected7-r-pre15    | 39 ++++++++++++++++++++++
.../tests/001.load_balance/expected/expected7-s    | 30 +++++++++++++++++
.../001.load_balance/expected/expected7-s-pre15    | 30 +++++++++++++++++
.../tests/001.load_balance/expected/expected8-s    | 30 +++++++++++++++++
.../001.load_balance/expected/expected8-s-pre15    | 30 +++++++++++++++++
.../regression/tests/001.load_balance/sql/7.sql    | 16 +++++++++
8 files changed, 215 insertions(+), 1 deletion(-)