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_17_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/217eb08b45c5e90d3f084a4de42590da229541a3 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/meson.build | 1 + src/pl/plperl/plperl.c | 44 ++++++-- src/pl/plperl/plperl.h | 10 ++ src/pl/plperl/sql/plperl_tied.sql | 113 +++++++++++++++++++ 12 files changed, 430 insertions(+), 16 deletions(-)
