[pgpool-committers: 9190] pgpool: Test: fix 001.loadbalance test failure.

Tatsuo Ishii ishii at sraoss.co.jp
Fri Feb 17 18:03:44 JST 2023


Test: fix 001.loadbalance test failure.

Since this commit:
https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=f8c3d7b49a1c6496eca2203e95248b86c204bbfa

001.loadbalance test fails on pre PostgreSQL 15, because of the change
in psql.  PostgreSQL 15's psql now prints the whole query results in a
multi-statement query.  Consider following example:

SELECT \BEGIN\;SELECT 1;ROLLBACK;

In 15, the result of SELECT will be printed by psql, while pre-15 will
not.  This causes some test results not to match with expected
results.  To fix this, I added expected7-r-pre15 etc. for pre-15.
test.sh now recognizes "-pre15" suffix. If the server version is
pre-15 and an expected file with suffix "pre-15" exists, the file will
be used.

Branch
------
master

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

Modified Files
--------------
.../001.load_balance/expected/expected7-r-pre15    | 94 ++++++++++++++++++++++
.../001.load_balance/expected/expected7-s-pre15    | 83 +++++++++++++++++++
.../001.load_balance/expected/expected8-s-pre15    | 83 +++++++++++++++++++
src/test/regression/tests/001.load_balance/test.sh | 16 +++-
4 files changed, 274 insertions(+), 2 deletions(-)



More information about the pgpool-committers mailing list