pgsql: Provide plpgsql tests for cases involving record field changes. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Provide plpgsql tests for cases involving record field changes.
Date
Msg-id E1fiob5-00086J-QP@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Provide plpgsql tests for cases involving record field changes.

We suppressed one of these test cases in commit feb1cc559 because
it was failing to produce the expected results on CLOBBER_CACHE_ALWAYS
buildfarm members.  But now we need another test with similar behavior,
so let's set up a test file that is expected to vary between regular and
CLOBBER_CACHE_ALWAYS cases, and provide variant expected files.

Someday we should fix plpgsql's failure for change-of-field-type, and
then the discrepancy will go away and we can fold these tests back
into plpgsql_record.sql.  But today is not that day.

Discussion: https://postgr.es/m/87wotkfju1.fsf@news-spur.riddles.org.uk

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/c606f10ff832fc54258bb8a259a8e0daa46468ee

Modified Files
--------------
src/pl/plpgsql/src/Makefile                     |  2 +-
src/pl/plpgsql/src/expected/plpgsql_cache.out   | 67 +++++++++++++++++++++++
src/pl/plpgsql/src/expected/plpgsql_cache_1.out | 72 +++++++++++++++++++++++++
src/pl/plpgsql/src/expected/plpgsql_record.out  | 16 +-----
src/pl/plpgsql/src/sql/plpgsql_cache.sql        | 50 +++++++++++++++++
src/pl/plpgsql/src/sql/plpgsql_record.sql       | 13 +----
6 files changed, 194 insertions(+), 26 deletions(-)


pgsql-committers by date:

Previous
From: Andres Freund
Date:
Subject: pgsql: LLVMJIT: Release JIT context after running ExprContextshutdown
Next
From: Michael Paquier
Date:
Subject: pgsql: Fix handling of pgbench's hash when no argument is provided