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_18_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/bbe476c747f31e521dbdc395fc6f16db96fc680d
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