pgsql: pg_stat_statements: Add some tests for older versions still usab - Mailing list pgsql-committers

From Michael Paquier
Subject pgsql: pg_stat_statements: Add some tests for older versions still usab
Date
Msg-id E1mWaZq-0002jt-9b@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
pg_stat_statements: Add some tests for older versions still usable

When the newest version is loaded, the backend would load objects from
the oldest complete SQL file (here 1.4) and then update to the latest
version with transition scripts (up to 1.9 currently).  This provides
some coverage for upgrades of pg_stat_statements, but there is no test
to show how things have changed across each version.

This adds a couple of tests for the upgrade paths using objects from
each version supported, stressing the objects whose behaviors have
changed across each version supported.

Author: Erica Zhang
Reviewed-by: Julien Rouhaud, Michael Paquier
Discussion: https://postgr.es/m/tencent_BBA974AFF61379F2345E782FD6C55891950A@qq.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/2b0da0365bec6c62cc9c5c317bab6cbee3d52ef4

Modified Files
--------------
contrib/pg_stat_statements/Makefile                |   2 +-
.../pg_stat_statements/expected/oldextversions.out | 139 +++++++++++++++++++++
contrib/pg_stat_statements/sql/oldextversions.sql  |  39 ++++++
3 files changed, 179 insertions(+), 1 deletion(-)


pgsql-committers by date:

Previous
From: Andres Freund
Date:
Subject: pgsql: Reference test binary using TESTDIR in 001_libpq_pipeline.pl.
Next
From: Tom Lane
Date:
Subject: pgsql: Re-alphabetize the win32_tzmap[] array.