CVE-2026-121265 PUBLISHED

SQL::Abstract versions before 2.000003 for Perl allow SQL injection via an arrayref column value in insert and update

Assigner: CPANSec
Reserved: 03.11.2026 Published: 07.11.2026 Updated: 07.11.2026

SQL::Abstract versions before 2.000003 for Perl allow SQL injection via an arrayref column value in insert and update.

With the array_datatypes option off, which is the default, insert(), update() and values() treat an arrayref column value as literal SQL. Its first element goes into the SQL text unescaped and the rest become bind values. A JSON array, or a repeated form field decoded as an arrayref, is such a value.

An application that passes request data as column values to insert or update with the default options allows SQL injection.

Releases before 2.000003 also treat an arrayref in generate() as literal SQL, including through AUTOLOAD when allow_autoload is on, whatever array_datatypes is set to.

Product Status

Package Collection https://cpan.org/modules
Package Name SQL-Abstract
Versions Default: unaffected
  • affected from 0 to 2.000003 (excl.)

Solutions

Upgrade to SQL-Abstract 2.000003 or later.

References

Problem Types

  • CWE-89 Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection') CWE