Support tied Perl objects in plperl and associated contrib modules. Up to now, if you passed a "tied" object to a PL/Perl operation, it would most likely get treated as "undef", since we failed to perform get magic on values we're passed. Tied hashes worked partially, in that you could read out their keys, but the values always read as undef.
To fix, use hv_iterval() not HeVAL() to fetch values from perl hashes, and be careful to apply plperl_materialize_sv() before testing SvOK() or SvROK() on any perl SV. Add regression test cases exercising some typical usage scenarios for tied objects. This is a back-patch of commit ccab6d36d. The original intent was for that to be master-only on the grounds that it wasn't worth the risk to back-patch. However, we now realize that there are several security issues around tied Perl objects, some of which are reachable even without this fix. Having to test different behaviors in master and back branches doesn't seem like a good plan, so as a first step do this to make the branches more alike. Author: Andrey Rachitskiy <[email protected]> Reviewed-by: Tom Lane <[email protected]> Discussion: https://postgr.es/m/[email protected] Backpatch-through: 14-19 Security: CVE-2026-116326 Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/8b3a668b111b9a20955692efd1eca70373dc7679 Author: Tom Lane <[email protected]> Modified Files -------------- contrib/hstore_plperl/expected/hstore_plperl.out | 25 +++++ contrib/hstore_plperl/hstore_plperl.c | 10 +- contrib/hstore_plperl/sql/hstore_plperl.sql | 22 ++++ contrib/jsonb_plperl/expected/jsonb_plperl.out | 46 +++++++- contrib/jsonb_plperl/jsonb_plperl.c | 2 + contrib/jsonb_plperl/sql/jsonb_plperl.sql | 39 +++++++ src/pl/plperl/GNUmakefile | 2 +- src/pl/plperl/expected/plperl_tied.out | 132 +++++++++++++++++++++++ src/pl/plperl/plperl.c | 44 ++++++-- src/pl/plperl/plperl.h | 13 +++ src/pl/plperl/sql/plperl_tied.sql | 113 +++++++++++++++++++ 11 files changed, 432 insertions(+), 16 deletions(-)
