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