{"id":"CVE-2026-15043","summary":"DBI::SQL::Nano versions from 1.42 before 1.651 for Perl have inverted \u003c= and \u003e= SQL operators on text","details":"DBI::SQL::Nano versions from 1.42 before 1.651 for Perl have inverted \u003c= and \u003e= SQL operators on text.\n\nDBI::SQL::Nano, DBI's built-in mini-SQL engine, evaluated WHERE predicates incorrectly in some cases. In the non-numeric string branch of the is_matched method, \u003c= was evaluated using Perl's ge operator, and \u003e= was evaluated using Perl's le operator.\n\nSQL::Nano is the fallback query engine for DBI's file-backed drivers (DBD::File, DBD::DBM, CSV-style drivers) whenever SQL::Statement is not installed, and is forced whenever DBI_SQL_NANO=1. Queries over such tables use these predicates directly.\n\nThe impact depends on the context. Where an application relies on a WHERE clause to filter file-backed data for policy or authorization, an inverted \u003c=/\u003e= comparison silently returns the wrong rows.","aliases":["GHSA-mv45-ff6j-x9jp"],"modified":"2026-07-18T08:59:29.758799302Z","published":"2026-07-14T09:44:25.733Z","related":["openSUSE-SU-2026:11298-1"],"database_specific":{"osv_generated_from":"https://github.com/CVEProject/cvelistV5/tree/main/cves/2026/15xxx/CVE-2026-15043.json","cna_assigner":"CPANSec","cwe_ids":["CWE-480"]},"references":[{"type":"WEB","url":"http://www.openwall.com/lists/oss-security/2026/07/14/9"},{"type":"WEB","url":"https://cpan.org/modules"},{"type":"ADVISORY","url":"https://github.com/CVEProject/cvelistV5/tree/main/cves/2026/15xxx/CVE-2026-15043.json"},{"type":"ADVISORY","url":"https://github.com/perl5-dbi/dbi/security/advisories/GHSA-mv45-ff6j-x9jp"},{"type":"ADVISORY","url":"https://metacpan.org/release/HMBRAND/DBI-1.651/changes"},{"type":"ADVISORY","url":"https://nvd.nist.gov/vuln/detail/CVE-2026-15043"},{"type":"FIX","url":"https://github.com/perl5-dbi/dbi/commit/e9742ef85a75867cbd696860e3bf3e32b681f98d.patch"},{"type":"PACKAGE","url":"https://github.com/perl5-dbi/dbi"}],"affected":[{"ranges":[{"type":"GIT","repo":"https://github.com/perl5-dbi/dbi","events":[{"introduced":"53dd900f9fb940618290a0790bb57ea5ad5f8de3"},{"fixed":"042b14366406a0654f345bd5e8ddec43dfc8800b"},{"fixed":"e9742ef85a75867cbd696860e3bf3e32b681f98d"}],"database_specific":{"extracted_events":[{"introduced":"1.42"},{"fixed":"1.651"}],"source":["DESCRIPTION","REFERENCES"]}}],"database_specific":{"source":"https://storage.googleapis.com/cve-osv-conversion/osv-output/CVE-2026-15043.json"}}],"schema_version":"1.7.5","severity":[{"type":"CVSS_V3","score":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H"}]}