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(-)

Reply via email to