pg_stat_statements: Add some tests for older versions still usable
authorMichael Paquier <michael@paquier.xyz>
Sat, 2 Oct 2021 08:40:13 +0000 (17:40 +0900)
committerMichael Paquier <michael@paquier.xyz>
Sat, 2 Oct 2021 08:40:13 +0000 (17:40 +0900)
commit2b0da0365bec6c62cc9c5c317bab6cbee3d52ef4
tree0b9b49ae60c6d9995df9eb293cf47765840d22ea
parent795862c280c5949bafcd8c44543d887fd32b590a
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
contrib/pg_stat_statements/Makefile
contrib/pg_stat_statements/expected/oldextversions.out [new file with mode: 0644]
contrib/pg_stat_statements/sql/oldextversions.sql [new file with mode: 0644]