Fix type confusion in PL/Perl's get_perl_array_ref().

get_perl_array_ref() used sv_isa(sv, "PostgreSQL::InServer::ARRAY") to
recognize PL/Perl's own array wrapper objects, then cast SvRV(sv) to
HV * and looked up the "array" key.  But sv_isa() only reports which
package a reference was blessed into, and blessing is an unprivileged
Perl operation that constrains nothing about what is blessed.  A
function in trusted plperl could therefore return

        my $x = "hi"; return bless \$x, 'PostgreSQL::InServer::ARRAY';

whereupon hv_fetch_string() would read a hash bucket array out of the
body of a plain scalar and dereference it.  Since plperl is trusted,
any role with CREATE on a database can reach this.

Fix, per a suggestion from Tom Lane, by requiring SvTYPE(SvRV(sv)) to
be SVt_PVHV before consulting sv_isa().  A reference blessed into that
package but pointing at anything else now falls through to the caller's
existing handling for other references, which looks through the
reference; the example above fails with "malformed array literal".  Add
a regression test next to the existing forged-object case.

It's not clear if this is exploitable, but out of an abundance of
caution we treat it as if it is.

Reported-by: Zheng Yu <[email protected]>
Backpatch-through: 14
Security: CVE-2026-116309

Branch
------
REL_14_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/c032c0fbdc0cd9254d04ea83cbd8b07aa485ed95
Author: Andrew Dunstan <[email protected]>

Modified Files
--------------
src/pl/plperl/expected/plperl_array.out | 9 +++++++++
src/pl/plperl/plperl.c                  | 8 +++++++-
src/pl/plperl/sql/plperl_array.sql      | 8 ++++++++
3 files changed, 24 insertions(+), 1 deletion(-)

Reply via email to