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_14_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/68abacacac0c61c727a24622cec73a1b52ff53ac
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(-)

Reply via email to