Horton

pg_stat_statements: Add some tests for older versions still usable

Michael Paquier <michael@paquier.xyz>

View on postgr.es
Commit: 2b0da0365bec6c62cc9c5c317bab6cbee3d52ef4
Author: Michael Paquier <michael@paquier.xyz>
Date: 2021-10-02T08:40:13Z
Releases: 15.0 
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

Files

PathChange+/−
contrib/pg_stat_statements/expected/oldextversions.out added +139 −0
contrib/pg_stat_statements/Makefile modified +1 −1
contrib/pg_stat_statements/sql/oldextversions.sql added +39 −0

Discussion